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!