1
0
mirror of https://github.com/chylex/Nextcloud-News.git synced 2024-10-17 08:42:48 +02:00
Commit Graph

48 Commits

Author SHA1 Message Date
Daniel Starzmann
2d4cb5ed1c Improve sql query performance by removing unused payload
Signed-off-by: Daniel Starzmann <daniel@starze.de>
2023-04-16 11:13:30 +02:00
Benjamin Brahmer
a70d155ce4 Set lastmodified in read all
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-04-05 19:43:02 +02:00
Benjamin Brahmer
b88e1a546a New administrator setting for deleting unread items automatically
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-10-08 17:29:08 +02:00
Benjamin Brahmer
a7f69c4b63 fix readAll
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-08-31 16:14:18 +02:00
Benjamin Brahmer
4afd5a547d change itemMapper readAll
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-08-21 16:39:07 +02:00
Benjamin Brahmer
66a161e4f7 fix type always string for findAllFromUser
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-06-28 17:29:13 +02:00
Benjamin Brahmer
f0a1c92502 Fix code style
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2021-11-18 14:10:57 +01:00
Sean Molenaar
a52eee5671 chore: use executeStatement instead of executeUpdate
Signed-off-by: Sean Molenaar sean@seanmolenaar.eu
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2021-11-18 14:10:57 +01:00
Sean Molenaar
74f09ee716 db: no longer order by items.last_modified
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2021-05-27 19:12:55 +02:00
Sean Molenaar
111bf5fff2 DB: only sort on item IDs
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-04-14 13:56:54 +02:00
Marco Nassabain
bbdd95c30d 🔥 Remove UserManager code from ItemMapper & tests
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
4d0a82d429 ✏️ Fix phpcs indentation error
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
7306370ece Item: add sharer display name in findEntities
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
9bd27da9ba 🔥 Remove old share item logic & functions
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
af02560363 🎨 ItemMapperV2: add new offset code (findShared)
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
08982fc540 Add findAllSharedAfter
- adapted Controller, Service and Mapper (newItems)

Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
1f0924fb57 ItemMapperV2: exclude shared items in functions
updated the following functions to exclude shared_items:
- findAllInFeedAfter
- findAllInFolderAfter
- findAllFeed
- findAllFolder

Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
26ae92bc7b ItemMapperV2: include shared in functions
updated the following functions to include shared items:
- findFromUser
- findForUserByGuidHash
- readAll
- findAllAfter
- findAllItems

Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
83bdbc08a0 ItemMapperV2: include shared in functions
updated the following functions to include shared items:
- findAllFromUser
- newest

Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
c3cc70b15e ItemMapperV2: added findAllSharedWithUser funct
- return all items shared with a given user

Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Sean Molenaar
90702dd297 DB: Use boolean parameter for unread/starred
Issue GH-1278

Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-04-06 12:43:24 +02:00
Sean Molenaar
951f3eb7ee DB: Allow negative limits
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-04-05 19:18:19 +02:00
Sean Molenaar
78dce7ffe1 DB: Updates should use set()
Issue GH-1211

Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-03-31 22:39:00 +02:00
Sean Molenaar
2baa7a2b91 Make PHPstan stricter
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-03-25 18:47:38 +01:00
Sean Molenaar
baf1ca8ec9 DB: Don't show deleted feed items
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-03-23 21:11:25 +01:00
Sean Molenaar
9d5d35ce23 DB: Fix offset quotes
Issue GH-1200

Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-02-27 15:12:59 +01:00
Sean Molenaar
bf1e71f1a7 DB: Use ID as offset in item queries
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-02-23 17:16:20 +01:00
Sean Molenaar
4a107b3d53 General: Fix folder query
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-02-20 13:57:09 +01:00
anoy
8ca7ef7e49 update sorting column
follow-up for b4fa772bc5 (#1056)

Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-02-14 17:15:46 +01:00
Sean Molenaar
b4fa772bc5 Remove V1 item API
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-02-13 13:22:57 +01:00
anoy
7e9fd48f4a fix refetching of purged articles
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-02-10 13:58:13 +01:00
Sean Molenaar
5406086829 Psalm: Fix class loading 2021-02-05 07:27:11 +01:00
anoy
5c7838e9bd fix result ordering for purging query
updated_date is currently always NULL

Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-02-04 09:03:06 +01:00
anoy
e601f07ee6 fix articlesPerUpdate alias
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-02-02 20:50:34 +01:00
anoy
f2b74a0ba1 fix item purger for PostgreSQL
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-02-02 13:48:55 +01:00
Sean Molenaar
023c61b88f Mappers: Implement item purging
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-01-30 18:27:06 +01:00
Sean Molenaar
67b6c4e1b0 Fix psalm issues
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2021-01-12 13:29:08 +01:00
anoy
8de3ad77fc remove deprecated colon prefix for parameters
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-01-11 09:32:23 +01:00
Benjamin Brahmer
7180e11bdb fixes done by psalm
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2021-01-08 22:45:10 +01:00
Sean Molenaar
05377d023e Remove PHPunit integration tests
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-12-30 11:21:44 +01:00
Sean Molenaar
e0edfd0dc5 Fix alias usage in v2 mapper
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-12-08 16:11:17 +01:00
Sean Molenaar
4ee3fcb781 Refactor User ID fetching and fix non-specific cleanup
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-12-08 13:58:12 +01:00
Sean Molenaar
5bdc2df7f4 Fix unread count and related issues
Issue GH-924

Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-11-10 16:47:42 +01:00
anoy
1fcab6e6c6 fix multiple results for guid_hash
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2020-10-09 20:38:58 +02:00
anoy
bfcf38a480 update only relevant item fields
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-10-04 21:35:31 +02:00
Sean Molenaar
167dc70238 Fix various 15.0 bugs
Issue #821,#820,#819

Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-10-03 14:01:36 +02:00
Sean Molenaar
35b53ecd40 OPML export command and fixes
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-09-29 14:56:07 +02:00
Sean Molenaar
d00d1ab2a2 Create V2 mapper, Service and management commands
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
2020-09-27 15:35:31 +02:00