Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

View NsAveek's full-sized avatar
🏠
Working from home

Aveek NsAveek

🏠
Working from home
View GitHub Profile
@NsAveek
NsAveek / DatabaseHelper.java
Last active August 19, 2018 05:22
The Actual DatabaseHelper class which is responsible for creating tables with default values in Sqlite
public class DatabaseHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "data.db";
private static final int DATABASE_VERSION = 1;
public DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
@NsAveek
NsAveek / DatabaseHelper.java
Created August 19, 2018 05:11
The magic method createTable() to handle creation of the given fields automatically
private void createTable(String tableName, Map<String, String> fields, SQLiteDatabase db) {
Iterator iter = fields.entrySet().iterator();
String columns = "(";
Log.d("column", columns);
int counter = 1;
while (iter.hasNext()) {
Map.Entry mEntry = (Map.Entry) iter.next();
columns += mEntry.getKey() + " " + mEntry.getValue();
if (counter == fields.size()) {
columns += ")";