wires-mysql v0.0.7

wires-mysql

About

An API to mysql database, using mongolike queries

Usage

Connection

var mosql = require('wires-mysql');

mosql.connection.createPool({
    host : '', user : '', password : '', database : ''
})

Schema

All operations require schema, there is an example how to do it:

var usersSchema = {
    id: {},
    name: {},
    email : {},
    age : { type : 'int'}
}

When synced, id is created automatically, it does not matter whether it's preset there or not It will be created with autoincrement option.

Sync schema

Sync accepts a list of objects. Let's say, we have

var tables = [{
    name: "users",
    schema: schema
}]

Then kick of sync process:

var sync = new mosql.schema.Sync(tables);
sync.start(function() {
	// We are done
})

Columns

Col length

To specify column length, provide it within parentheses. E.g varchar(255). Default values are below:

Default maxlength

Columns

Along with native mysql column types, here are some helpers

If you are planning on putting javascript object, don't forget to set json column type, otherwise value will be recognized as a simple string

Operations

var Operation = mosql.operations.Operation;

Insert

var insert = Operation.provide("users", "insert", schema);
insert.setData({
    name: "Test",
    email: "test@example.com",
    age: 31
});
insert.request(function(err, newid){
    console.log(err || newid);
})

Update

var update = Operation.provide("users", "update", schema);
update.setData({
    name: "Ivan11",
    email: "ivan@sukka.com",
    age: 30
}).where({id : 1}).request(function(){

});

Select

var select = Operation.provide("users", "select", schema);
select.where({
    id: {
        $gt: 1
    }
}).order({
    id: 'desc'
}).limit(1).offset(1).group(['name'])
select.request(function(err, res) {
    console.log(err||res);
});