1.0.7 • Published 5 years ago
sqll v1.0.7
sqll
sqll is a very simple Node.js ORM for MySQL.
Installation
Use the package manager npm
npm i sqll
or yarn
yarn add sqll
to install sqll.
Usage
const {Model} = require('sqll')
class BaseModel extends Model {
getDatabaseConfig() {
return {
host: 'localhost',
user: 'db_user',
password: '12345678',
database: 'my_database',
port: '8889'
}
}
}
class UserModel extends BaseModel {
getTableName() {
return "users"
}
}
class OtherModel extends BaseModel {
getTableName() {
return "others"
}
}
async function run() {
try {
const model = new UserModel()
const [rows, fields] = await model.query("select * from users")
console.log(rows)
} catch (err) {
console.log(err)
}
}
Contributing
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.