Sutando is an object-relational mapper (ORM) that makes it enjoyable to interact with your database. When using Sutando, each database table has a corresponding "Model" that is used to interact with that table. In addition to retrieving records from the database table, Sutando models allow you to insert, update, and delete records from the table as well.
Heavily inspired by Laravel's ORM Eloquent.
Check the full documentation on https://sutando.org | 中文文档
Let’s take mysql as an example.
Install Sutando and mysql database library
$ npm install sutando mysql2 --save
The easiest way to make SQL queries is to use the Database query builder. It allows you to construct simple and complex SQL queries using JavaScript methods.
const { sutando, Model } = require('sutando');
// Add SQL Connection Info
sutando.addConnection({
client: 'mysql2',
connection: {
host : '127.0.0.1',
port : 3306,
user : 'root',
password : '',
database : 'test'
},
});
const db = sutando.connection();
// Query Builder
const users = await db.table('users').where('age', '>', 35).get();
// ORM
class User extends Model {}
// Query Data
const users = await User.query().where('age', '>', 35).get();
// Insert
const user = new User;
user.name = 'David Bowie';
await user.save();
// Delete
await user.delete();
// Pagination
const users = await User.query().paginate();
// Eager Loading
const users = await User.query().with('posts').get();
// Constraining Eager Loads
const users = await User.query().with({
posts: q => q.where('likes_count', '>', 100)
}).get();
// Lazy Eager Loading
await user.load('posts');
Please ⭐️ this repository if this project helped you
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。