floopi v0.0.14

Floopi

Floopi is a tool I made because I found myself needing to setup MySQL and pooling often and so it naturally came to be.

Install

npm install --save floopi

Use

Import

const  Floopi  = require("floopi")

ES6

import { Floopi } from "floopi";

Create New Instance

const db = new Floopi({
    host: 'localhost',
    database: 'test',
    user: 'root',
    password: '',
    port: 3306,
})

Write Some Queries

db.query("SELECT * FROM `pets`").then((results)=>{
    console.log(results)
}).catch((e)=>{
    throw e
})

OR

try{ 
    const pets = await db.query("SELECT * FROM `pets`")
    console.log(pets)
}catch (e) {
    throw e
}

Param Binding

db.query("SELECT * FROM `pets` WHERE `type`=?",["cat"]).then((results)=>{
    console.log(results)
})

db.query("SELECT * FROM ?? WHERE `type`=?",["pets","cat"]).then((results)=>{
    console.log(results)
})