Lite-manager NPM

lite-manager sqlite database manager

Now you no longer need to inform the model because the self model program now!

create a table

const lite = require("lite-manager")
const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
const table = sql.connect("tname", {
  name: {
    type: "TEXT"
  },
});

insert into a table

 const lite = require("lite-manager")
 const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
 const table = sql.connect("tname", {
   name: {
     type: "TEXT"
   },
 });
 table.create({
   name: "Hello World!"
 })

get all values

 const lite = require("lite-manager")
 const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
 const table = sql.connect("tname", {
   name: {
     type: "TEXT"
   },
 });
 table.getAll().then(data => {
   console.log(data)
 })

get values by id

 const lite = require("lite-manager")
 const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
 const table = sql.connect("tname", {
   name: {
     type: "TEXT"
   },
 });
 table.getById(1).then(data => {
   console.log(data)
 })

get one value

 const lite = require("lite-manager")
 const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
 const table = sql.connect("tname", {
   name: {
     type: "TEXT"
   },
 });
 table.getOne({name: "Hello!"}).then(data => {
   console.log(data)
 })

update value

 const lite = require("lite-manager")
 const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
 const table = sql.connect("tname", {
   name: {
     type: "TEXT"
   },
 });
 table.update({
   name: "Hello!"
 },{id: 1})

delete value

 const lite = require("lite-manager")
 const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
 const table = sql.connect("tname", {
   name: {
     type: "TEXT"
   },
 });
 table.delete({id: 1})

aditional

note you can also use :memory: database

add a base64 str

const lite = require("lite-manager")
 const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
 const table = sql.connect("tname", {
   file: {
     type: "TEXT",
   },
 });
 const liteTypes = lite.types
 table.create({
   file: liteTypes.base64("./example_img.png")
 })

note you can add anything in base64

tables value models

text

 const lite = require("lite-manager")
 const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
 const liteTypes = lite.types
 const table = sql.connect("tname", {
   file: {
     type: liteTypes.text()
   },
 });

real

 const lite = require("lite-manager")
 const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
 const liteTypes = lite.types
 const table = sql.connect("tname", {
   file: {
     type: liteTypes.real()
   },
 });

integer

 const lite = require("lite-manager")
 const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
 const liteTypes = lite.types
 const table = sql.connect("tname", {
   file: {
     type: liteTypes.integer()
   },
 });

blob

 const lite = require("lite-manager")
 const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
 const liteTypes = lite.types
 const table = sql.connect("tname", {
   file: {
     type: liteTypes.blob()
   },
 });

run query

 const lite = require("lite-manager")
 const liteRun = lite.run
 const Run = new liteRun(":memory:")
 Run.run(".show")

under development

options

getTypes

getTypes will define how you want to get the values

example 1

const lite = require("lite-manager")
const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
const liteTypes = lite.types
const table = sql.connect("tname", {
  file: {
    type: liteTypes.text()
  },
});
table.getAll().then(pr => console.log(pr))

* you will use .then in the promise
* example 2

const lite = require("lite-manager") const sql = new lite.lite("./tmp.db",{ getType: "value" } ) const liteTypes = lite.types const table = sql.connect("tname", { file: { type: liteTypes.text() }, }); var values = table.getAll() console.log(values)

* you will use a function in value
* example 3

const lite = require("lite-manager") const sql = new lite.lite("./tmp.db",{ getType: "callback" } ) const liteTypes = lite.types const table = sql.connect("tname", { file: { type: liteTypes.text() }, }); table.getAll(data => { console.log(data) })

* you will use callback in this

# the asynchronous mode
* asynchronous mode works in a way that You can use multiple functions at the same time note that get used callbacks
* example

const lite = require("lite-manager") const sql = lite.sync("./tmp.db","table_name")

sql.create({name:"Hello"}) .update({name:"Hello World!"},{name:"Hello"}) .delete({name:"Hello World!"}) .getAll(cb => { console.log(cb) // { rows: {name: "Test" } , size: 1 } })