summaryrefslogtreecommitdiff
path: root/app/Models/EntryDAO_SQLite.php
diff options
context:
space:
mode:
Diffstat (limited to 'app/Models/EntryDAO_SQLite.php')
-rw-r--r--app/Models/EntryDAO_SQLite.php42
1 files changed, 0 insertions, 42 deletions
diff --git a/app/Models/EntryDAO_SQLite.php b/app/Models/EntryDAO_SQLite.php
deleted file mode 100644
index f148f3c63..000000000
--- a/app/Models/EntryDAO_SQLite.php
+++ /dev/null
@@ -1,42 +0,0 @@
-<?php
-
-class FreshRSS_EntryDAO_SQLite extends FreshRSS_EntryDAO {
-
- public function markRead($ids, $is_read = true) {
- if (is_array($ids)) { //Many IDs at once
- if (true) { //Not supported yet in SQLite, so always call IDs one by one
- $affected = 0;
- foreach ($ids as $id) {
- $affected += $this->markRead($id, $is_read);
- }
- return $affected;
- }
- } else {
- $this->bd->beginTransaction();
- $sql = 'UPDATE `' . $this->prefix . 'entry` e SET e.is_read = ? WHERE e.id=? AND e.is_read<>?';
- $values = array($is_read ? 1 : 0, $ids, $is_read ? 1 : 0);
- $stm = $this->bd->prepare($sql);
- if (!($stm && $stm->execute ($values))) {
- $info = $stm == null ? array(2 => 'syntax error') : $stm->errorInfo();
- Minz_Log::record('SQL error markRead: ' . $info[2], Minz_Log::ERROR);
- $this->bd->rollBack ();
- return false;
- }
- $affected = $stm->rowCount();
- if ($affected > 0) {
- $sql = 'UPDATE `' . $this->prefix . 'feed` f SET f.cache_nbUnreads=f.cache_nbUnreads' . ($is_read ? '-' : '+') . '1 '
- . 'WHERE f.id=(SELECT e.id_feed FROM `' . $this->prefix . 'entry` e WHERE e.id=?)';
- $values = array($ids);
- $stm = $this->bd->prepare($sql);
- if (!($stm && $stm->execute ($values))) {
- $info = $stm == null ? array(2 => 'syntax error') : $stm->errorInfo();
- Minz_Log::record('SQL error markRead: ' . $info[2], Minz_Log::ERROR);
- $this->bd->rollBack ();
- return false;
- }
- }
- $this->bd->commit();
- return $affected;
- }
- }
-}