1.2.0 • Published 6 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
6 years ago
1.1.20
6 years ago
1.1.17
6 years ago
1.1.16
6 years ago
1.1.15
6 years ago
1.1.13
6 years ago
1.1.12
6 years ago
1.1.11
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.0
6 years ago