yy-orm

Getting Started

var orm = require("yy-orm");

Create Database Object

var opt = { host: 'localhost', user: 'root', password: 'root', database: 'test' }; var db = orm.create(opt);

Define Schema

var def = { id: type.id(), name: type.varchar(32).unique(), alias: type.varchar("Rookie"), rank: type.integer().default(0), registTime: type.datetime().notNull(), }; var User = db.define("User", def);

Type

integer varchar datetime

Props

default length

Constraint

notNull unique

Cond

Simple Cond

eq ne gt lt gte lte in nin between

Combined Cond

and or

Decorate Cond

asc desc limit

batch update but has delete...