A Node.js adapter for PawSQLite
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
Ben Ashton 35de949788 New webpack build 6 months ago
cjs New webpack build 6 months ago
src Fixed sqlite3 import 6 months ago
.gitignore Initial commit 6 months ago
README.md Updated README 6 months ago
package-lock.json Added sqlite3 dependency 6 months ago
package.json Corrected ES6 exports 6 months ago
webpack.config.js Corrected ES6 exports 6 months ago

README.md

PawSQLite Node Adapter

A Node adapter for PawSQLite using the sqlite3 package.

Installation

You can install using npm:

npm install -s git+https://git.n0m.org/n0m/PawSQLite.git
npm install -s git+https://git.n0m.org/n0m/PawSQLite-Node-Adapter.git

Usage

For more detailed usage, please see: https://git.n0m.org/n0m/PawSQLite

const PawSQLite = require("pawsqlite");
const PawSQLiteNodeAdapter = require("pawsqlite-node-adapter");

PawSQLite.registerAdapter(PawSQLiteNodeAdapter)

const db = await PawSQLite.open("test", {
  adapter: 'PawSQLiteNodeAdapter'
});

await db.sql(`
  CREATE TABLE contacts (
    contact_id INTEGER PRIMARY KEY,
    first_name TEXT NOT NULL,
    last_name TEXT NOT NULL
  );
`);

const transaction = db.transaction();

console.log(await db.sql("SELECT * FROM contacts"));

await transaction.sql(
  "INSERT INTO contacts (first_name, last_name) VALUES (?, ?)",
  "John",
  "Lennon"
);

await transaction.commit();

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

License

MIT