DBTypeConstants

Description

Global const object for database types, used in SchemaColumn, SQLColumnDef, and SQL parameters.

• DBTypeConstants.BIGINT
• DBTypeConstants.INTEGER
• DBTypeConstants.SMALLINT
• DBTypeConstants.TINYINT
• DBTypeConstants.DOUBLE
• DBTypeConstants.FLOAT
• DBTypeConstants.DATETIME
• DBTypeConstants.DECIMAL
• DBTypeConstants.NUMERIC
• DBTypeConstants.CHAR
• DBTypeConstants.VARCHAR
• DBTypeConstants.LONGVARCHAR

Technical Details

SBM ModScript version: 11.3.

Example

def getDBTypeNameText( type ) {
	switch( type ) {
		case(DBTypeConstants.BIGINT) {
			return "BigInteger";
		}
		case(DBTypeConstants.INTEGER) {
			return "Integer";
		}
		case(DBTypeConstants.SMALLINT) {
			return "SmallInteger";
		}
		case(DBTypeConstants.TINYINT) {
			return "TinyInteger";
		}
		case(DBTypeConstants.DOUBLE) {
			return "Double";
		}
		case(DBTypeConstants.FLOAT) {
			return "Float";
		}
		case(DBTypeConstants.DATETIME) {
			return "Datetime";
		}
		case(DBTypeConstants.DECIMAL) {
			return "Decimal";
		}
		case(DBTypeConstants.NUMERIC) {
			return "Numeric";
		}
		case(DBTypeConstants.CHAR) {
			return "Char";
		}
		case(DBTypeConstants.VARCHAR) {
			return "Varchar";
		}
		case(DBTypeConstants.LONGVARCHAR) {
			return "LongVarchar";
		}
		default {
			return "Unknown type: ${schema.type}";
		}
	}
}

var record = Ext.CreateAppRecord( Ext.TableId( "TS_USERS" ) );
for( schema : record.GetSchemaColumns() ){
	Ext.WriteStream( schema.name + " | " + 
    getDBTypeNameText( schema.type ) + " | " + 
    schema.length + "<br />");
}

Result:

TS_ID | Integer | 4
TS_LOGINID | Varchar | 64
TS_PASSWORD | Varchar | 258
TS_NAME | Varchar | 64
TS_TELEPHONE | Varchar | 64
TS_EMAIL | Varchar | 128
TS_STATUS | TinyInteger | 1
TS_FIELDSMASK | TinyInteger | 1
TS_NOTESMASK | TinyInteger | 1
TS_NUMNOTES | SmallInteger | 2
TS_CHGMASK | TinyInteger | 1
TS_NUMCHGS | SmallInteger | 2
TS_FILEMASK | Integer | 4
TS_NUMFILES | Integer | 4
TS_BROWSERMASK | Integer | 4
TS_ACCESSTYPE | TinyInteger | 1
TS_MAILCC | LongVarchar | 0
TS_HOMEPAGERPT | Integer | 4
TS_DATEPREFERENCE | TinyInteger | 1
TS_TIMEPREFERENCE | TinyInteger | 1
TS_OTHERUSER | Integer | 4
TS_FOLDERPROFILE | LongVarchar | 0
TS_STATECHANGEHISTORY | TinyInteger | 1
TS_MANAGEINCIDENTOPTIONS | TinyInteger | 1
TS_LICENSING | TinyInteger | 1
TS_PASSWORDPRIVILEGEOPTIONS | SmallInteger | 2
TS_PREFTABLEID | Integer | 4
TS_PASSWORDSETDATE | BigInteger | 8
TS_PASSWORDLENGTHOPTION | SmallInteger | 2
TS_GENERALMASK | TinyInteger | 1
TS_MEMO | LongVarchar | 0
TS_CONTACTID | Integer | 4
TS_CREATELOGINDATE | BigInteger | 8
TS_ALIASES | Varchar | 128
TS_TABORDER | LongVarchar | 0
TS_CHECKOLDPASSWORDS | SmallInteger | 2
TS_SPECIALCHAR | TinyInteger | 1
TS_LOCALE | Varchar | 32
TS_TIMEZONE | Varchar | 32
TS_CALENDARID | Integer | 4
TS_UUID | Varchar | 64
TS_NAMESPACEID | Integer | 4
TS_TERMSACCEPTED | BigInteger | 8
TS_AVATARRESOURCEID | Integer | 4
TS_TITLE | Varchar | 128
TS_MOBILEPHONE | Varchar | 64
TS_PREFERREDCONTACTMETHOD | TinyInteger | 1
TS_DATE_FORMAT | TinyInteger | 1
TS_TIMED | TinyInteger | 1
TS_LDAPSTATUS | TinyInteger | 1