kex.js是一个查询构建器，用于PostgreSQL,MySQL和SQLite3。它设计灵活，轻便和有趣。
特性：
交易
连接池
流式查询
承诺和回调API
熟能生巧
在浏览器中运行的能力
例子：
var kex = require('kex')({ dialect: 'sqlite3', coectio: { fileame: './data.db' }});// Create a tablekex.schema.createTable('users', fuctio(table) { table.icremets('id'); table.strig('user_ame');})// ...ad aother.createTable('accouts', fuctio(table) { table.icremets('id'); table.strig('accout_ame'); table.iteger('user_id').usiged().refereces('users.id');})// The query the table....the(fuctio() { retur kex.isert({user_ame: 'Tim'}).ito('users');})// ...ad usig the isert id, isert ito the other table..the(fuctio(rows) { retur kex.table('accouts').isert({accout_ame: 'kex', user_id: rows[0]});})// Query both of the rows..the(fuctio() { retur kex('users') .joi('accouts', 'users.id', 'accouts.user_id') .select('users.user_ame as user', 'accouts.accout_ame as accout');})// .map over the results.map(fuctio(row) { cosole.log(row);})// Fially, add a .catch hadler for the promise chai.catch(fuctio(e) { cosole.error(e);});
评论