summaryrefslogtreecommitdiffstats
path: root/lib/Db
AgeCommit message (Collapse)Author
2024-01-25StylingIgorA100
Signed-off-by: IgorA100 <igora100@gmail.com>
2024-01-25Replacing tabs with spacesIgorA100
Signed-off-by: IgorA100 <igora100@gmail.com>
2024-01-25Cancel preserve keys of the items array.IgorA100
Signed-off-by: IgorA100 <igora100@gmail.com>
2024-01-25Fix: Mark over 65535 unread items as "read"IgorA100
If there are more than 65535 unread items, then when checking β€œmark as read” you will get an SQL error (SQLSTATE[HY000]: General error: 7 number of parameters must be between 0 and 65535 at) due to the limitation of the number of parameters. The array is divided into smaller ones. Signed-off-by: IgorA100 <igora100@gmail.com>
2023-11-08fix dbal deprecationsBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2023-04-16Improve sql query performance by removing unused payloadDaniel Starzmann
Signed-off-by: Daniel Starzmann <daniel@starze.de>
2023-04-05Set lastmodified in read allBenjamin Brahmer
if this is not updated the API won't work correctly and we get sync errors. Adjust test to use item api Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2023-01-12Update lib/Db/Feed.phpBenjamin Brahmer
Co-authored-by: Sean Molenaar <SMillerDev@users.noreply.github.com> Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2023-01-12don't process link if it's nullBenjamin Brahmer
don't process body of feed if it's null Co-authored-by: Sean Molenaar <SMillerDev@users.noreply.github.com> Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-10-08New administrator setting for deleting unread items automaticallyBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-08-31fix readAllBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-08-21change itemMapper readAllBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-08-19Fix deprecation warnings from Nextcloud. (#1869)Benjamin Brahmer
* don't use private class anymore * execute is deprecated * fix migration execute statement * fix unittest Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-08-19Fix deprecationsBenjamin Brahmer
add phpstan deprecation rules Co-authored-by: Sean Molenaar <SMillerDev@users.noreply.github.com> Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-08-19Fix Test and adjust codeBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-08-19add item types to api docsBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-08-19adapt generateSearchIndexBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-06-28fix type always string for findAllFromUserBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-05-04check if variable is null before striping tagsBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de> Co-authored-by: Sean Molenaar <SMillerDev@users.noreply.github.com>
2022-05-02update last_modified when marking an item as readBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de> this way it works Signed-off-by: Benjamin Brahmer <info@b-brahmer.de> add changelog entry Signed-off-by: Benjamin Brahmer <info@b-brahmer.de> Partly fix test Signed-off-by: Benjamin Brahmer <info@b-brahmer.de> test passing Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-03-18rename maxItemId to newestItemId to match docsBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2021-11-18Fix code styleBenjamin Brahmer
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2021-11-18chore: use executeStatement instead of executeUpdateSean Molenaar
Signed-off-by: Sean Molenaar sean@seanmolenaar.eu Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2021-06-16πŸš‘ Item: set id to null in clone functionMarco Nassabain
This is done to set the id to null BEFORE resetting the updated fields. The purpose of this is to avoid explicitly adding a NULL id into the DB, which provokes an error in some DBMS (like postgres). Fixes #1375 Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-05-27db: no longer order by items.last_modifiedSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu> Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2021-04-14DB: only sort on item IDsSean Molenaar
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-04-08πŸ”₯ Remove changes to back-end from front-end prMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08(+) Adding sharing_user names to EVERY articles + pre-condition if ↡Jimmy Huynh
sharedArticle: no title feed (e.g.: from wikiRSS...) Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08🩹 Item: change $sharedBy to string|null in annot.Marco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08🩹 Fix sharedByDisplayName bug:Marco Nassabain
- setting sharedByDisplayName shouldn't mark it as updated Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08πŸ”₯ Remove UserManager code from ItemMapper & testsMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08✏️ Fix phpcs indentation errorMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08🩹 Fix issues after rebaseMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08🩹 Item: mark categoriesJson as updated in cloneMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08✨ Item: add sharer display name in findEntitiesMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08✨ Update Item model: add sharedByDisplayNameMarco Nassabain
- added field + setters + getters - include field in serialized Item Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08♻️ Item: Remove isSharedMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08🧹 Cleanup code, remove spaces, rename variablesMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08πŸš‘ Fix newsItem insert errorMarco Nassabain
- add Item::__clone method resetting updated fields - set item id to null in ShareService Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08🎨 Item.php: make shared_by nullableMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08🎨 Item.php: Remove shared_withMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08πŸ”₯ Remove old share item logic & functionsMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08πŸ—‘ '!=' is discouraged, replaced by '!=='WENDLING NICOLAS
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08πŸ—‘ '!=' is discouraged, replaced by '!=='WENDLING NICOLAS
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08🎨 ItemMapperV2: add new offset code (findShared)Marco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08πŸ”₯ Remove old ItemMapper & ItemServiceMarco Nassabain
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08🩹 Remove traces of feed_id being nullableMarco Nassabain
- feed_id is not nullable so we remove default values Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08✨ Add findAllSharedAfterMarco Nassabain
- adapted Controller, Service and Mapper (newItems) Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08✨ ItemMapperV2: exclude shared items in functionsMarco Nassabain
updated the following functions to exclude shared_items: - findAllInFeedAfter - findAllInFolderAfter - findAllFeed - findAllFolder Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08✨ ItemMapperV2: include shared in functionsMarco Nassabain
updated the following functions to include shared items: - findFromUser - findForUserByGuidHash - readAll - findAllAfter - findAllItems Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>