mysql-format

MySQL Format

Simplified MySQL Promises Package Coded In TypeScript

Installation

npm

  npm i mysql-format

Functions

Type	Usage
arrayResults	getAll()
arrayResults	getByFiled({...FilterFiled})
jsonResults	getOneByFiled({...FilterFiled})
boolResults	createOne({...NewField},customQuery?, ...args)
boolResults	updateOne({...FilterFiled}, {...NewFiled}, customQuery?, ...args)
boolResults	deleteOne({...FilterFiled})
boolResults	deleteAll()
evalResults	evalAsync("SQL QUERY", ...args)
callback	eval("SQL QUERY", (err, data)=> void, ...args)

Usage/Examples

import { Connection } from "mysql-format";

let connection = new Connection(
  {
    port: 3308,
    user: "username",
    password: "password",
    host: "localhost",
    database: "database",
  },
  {
    printErrors: false,
    throwErrors: true,
  }
);

async function Test() {
  let results = await db.evalAsync("SELECT * FROM quizServers");
  let parsed = JSON.parse(results.results[0].connections);
  const newJson: any[] = [];
  for (const i in parsed) {
    let data = parsed[i];
    if (!newJson.find((e) => e.id == data.id)) {
      newJson.push(data);
    }
  }
  newJson.push({
    id: 555,
    position: 8,
  });
  let data = await db.evalAsync(
    `UPDATE quizServers SET connections=? WHERE id="25"`,
    JSON.stringify(newJson.sort((a, b) => a.position - b.position))
  );
  console.log(data.results);
}

async function Test() {
  const model = db.useModel("accounts");
  let results = await model.getAll();
  console.log(results.results); // any[]
}

Author

• @orjdev

License

ISC