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

• still in development

bye bye!