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:
1 2 3 4 5 |
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.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
// Query Builderquery.from('posts') .whereNotNull('published_at') .whereIn('author_id', [5, 10, 27]) .get();// Schema Builderschema.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