Flat file database
npm install simple-ffdb
> npm install --save simple-ffdb
`
$3
Database Doc
Simple Initialization
`javascript
let Database = require("simple-ffdb");
let database = new Database("database_directory", password?);
if (!database.initialized) {
database.initialize() / Generate folder and file structure in indicated directory /;
}
`
$3
`
$ node
> require("simple-ffdb").init(name, password?);
> .exit
`
Simple Usage
`javascript
/ Create Table selects the created table for modification /
database.createTable("users", ["username", "password", "email"]);
/ Insert a row /
database.insertRow("richardred15", "password", "richardred15@gmail.com");
/ All row values are not required /
database.inserRow("eric", "password");
/ Insert with key/value pairs /
database.insertRow({
username: "foo",
email: "baz@example.com",
password: "bar"
})
/ Insert an empty row /
database.insertRow();
/ Set columns in a row where column value matches /
database.updateRows(
/ New Values /
{
password: "new_password"
},
/ Where column matches /
{
username: "richardred15"
}
)
/ Delete a row where columns have value, returns deleted rows /
let deleted = database.deleteRows({
username: "foo"
})
`
deleted:
`
[
{
username: 'foo',
password: 'bar',
email: 'baz@example.com'
}
]
`
`javascript
database.selectTable("users")/ Switch to table /;
let user_data = database.searchColumn("username", "richardred15");
`
user_data:
`
[
{
username: 'richardred15',
password: 'new_password',
email: 'richardred15@gmail.com'
}
]
`
`javascript
let rows = database.getRows();
`
rows:
`
[
[ 'richardred15', 'new_password', 'richardred15@gmail.com' ],
[ 'eric', 'password', '' ],
[ '', '', '' ]
]
``