less-sql
A minimal DB layer based on MoSQL[https://github.com/goodybag/mongo-sql]. (postgresql only now)
Install
npm install less-sql --save
Usage
export DATABASE_URL=postgres://localhost/dbname
All functions return promises. Works best in combination with with co;
For more Query syntax, please check the MoSQL document Conditional Helpers[https://github.com/goodybag/mongo-sql/blob/master/docs/conditional-helpers.md]
var lessSQL = // Create Tablevar table = "User"var definition = id: type: 'serial' primaryKey: true name: type: 'text' lessSQL // Drop Table lessSQL // Create Index lessSQL lessSQL lessSQL // unique// or lessSQL // unique index // Find// by query lessSQL// return [{ id:6, name: "tim"}, {id:7}, name:"john"}] // FindOne lessSQL// return {id:5 , name: "Mary"} // Count lessSQL// return 10 // Insert lessSQL// return {id:10, name:"bob"} // Update lessSQL// return [{ id:6, name: "tim"}, {id:7}, name:"tim"}] // Remove lessSQL// return [{ id:6, name: "tim"}, {id:7}, name:"john"}] // Transaction// create a new transactionvar tx = lessSQL //do some works in the transanction , update , delete, .. tx // commit tx // or rollback tx // warning: You should not use the transaction after it commit or rollback. The connection to postgres server of the transaction is closed after that. // Json Query buildervar usersQuery = type: 'select' table: 'users' where: $or: id: 5 name: 'Bob' ; var result = lessSQL; result // select "users".* from "users" where "users.id" = $1 or "users"."name" = $2 resultvalues// Array of values