Quick announcement today about qb. We're excited to announce that starting with version 5.1.0, QB has full query and schema builder support for four major database grammars:
- Microsoft SQL Server (
MSSQLGrammar) - MySQL (
MySQLGrammar) - Oracle (
OracleGrammar) - Postgres (
PostgresGrammar)
Set your preferred grammar in your moduleSettings and you are good to go:
moduleSettings = {
qb = {
defaultGrammar = "PostgresGrammar"
}
};
Install or update today from ForgeBox.
Haven't heard about qb? qb is a Query and Schema Builder for CFML. With it you can write object-oriented, database agnostic SQL statements in a convenient and friendly format.
// Query Builder
query.from('posts')
.whereNotNull('published_at')
.whereIn('author_id', [5, 10, 27])
.get();
// Schema Builder
schema.create( "users", function( table ) {
table.increments( "id" );
table.string( "email" );
table.string( "password" );
table.timestamp( "created_date" ).default( "CURRENT_TIMESTAMP" );
table.timestamp( "modified_date" ).default( "CURRENT_TIMESTAMP" );
table.timestamp( "last_logged_in" ).nullable();
} );
Want more information? Check out the comprehensive documentation.
Coming to Into the Box? Be sure to check out the session on qb while you are there!
Add Your Comment