SuitcaseManager/ItemHelper.java at master · akshay-sarkar/SuitcaseManager · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
package edu.uta.cse5320.dao;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;


public class ItemHelper extends SQLiteOpenHelper {

    public static final String DATABASE_NAME = "items.db";
    public static final String TABLE_NAME = "item_data";
    public static final String COL1 = "ID";
    public static final String COL2 = "itemName";
    public static final String COL3 = "itemQuantity";
    public static final String COL4 = "imageUrl1";
    public static final String COL5 = "imageUrl2";
    public static final String COL6 = "imageUrl3";

    public ItemHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String createTable = "CREATE TABLE " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT, " +
                COL2 + " TEXT," +
                COL3 + " TEXT," +
                COL4 + " TEXT," +
                COL5 + " TEXT," +
                COL6 + " TEXT)";
        db.execSQL(createTable);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP IF TABLE EXISTS " + TABLE_NAME);
        onCreate(db);
    }

    public long addData(String itemName, int itemQuantity, String imageUrl1, String imageUrl2, String imageUrl3) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL2, itemName);
        contentValues.put(COL3, itemQuantity);
        contentValues.put(COL4, imageUrl1);
        contentValues.put(COL5, imageUrl2);
        contentValues.put(COL6, imageUrl3);

        long result = db.insert(TABLE_NAME, null, contentValues);
        return result;
    }

    public void addDataCompleteSync(long id, String itemName, int itemQuantity, String imageUrl1, String imageUrl2, String imageUrl3){
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL1, id);
        contentValues.put(COL2, itemName);
        contentValues.put(COL3, itemQuantity);
        contentValues.put(COL4, imageUrl1);
        contentValues.put(COL5, imageUrl2);
        contentValues.put(COL6, imageUrl3);

        db.insert(TABLE_NAME, null, contentValues);
    }


    public boolean updateDetails(long rowId, String itemName, int itemQuantity, String imageUrl1, String imageUrl2, String imageUrl3)
    {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL2, itemName);
        contentValues.put(COL3, itemQuantity);
        contentValues.put(COL4, imageUrl1);
        contentValues.put(COL5, imageUrl2);
        contentValues.put(COL6, imageUrl3);
        int i =  db.update(TABLE_NAME, contentValues, "ID=" + rowId, null);
        return i > 0;
    }

    //query for 1 week repeats
    public Cursor getListContents() {
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor data = db.rawQuery("SELECT * FROM " + TABLE_NAME, null);
        return data;
    }

    public int getListContent(long rowId) {
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor data = db.rawQuery("SELECT * FROM " + TABLE_NAME+ " WHERE "+COL1+" =" + rowId, null);
        return data.getCount();
    }

    public boolean deleteContent(long rowId) {
        SQLiteDatabase db = this.getWritableDatabase();
        int row_affected = db.delete(TABLE_NAME, COL1 + " ="+ rowId, null);
        if(row_affected>0){
            return true;
        }
        return false;
    }

}