DerpyDB
Basic code
const Database = require('derpydb');
// SQlite
const db = new Database({ uri: 'sqlite://db.sqlite' });
// MySQL
const db = new Database({ uri: 'mysql://user:pass@host/dbname' });
new Database([options])
-
options.uri
: specific uri to connect (default:sqlite://db.sqlite
).
Creates a new database connection.
const db = new Database({ uri: "sqlite://db.sqlite" });
.createTable([options])
Get the data from given id or id and target
-
options.table
: specific table name to create (default:main
).
db.createTable({ table: 'players' }); // true
.get(id, [options])
Get the data from given id
-
options.table
: specific table in the database (default:null
). -
options.target
: specific a target to be get (default:null
).
// without target
const data = db.get('derpy', { table: 'info' }); // { name: "Derpy", age: 19 }
// with target
const data = db.get('derpy', { table: 'info', target: 'age' }); // 18
const data = db.get('derpy.age', { table: 'players' }); // 18
.set(id, value, [options])
set new data to given id
-
options.table
: specific table in the database (default:null
). -
options.target
: specific a target to be set (default:null
).
db.set('derpy.age', 20, { table: 'info' }); // 20
.has(id, [options])
find if the given id is exits
-
options.table
: specific table in the database (default:null
). -
options.target
: specific a target to find (default:null
).
db.has('derpy.age', { table: 'info' }); // true
.type(id, [options])
find the type of the given id
-
options.table
: specific table in the database (default:null
). -
options.target
: specific a target to find type (default:null
).
db.type('derpy.age', { table: 'info' }); // number
.startsWith(string, [options])
find the list datas that starts with the given string
-
options.table
: specific table in the database (default:null
).
db.startsWith('der', { table: 'info' }); // [{ id: 'derpy', value: { name: "Derpy", age: 19 }}]
.add(id, number, [options])
add number value to the given id
-
options.table
: specific table in the database (default:null
). -
options.target
: specific a target to be added the number (default:null
).
db.add('derpy.age', 1, { table: 'info' }); // 20
.remove(id, number, [options])
remove number value from the given id
-
options.table
: specific table in the database (default:null
). -
options.target
: specific a target to be removed the number (default:null
).
db.remove('derpy.age', 1, { table: 'info' }); // 18
.push(id, value, [options])
push new item value to the given id
-
options.table
: specific table in the database (default:null
). -
options.target
: specific a target to be pushed in to (default:null
).
db.get('derpy.list', { table: 'info' }); // ['banana', 'grape']
db.push('derpy.list', 'apple', { table: 'info' }); // ['banana', 'grape', 'apple']
.pull(id, value, [options])
pull item value from the given id
-
options.table
: specific table in the database (default:null
). -
options.target
: specific a target to be pulled from it (default:null
).
db.get('derpy.list', { table: 'info' }); // ['banana', 'grape', 'apple']
db.pull('derpy.list', 'grape', { table: 'info' }); // ['banana', 'apple']
.delete(id, [options])
delete value from the given id
-
options.table
: specific table in the database (default:null
). -
options.target
: specific a target to be deleted from it (default:null
).
db.delete('derpy', { table: 'info' }); // true
.all([options])
get list of databases in specific table
-
options.table
: specific table in the database (default:null
).
db.all({ table: 'info' }); // [{ id: 'derpy', value: { name: 'Derpy', age: 19 }}]
.deleteAll([options])
delete all the databases from specific table
-
options.table
: specific table in the database (default:null
).
db.deleteAll({ table: 'info' }); // []
.tables()
get the list of the tables you created
db.tables(); // ['info']
.deleteTable([options])
delete specific table
-
options.table
: specific table in the database (default:null
).
db.deleteTable({ table: 'info' }); // true
.getTable([options])
get specific table information
-
options.table
: specific table in the database (default:null
).
db.getTable({ table: 'info' }); // { table: 'info', id: 'TEXT', value: 'TEXT' }
.db
run code through sqlite
db.db.prepare('SELECT * FROM info WHERE id = (?)').get('derpy')