hxjiPp5q

1private static void createAllTables(SQLiteDatabase database) {
2
3    //database.execSQL(" CREATE TABLE IF NOT EXISTS " + IN_RIDE_DATA + " (" + USER_ID  +"," + TOTAL_DISPLACEMENT_DISTANCE  + "" + ");");
4
5    database.execSQL(" CREATE TABLE IF NOT EXISTS " + IN_RIDE_DATA + " ("
6            + TOTAL_DISPLACEMENT_DISTANCE + " TEXT, "
7            + USER_ID + " TEXT" + ");");
8
9}
10	
11public void insertDisplacement(String id, String displacement) {
12    try {
13        deleteDriverLocData();
14        ContentValues contentValues = new ContentValues();
15        contentValues.put(NewDatabaseForInRideData.USER_ID, id);
16        contentValues.put(NewDatabaseForInRideData.TOTAL_DISPLACEMENT_DISTANCE, displacement);
17        database.insert(NewDatabaseForInRideData.IN_RIDE_DATA, null, contentValues);
18    } catch (Exception e) {
19        e.printStackTrace();
20    }
21}
22	
23public String getDisplacement() {
24    try {
25        String[] columns = new String[]{NewDatabaseForInRideData.TOTAL_DISPLACEMENT_DISTANCE};
26        Cursor cursor = database.query(NewDatabaseForInRideData.IN_RIDE_DATA, columns, null, null, null, null, null);
27        cursor.moveToFirst();
28        String totaldisplacement = cursor.getString(cursor.getColumnIndex(NewDatabaseForInRideData.TOTAL_DISPLACEMENT_DISTANCE));
29        return totaldisplacement;
30    } catch (Exception e) {
31        e.printStackTrace();
32        return "";
33    }
34}
35	
36public void deleteDriverLocData() {
37    try {
38        database.delete(NewDatabaseForInRideData.IN_RIDE_DATA, null, null);
39    } catch (Exception e) {
40        e.printStackTrace();
41    }
42}