pro.sql

• This package was created by NoonServ.com
• This package gives you the best SQL shortcuts at no cost
• NoonServ Support Team

Installation

npm i pro.sql
npm i mysql2

Playback Method

1 - Create an app.js file

2 - You need to add the following codes

const mysql2 = require("mysql2");
const SQL = require("pro.sql");
require('colors')

let data = {
    host: '...',
    database: '...',
    user: '...',
    password: '...',
    port: 3306
}

const connection = mysql2.createConnection({
    host: data.host,
    database: data.database,
    user: data.user,
    password: data.password,
    password1: data.password,
    password2: data.password,
    password3: data.password,
    port: data.port
})

connection.connect(function (err) {
    if (err) throw err;
    console.log("Connected!");
});

... // Add required commands here! such as( createTable, deleteTabel, add, get, and more... )

Create Table

(async () => {
    let data = await SQL.createTable(connection, 'users', ['name', 'email', 'password'])
    return console.log(data) // { code: 0, message: 'TABLE_CREATED' }
})();

Delete Table

(async () => {
    let data = await SQL.deleteTable(connection, 'users')
    return console.log(data) // { code: 0, message: 'TABLE_DROP' }
})();

Add

(async () => {
    let data = await SQL.add(connection, 'users', { name: 'Jake Smith', email: '[e-mail]', password: '123456' });
    return console.log(data) // { code: 0,  message: 'INSERT_ADD', result: ResultSetHeader { ... } }
})();

Get

(async () => {
    let data = await SQL.get(connection, 'users', 1);
    return console.log(data) // { code: 0, message: 'INSERT_GET', result: { ... } }
})();

All

(async () => {
    let data = await SQL.all(connection, 'users',)
    return console.log(data) // { code: 0, message: 'INSERT_ALL', result: [ { ... }, { ... }, { ... } ] }
})();

Update

(async () => {
    let data = await sql.update(connection, 'users', 'name', 'NoonServ', 1)
    return console.log(data) // { code: 0, message: 'INSERT_UPDATE', result: ResultSetHeader { ... } }
})();

Delete

(async () => {
    let data = await sql._delate(connection, 'users', 1)
    return console.log(data) // { code: 0, message: 'INSERT_DELETE', result: ResultSetHeader { ... } }
})();

Note

• If data.code is 0, it means the process is successful, if it is 1, it means there is an error, and to extract the error data.error
• You need to add a 'mysql2' cage to your sql connection first

npm i mysql2

Support

• Discord: in2_yt
• whatsapp: [phone]
• e-Mail: [e-mail]