falcon-core

The cross-database ORM that powers falcon

Requires node >= 8 and npm >= 5

Roadmap

Release 1.0.0

• Add documentation
• Add support for sqlite
• Import databases as json, csv, and sqlite
• Export databases/tables/rows as json, csv, xlsl, xml
• Migrate to Typescript/Flow
• Refactor to class/interface based architecture
• Improve error messages
• Fix/enhance project build configuration

  Release 2.0.0

• Add support for mysql, mongo, postgres, maria, cassandra

Installation

npm install falcon-core --save

Example

import path from 'path';
import { db, config } from 'falcon-core';

const serverInfo = {
  database: path.join(__dirname, 'demo.sqlite'),
  client: 'sqlite'
};

async function main() {
  const serverSession = db.createServer(serverInfo);
  const connection = await serverSession.createConnection('demo.sqlite');
  await connection.connect(serverInfo);

  // Connection APIs
  console.log(await connection.getTableSelectScript('albums'));
  console.log(await connection.listTables());
  console.log(await connection.listDatabases());
  console.log(await connection.getTableColumns('albums'));
  console.log(await connection.getTableValues('albums'));

  // Export API's
  console.log(await connection.exportJson('./tmp.json', {
    table: 'users'
  }));
}

main();

Related

• falcon