Security News
Introducing the Socket Python SDK
The initial version of the Socket Python SDK is now on PyPI, enabling developers to more easily interact with the Socket REST API in Python projects.
Simple Node.js module which allows insert, update and delete mysql queries (Using package mysql)
=========
Simple Node.js mysql module using [mysql] (https://github.com/mysqljs/mysql)
npm install mysql-json
var MysqlJson = require('mysql-json');
var mysqlJson = new MysqlJson(options); // Takes mysql package options
All methods take a callback which is called with 2 parameters (err, response)
// Used to return a mysql connection
mysqlJson.connect(callback);
// Used to launch a query to mysql server
mysqlJson.query(mysqlQuery, callback);
// Used to find a row by primary key
mysqlJson.findByPrimaryKey(tableName, id, callback);
// Used to insert a new row with JSON data
mysqlJson.insert(tableName, dataToInsert, callback);
// Used to update some row(s) matching with JSON conditions
mysqlJson.update(tableName, data, conditions, callback);
// Used to delete some row(s) matching with JSON conditions
mysqlJson.delete(tableName, conditions, callback);
Condition Objects has to be build with this schema :
{
column1: {operator:'=', value:'test'},
column2: {operator:'>', value:29},
}
// Initialization
var MysqlJson = require('mysql-json');
var mysqlJson = new MysqlJson({
host:'127.0.0.1',
user:'root',
password:'root',
database:'myDatabase'
});
// Query method
mysqlJson.query("SELECT * FROM users WHERE login LIKE '%admin%'", function(err, response) {
if (err) throw err;
console.log(response);
});
// Find a document where Primary Key = 1
mysqlJson.findByPrimaryKey('myTable', 1, function(err, response) {
if (err) throw err;
console.log(response);
});
// Insert new document with login=root, firstname=John, lastName=Doe, Age=45
mysqlJson.insert('myTable', {
login:'root',
firstName:'John',
lastName:'Doe',
age:45
}, function(err, response) {
if (err) throw err;
console.log(response);
});
// Update any documents and set lastname=foo, age=47 where login=root
mysqlJson.update('myTable',
{lastName:'Foo', age:27},
{login:{operator:'=', value:'root'}},
function(err, response) {
if (err) throw err;
console.log(response);
});
// Delete any documents where login=root
mysqlJson.delete('myTable', {
login:{operator:'=', value:'root'}
}, function(err, response) {
if (err) throw err;
console.log(response);
});
In lieu of a formal styleguide, take care to maintain the existing coding style. Add unit tests for any new or changed functionality. Lint and test your code.
FAQs
Simple Node.js module which allows insert, update and delete mysql queries (Using package mysql)
The npm package mysql-json receives a total of 400 weekly downloads. As such, mysql-json popularity was classified as not popular.
We found that mysql-json demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
The initial version of the Socket Python SDK is now on PyPI, enabling developers to more easily interact with the Socket REST API in Python projects.
Security News
Floating dependency ranges in npm can introduce instability and security risks into your project by allowing unverified or incompatible versions to be installed automatically, leading to unpredictable behavior and potential conflicts.
Security News
A new Rust RFC proposes "Trusted Publishing" for Crates.io, introducing short-lived access tokens via OIDC to improve security and reduce risks associated with long-lived API tokens.