Database: ORM
An ORM to be used inside and outside StackerJS
Preparing
Entities must be configured:
// Entities/User.js return 'table': 'users' 'fields': 'name': 'id' 'type': 'pk' 'name': 'name' 'type': 'string' 'required': true 'name': 'active' 'type': 'boolean' 'default': true 'relations':
And then Repository is declared:
// Repositories/UserRepository.js; { thisentity = ; }
Inserting
let user = ;user'name' = 'My Name is...'; let usersRepository = ;usersRepository ;
Querying
let usersRepository = ; // Fetching by IDlet user = await usersRepository; // Fetching one by filter as stringlet user = await usersRepository; //Fetching many by filter as objectlet user = await usersRepository;
Comparisions
Term | MySQL Term | Description |
---|---|---|
eq | = | Looks for exactly equal results |
neq | <> | Looks for exactly different |
gt | > | Looks for greater values |
gte | >= | Looks for greater or equal values |
lt | < | Looks for lower values |
lte | <= | Looks for lower or equal values |
in | IN | Looks for values inside array |
nin | NOT INT | Looks for values not inside array |