// 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; }