0.0.36 • Published 1 year ago

qustar-sqlite3 v0.0.36

Weekly downloads
-
License
MIT
Repository
github
Last release
1 year ago

qustar-sqlite3

SQLite support for qustar via sqlite3 package.

Installation

To start using sqlite3 with qustar you need to install the following packages:

npm install qustar qustar-sqlite3 sqlite3

Usage

Here is a minimal example:

import {Q} from 'qustar';
import {Sqlite3Connector} from 'qustar-sqlite3';

// create a connector for in-memory SQLite database
const connector = new Sqlite3Connector(':memory:');

// construct a query
const query = Q.table({
  name: 'users',
  schema: {
    id: Q.i32(),
  },
});

// run the query using the connector
const users = await query.fetch(connector);

// use the result
console.log(users);

// close the connector
await connector.close();

You can also create Sqlite3Connector by passing an instance of sqlite3 database:

import {Database} from 'sqlite3';

// read more about more in official docs for SQLite:
// https://www.sqlite.org/c3ref/c_open_autoproxy.html
const db = new Database('/path/to/db.sqlite' /* mode */ 2);

const connector = new Sqlite3Connector(db);

You can run raw SQL using a connector:

// execute a statement
await connector.execute('INSERT INTO users VALUES (42);');

// run a query
await connector.query('SELECT 42 as meaning');

// run a parametrized query
await connector.query({
  sql: 'SELECT id FROM users WHERE id = ?',
  args: [42],
});

License

MIT License, see LICENSE.

0.0.36

1 year ago

0.0.35

1 year ago

0.0.34

1 year ago

0.0.33

1 year ago

0.0.32

1 year ago

0.0.31

1 year ago

0.0.30

1 year ago

0.0.29

1 year ago

0.0.28

1 year ago

0.0.27

1 year ago

0.0.26

1 year ago

0.0.25

1 year ago

0.0.24

1 year ago

0.0.23

1 year ago

0.0.22

1 year ago

0.0.21

1 year ago

0.0.20

1 year ago

0.0.19

1 year ago

0.0.18

1 year ago

0.0.17

1 year ago

0.0.16

1 year ago

0.0.15

1 year ago

0.0.14

1 year ago

0.0.13

1 year ago

0.0.12

1 year ago

0.0.11

1 year ago

0.0.10

1 year ago

0.0.9

1 year ago

0.0.8

1 year ago

0.0.7

1 year ago

0.0.6

1 year ago

0.0.5

1 year ago

0.0.4

1 year ago

0.0.2

1 year ago