The datalayer-js is a persistent abstraction component of your database that serverless-mysql has prepared instructions for performing common routines such as registering, reading, editing, and removing data.

• Easy to set up (Fácil de configurar)
• Total CRUD abstraction (Abstração total do CRUD)
• Create safe models (Crie de modelos seguros)

DataLayer-js is available via NPM:

  npm i db-datalayer-js

on the root of the project create a .env file with the following contents.

  DRIVER = mysql
  HOST = <YOUR HOST>
  PORT = 3306
  USER = <YOUR USER>
  PASSWORD = <YOUR PASS>
  DATABASE = <YOUR DATABASE>

then you create a folder named models, create a model like this:

  import DataLayer from "db-datalayer-js";

  class User extends DataLayer {
    constructor() {
        // entity, required, primary and timestamps
        super("users", [], "id", true)
    }
  }

Now you are ready to use the datalayer function :D

• find

  This is a select from your database

  await user.find().fetch() // same: SELECT * FROM users

  example with all params

  await user.find({ 
    entity_nickname: "user",
    columns: ["user.username", "users_roles.name as role"],
    joins: [{
      type: "left",
      table: "users_roles",
      conditions: ["user.role_id = users_roles.id"]
    }],
    where: [
      "user.username = 'teste'"
    ],
    limit: 1,
    group_by: "user.id",
    order_by: "user.id"
  }).fetch(true)

• findById

   await user.findById(7).

• create

   await user.create({
     name:  "value",
   }).save()
  
   // Multiple lines insert
  
   await produtos.create([
     {code:"000", name:"teste 1",value: 1.5},
     {code:"001", name:"teste 1", value: null},
   ]).save();

• update

   await user.update({
     name:  "value",
   })

• delete

  let current_user = user.findById(4);
  // param is bool, default value is false and it will update your deleted_at column in your database.
  // when is true the method will delete the current_user
  current_user.destroy() 

you can do it just make a pull request, I'll be happy XD