· 9 years ago · Oct 19, 2016, 03:16 PM
1import android.content.ContentValues;
2import android.database.Cursor;
3import android.database.sqlite.SQLiteDatabase;
4import android.util.Log;
5
6import java.util.ArrayList;
7
8import me.dle.medtrack.db.DBManager;
9import me.dle.medtrack.models.Med;
10
11public class MedRepo {
12
13 private static final String TABLE = "Medication";
14 private static final String NAME = "Name";
15 private static final String ID = "ID";
16 private static final String TAG = "MedRepo";
17
18
19 public static String createTable() {
20 return "create table if not exists " + TABLE + " (" + NAME + " text primary key, " + ID + " integer " +
21 "autoincrement)";
22 }
23
24 public boolean insertMed(Med med) {
25 try {
26 SQLiteDatabase db = DBManager.getInstance().openDatabase();
27 ContentValues values = new ContentValues();
28 values.put(NAME, med.getName());
29 db.insert(TABLE, null, values);
30 Log.e(TAG, "SUCCESS: insertMed: " + med.getName());
31 DBManager.getInstance().closeDatabase();
32 return true;
33 } catch (Exception e) {
34
35 Log.e(TAG, "FAIL: insertMed " + e.getMessage());
36 return false;
37 }
38 }