| 2388 | |
| 2389 | |
| 2390 | void NoteTable::removeReminder(qint32 lid) { |
| 2391 | NSqlQuery query(db); |
| 2392 | db->lockForWrite(); |
| 2393 | query.prepare("Delete from DataStore where lid=:lid and key=:key"); |
| 2394 | query.bindValue(":lid", lid); |
| 2395 | query.bindValue(":key", NOTE_ATTRIBUTE_REMINDER_DONE_TIME); |
| 2396 | query.exec(); |
| 2397 | |
| 2398 | query.prepare("Delete from DataStore where lid=:lid and key=:key"); |
| 2399 | query.bindValue(":lid", lid); |
| 2400 | query.bindValue(":key", NOTE_ATTRIBUTE_REMINDER_ORDER); |
| 2401 | query.exec(); |
| 2402 | |
| 2403 | |
| 2404 | query.prepare("Delete from DataStore where lid=:lid and key=:key"); |
| 2405 | query.bindValue(":lid", lid); |
| 2406 | query.bindValue(":key", NOTE_ATTRIBUTE_REMINDER_TIME); |
| 2407 | query.exec(); |
| 2408 | |
| 2409 | query.prepare("Update NoteTable set reminderTime=0 where lid=:lid"); |
| 2410 | query.bindValue(":lid", lid); |
| 2411 | query.exec(); |
| 2412 | query.finish(); |
| 2413 | |
| 2414 | query.prepare("Update NoteTable set reminderDoneTime=0 where lid=:lid"); |
| 2415 | query.bindValue(":lid", lid); |
| 2416 | query.exec(); |
| 2417 | query.finish(); |
| 2418 | |
| 2419 | db->unlock(); |
| 2420 | } |
| 2421 | |
| 2422 | |
| 2423 | void NoteTable::getAllReminders(QList< QPair<qint32,qlonglong>* > *reminders) { |