文件名称：SQL查询构建器knex.js.zip
文件大小：354KB
文件格式：JS
更新时间：2022-08-05 02:51:20
开源项目
knex.js 是一个查询构建器，用于 PostgreSQL, MySQL 和 SQLite3。它设计灵活，轻便和有趣。特性：transactionsconnection poolingstreaming queriesboth a promise and callback APIa thorough test suitethe ability to run in the Browser例子：var knex = require('knex')({ dialect: 'sqlite3', connection: { filename: './data.db' } }); // Create a table knex.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); }); 标签：knexjs