private void requestsSeen() { SQLiteConnection sql = new SQLiteConnection(this); sql.executeQuery("UPDATE " + SQLiteConnection.TABLE_REQUESTS + " SET seen=1"); sql.close(); }
public boolean saveDataFromMyContact() { // speichere Daten von der UI try { SQLiteConnection db_conn = new SQLiteConnection(this); String[][] ui_data = getMyContactObjects(); if ((!myContactIsLoaded) || (ui_data == null)) { db_conn.close(); return false; } Cursor data = db_conn.query("SELECT entrynames_id,value FROM " + SQLiteConnection.TABLE_USER_DATA); String[][] data_edit = new String[data.getCount()][]; for (int i = 0; i < data.getCount(); i++) { data.moveToPosition(i); data_edit[i] = new String[] {String.valueOf(data.getInt(0)), data.getString(1)}; } if (!Functions.equalsArray(ui_data, data_edit)) { // Mein Kontakt in lokale db schreiben db_conn.executeQuery("DELETE FROM " + SQLiteConnection.TABLE_USER_DATA); for (int i = 0; i < ui_data.length; i++) { String[] str_tmp = ui_data[i]; ContentValues values = new ContentValues(); values.put("id", i); values.put("entrynames_id", Integer.parseInt(str_tmp[0])); values.put("value", str_tmp[1]); db_conn.insert(SQLiteConnection.TABLE_USER_DATA, values); } db_conn.executeQuery( "UPDATE " + SQLiteConnection.TABLE_USER + " SET change_date=CURRENT_TIMESTAMP"); String checksums = db_conn.getChecksums(); db_conn.setChecksums( checksums.replace(checksums.substring(32, 64), "00000000000000000000000000000000")); try { if (thread_sync != null) thread_sync.interrupt(); } finally { } thread_sync = new Thread( new Runnable() { public void run() { new UserFunctions(getApplicationContext()).sync(); } }); thread_sync.start(); } data.close(); db_conn.close(); } catch (Exception ex) { ex.printStackTrace(); return false; } return true; }