Important: This documentation covers Yarn 1 (Classic).
For Yarn 2+ docs and migration guide, see yarnpkg.com.

Package detail

sqll

kmltrk16MIT1.0.7TypeScript support: included

sqll is a very simple Node.js ORM for MySQL.

readme

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.

License

MIT