# SQLiteConnection_Android_iOS
NPM Database Connection Package for android
https://www.npmjs.com/package/reactnative_sqlconnection_android_ios
Steps:
1: npm install –save sqliteconnection_android_ios
2: npm link sqliteconnection_android_ios
3: Add following code in settings.gradle
include ‘:reactnative_sqlconnection_android_ios’
project(‘:reactnative_sqlconnection_android_ios’).projectDir = new File(rootProject.projectDir, ‘../node_modules/reactnative_sqlconnection_android_ios/android’)
4: Add in App build.gradle
compile project(":reactnative_sqlconnection_android_ios")
5: Check in default configuration with multidex enable or not
multiDexEnabled true
@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);”,
];
SQLConnection.CreateTables(appTables,(result)=> { this.setState(()=>({nativeModuleText:result})); console.log(“Tables Created”); })
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:
result[0].group_name
})); console.log(“Tables Created”); })
};
4: Count Rows
SQLConnection.getCountRows( “core_group”,”group_id”,(result)=> { this.setState(()=>({nativeModuleText:result })); console.log(“Tables Created”); })