@chego/chego-mysql

chego-mysql

This is a MySQL driver for Chego library.

Install

npm install --save @chego/chego-mysql

Usage

Create a new Chego object using the mysqlDriver and configuration object.

const { newChego, newQuery } = require("@chego/chego");
const { chegoMySQL } = require("@chego/chego-mysql");
const chego = newChego(chegoMySQL, {
  host     : 'localhost',
  user     : 'foo',
  password : 'bar',
  database : 'some_db'
});

...

const query = newQuery();

await chego.connect();

query.select('*').from('superheroes').where('origin').is.eq('Gotham City').limit(10);

chego.execute(query)
.then(result => { 
    console.log('RESULT:', JSON.stringify(result));
    chego.disconnect();
})
.catch(error => { 
    console.log('ERROR:', error); 
    chego.disconnect();
});

...

Under the hood it uses Node.js MySQL module, so please refer to this link for more information on the configuration.

For more information on how Chego works with database drivers, please read Chego Usage guide.

Tips

Transactions

It is possible to run multiple queries in one call. In chego-mysql these queries are set in the transaction statement. More information about transactions can be found here.

Contribute

There is still a lot to do, so if you want to be part of the Chego project and make it better, it's great. Whether you find a bug or have a feature request, please contact us. With your help, we'll make it a great tool.

How to contribute

Follow our kanban boards to be up to date

Kanban board

Join the team, feel free to catch any task or suggest a new one.

License

Copyright (c) 2019 Chego Team

Licensed under the MIT license.