ormysql v0.0.8

ORMySQL

ORMySQL is a basic ORM for MySQL

Installation

$ npm i ormysql

Configure connection

const ormysql = require("ormysql");

const config = {
    host     : 'localhost',
    user     : 'root',
    password : '',
    database : 'test'
}
ormysql.connect(config);

Create a Model

let User = new ormysql.Model("user", {
    use_id:{
        type:Number,
        auto_increment:true,
        key:"PRIMARY KEY"
    },
    use_username:String,
    use_edad:Number,
    use_joined_at:Date
});

Basic methods

//List All
User.findAll().then(res => {
    console.log(res)
});

//Find One
User.findOne({use_id:1}).then(res => {
    console.log(res);
});

//Save
User.save({
    use_username:"john_doe",
    use_email:"john_doe@gmail.com",
    use_joined_at:new Date()
}).then(res => {
    console.log(res)
});

//Update
User.update(
    {
        use_id: 1,
        use_username: 'john_doe_999',
    }
);

//Delete
User.delete({use_id:1}).then(res => {
    console.log(res);
});

// Execute a raw query
User.executeRawQuery("select * from user where use_id<=5").then(res=>{
    console.log(res);
});

Todos

• Write MORE Tests
• Add more methods (Find multiple)

License

MIT