1.4.2 • Published 6 years ago
stackerjs-orm v1.4.2
Database: ORM
An ORM to be used inside and outside StackerJS
Preparing
Entities must be configured:
// Entities/User.js
export class User
{
metadata()
{
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
import { User } from './../Entities/User';
export class UserRepository
{
constructor()
{
this.entity = new User();
}
}
Inserting
let user = new User();
user['name'] = 'My Name is...';
let usersRepository = new UserRepository();
usersRepository.save(user)
.then(response => {
if (!response)
console.log(usersRepository.getErrors());
return response;
});
Querying
let usersRepository = new UserRepository();
// Fetching by ID
let user = await usersRepository.findById(1);
// Fetching one by filter as string
let user = await usersRepository.findOne("active = 1");
//Fetching many by filter as object
let user = await usersRepository.findAll({
'active': { 'eq': true } // or 'active': [ 'eq', true ]
});
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 |
1.4.2
6 years ago
1.4.1
6 years ago
1.4.0
6 years ago
1.3.0
6 years ago
1.2.0
6 years ago
1.1.10
6 years ago
1.1.9
6 years ago
1.1.8
6 years ago
1.1.7
6 years ago
1.1.6
6 years ago
1.1.5
6 years ago
1.1.4
6 years ago
1.1.3
6 years ago
1.1.2
6 years ago
1.1.1
6 years ago
1.1.0
6 years ago
1.0.11
6 years ago
1.0.10
6 years ago
1.0.9
6 years ago
1.0.9-beta.1
6 years ago
1.0.8
6 years ago
1.0.7
6 years ago
1.0.6
6 years ago
1.0.5
6 years ago
1.0.4
6 years ago
1.0.3
6 years ago
1.0.2
6 years ago
1.0.1
6 years ago
1.0.0
6 years ago