1.5.6 • Published 9 months ago

mysql2-json-sql v1.5.6

Weekly downloads
-
License
ISC
Repository
github
Last release
9 months ago

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