import { createEngine, createModel, dp } from 'magicorm'
import '@magicorm/driver-mysql'
const User = createModel({
id: dp('int')
.comment('用户 id')
.primary.notnull.autoinc,
username: dp('varchar(16)')
.comment('用户名')
.unique.notnull,
nickname: dp('varchar')
.comment('昵称')
.notnull
})
const engine = createEngine({
driver: 'mysql',
driverOptions: {
url: 'mysql://root:@localhost/demo'
}
})
const u1 = new User({
nickname: 'test001',
username: 'test001'
})
const u2 = new User({
nickname: 'test002',
username: 'test002'
}, false)
const u = await User.query
.where(User.id.gte(1))
.first()
await u.update({ nickname: 'demo001' })
u.nickname = 'demo002'
await u.save()
兼容 sqlite, mongodb, postgresql, mysql
调用足够简单,使用要符合直觉
目的是给一个统配化的 ORM ,目前想到的应用场景有: