1.2.0 • Published 5 years ago
soul-orm v1.2.0
npm install soul-orm
const users = await db.table('user').where({ name: 'jake' }).order('age', 'desc').select();
const users = await db.table('user').where('name = ?', ['jake']).limit(10, 20).select();
const user = await db.table('user').where({ name: 'jake' }).field('name', 'age').find();
const user = await db.table('user').where({ name: 'jake' }).findOrEmpty();
// insert
await db.table('user').insert({ name: 'jake', age: '22' });
await db.table('user').insert([{ name: 'jake', age: '22' }, { name: 'jake', age: '22' }]);
// update
await db.table('user').where({ name: 'jake' }).update({ name: 'new name' });
// delete
await db.table('user').where({ name: 'jake' }).delete();
// transaction
const tx = await db.beginTx();
try {
await tx.table('user').insert({ name: 'jake' });
await tx.table('user').where({ name: 'jake' }).update({ name: 'new name' });
await tx.commit();
} catch (error) {
await tx.rollback();
}
// row query
const result = await db.query(`SELECT * FROM user U LEFT JOIN user_roles UR ON UR.user_id = U.id WHERE U.type = ?`, ['type']);
1.2.0
5 years ago
1.1.20
5 years ago
1.1.17
5 years ago
1.1.16
5 years ago
1.1.15
5 years ago
1.1.13
5 years ago
1.1.12
5 years ago
1.1.11
5 years ago
1.1.10
5 years ago
1.1.9
5 years ago
1.1.8
5 years ago
1.1.7
5 years ago
1.1.6
5 years ago
1.1.5
5 years ago
1.1.4
5 years ago
1.1.3
5 years ago
1.1.2
5 years ago
1.1.1
5 years ago
1.1.0
5 years ago
1.0.0
5 years ago