orm-ts
Install
npm i orm-ts --save
Example
a simple example
service:
@register()
export class ActivityService {
@lazyInject()
private acitvityDomain: ActivityDomain;
async getById(id: number) {
return this.acitvityDomain.getById(id);
}
}
domain:
@register()
export class ActivityDomain extends BaseDomain {
@lazyInject()
repository: ActivityRepository;
async getById(id: number) {
return this.repository.getById(id);
}
}
repository:
@repository(ActivityModel)
export class ActivityRepository extends BaseRepository<ActivityModel> {
}
@repository(UserModel)
export class UserRepository extends BaseRepository<UserModel> {
@cachePut((username: string) => `user_${username}`, { expiredTime: 30 * 60 })
@bindSql(`select * from #table# where username = #username#`, { page: false })
async getByUsername(username: string) {
// SQL
return new UserModel(this.queryOne(`
xxxxxxxx
`, arguments));
}
async add(model: UserModel) { }
@cacheEvict((username: string) => `user_${username}`)
async updateByUsername(username: string, model: UserModel) { }
@cacheEvict((username: string) => `user_${username}`)
async deleteByUsername(username: string) { }
}
domain:
export class ActivityModel extends BaseModel {
id: number;
@manyToOne('owner', UserModel, 'getByUsername')
user: Promise<UserModel>;
@manyToOne('teamId', TeamModel)
team: Promise<TeamModel>;
}
export class UserModel extends BaseModel {
id: number;
@valid([
{ minLength: 10 },
{ custom: (str: string) => true, errorMsg: 'xxx' }
])
username: string;
}