2.3.4 • Published 5 years ago
sync-mysql-database v2.3.4
nodejs-sync-mysql-database
A NodeJS package to manage a MySQL Database Synchronously (this is a wrapper around sync-mysql package)
Installation
npm install --save sync-mysql-database
Usage (Skeleton)
- auth.json
{
"user": "username",
"host": "localhost",
"password": "password",
"database": "sampleDatabase"
}
*Note: The database field is required unlike in sync-mysql where you can use USE <DATABASE>
query.
- structure.json
{
"version": "1",
"tables": [
{
"name": "users",
"columns" : [
{"name": "id", "type": "INTEGER", "constraints": "auto_increment"},
{"name": "username", "type": "varchar(20)"},
{"name": "password", "type": "char(20)"}
],
"primary_key": "id"
}
]
}
- main.js
const Database = require("sync-mysql-database").Database;
const auth = require("./auth.json");
const struct = require("./structure.json");
var sampleDatabase = new Database(auth, struct);
sampleDatabase.getTable("users").query().select("username", "password").insert("user1", "password");
console.log(sampleDatabase.getTable("users").query().get());
Reference
2.3.4
5 years ago
2.3.3
5 years ago
2.3.2
5 years ago
2.2.2
5 years ago
2.2.1
5 years ago
2.1.1
5 years ago
2.1.0
5 years ago
2.0.0
5 years ago
1.7.0
5 years ago
1.6.1
5 years ago
1.6.0
5 years ago
1.5.5
5 years ago
1.5.4
5 years ago
1.5.3
5 years ago
1.5.2
5 years ago
1.4.2
5 years ago
1.4.1
5 years ago
1.4.0
5 years ago
1.3.0
5 years ago
1.2.1
5 years ago
1.1.1
5 years ago
1.1.0
5 years ago
1.0.0
5 years ago