0.0.14 • Published 2 years ago

floopi v0.0.14

Weekly downloads
-
License
ISC
Repository
-
Last release
2 years ago

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)
})
0.0.14

2 years ago

0.0.13

2 years ago

0.0.12

2 years ago

0.0.11

2 years ago

0.0.10

2 years ago

0.0.23

2 years ago

0.0.2

2 years ago

0.0.1

2 years ago

1.0.2

2 years ago

1.0.1

2 years ago

1.0.0

2 years ago