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();
}
}
