JSPM

const sql = require('mxtorie')

const db = new sql.database({
    host: '127.0.0.1',
    user: 'admin',
    pass: 'mysecretpass',
    database: 'local',
    port: 3306 //if you don't give any port the database will be connected trought the port 3306
}, {
    myfirsttable: [{
        name: 'message',
        type: sql.datatype.VARCHAR,
        length: 255
    }, {
        name: 'people',
        type: sql.datatype.INT,
        length: 255
    }],
    mysecondtable: [{
        name: 'onlyonecolumn',
        type: sql.datatype.JSON
    }]
    //If the tables is not existing in your database they will be created. 
    //If the tables is existing but for example 'people' is not created in the table, the program will add it.
})

db.connectToDb().then(()=>{
    console.log('connected')
}).catch(e=>{
    console.log('Error during the connection : '+e)
})

db.insert('myfirsttable', [{message: 'this is a message', people: 1000}])
//will insert a new line in the table 'myfirsttable' with message = 'this is a message' and people = 1000

db.delete('myfirsttable', [{people: 1000}])
//will delete the line where people is equal to 1000

db.save('myfirsttable', ['message', 'people'], [{message: 'this is a message'}])
//will save the values 'message' and 'people' in the database where 'message' is equal to 'this is a message'

db.saveDeleted('myfirsttable')
//will save all deleted in the database (delete the lines), do this after using : "db.delete()"

db.set('myfirsttable', [{message: 'this is a message'}], 'message', 'this is a new message')
//will change the value of 'message' to 'this is a new message' where 'message' is equal to 'this is a message'

let message = await db.get('myfirsttable', [{people: 1000}], 'message')
//will return an array with all values of 'message' where 'people' is equal to 1000
//return ['this is a message']

let onlyOne = await db.getOne('myfirstttable', [{people: 1000}], 'message')
//will return one value of 'message' where 'people' is equal to 1000
//return 'this is a message'

let all = await db.getAllWhere('myfirsttable', [{message: 'this is a message', people: 1000}])
//will return an array with every data where 'message' = 'this is a message' and 'people' = 1000

let hasThisTable = await db.hasTable('myfirsttable')
//return true if the table is existing in the LOCAL cache or false if not

let has = await db.has('myfirsttable', [{people: 1000}])
//return true if the LOCAL cache have a line where "people" is equal to 1000 or false if not