aboutsummaryrefslogtreecommitdiff
path: root/app/Models/EntryDAO.php
AgeCommit message (Collapse)Author
2018-03-01cleanOldEntries call autoUpdateDb (#1804)Gravatar Alexandre Alapetite
* cleanOldEntries call autoUpdateDb https://github.com/FreshRSS/FreshRSS/issues/1803 * Fix feedDAO autoUpdateDb * Move cleanOldEntries to EntryDAO Only the entry table is concerned
2018-02-08API /reader/api/0/stream/items/contents (#1774)Gravatar Alexandre Alapetite
* API /reader/api/0/stream/items/contents For FeedMe * Fix continuation * Continuation in stream/items/ids * Fix multiple continuations * Allow empty POST tokens For FeedMe. This token is not used by e.g. The Old Reader API. There is the Authorization header anyway. TODO: Check security consequences * API compatibility FeedMe: add/remove feed FeedMe uses GET for some parameters typically given by POST * A bit of sanitization * Links to FeedMe * API favicons more robust when base_url is not set * Changelog FeedMe
2018-01-01Add mute strategy configuration (#1750)Gravatar Alexis Degrugillier
2017-10-12CLI optimize database (#1663)Gravatar Alexandre Alapetite
CLI optimize database https://github.com/FreshRSS/FreshRSS/issues/1583 And VACUUM in SQLite https://github.com/FreshRSS/FreshRSS/issues/918 Add VACUUM for PostgreSQL (Not tested yet)
2017-09-22[ci] Add Travis (#1619)Gravatar Frans de Jonge
* [ci] Add Travis * Exclude some libs * Semi-auto whitespace fixes * line length in SQLite * Exclude tests from line length * Feed.php line length * Feed.php: get rid of unnecessary concat * Feed.php: line length * bootstrap.php: no newline at end of file * Allow concatenating across multiple lines * Add Travis badge * do-install line length * update-or-create-user line length * cli/create-user line length * tests/app/Models/SearchTest.php fix indentation * tests/app/Models/UserQueryTest.php fix indentation * tests/app/Models/CategoryTest.php fix indentation * [fix] PHP 5.3 on precise * cli/do-install no spaces * cli/list-users line length * cli/reconfigure line length * empty catch statements * api/index line length nonsense * spaces before semicolon * app/Models/EntryDAO bunch of indentation * extra blank lines * spaces before comma in function call * testing tabwidth * increase to 10 * comment out tabwidth line * try older phpcs version 3.0.0RC4 * line length exception for app/install.php * proper spaces * stray spaces in i18n * Minz/ModelPdo line length * Minz whitespace * greader line length * greader elseif placement * app/Models/Feed.php spacing in function argument * ignore php 5.3 * app/Models/ConfigurationSetter.php stray whitespace * EntryDAOSQLite line length * I vote for higher max line length =P * ignore SQL * remove classname complaint * line length/more legible SQL * ignore line length nonsense * greader line length * feedController issues * uppercase TRUE, FALSE, NULL * revert * importExportController lowercase null * Share.php default value not necessary because ! is_array () a few lines down * CategoryDAO constants should be UPPERCASE * EntryDAO reduce line length * contentious autofix * Allow failures on all versions of PHP except 7.1 because reasons
2017-04-01Negative searchesGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/1381 Possibility to exclude authors, titles, tags, urls, words by prefixing them by ! or - (like Google Search): * !intitle:unwanted * -intitle:unwanted * -author:unwanted * -#unwanted * -unwanted And one can use many of each and combine them with positive searches
2017-04-01Improve search: intitle, author, inurlGravatar Alexandre Alapetite
Allow multiple values of intitle: , author:, inurl: Note: Tests for UserQueryTest are broken due to https://github.com/sebastianbergmann/phpunit/wiki/Release-Announcement-for-PHPUnit-4.0.0#backwards-compatibility-issues
2017-03-26Merge branch 'FreshRSS/dev' into defered-insertionGravatar Alexandre Alapetite
2017-03-26PDO fix PHP 7.1Gravatar Alexandre Alapetite
http://php.net/manual/migration71.changed-functions.php#migration71.changed-functions.pdo
2017-03-26SimplePie light manual updateGravatar Alexandre Alapetite
2017-03-26More defered insertion. New SQL indexGravatar Alexandre Alapetite
New index entry_feed_read_index TODO: Auto add this index to existing version
2017-03-26Defered insertion MySQL bugGravatar Alexandre Alapetite
The update of cached values remains to be optimized
2017-03-26Candidate implementation of defered insertionGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/530
2017-01-27postgres fixesGravatar Thomas Citharel
2016-11-15Stream JSON exportGravatar Alexandre Alapetite
Avoid large in-memory copies https://github.com/FreshRSS/FreshRSS/issues/1372
2016-11-05Add CLI for user information + Fix last user activityGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/1345
2016-11-02Use bindValue instead of bindParamGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/1349 We should later replace all bindParam by bindValue
2016-10-20Extract function safe_ascii()Gravatar Alexandre Alapetite
2016-10-20guid and urls should not contain low/high charactersGravatar Alexandre Alapetite
It looks like SimplePie does not always filter everything Having a character not in latin1 would create MySQL collate errors
2016-10-16Fix updateEntry warningGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/1325
2016-10-14PostgreSQL compatibility booleanGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/1311
2016-10-11Better error message in markReadFeedGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/1299
2016-10-05Take better advantage of other users refreshGravatar Alexandre Alapetite
2016-10-01PostgreSQL case-insensitivity bugGravatar Alexandre Alapetite
2016-10-01Bug updateEntry()Gravatar Alexandre Alapetite
2016-10-01BindParam bugGravatar Alexandre Alapetite
2016-10-01PostgreSQL updateEntry()Gravatar Alexandre Alapetite
2016-09-06MySQL use unhex instead of hex litteralGravatar Alexandre Alapetite
X' syntax did not work well with bind values
2016-08-31Quoted upper-cases instead of string replaceGravatar Alexandre Alapetite
2016-08-23More PostgreSQLGravatar Alexandre Alapetite
2016-08-20Merge branch 'FreshRSS/dev' into PostgreSQLGravatar Alexandre Alapetite
2016-08-19More SQLite fix for mark search as readGravatar Alexandre Alapetite
2016-08-19SQLite fix for mark search as readGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/1220 https://github.com/FreshRSS/FreshRSS/pull/1218 https://github.com/FreshRSS/FreshRSS/issues/608
2016-08-18SQL mark search as readGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/608
2016-08-02PostgreSQL draftGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/416 Based on @Damstre work https://github.com/FreshRSS/FreshRSS/pull/1071 Not tested
2016-08-01MySQL UTF8MB4 minor detailsGravatar Alexandre Alapetite
2016-07-30Update MySQL to utf8mb4 (full unicode) 🔥Gravatar Alexandre Alapetite
* Requires MySQL 5.5.3+ (drop support for MySQL 5.0) * Requires PHP 5.3.3+ (drop support for PHP 5.3.0) https://github.com/FreshRSS/FreshRSS/issues/789#issuecomment-73878076
2015-07-10Avoid hex2bin for PHP 5.3Gravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/894 And use native hexadecimal function when available (MySQL) to avoid having binary data in the SQL logs.
2015-05-31Minor comment 1.1.1Gravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/845
2015-05-31MySQL create table bugGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/845 And updated version comments to 1.1.1
2015-05-24Bug EntryDAO filterGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/850
2015-05-11More SQLite compatibilityGravatar Alexandre Alapetite
Additional changes to add compatibility with SQLite for the new hash/lastSeen mode of updating articles.
2015-05-10Hexadecimal literals do not work with SQLite/PDOGravatar Alexandre Alapetite
X'09AF' hexadecimal literals do not work with SQLite/PDO. Replaced by PHP hex2bin(). https://github.com/FreshRSS/FreshRSS/commit/711530a512b370d79b079205ce1f8376174f7f03
2015-05-09Merge branch 'FreshRSS/dev' into devGravatar Alexandre Alapetite
2015-05-09SQL: update request for updated articlesGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/798
2015-04-22Split the search into valuesGravatar Alexis Degrugillier
Before, the search was a single value. Now it is splited in chuncks when separated by spaces. Except if they are enclosed by single quotes or double quotes. For some reasons, the unit tests are working for both single and double quotes but the search box isn't. It is working only with single quotes. We need to investigate the reason of this behavior. See #823
2015-04-04SQL: detection of updates, and preparation for better burgeGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/798 https://github.com/FreshRSS/FreshRSS/issues/493 SQLite not yet tested. Only MySQL tested so far.
2015-03-05Fix spacingGravatar Alexis Degrugillier
2015-03-05Introduce user queries objectsGravatar Alexis Degrugillier
There is now an object to manipulate user queries. It allows to move logic to handle those from the view and the controller in the model. Thus making the view and the controller easier to read. I introduced a new interface to start using dependency injection. There is still some rough edges but we are moving in the right direction. The new object is fully tested but it still need some improvements, for instance, it is still tied to the search object. There might be a better way to do that.
2015-03-02Add missing white spaceGravatar Alexis Degrugillier
generated by cgit v1.2.3 (git 2.39.1) at 2026-02-10 15:06:12 +0000