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$ }
/** @return null when not found */ public TLongList listLabelIds(long bukmak2_id) { TLongList res = null; Cursor cursor = helper .getReadableDatabase() .rawQuery( "select " + Db.TABEL_Bukmak2_Label + "." + Db.Bukmak2_Label.label_id + " from " + Db.TABEL_Bukmak2_Label + " where " + Db.TABEL_Bukmak2_Label + "." + Db.Bukmak2_Label.bukmak2_id + "=?", new String[] { String.valueOf(bukmak2_id) }); //$NON-NLS-1$//$NON-NLS-2$//$NON-NLS-3$//$NON-NLS-4$//$NON-NLS-5$//$NON-NLS-6$ try { int col_label_id = cursor.getColumnIndexOrThrow(Db.Bukmak2_Label.label_id); while (cursor.moveToNext()) { if (res == null) res = new TLongArrayList(); res.add(cursor.getLong(col_label_id)); } } finally { cursor.close(); } return res; }
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 getWarnaRgbStabilo(int ari) { // cek dulu ada ato ga Cursor c = helper .getReadableDatabase() .query( Db.TABEL_Bukmak2, null, Db.Bukmak2.ari + "=? and " + Db.Bukmak2.jenis + "=?", new String[] {String.valueOf(ari), String.valueOf(Db.Bukmak2.jenis_stabilo)}, null, null, null); //$NON-NLS-1$ //$NON-NLS-2$ try { if (c.moveToNext()) { // sudah ada! Bookmark2 bukmak = Bookmark2.dariCursor(c); return U.decodeHighlight(bukmak.tulisan); } else { return -1; } } finally { c.close(); } }
public int updateBukmak(Bookmark2 bukmak) { return helper .getWritableDatabase() .update( Db.TABEL_Bukmak2, bukmak.toContentValues(), "_id=?", new String[] {String.valueOf(bukmak._id)}); // $NON-NLS-1$ }
/** * @param map_0 adalah ayat, basis 0 * @return null kalau ga ada warna stabilo, atau int[] kalau ada, sesuai offset map_0. */ public int[] putAtribut(int ari_kitabpasal, int[] map_0) { int ariMin = ari_kitabpasal & 0x00ffff00; int ariMax = ari_kitabpasal | 0x000000ff; int[] res = null; sql_getCatatan_params[0] = String.valueOf(ariMin); sql_getCatatan_params[1] = String.valueOf(ariMax); Cursor cursor = helper .getReadableDatabase() .rawQuery( "select * from " + Db.TABEL_Bukmak2 + " where " + Db.Bukmak2.ari + ">=? and " + Db.Bukmak2.ari + "<?", sql_getCatatan_params); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ try { int kolom_jenis = cursor.getColumnIndexOrThrow(Db.Bukmak2.jenis); int kolom_ari = cursor.getColumnIndexOrThrow(Db.Bukmak2.ari); int kolom_tulisan = cursor.getColumnIndexOrThrow(Db.Bukmak2.tulisan); while (cursor.moveToNext()) { int ari = cursor.getInt(kolom_ari); int jenis = cursor.getInt(kolom_jenis); int ofsetMap = Ari.toVerse(ari) - 1; // dari basis1 ke basis 0 if (ofsetMap >= map_0.length) { Log.e( TAG, "ofsetMap kebanyakan " + ofsetMap + " terjadi pada ari 0x" + Integer.toHexString(ari)); // $NON-NLS-1$ //$NON-NLS-2$ } else { if (jenis == Db.Bukmak2.kind_bookmark) { map_0[ofsetMap] |= 0x1; } else if (jenis == Db.Bukmak2.kind_note) { map_0[ofsetMap] |= 0x2; } else if (jenis == Db.Bukmak2.jenis_stabilo) { map_0[ofsetMap] |= 0x4; String tulisan = cursor.getString(kolom_tulisan); int warnaRgb = U.decodeHighlight(tulisan); if (res == null) res = new int[map_0.length]; res[ofsetMap] = warnaRgb; } } } } finally { cursor.close(); } return res; }
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 int getWarnaRgbStabilo(int ariKp, IntArrayList terpilih) { int ariMin = ariKp; int ariMax = ariKp | 0xff; int[] xwarna = new int[256]; int res = -2; for (int i = 0; i < xwarna.length; i++) xwarna[i] = -1; // cek dulu ada ato ga Cursor c = helper .getReadableDatabase() .query( Db.TABEL_Bukmak2, null, Db.Bukmak2.ari + ">? and " + Db.Bukmak2.ari + "<=? and " + Db.Bukmak2.jenis + "=?", new String[] { String.valueOf(ariMin), String.valueOf(ariMax), String.valueOf(Db.Bukmak2.jenis_stabilo) }, null, null, null); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ try { int ari_col = c.getColumnIndexOrThrow(Db.Bukmak2.ari); int tulisan_col = c.getColumnIndexOrThrow(Db.Bukmak2.tulisan); // masukin aja ke array dulu while (c.moveToNext()) { int ari = c.getInt(ari_col); int index = ari & 0xff; int warna = U.decodeHighlight(c.getString(tulisan_col)); xwarna[index] = warna; } // tentukan warna default. Kalau semua berwarna x, maka jadi x. Kalau ada salah satu yang // bukan x, jadi -1; for (int i = 0; i < terpilih.size(); i++) { int ayat_1 = terpilih.get(i); int warna = xwarna[ayat_1]; if (res == -2) { res = warna; } else if (warna != res) { return -1; } } if (res == -2) return -1; return res; } finally { c.close(); } }
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 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 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 int getUrutanTerbesarLabel() { SQLiteDatabase db = helper.getReadableDatabase(); SQLiteStatement stmt = db.compileStatement( "select max(" + Db.Label.urutan + ") from " + Db.TABEL_Label); // $NON-NLS-1$//$NON-NLS-2$ try { return (int) stmt.simpleQueryForLong(); } finally { stmt.close(); } }
public int countBukmakDenganLabel(Label label) { SQLiteDatabase db = helper.getReadableDatabase(); SQLiteStatement stmt = db.compileStatement( "select count(*) from " + Db.TABEL_Bukmak2_Label + " where " + Db.Bukmak2_Label.label_id + "=?"); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ try { stmt.bindLong(1, label._id); return (int) stmt.simpleQueryForLong(); } finally { stmt.close(); } }
/** @return null when not found */ public List<Label> listLabels(long bukmak2_id) { List<Label> res = null; Cursor cursor = helper .getReadableDatabase() .rawQuery( "select " + Db.TABEL_Label + ".* from " + Db.TABEL_Label + ", " + Db.TABEL_Bukmak2_Label + " where " + Db.TABEL_Bukmak2_Label + "." + Db.Bukmak2_Label.label_id + " = " + Db.TABEL_Label + "." + BaseColumns._ID + " and " + Db.TABEL_Bukmak2_Label + "." + Db.Bukmak2_Label.bukmak2_id + " = ? order by " + Db.TABEL_Label + "." + Db.Label.urutan + " asc", new String[] { String.valueOf(bukmak2_id) }); //$NON-NLS-1$//$NON-NLS-2$//$NON-NLS-3$//$NON-NLS-4$//$NON-NLS-5$//$NON-NLS-6$//$NON-NLS-7$ //$NON-NLS-8$ //$NON-NLS-9$ //$NON-NLS-10$ //$NON-NLS-11$ //$NON-NLS-12$ try { while (cursor.moveToNext()) { if (res == null) res = new ArrayList<Label>(); res.add(Label.fromCursor(cursor)); } } finally { cursor.close(); } return res; }
public boolean adakahEdisiYesDenganNamafile(String namafile) { SQLiteDatabase db = helper.getReadableDatabase(); SQLiteStatement stmt = db.compileStatement( "select count(*) from " + Db.TABEL_Edisi + " where " + Db.Edisi.jenis + "=? and " + Db.Edisi.namafile + "=?"); //$NON-NLS-1$//$NON-NLS-2$//$NON-NLS-3$//$NON-NLS-4$ try { stmt.clearBindings(); stmt.bindLong(1, Db.Edisi.jenis_yes); stmt.bindString(2, namafile); return stmt.simpleQueryForLong() > 0; } finally { stmt.close(); } }
/** Coba ambil artikel dari db lokal. Artikel ga siap pakai pun akan direturn. */ public IArtikel cobaAmbilRenungan(String nama, String tgl) { Cursor c = helper .getReadableDatabase() .query( Db.TABEL_Renungan, null, Db.Renungan.nama + "=? and " + Db.Renungan.tgl + "=?", new String[] {nama, tgl}, null, null, null); //$NON-NLS-1$ //$NON-NLS-2$ try { if (c.moveToNext()) { IArtikel res = null; if (nama.equals("rh")) { // $NON-NLS-1$ res = new ArtikelRenunganHarian( tgl, c.getString(c.getColumnIndexOrThrow(Db.Renungan.judul)), c.getString(c.getColumnIndexOrThrow(Db.Renungan.header)), c.getString(c.getColumnIndexOrThrow(Db.Renungan.isi)), c.getInt(c.getColumnIndexOrThrow(Db.Renungan.siapPakai)) > 0); } else if (nama.equals("sh")) { // $NON-NLS-1$ res = new ArtikelSantapanHarian( tgl, c.getString(c.getColumnIndexOrThrow(Db.Renungan.judul)), c.getString(c.getColumnIndexOrThrow(Db.Renungan.header)), c.getString(c.getColumnIndexOrThrow(Db.Renungan.isi)), c.getInt(c.getColumnIndexOrThrow(Db.Renungan.siapPakai)) > 0); } return res; } else { return null; } } finally { c.close(); } }
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 Label getLabelById(long labelId) { SQLiteDatabase db = helper.getReadableDatabase(); Cursor cursor = db.query( Db.TABEL_Label, null, BaseColumns._ID + "=?", new String[] {String.valueOf(labelId)}, null, null, null); //$NON-NLS-1$ try { if (cursor.moveToNext()) { return Label.fromCursor(cursor); } else { return null; } } finally { cursor.close(); } }
public Bookmark2 getBukmakById(long id) { Cursor cursor = helper .getReadableDatabase() .query( Db.TABEL_Bukmak2, null, "_id=?", //$NON-NLS-1$ new String[] {String.valueOf(id)}, null, null, null); try { if (!cursor.moveToNext()) return null; return Bookmark2.dariCursor(cursor); } finally { cursor.close(); } }
public List<MVersionYes> listAllVersions() { List<MVersionYes> res = new ArrayList<MVersionYes>(); Cursor cursor = helper .getReadableDatabase() .query( Db.TABEL_Edisi, null, null, null, null, null, Db.Edisi.urutan + " asc"); // $NON-NLS-1$ try { int col_aktif = cursor.getColumnIndexOrThrow(Db.Edisi.aktif); int col_shortName = cursor.getColumnIndexOrThrow(Db.Edisi.shortName); int col_judul = cursor.getColumnIndexOrThrow(Db.Edisi.judul); int col_keterangan = cursor.getColumnIndexOrThrow(Db.Edisi.keterangan); int col_namafile = cursor.getColumnIndexOrThrow(Db.Edisi.namafile); int col_namafile_pdbasal = cursor.getColumnIndexOrThrow(Db.Edisi.namafile_pdbasal); int col_urutan = cursor.getColumnIndexOrThrow(Db.Edisi.urutan); while (cursor.moveToNext()) { MVersionYes yes = new MVersionYes(); yes.cache_active = cursor.getInt(col_aktif) != 0; yes.type = Db.Edisi.jenis_yes; yes.description = cursor.getString(col_keterangan); yes.shortName = cursor.getString(col_shortName); yes.longName = cursor.getString(col_judul); yes.filename = cursor.getString(col_namafile); yes.originalPdbFilename = cursor.getString(col_namafile_pdbasal); yes.ordering = cursor.getInt(col_urutan); res.add(yes); } } finally { cursor.close(); } return res; }
public List<Label> listSemuaLabel() { List<Label> res = new ArrayList<Label>(); Cursor cursor = helper .getReadableDatabase() .query( Db.TABEL_Label, null, null, null, null, null, Db.Label.urutan + " asc"); // $NON-NLS-1$ try { while (cursor.moveToNext()) { res.add(Label.fromCursor(cursor)); } } finally { cursor.close(); } return res; }
public Bookmark2 getBukmakByAri(int ari, int jenis) { Cursor cursor = helper .getReadableDatabase() .query( Db.TABEL_Bukmak2, new String[] { BaseColumns._ID, Db.Bukmak2.tulisan, Db.Bukmak2.waktuTambah, Db.Bukmak2.waktuUbah }, Db.Bukmak2.ari + "=? and " + Db.Bukmak2.jenis + "=?", // $NON-NLS-1$ //$NON-NLS-2$ new String[] {String.valueOf(ari), String.valueOf(jenis)}, null, null, null); try { if (!cursor.moveToNext()) return null; return Bookmark2.dariCursor(cursor, ari, jenis); } finally { cursor.close(); } }
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 countAtribut(int ari_kitabpasal) { int ariMin = ari_kitabpasal & 0x00ffff00; int ariMax = ari_kitabpasal | 0x000000ff; if (stmt_countAtribut == null) { stmt_countAtribut = helper .getReadableDatabase() .compileStatement( "select count(*) from " + Db.TABEL_Bukmak2 + " where " + Db.Bukmak2.ari + ">=? and " + Db.Bukmak2.ari + "<?"); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ } stmt_countAtribut.clearBindings(); stmt_countAtribut.bindLong(1, ariMin); stmt_countAtribut.bindLong(2, ariMax); return (int) stmt_countAtribut.simpleQueryForLong(); }
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 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 Cursor listSemuaBukmak() { return helper.getReadableDatabase().query(Db.TABEL_Bukmak2, null, null, null, null, null, null); }
public void hapusEdisiYes(MVersionYes edisi) { SQLiteDatabase db = helper.getWritableDatabase(); db.delete( Db.TABEL_Edisi, Db.Edisi.namafile + "=?", new String[] {edisi.filename}); // $NON-NLS-1$ }