an SQLite helper for esoftplay developer
npm install react-native-esoftplay-db
note : this module require to install expo first
`#### Instalation
1. install the npm package
`
npm install --save react-native-esoftplay-db
`
2. Create class extends Helper (simple example)
`
export default class Event extends Helper {
*require
// table name
static table = 'event' // fields
static id = 'id'
static title = "title";
static intro = "intro";
static description = "description";
static image = "image";
static created = "created";
static url = "url";
sql = "CREATE TABLE IF NOT EXISTS '" + Event.table + "' (" + this.getSQLFormat() + ")"
//*require
constructor() {
super();
this.init(Event.table, this.sql)
}
//*require
getColumn() {
return [Event.id, Event.title, Event.intro, Event.description, Event.image, Event.created, Event.url]
}
}
`
3. done#### Usage
###### CREATE OBJECT FROM DB
`
var db = new Event()
`
###### INSERT
`
db.Insert(values, insertId, debug)
`
Arguments
- values (object) - object with key-value to insert
- insertId (callback) - callback with 1 param (insertId)
- insertId: last id after insert
- debug(0|1) : console log db process default 0
###### UPDATE
`
db.Update(id, values, rowAffected, debug)
`
Arguments
- id (string|int) - an id for 'where' reference
- values (object) - object with key-value to update
- rowAffected (callback) - callback with 1 param (rowAffected)
- rowAffected: how many row affected in this execution
- debug(0|1) : console log db process default 0
###### DELETE (with WHERE id)
`
db.Delete(id,rowAffected, debug)
`
Arguments
- id (string|int) - an id for 'where' reference
- rowAffected (callback) - callback with 1 param (rowAffected)
- rowAffected: how many row affected in this execution
- debug(0|1) : console log db process default 0
###### DELETE (with WHERE clause)
`
db.Delete(fields,arguments, rowAffected, debug)
`
Arguments
- fields (array) - an array fieldname
- arguments (array) - an array argument to match with fields
- rowAffected (callback) - callback with 1 param (rowAffected)
- rowAffected: how many row affected in this execution
- debug(0|1) : console log db process default 0
###### GET ONE ROW (with WHERE id)
`
db.getRow(id, result, debug)
`
Arguments
- id (string|int) - an id for 'where' reference
- result (callback) - callback with 1 param (result)
- result: query result
- debug(0|1) : console log db process default 0
###### GET ONE ROW (with WHERE clause)
`
db.getRow(fields, arguments, result, debug)
`
Arguments
- fields (array) - an array fieldname
- arguments (array) - an array argument to match with fields
- result (callback) - callback with 1 param (result)
- result: query result
- debug(0|1) : console log db process default 0
###### GET ALL
`
db.getAll(result)
db.getAll(result, debug)
db.getAll(orderBy, result)
db.getAll(orderBy, result,debug)
db.getAll(fields, arguments, result)
db.getAll(limit, offset, result)
db.getAll(fields, arguments, result, debug)
db.getAll(limit, offset, result, debug)
db.getAll(fields, arguments, orderBy, limit, offset, groupBy, result, debug)
`
Arguments
- fields (array) - an array fieldname
- arguments (array) - an array argument to match with fields
- orderBy (string) - fieldname
- limit (int) - limit query result
- offset (int) - offset query result
- groupBy (string) - fieldname
- result (callback) - callback with 1 param (result)
- result: query result
- debug(0|1) : console log db process default 0
###### CUSTOM QUERY
`
db.execute(query, result, debug)
`
Arguments
- query (string) - an sql query
- result (callback) - callback with 1 param (result)
- result: query result with webSQLiteResult format
- debug(0|1) : console log db process default 0#### Example
###### GET ROW
`
db.getRow([Event.title, Event.Intro], ['masmun','jos'], (result)=>{ //do your stuff })
``