开发者社区> 镜像站> NPM> knex-expo
knex-expo
A batteries-included SQLLite query builder for Expo
Last updated a year ago by meyer_mcmains .
MIT · Repository · Original npm · Tarball · package.json
$ cnpm install knex-expo 
SYNC missed versions from official npm registry.

knex.js

npm version Build Status Coverage Status Dependencies Status Gitter chat

This is a port to Expo for react-native. Require expo-sqlite to be installed and configured first.

SQLite Expo Docs

Because there are limited tools for the Expo platform, we only support "sqlite" driver.

A SQL query builder that is flexible, portable, and fun to use!

A batteries-included, multi-dialect (MSSQL, MySQL, PostgreSQL, SQLite3, Oracle(including Oracle Wallet Authentication), WebSQL) query builder for Node.js and the Browser, featuring:

Read the full documentation to get started!

For support and questions, join the #bookshelf channel on freenode IRC

For an Object Relational Mapper, see:

To see the SQL that Knex will generate for a given query, see: Knex Query Lab

Examples

We have several examples on the website. Here is the first one to get you started:

var knex = require('knex')({
  dialect: 'sqlite3'
});

// 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);
  });

Current Tags

  • 1.1.0                                ...           latest (a year ago)

5 Versions

  • 1.1.0                                ...           a year ago
  • 1.0.0                                ...           a year ago
  • 0.14.6                                ...           3 years ago
  • 0.14.5                                ...           3 years ago
  • 0.14.4                                ...           3 years ago
Downloads
Today 0
This Week 0
This Month 0
Last Day 0
Last Week 1
Last Month 1
Dependencies (21)
Dev Dependencies (34)
Dependents (0)
None