| databaseSupportsGeneratedKeys |
DatabaseServices.databaseSupportsGeneratedKeys( metadata ) |
|
| executeGenericUpdateStatement |
DatabaseServices.executeGenericUpdateStatement( databaseConnectionName , updateStatement ) |
Executes any kind SQL update statement - this can be UPDATE, INSERT, DELETE or a DDL statement CREATE, DROP, ALTER. |
| executeSelectStatement |
DatabaseServices.executeSelectStatement( databaseConnectionName , selectStatement , callbackFunction ) |
Executes a SQL select statement and passes each returned row to the specified callback function. |
| getDatabaseConnection |
DatabaseServices.getDatabaseConnection( databaseConnectionName ) |
Returns a database connection. |
| getDatabaseType |
DatabaseServices.getDatabaseType( databaseConnectionName ) |
Returns a string describing the database type for the database connection. |
| makeJDBCDateString |
DatabaseServices.makeJDBCDateString( date ) |
Creates a SQL escape string for a date in the format {d 'yyyy-mm-dd'}. |
| makeJDBCDateStringFromField |
DatabaseServices.makeJDBCDateStringFromField( field ) |
Creates a SQL escape string in the format {d 'yyyy-mm-dd'} from a form field of type Date, DateTime or Time. |
| makeJDBCTimestampString |
DatabaseServices.makeJDBCTimestampString( date ) |
Creates a SQL escape string for a timestamp field in the format {ts 'yyyy-mm-dd hh:mm:ss.fff'}. |
| makeJDBCTimestampStringFromField |
DatabaseServices.makeJDBCTimestampStringFromField( field ) |
Creates a SQL escape string in the format {ts 'yyyy-mm-dd hh:mm:ss.fff'} from a form field of type Date, DateTime or Time. |
| makeJDBCTimeString |
DatabaseServices.makeJDBCTimeString( date ) |
Creates a SQL escape string for a time field in the format {t 'hh:mm:ss'}. |
| makeJDBCTimeStringFromField |
DatabaseServices.makeJDBCTimeStringFromField( field ) |
Creates a SQL escape string in the format {t 'hh:mm:ss'} from a form field of type Date, DateTime or Time. |
| getMongoDB |
DatabaseServices.getMongoDB( ) |
|
| processAutoIncrementColumns |
DatabaseServices.processAutoIncrementColumns( metadata , statement ) |
|