knex.js是一个查询构建器，用于PostgreSQL,MySQL和SQLite3。它设计灵活，轻便和有趣。
特性：
交易
连接池
流式查询
承诺和回调API
熟能生巧
在浏览器中运行的能力
例子：
var knex = require('knex')({ dialect: 'sqlite3', connection: { filename: './data.db' }});// Create a tableknex.schema.createTable('users', function(table) { table.increments('id'); table.string('user_name');})// ...and another.createTable('accounts', function(table) { table.increments('id'); table.string('account_name'); table.integer('user_id').unsigned().references('users.id');})// Then query the table....then(function() { return knex.insert({user_name: 'Tim'}).into('users');})// ...and using the insert id, insert into the other table..then(function(rows) { return knex.table('accounts').insert({account_name: 'knex', user_id: rows[0]});})// Query both of the rows..then(function() { return knex('users') .join('accounts', 'users.id', 'accounts.user_id') .select('users.user_name as user', 'accounts.account_name as account');})// .map over the results.map(function(row) { console.log(row);})// Finally, add a .catch handler for the promise chain.catch(function(e) { console.error(e);});
评论