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.
1.2 KiB
1.2 KiB
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.