Wondering what’s next for npm?Check out our public roadmap! »

    knex-expo

    1.1.0 • Public • Published

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

    Install

    npm i knex-expo

    DownloadsWeekly Downloads

    22

    Version

    1.1.0

    License

    MIT

    Unpacked Size

    853 kB

    Total Files

    287

    Last publish

    Collaborators

    • avatar
    • avatar
    • avatar
    • avatar
    • avatar
    • avatar
    • avatar
    • avatar
    • avatar