public int hapusRenunganBerwaktuSentuhSebelum(Date date) { SQLiteDatabase db = helper.getWritableDatabase(); return db.delete( Db.TABEL_Renungan, Db.Renungan.waktuSentuh + "<?", new String[] {String.valueOf(Sqlitil.toInt(date))}); // $NON-NLS-1$ }
public void hapusBukmakByAri(int ari, int jenis) { SQLiteDatabase db = helper.getWritableDatabase(); db.beginTransaction(); try { long _id; SQLiteStatement stmt = db.compileStatement( "select _id from " + Db.TABEL_Bukmak2 + " where " + Db.Bukmak2.jenis + "=? and " + Db.Bukmak2.ari + "=?"); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ try { stmt.bindLong(1, jenis); stmt.bindLong(2, ari); _id = stmt.simpleQueryForLong(); } finally { stmt.close(); } String[] params = {String.valueOf(_id)}; db.delete(Db.TABEL_Bukmak2_Label, Db.Bukmak2_Label.bukmak2_id + "=?", params); // $NON-NLS-1$ db.delete(Db.TABEL_Bukmak2, "_id=?", params); // $NON-NLS-1$ db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
public int updateBukmak(Bookmark2 bukmak) { return helper .getWritableDatabase() .update( Db.TABEL_Bukmak2, bukmak.toContentValues(), "_id=?", new String[] {String.valueOf(bukmak._id)}); // $NON-NLS-1$ }
public void setEdisiYesAktif(String namafile, boolean aktif) { SQLiteDatabase db = helper.getWritableDatabase(); ContentValues cv = new ContentValues(); cv.put(Db.Edisi.aktif, aktif ? 1 : 0); db.update( Db.TABEL_Edisi, cv, Db.Edisi.jenis + "=? and " + Db.Edisi.namafile + "=?", new String[] {String.valueOf(Db.Edisi.jenis_yes), namafile}); // $NON-NLS-1$ //$NON-NLS-2$ }
public Label tambahLabel(String judul, String warnaLatar) { Label res = new Label(-1, judul, getUrutanTerbesarLabel() + 1, warnaLatar); SQLiteDatabase db = helper.getWritableDatabase(); long _id = db.insert(Db.TABEL_Label, null, res.toContentValues()); if (_id == -1) { return null; } else { res._id = _id; return res; } }
public Bookmark2 insertBukmak( int ari, int jenis, String tulisan, Date waktuTambah, Date waktuUbah) { Bookmark2 res = new Bookmark2(ari, jenis, tulisan, waktuTambah, waktuUbah); SQLiteDatabase db = helper.getWritableDatabase(); long _id = db.insert(Db.TABEL_Bukmak2, null, res.toContentValues()); if (_id == -1) { return null; } else { res._id = _id; return res; } }
public void hapusLabelById(long id) { SQLiteDatabase db = helper.getWritableDatabase(); db.beginTransaction(); try { String[] params = new String[] {String.valueOf(id)}; db.delete(Db.TABEL_Bukmak2_Label, Db.Bukmak2_Label.label_id + "=?", params); // $NON-NLS-1$ db.delete(Db.TABEL_Label, "_id=?", params); // $NON-NLS-1$ db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
public void tambahEdisiYesDenganAktif(MVersionYes edisi, boolean aktif) { SQLiteDatabase db = helper.getWritableDatabase(); ContentValues cv = new ContentValues(); cv.put(Db.Edisi.aktif, aktif); cv.put(Db.Edisi.jenis, Db.Edisi.jenis_yes); cv.put(Db.Edisi.shortName, edisi.shortName); cv.put(Db.Edisi.judul, edisi.longName); cv.put(Db.Edisi.keterangan, edisi.description); cv.put(Db.Edisi.namafile, edisi.filename); cv.put(Db.Edisi.namafile_pdbasal, edisi.originalPdbFilename); cv.put(Db.Edisi.urutan, edisi.ordering); Log.d(TAG, "tambah edisi yes: " + cv.toString()); // $NON-NLS-1$ db.insert(Db.TABEL_Edisi, null, cv); }
public boolean simpanArtikelKeRenungan(IArtikel artikel) { boolean res = false; SQLiteDatabase db = helper.getWritableDatabase(); db.beginTransaction(); try { // hapus dulu yang lama. db.delete( Db.TABEL_Renungan, Db.Renungan.nama + "=? and " + Db.Renungan.tgl + "=?", new String[] {artikel.getNama(), artikel.getTgl()}); // $NON-NLS-1$ //$NON-NLS-2$ ContentValues values = new ContentValues(); values.put(Db.Renungan.nama, artikel.getNama()); values.put(Db.Renungan.tgl, artikel.getTgl()); values.put(Db.Renungan.siapPakai, artikel.getSiapPakai() ? 1 : 0); if (artikel.getSiapPakai()) { values.put(Db.Renungan.judul, artikel.getJudul().toString()); values.put(Db.Renungan.isi, artikel.getIsiHtml()); values.put(Db.Renungan.header, artikel.getHeaderHtml()); } else { values.put(Db.Renungan.judul, (String) null); values.put(Db.Renungan.isi, (String) null); values.put(Db.Renungan.header, (String) null); } values.put(Db.Renungan.waktuSentuh, Sqlitil.nowDateTime()); db.insert(Db.TABEL_Renungan, null, values); db.setTransactionSuccessful(); res = true; Log.d(TAG, "TukangDonlot donlot selesai dengan sukses dan uda masuk ke db"); // $NON-NLS-1$ } finally { db.endTransaction(); } return res; }
public void updateLabels(Bookmark2 bukmak, Set<Label> labels) { SQLiteDatabase db = helper.getWritableDatabase(); db.beginTransaction(); try { // hapus semua db.delete( Db.TABEL_Bukmak2_Label, Db.Bukmak2_Label.bukmak2_id + "=?", new String[] {String.valueOf(bukmak._id)}); // $NON-NLS-1$ // tambah semua ContentValues cv = new ContentValues(); for (Label label : labels) { cv.put(Db.Bukmak2_Label.bukmak2_id, bukmak._id); cv.put(Db.Bukmak2_Label.label_id, label._id); db.insert(Db.TABEL_Bukmak2_Label, null, cv); } db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
public int deleteDevotionsWithLessThanInTitle() { SQLiteDatabase db = helper.getWritableDatabase(); return db.delete(Db.TABEL_Renungan, Db.Renungan.judul + " like '%<%'", null); }
public void updateLabel(Label label) { SQLiteDatabase db = helper.getWritableDatabase(); ContentValues cv = label.toContentValues(); db.update(Db.TABEL_Label, cv, "_id=?", new String[] {String.valueOf(label._id)}); // $NON-NLS-1$ }
public void hapusEdisiYes(MVersionYes edisi) { SQLiteDatabase db = helper.getWritableDatabase(); db.delete( Db.TABEL_Edisi, Db.Edisi.namafile + "=?", new String[] {edisi.filename}); // $NON-NLS-1$ }
public void updateAtauInsertStabilo(int ariKp, IntArrayList ayatTerpilih, int warnaRgb) { SQLiteDatabase db = helper.getWritableDatabase(); String[] params = {null /* buat ari */, String.valueOf(Db.Bukmak2.jenis_stabilo)}; db.beginTransaction(); try { // setiap ayat yang diminta for (int i = 0; i < ayatTerpilih.size(); i++) { int ayat_1 = ayatTerpilih.get(i); int ari = Ari.encodeWithKp(ariKp, ayat_1); params[0] = String.valueOf(ari); Cursor c = db.query( Db.TABEL_Bukmak2, null, Db.Bukmak2.ari + "=? and " + Db.Bukmak2.jenis + "=?", params, null, null, null); //$NON-NLS-1$ //$NON-NLS-2$ try { if (c.moveToNext()) { // cek dulu ada ato ga // sudah ada! Bookmark2 bukmak = Bookmark2.dariCursor(c); bukmak.waktuUbah = new Date(); if (warnaRgb != -1) { bukmak.tulisan = U.encodeHighlight(warnaRgb); db.update( Db.TABEL_Bukmak2, bukmak.toContentValues(), "_id=?", new String[] {String.valueOf(bukmak._id)}); // $NON-NLS-1$ } else { // delete db.delete( Db.TABEL_Bukmak2, "_id=?", new String[] {String.valueOf(bukmak._id)}); // $NON-NLS-1$ } } else { // belum ada! if (warnaRgb == -1) { // ga usa ngapa2in, dari belum ada jadi tetep ga ada } else { Date kini = new Date(); Bookmark2 bukmak = new Bookmark2( ari, Db.Bukmak2.jenis_stabilo, U.encodeHighlight(warnaRgb), kini, kini); db.insert(Db.TABEL_Bukmak2, null, bukmak.toContentValues()); } } } finally { c.close(); } } db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
public void importBukmak( List<Bookmark2> xbukmak, boolean tumpuk, TObjectIntHashMap<Bookmark2> bukmakToRelIdMap, TIntLongHashMap labelRelIdToAbsIdMap, TIntObjectHashMap<TIntList> bukmak2RelIdToLabelRelIdsMap) { SQLiteDatabase db = helper.getWritableDatabase(); db.beginTransaction(); try { TIntLongHashMap bukmakRelIdToAbsIdMap = new TIntLongHashMap(); { // tulis bukmak2 baru String[] params1 = new String[1]; String[] params2 = new String[2]; for (Bookmark2 bukmak : xbukmak) { int bukmak2_relId = bukmakToRelIdMap.get(bukmak); params2[0] = String.valueOf(bukmak.ari); params2[1] = String.valueOf(bukmak.jenis); long _id = -1; boolean ada = false; Cursor cursor = db.query( Db.TABEL_Bukmak2, null, Db.Bukmak2.ari + "=? and " + Db.Bukmak2.jenis + "=?", params2, null, null, null); //$NON-NLS-1$ //$NON-NLS-2$ if (cursor.moveToNext()) { ada = true; _id = cursor.getLong(cursor.getColumnIndexOrThrow(BaseColumns._ID)); /* [1] */ } cursor.close(); // --------------------------------- dapet _id dari // ada tumpuk: delete insert [2] // ada !tumpuk: (nop) [1] // !ada tumpuk: insert [2] // !ada !tumpuk: insert [2] if (ada && tumpuk) { params1[0] = String.valueOf(_id); db.delete(Db.TABEL_Bukmak2, "_id=?", params1); // $NON-NLS-1$ db.delete( Db.TABEL_Bukmak2_Label, Db.Bukmak2_Label.bukmak2_id + "=?", params1); // $NON-NLS-1$ } if ((ada && tumpuk) || (!ada)) { _id = db.insert(Db.TABEL_Bukmak2, null, bukmak.toContentValues()); /* [2] */ } // map it bukmakRelIdToAbsIdMap.put(bukmak2_relId, _id); } } { // sekarang pemasangan label String where = Db.Bukmak2_Label.bukmak2_id + "=?"; // $NON-NLS-1$ String[] params = {null}; ContentValues cv = new ContentValues(); // nlabel>0 tumpuk: delete insert // nlabel>0 !tumpuk: (nop) // nlabel=0 tumpuk: insert // nlabel=0 !tumpuk: insert for (int bukmak2_relId : bukmak2RelIdToLabelRelIdsMap.keys()) { TIntList label_relIds = bukmak2RelIdToLabelRelIdsMap.get(bukmak2_relId); long bukmak2_id = bukmakRelIdToAbsIdMap.get(bukmak2_relId); if (bukmak2_id > 0) { params[0] = String.valueOf(bukmak2_id); // cek ada berapa label untuk bukmak2_id ini int nlabel = 0; Cursor c = db.rawQuery( "select count(*) from " + Db.TABEL_Bukmak2_Label + " where " + where, params); //$NON-NLS-1$ //$NON-NLS-2$ try { c.moveToNext(); nlabel = c.getInt(0); } finally { c.close(); } if (nlabel > 0 && tumpuk) { db.delete(Db.TABEL_Bukmak2_Label, where, params); } if ((nlabel > 0 && tumpuk) || (!(nlabel > 0))) { for (int label_relId : label_relIds.toArray()) { long label_id = labelRelIdToAbsIdMap.get(label_relId); if (label_id > 0) { cv.put(Db.Bukmak2_Label.bukmak2_id, bukmak2_id); cv.put(Db.Bukmak2_Label.label_id, label_id); db.insert(Db.TABEL_Bukmak2_Label, null, cv); } else { Log.w(TAG, "label_id ngaco!: " + label_id); // $NON-NLS-1$ } } } } else { Log.w(TAG, "bukmak2_id ngaco!: " + bukmak2_id); // $NON-NLS-1$ } } } db.setTransactionSuccessful(); } finally { db.endTransaction(); } }