summaryrefslogtreecommitdiff
path: root/app/Models/EntryDAO.php
AgeCommit message (Collapse)Author
2014-09-18Refactor code for strict unread message displayGravatar Alexis Degrugillier
Before, when you choose the show unread message option and the hide categories and feeds options, the categories and feeds weren't hidden. Now it is working properly. Before, the unread filter icon was not selected with the previous way of using the constants. Now, the filter is highlighted when selected in strict mode. See #619
2014-09-06Add a new configuration optionGravatar Alexis Degrugillier
Before, when you selected the option to display only unread articles, it shows read articles if no unread article were found. Now, this option is renamed to include information on fallback behavior and a new option is created to have the "only unread" behavior See #551 It is missing the german translation
2014-08-23Fix bug add favorite entryGravatar Marien Fressinaud
See https://github.com/marienfressinaud/FreshRSS/issues/494
2014-08-19Improvement for ASC orderGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/495
2014-08-07First bug for old articles firstGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/495
2014-07-23Fix bugs in import/exportGravatar Marien Fressinaud
- EntryDAO.php: add a missing "FreshRSS_EntryDAO::" - Fix htmlspecialchars in opml export
2014-07-17SQL: Bug with order ASCGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/538
2014-07-10SQL: MySQL speed optimisationGravatar Alexandre Alapetite
Would be nice to test with other versions of MySQL too. Comparison before/after: mysql> EXPLAIN SELECT e.id, e.guid, e.title, e.author, UNCOMPRESS(content_bin) AS content, e.link, e.date, e.is_read, e.is_favorite, e.id_feed, e.tags FROM `freshrss_alex_entry` e INNER JOIN (SELECT e1.id FROM `freshrss_alex_entry` e1 INNER JOIN `freshrss_alex_feed` f ON e1.id_feed=f.id WHERE f.priority > 0 AND (e1.id >= 1381615200000000 OR e1.is_read=0 OR e1.is_favorite=1 OR (f.keep_history <> 0)) ORDER BY e1.id DESC LIMIT 31) e2 ON e2.id=e.id ORDER BY e.id DESC; +----+-------------+------------+--------+-------------------------------------+----------+---------+---------------+------+----------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+------------+--------+-------------------------------------+----------+---------+---------------+------+----------------------------------------------+ | 1 | PRIMARY | <derived2> | ALL | NULL | NULL | NULL | NULL | 31 | Using temporary; Using filesort | | 1 | PRIMARY | e | eq_ref | PRIMARY | PRIMARY | 8 | e2.id | 1 | | | 2 | DERIVED | f | range | PRIMARY,priority,keep_history | priority | 1 | NULL | 137 | Using where; Using temporary; Using filesort | | 2 | DERIVED | e1 | ref | PRIMARY,id_feed,is_favorite,is_read | id_feed | 2 | freshrss.f.id | 452 | Using where | +----+-------------+------------+--------+-------------------------------------+----------+---------+---------------+------+----------------------------------------------+ 4 rows in set (3.50 sec) mysql> EXPLAIN SELECT e.id, e.guid, e.title, e.author, UNCOMPRESS(content_bin) AS content, e.link, e.date, e.is_read, e.is_favorite, e.id_feed, e.tags FROM `freshrss_alex_entry` e INNER JOIN (SELECT e1.id FROM `freshrss_alex_entry` e1 INNER JOIN `freshrss_alex_feed` f ON e1.id_feed=f.id WHERE f.priority > 0 AND e1.id <=9000000000000000 AND (e1.id >= 1381615200000000 OR e1.is_read=0 OR e1.is_favorite=1 OR (f.keep_history <> 0)) ORDER BY e1.id DESC LIMIT 31) e2 ON e2.id=e.id ORDER BY e.id DESC; +----+-------------+------------+--------+-------------------------------------+---------+---------+---------------------+-------+---------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+------------+--------+-------------------------------------+---------+---------+---------------------+-------+---------------------------------+ | 1 | PRIMARY | <derived2> | ALL | NULL | NULL | NULL | NULL | 31 | Using temporary; Using filesort | | 1 | PRIMARY | e | eq_ref | PRIMARY | PRIMARY | 8 | e2.id | 1 | | | 2 | DERIVED | e1 | range | PRIMARY,id_feed,is_favorite,is_read | PRIMARY | 8 | NULL | 70084 | Using where | | 2 | DERIVED | f | eq_ref | PRIMARY,priority,keep_history | PRIMARY | 2 | freshrss.e1.id_feed | 1 | Using where | +----+-------------+------------+--------+-------------------------------------+---------+---------+---------------------+-------+---------------------------------+ 4 rows in set (0.01 sec)
2014-07-08SQL: removed superfluous transactions to avoid some dead locksGravatar Alexandre Alapetite
2014-07-07SQL: improved performance for adding new articlesGravatar Alexandre Alapetite
2014-07-05Add support for SQLiteGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/100 Warning: MySQL has been changed too, so bugs may have been introduced
2014-07-03Preparation for SQLiteGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/100
2014-06-01Search order of filtersGravatar Alexandre Alapetite
For now, process them in the same order as specified by the user Specifying for instance `date:` first will be much faster than specifying a free text word first. https://github.com/marienfressinaud/FreshRSS/issues/511
2014-06-01New search system, including date: and pubdate: and combinationGravatar Alexandre Alapetite
Now also accepts combination of #tag and intitle: and inurl: and author: and the new date: and pubdate: https://github.com/marienfressinaud/FreshRSS/issues/511 Each search prefix stop at the first space (we should add a possibility to have quotes for multiple words) So if you want two words in title, write "intitle:word1 intitle:word2" Examples of dates: date:2014 date:2014-02/2014-04 or date:201402/201404 date:P1W for the last week
2014-04-15Minor syntax changes for: New toggle buttons to filter articlesGravatar Alexandre Alapetite
See http://programmers.stackexchange.com/questions/23852/bitwise-or-vs-adding-flags https://github.com/marienfressinaud/FreshRSS/pull/486 https://github.com/marienfressinaud/FreshRSS/issues/376
2014-04-13Move state constants from Configuration to EntryGravatar Alexis Degrugillier
2014-04-13Revert deletion of the favorite actionsGravatar Alexis Degrugillier
2014-04-13Add a new status for 'ALL'Gravatar Alexis Degrugillier
I made the conversion in every file I can think of. It should not have any reference to the string 'all' for the state context
2014-04-12Delete favorite buttonGravatar Alexis Degrugillier
I extract drop-down menu actions to make them as button action in the page header. I removed the favorite button on the category list because it is a duplicate from the button action. Now button action act as filters and you can combine them. It is a test to see if we can keep it like that. There is still work to do to extract other actions from the drop-down list. I did not want to change everything if we don't keep it. See #376 and #277
2014-03-30Import of articles is implemented!Gravatar Marien Fressinaud
- Remove massiveImportAction and addCategories from FeedController - Fix typo for some methods (camelCase) - addCategoryObject and addFeedObject return id if corresponding object already exists in DB - introduce addEntryObject. Return -1 if Entry already exist (in order to keep quite good performances) - Complete importArticles method Need some more tests + better performance
2014-03-03API: Add continuation modeGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/443 Needed for e.g. EasyRSS
2014-03-02API : SQL optimisation WHERE ... IN, and better compatibility EasyRSSGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/13
2014-03-01API: SQL optimisationGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/13
2014-02-28API streamContents for categories and feedsGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/13
2014-02-27Alpha version of Google Reader compatible APIGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/13 Hardcoded passwords, no possibility to add/delete feeds or edit categories yet.
2014-02-21Bug "mark all as read" when using DESC and pagination and no scrollGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/431#issuecomment-35774488
2014-01-08Ajout d'un filtre sur les articles lusGravatar Alexis Degrugillier
Ajout d'un filtre sur les articles favoris
2014-01-05Compatibilité MySQL 5.5 WindowsGravatar Alexandre Alapetite
Testé vite fait avec MySQL 5.5 sous Windows, et les chaînes vides '' utilisées jusqu'à présent dans le cas de booléens faux causaient une erreur. Vérifier s'il n'y a pas d'autres exemples ailleurs dans le code
2013-12-25Fin taille historiqueGravatar Alexandre Alapetite
Permet d'éviter les problèmes de flux vides à l'importation https://github.com/marienfressinaud/FreshRSS/issues/332 , ou de nombre d'articles non-lus qui ne correspondent pas au nombre d'articles affichés
2013-12-25Option globale pour la taille minimale de l'historique par défautGravatar Alexandre Alapetite
Plus une réorganisation des options
2013-12-24Permet de configurer plus finement le nombre d’articles minimum à ↵Gravatar Alexandre Alapetite
conserver par flux
2013-12-23Synchronisation quelques lignes blanchesGravatar Alexandre Alapetite
2013-12-19Refactorisation : correction classes oubliéesGravatar Alexandre Alapetite
2013-12-16Recherches spéciales intitle: ou inurl: ou author:Gravatar Alexandre Alapetite
Permet de chercher en utilisant intitle: ou inurl: ou author: comme dans certains moteurs de recherche. Pour l'instant, un seul de ces mots clefs à la fois peut être spécifié en tout début de chaîne de recherche et sera appliqué à l'ensemble du reste de la recherche. NB: À ajouter à la documentation, wiki
2013-12-16SQL : permet recherche du caractère dièseGravatar Alexandre Alapetite
2013-12-16SQL : petits changement rechercheGravatar Alexandre Alapetite
Traite mieux les caractères spéciaux. Permet par exemple une recherche sur des mots contenant des apostrophes, ou le signe pourcentage, etc. Il faudra toujours essayer d'améliorer la recherche en particulier lorsque plusieurs mots sont fournis
2013-12-16SQL : correction rechercheGravatar Alexandre Alapetite
Oups, mon précédent changement SQL avait cassé la recherche. Patch rapide en attendant une ré-optimisation en particulier pour le cas de recherche sur plusieurs mots
2013-12-16SQL : performancesGravatar Alexandre Alapetite
Tentative de reformulation de la requête principale pour améliorer les performances. Utilisation d'une sous-jointure qui retourne uniquement e.id. Sur mon serveur avec 13000 articles, la requête de la page d'accueil sans article non lu mettait 1.38s avant le patch, contre 0.08s après (en désactivant bien sûr le cache SQL). Il faudra re-tester et tenter d'autres optimisations (notamment sur les index) avec un nombre d'articles plus important. Avant : SELECT SQL_NO_CACHE e.id, e.guid, e.title, e.author, UNCOMPRESS(e.content_bin) AS content, e.link, e.date, e.is_read, e.is_favorite, e.id_feed, e.tags FROM `freshrss_alex_entry` e INNER JOIN `freshrss_alex_feed` f ON e.id_feed = f.id WHERE f.priority > 0 AND (e.id >= 1371597014000000 OR e.is_favorite = 1 OR f.keep_history = 1) ORDER BY e.id DESC LIMIT 33; Après : SELECT SQL_NO_CACHE e.id, e.guid, e.title, e.author, UNCOMPRESS(e.content_bin) AS content, e.link, e.date, e.is_read, e.is_favorite, e.id_feed, e.tags FROM `freshrss_alex_entry` e INNER JOIN (SELECT e1.id FROM `freshrss_alex_entry` e1 INNER JOIN `freshrss_alex_feed` f ON e1.id_feed = f.id WHERE f.priority > 0 AND (e1.id >= 1371597014000000 OR e1.is_favorite = 1 OR f.keep_history = 1) ORDER BY e1.id DESC LIMIT 33) e2 ON e2.id = e.id ORDER BY e.id DESC;
2013-12-15SQL : Petite amélioration de la requête principaleGravatar Alexandre Alapetite
En particulier pour les favoris, où cela évite une jointure.
2013-12-15Date minimum : cas des favoris et de l'historique completGravatar Alexandre Alapetite
Suite de https://github.com/marienfressinaud/FreshRSS/issues/323
2013-12-15Date minimum pour afficher les articlesGravatar Alexandre Alapetite
Implémente décision https://github.com/marienfressinaud/FreshRSS/issues/323
2013-12-15Grosse refactorisation pour permettre le chargement automatique des classesGravatar Alexandre Alapetite
C'est parti de changements pour https://github.com/marienfressinaud/FreshRSS/issues/255 et finalement j'ai continué la refactorisation... Ajout de préfixes FreshRSS_ et Minz_ sur le modèle de SimplePie_. Toutes les classes sont maintenant en chargement automatique (devrait améliorer les performances en évitant de charger plein de classes inutilisées, et faciliter la maintenance). Suppression de set_include_path(). Si souhaité, certaines classes de Minz pourraient être déplacées dans un sous-répertoire, par exemple les exceptions. Tests et relecture nécessaires.
generated by cgit v1.2.3 (git 2.39.1) at 2026-02-11 10:22:26 +0000