summaryrefslogtreecommitdiffstats
path: root/lib/Db
AgeCommit message (Collapse)Author
2021-05-05mitigate 32-bit issues with microsecondsanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-04-16DB: only sort on item IDsSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-04-06DB: Use boolean parameter for unread/starredSean Molenaar
Issue GH-1278 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-04-05DB: Allow negative limitsSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-03-31DB: Updates should use set()Sean Molenaar
Issue GH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-03-25Make PHPstan stricterSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-03-23DB: Don't show deleted feed itemsSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-03-17🎨 Item: implode categories for search indexMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-03-17🎨 Item: store categories as json & add helper fnsMarco Nassabain
+ added setter/getters that work with arrays to simplify use case Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-03-17✨ Item: add categories into search indexMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-03-17✨ Add 'catagories' to jsonSerialize()Jimmy Huynh
Signed-off-by: Jimmy Huynh <jimmy.huynh@etu.unistra.fr>
2021-03-17♻️ Renaming 'tags' into 'categories'Jimmy Huynh
Signed-off-by: Jimmy Huynh <jimmy.huynh@etu.unistra.fr>
2021-03-17🐛 Fix Item model: set default value for setTagsMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-03-17✨ Update 'Item' model: add 'tags' fieldJimmy Huynh
Signed-off-by: Jimmy Huynh <jimmy.huynh@etu.unistra.fr>
2021-02-27DB: Fix offset quotesSean Molenaar
Issue GH-1200 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-02-23DB: Use ID as offset in item queriesSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-02-20General: Fix folder querySean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-02-20Command: Add debug item list commandsSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-02-14update sorting columnanoy
follow-up for b4fa772bc5f23f84fc292f5d6bf884543d2bfe51 (#1056) Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-02-13Remove V1 item APISean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-02-10fix refetching of purged articlesanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-02-05DB: Remove unused fieldsSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-02-05Psalm: Fix class loadingSean Molenaar
2021-02-04fix result ordering for purging queryanoy
updated_date is currently always NULL Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-02-02fix articlesPerUpdate aliasanoy
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
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>