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
a7f69c4b63
fix readAll
...
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-08-31 16:14:18 +02:00
Benjamin Brahmer
1a76e03f5a
fix unittest
...
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
2022-08-21 16:39:07 +02: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
anoy
ed066a8129
adapt tests to QBMapper changes in NC22
...
Signed-off-by: anoy <anoymouserver+github@mailbox.org>
2021-07-17 20:31:29 +02: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
af84bbf204
✅ Item: update tests - include sharer display name
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
2cba1e4146
🧹 Cleanup code, remove spaces, rename variables
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
2ee5112760
🔥 Remove old share logic from tests & old tests
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
702d611f35
🔀 Resolving merge: moving shared tests
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
85dbed9ffa
🧹 Cleanup test files: added new lines
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
dd4617d368
Fix findFromUser, testFindAllFromUserWithParams, testFindAllFromUser
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
5a12e50cca
Fix testFindForUserByGUIDHash
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
2c59331316
Fix testNewest
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
306f97d656
Fix tests testFindAllInFolderAfterHideRead, testFindAllInFolderAfter, testFindAllInFeedAfterHideRead, testFindAllInFeedAfter
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
6775fe541e
Fix testFindAllItemsStarredSearch, testFindAllItemsStarred, testFindAllItemsUnread
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
e7ec222c1d
Fix testFindAllItemsInvalid, testFindAllAfterInvalid, testFindAllAfterStarred, testFindAllAfterUnread
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
d6b32cf674
fix test findAllFeed
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
d314e8b495
Fix test findAllFeedSearch and findAllFeedHideRead
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
f59fe96105
Fix test findAllFolderIdNull and findAllFolderHideRead
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
319b15a655
Fix test findAllFolderHideReadInvertOrder
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
8b51ee583e
Fix test FindAllFolderSearchId
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Aurélien
818736c2be
fix test readAll
...
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
fc8670f5be
✅ ItemMapperTest: add tests for findAllSharedAfter
...
- testFindAllSharedAfter
- testFindAllSharedAfterHideRead
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +02:00
Marco Nassabain
cbe1ca6b4d
✅ ItemMapperTest: test findAllSharedWithUser func
...
- testFindAllSharedWithUser
- testFindAllSharedWithUserHideRead
- testFindAllSharedWithUserSearch
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
2021-04-08 22:31:21 +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
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
Daniel Opitz
a97dd58e3b
Split binary to booleans ( #203 )
...
* 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-08-14 10:34:53 +02:00
Bernhard Posselt
7a3a22bd27
Adjust copyright header
2016-07-23 21:32:42 +02:00
Bernhard Posselt
004fcbbcc7
Move to new directory structure
2016-07-23 21:24:54 +02:00