sqlitebruv
v1.0.20
Published
A Simple and Efficient Query Builder for D1 and Bun's SQLite
Downloads
446
Maintainers
Readme
SqliteBruv
A Fast and Easy Query Builder for Cloudflare's D1
Lightweight, SQLite query builder designed to simplify database interactions and optimize performance. Key Features:
- Works with cloudflare D1.
- Works with bun's Inbuilt SQLite.
- Simple Query Building: Construct queries with ease.
- Parameterized Queries: Prevent SQL injection attacks.
- Provides raw query.
Installation
Install sqlitebruv with npm
npm install sqlitebruv
Usage/Examples
import { SQLiteBruv } from "SQLiteBruv";
// Example usage:
const db = Database.open("database.db");
db.run(`
CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
email TEXT NOT NULL,
age INTEGER,
country TEXT
);
`);
const queryBuilder = new SqliteBruv({
db, //? or
D1: {
accountId: "xxx",
databaseId: "xxx",
apiKey: "xxx",
}, //? or nothing to get the query instead
});
// Insert
await queryBuilder
.from("users")
.insert({ name: "John Doe", email: "[email protected]" })
.then((changes) => {
// console.log({ changes });
});
// Update
await queryBuilder
.from("users")
.where("id = ?", 1)
.update({ name: "Jane Doe" })
.then((changes) => {
// console.log({ changes });
});
// Search
await queryBuilder
.from("users")
.where("id = ?", 1)
.andWhere("name LIKE ?", `%oh%`)
.get()
.then((changes) => {
// console.log({ changes });
});
// Delete
await queryBuilder
.from("users")
.where("id = ?", 1)
.delete()
.then((changes) => {
console.log({ changes });
});
// Get all users
queryBuilder
.from("users")
.get()
.then((changes) => {
// console.log({ changes });
});
// Get one user
await queryBuilder
.from("users")
.where("id = ?", 1)
.getOne()
.then((changes) => {
// console.log({ changes });
});
// Select specific columns
await queryBuilder
.from("users")
.select("id", "name")
.get()
.then((changes) => {
// console.log({ changes });
});
// Where conditions
await queryBuilder
.from("users")
.where("age > ?", 18)
.get()
.then((changes) => {
// console.log({ changes });
});
// AndWhere conditions
await queryBuilder
.from("users")
.where("age > ?", 18)
.andWhere("country = ?", "USA")
.get()
.then((changes) => {
// console.log({ changes });
});
// OrWhere conditions
await queryBuilder
.from("users")
.where("age > ?", 18)
.orWhere("country = ?", "Canada")
.get()
.then((changes) => {
// console.log({ changes });
});
// Limit and Offset
await queryBuilder
.from("users")
.limit(10)
.offset(5)
.get()
.then((changes) => {
// console.log({ changes });
});
// OrderBy
await queryBuilder
.from("users")
.orderBy("name", "ASC")
.get()
.then((changes) => {
// console.log({ changes });
});
await queryBuilder
.from("users")
.orderBy("name", "ASC")
.get()
.then((changes) => {
// console.log({ changes });
});
License
Contributing
Contributions are always welcome! creates issues and pull requests.