Gravitybot SQL !

Installation

npm install @gravitybot/sql

Required

• MySQL 2

How to use?

@gravitybot/sql Is a simple module that includes simplified functions of the mysql module

This is an example usage of our package

// Import the module
const mysql = require("@gravitybot/sql");

// Create a connection
mysql.createConnection({
  host: "localhost",
  user: "root",
  database: "test",
  password: "mysecretpassword",
});

// Create a Model
const user = new mysql.Model("users", {
  // Default Values
  userId: 1,
  username: "User",
  age: 18,
});

// Export data from Model
const me = await user.findOne({ username: "eyun-dev" });

// Console the data
console.log(me);

CONSOLE:

{
  userId: 1,
  username: "eyun-dev",
  age: 18
}

Function	Description	Params
create	To create a new data in the table	values (optional)
find	To get an array of requested data	where (optional)
findOne	To get an object of requested data	where (optional)
findOneAndDelete	To delete some data from the table	where
findOneAndUpdate	To update some data in the table	where , values