sync-sql

sync-sql is designed to make synchronous queries to the database. It has been developed as a tool to help nightwatch.js tests - or other such tools - connect directly to an sql database.

Important note

!!! You should not be using this in a production evironment. Node.js is designed to be asynchronous, therefore running sync queries on the database will seriously impact performance and stability.

Install

``
npm install sync-sql
`

For using the latest version with bug fixes, try the command:

`
npm install cristidraghici/sync-sql
`

Example usage with mysql

`js
var syncSql = require('sync-sql');

var output = syncSql.mysql(
{
host: 'localhost',
user: 'user',
pass: 'password',
database: 'database',
port: '3306'
},
"select * from users"
);

console.log(JSON.stringify(output));
`

Testing

- please edit the .env.example with database information and the sql to test and save the file as .env;
- run npm install;
- run npm run test-mysql;
- run npm run test-pg;
- run npm run test`.

Workflow

Internally, this uses a separate worker process that is run using childProcess.spawnSync.

The worker then makes the actual query using the mysql and pg packages.

Thanks

Thanks to sync-request / Forbes Lindesay for providing the base knowledge for this package.

License

MIT