@orjdev/mysqm

Installation

Using NPM

  npm i @orjdev/mysqm

initialize

import mySQM from "@orjdev/mysqm";

let client = new mySQM.Client({
  port: 3306,
  user: "",
  password: "1234567",
  host: "localhost",
  database: "",
});

You Can Use Custom Types Too

type IExpectedResults = { id: number; username: string };
let userModel = client.useModel("users");

Event Listener

type IEvents =
  | "connected"
  | "disconnected"
  | "result"
  | "error"
  | "end"
  | "fields"
  | "packet";
client.on("connected", () => console.log("connected"));

Get One

let query = {
  where: {
    id: {
      eq: 1,
    },
  },
};
let resp = await userModel.findOne<IExpectedResults>(query);

Get All

let query = {
  where: {
    username: {
      eq: "test",
    },
  },
};
let resp = await userModel.findAll<IExpectedResults>(query);

Update One

let query = { where: { id: { eq: 1 } } };
let newFields = {
  username: {
    default: "newUsername",
  },
  perms: {
    special: JSON.stringify({ test: true }),
  },
};
let resp = await userModel.updateOne(query, newFields);

Delete

let query = { where: { id: { eq: 1 } } };
let resp = await userModel.delete(query);

Create One

let newFields = { username: { default: "test" } };
let resp = await userModel.createOne(newFields);