1.5.6 • Published 9 months ago
mysql2-json-sql v1.5.6
mysql2-json-sql
MySQL2 wrapper for Node.js with json interface. Supports prepared transactional
Installing with npm
npm install mysql2-json-sql
Usage
// Include mysql2-json
// for example: schema test_db contains table test
const mysql = require('mysql2-json-sql');
const db = mysql({
host: 'localhost',
user: 'test',
password: '',
database: 'test_db',
waitForConnections: true,
connectionLimit: 5,
queueLimit: 0
});
// use table manually
const test = db.test_db.table('test');
// or load all tables automatically
const tables = await db.test_db.tables();
// after loading table we can use 3 type of code
// #1 get data from table directly
test.find({_id:12},(err,result)=>{
console.log(result);
})
// #2 get data from tables
tables.test.find({_id:12},(err,result)=>{
console.log(result);
})
// #3 get data from db
db.test_db.test.find({_id:12},(err,result)=>{
console.log(result);
})
response
[{ "_id":12, "name": "test" }]
Inserting documents
var data = { _id:13, name: 'world'};
db.test_db.test.insert(data, function (err, newDoc) { // Callback is optional
// newDoc is the newly inserted document, including its _id
// newDoc has no key called notToBeSaved since its value was undefined
});
we can do bulk-insert data also
db.test_db.test.insert([{ _id: 14, name: 'hello' }, { _id: 15, name:'word' }], function (err, newDocs) { // Two documents were inserted in the database // newDocs is an array with these documents, augmented with their _id });
Finding data
// Finding all planets in the solar system
db.test_db.test.find({ name: 'world' }, function (err, docs) {
// docs is an array containing documents Mars, Earth, Jupiter
// If no document is found, docs is equal to []
});
1.5.5
9 months ago
1.5.4
10 months ago
1.5.3
10 months ago
1.5.2
10 months ago
1.5.1
10 months ago
1.5.0
10 months ago
1.4.9
10 months ago
1.4.8
10 months ago
1.5.6
9 months ago
1.4.6
11 months ago
1.4.7
11 months ago
1.4.5
1 year ago
1.4.4
1 year ago
1.4.3
1 year ago
1.4.2
1 year ago
1.4.1
1 year ago
1.3.7
1 year ago
1.3.6
1 year ago
1.4.0
1 year ago
1.3.5
1 year ago
1.3.4
1 year ago
1.3.3
1 year ago
1.3.2
1 year ago
1.3.1
1 year ago
1.3.0
2 years ago
1.2.7
3 years ago
1.2.6
3 years ago
1.2.5
3 years ago
1.2.4
3 years ago
1.2.3
3 years ago
1.2.0
4 years ago
1.2.2
4 years ago
1.2.1
4 years ago
1.1.0
4 years ago
1.0.5
4 years ago
1.0.4
4 years ago
1.0.3
4 years ago
1.0.2
4 years ago
1.0.1
4 years ago
1.0.0
4 years ago