sqliteconnection_android_ios v0.0.4

SQLiteConnection_Android_iOS

NPM Database Connection Package for android

npm install --save sqliteconnection_android_ios

npm link sqliteconnection_android_ios

@Android Copy database file to asset folder with name "database.db"

Methods:

CreateTables SQLConnection.CreateTables(SQLJSONArray,(result)=> { })

Execute SQLConnection.execute( SQLQuery);

Select SQLConnection.Select(SQLQuery)

Examples:

1: Create Tables var appTables = "CREATE TABLE 'core_user' ( 'user_id' INTEGER PRIMARY KEY, 'group_id' INTEGER);", ;

2: Execute SQLConnection.execute( "insert into core_group ('group_name') values('test1');");

3: Select SQLConnection.Select( "select group_name from core_group order by group_id desc;",(result)=> { this.setState(()=>({name:

result0.group_name

})); console.log("Tables Created"); }) };

4: Count Rows SQLConnection.getCountRows( "core_group","group_id",(result)=> { this.setState(()=>({nativeModuleText:result })); console.log("Tables Created"); })