// Gets the primary keys to Sync the next set of rows
public List<String> getKeyColumn(String fieldname, String tabname, String orderby) {
List<String> keyList = null;
try {
String query = "SELECT DISTINCT " + fieldname + " FROM " + tabname + " Order by " + orderby;
Cursor cursor = dbOperations.executeRawQuery(query);
keyList = getKeyColumnResultSet(cursor);
cursor.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new RuntimeException(e.toString());
}
return keyList;
}
// Gets the specific set of rows for deletion
public List<String> getRows(String fieldname, String key, String tabname, String value) {
List<String> keyList = null;
try {
String query =
"SELECT " + fieldname + " FROM " + tabname + " Where " + key + " in (" + value + ")";
Cursor cursor = dbOperations.executeRawQuery(query);
keyList = getKeyColumnResultSet(cursor);
cursor.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new RuntimeException(e.toString());
}
return keyList;
}