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(); } }
/** @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; }
/** * @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 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 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 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 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 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 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 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 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 Cursor listBukmak(int jenis, long labelId, String sortColumn, boolean sortAscending) { SQLiteDatabase db = helper.getReadableDatabase(); String sortClause = sortColumn + (Db.Bukmak2.tulisan.equals(sortColumn) ? " collate NOCASE " : "") + (sortAscending ? " asc" : " desc"); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ if (labelId == 0) { // no restrictions return db.query( Db.TABEL_Bukmak2, null, Db.Bukmak2.jenis + "=?", new String[] {String.valueOf(jenis)}, null, null, sortClause); //$NON-NLS-1$ } else if (labelId == BookmarkListActivity.LABELID_noLabel) { // only without label return db.rawQuery( "select " + Db.TABEL_Bukmak2 + ".* from " + Db.TABEL_Bukmak2 + " where " + Db.TABEL_Bukmak2 + "." + Db.Bukmak2.jenis + "=? and " + Db.TABEL_Bukmak2 + "." + BaseColumns._ID + " not in (select " + Db.Bukmak2_Label.bukmak2_id + " from " + Db.TABEL_Bukmak2_Label + ") order by " + Db.TABEL_Bukmak2 + "." + sortClause, new String[] { String.valueOf(jenis) }); //$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$ } else { // filter by labelId return db.rawQuery( "select " + Db.TABEL_Bukmak2 + ".* from " + Db.TABEL_Bukmak2 + ", " + Db.TABEL_Bukmak2_Label + " where " + Db.Bukmak2.jenis + "=? and " + Db.TABEL_Bukmak2 + "." + BaseColumns._ID + " = " + Db.TABEL_Bukmak2_Label + "." + Db.Bukmak2_Label.bukmak2_id + " and " + Db.TABEL_Bukmak2_Label + "." + Db.Bukmak2_Label.label_id + "=? order by " + Db.TABEL_Bukmak2 + "." + sortClause, new String[] { String.valueOf(jenis), String.valueOf(labelId) }); //$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$ } }
public Cursor listSemuaBukmak() { return helper.getReadableDatabase().query(Db.TABEL_Bukmak2, null, null, null, null, null, null); }