const lite = require("lite-manager")
const sql = new lite.lite("./tmp.db",{ getType: "promisse" } )
const table = sql.connect("tname", {
name: {
type: "TEXT"
},
});
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!"
})
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)
})
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)
})
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)
})
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})
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})
- note you can also use :memory: database
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
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()
},
});
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()
},
});
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()
},
});
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()
},
});
const lite = require("lite-manager")
const liteRun = lite.run
const Run = new liteRun(":memory:")
Run.run(".show")
- under development
- 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
- 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