summaryrefslogtreecommitdiffstats
path: root/lib/Db
AgeCommit message (Collapse)Author
2021-02-02fix item purger for PostgreSQLanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-01-30Mappers: Implement item purgingSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-01-17fix typo in string template valueanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-01-15fix TypeError in ItemMapperanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-01-13fix opened state of folders is not restoredanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-01-12Fix psalm issuesSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-01-11remove deprecated colon prefix for parametersanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-01-08autofix round2Benjamin Brahmer
2021-01-08fix the testBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2021-01-08fixes done by psalmBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2020-12-30Improve itemmapper wordingSean Molenaar
Co-authored-by: anoy. <anoymouserver@users.noreply.github.com>
2020-12-30Remove PHPunit integration testsSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-12-23fix FeedMapper find exceptionanoy
Exception: Argument 2 passed to OCA\News\Db\FeedMapper::find() must be of the type int, string given Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2020-12-15Remove LastModified-based cursor when updating feedsKevin Decherf
We remove the call to readSince() as some feeds push new articles with pubDate prior to the lastModified time stored for these feeds (e.g. lemonde.fr). As we go through all items of a feed again and again, we prevent the constant update of an item's lastModified timestamp by keeping the previous one if its fingerprint does not change. Fixes #921 Signed-off-by: Kevin Decherf <kevin@kdecherf.com>
2020-12-08Fix alias usage in v2 mapperSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-12-08Refactor User ID fetching and fix non-specific cleanupSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-12-08Remove usage of old Folder codeSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-11-11fix second where overrides previous conditionanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2020-11-10Fix unread count and related issuesSean Molenaar
Issue GH-924 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-11-03Add migration with foreign keysSean Molenaar
Closes #829 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-10-28DB: stop overloading getIDSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-10-09fix multiple results for guid_hashanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2020-10-09Add Type Info to EntitiesTilo Spannagel
Signed-off-by: Tilo Spannagel <development@tilosp.de>
2020-10-04update only relevant item fieldsanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org> Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-10-04trim whitespaces in item titlesanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2020-10-03remove doubled executeanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2020-10-03DB: Fix mime checkingSean Molenaar
Signed-off-by: Sean Molenaar <sean@m2mobi.com>
2020-10-03fix matching any stringBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2020-10-03Fix various 15.0 bugsSean Molenaar
Issue #821,#820,#819 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-09-29Add feed autodiscoverySean Molenaar
Issue GH-415 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-09-29OPML export command and fixesSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-09-27Create V2 mapper, Service and management commandsSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-09-25change statement for deleting items with help from @Talon24Benjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2020-08-29fix import with invalid guid_hashBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2020-08-25Add phpstan checksSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-05-21Do not create spurious links in item bodyDavid Engster
The 'str_replace' will match any HTML element that starts with '<a', including things like '<address' or '<article', thus creating spurious links in item bodies. Fix that by simply adding one whitespace. Fixes issue #527. Signed-off-by: David Engster <deng@randomsample.de>
2020-04-23Always show the unread articles.Cesar Enrique Garcia Dabo
The unread articles folder will always be visible, regardless of the "Show all" setting. If that setting is on, then an additional "All articles" folder will be show as before, but it doesn't substitute the "Uread articles" one. A new URL /apps/news/#/items/unread is also created that jumps to the unread articles. Signed-off-by: Cesar Enrique Garcia Dabo <cquike@arcor.de>
2020-03-01Different solution for ONLY_FULL_GROUP_BY (see #406) (Issue #80) (#407)Talon24
* Group by moved to subquery, get feed details from outer query (see #406) Signed-off-by: Talon <talontalon24@gmail.com>
2020-02-16Basic Media-RSS support (#599)Éloi Rivard
Signed-off-by: Éloi Rivard <azmeuk@gmail.com>
2019-03-22Stop assuming encoding of xml, let simplexml throw silently (#457)Sean Molenaar
2019-03-17fix/allow CDATA encoding (#428)Sean Molenaar
2019-01-30Parser: Switch to feedIO for parsing instead of picoFeedSean Molenaar
2018-12-14Define an official codestyle and adhere to it.Sean Molenaar
2018-10-14Fix lastModified to be a string rather than an integer. (#355)Detlev Zundel
This fixes https://github.com/nextcloud/news/issues/350#issue-369283392 Signed-off-by: Detlev Zundel <dzu@member.fsf.org>
2018-09-28add setters + getters to Folder and Item entities, fixed unit tests, ↵Daniel Opitz
rearranged methods
2018-09-28add php7 typesDaniel Opitz
2018-09-28add getters + setters for feed entityDaniel Opitz
2018-03-27Core: Fix compatibility with nextcloud codestyle (#280)Sean Molenaar
2017-08-14Split binary to booleans (#203)Daniel Opitz
* replaced old status with 2 flags for unread and starred * add fields to db, replace int(1,0) with booleans in sql queries, removed StatusFlags class + refactor code relying to it * add repair step for migration * again use integer(1,0) instead of bool in sql queries, because of sqlite doesn't support true/false * add/fix unit tests for new boolean status * set unread/starred flags as statements in sql * fixed mysql unknown column items.unread, fixed marking of read items on repair step * remove unnecessary bool casts * add empty checks to Items::is* methods * update migration to use native sql instead of the querybuilder * don't cast the flags manually, let the api do the work
2017-01-04Add updatedDate to item model (#81)Daniel Schaal
* Update picoFeed to v0.1.28 * Add updated_date to database and bump version to 10.1.1 * Add updatedDate to item model * Check for updatedDate when updating a feed * Fix unit test to check for newer updatedDate