43dc92df52
fix: add handling for MD5 on new MySQL and deprecate MD5 SQL function
...
Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de >
2026-06-21 22:26:00 +02:00
994565fec7
refactor: Use new IQueryBuilder::MAX_IN_PARAMETERS
...
Signed-off-by: Carl Schwan <carlschwan@kde.org >
2026-06-03 13:45:29 +02:00
1ab09ec753
chore: Apply new coding standard to all files
...
The diff can be checked using: git diff --ignore-all-space --ignore-blank-lines
To see only the changes not related to blank lines.
Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com >
2026-06-01 13:46:39 +02:00
ab33da21c6
docs: Adjust since for forUpdate & ConflictResolutionMode
...
Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de >
2026-05-13 00:47:57 +02:00
25ca85e329
docs(ocp): Add since tag
...
Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de >
2026-04-28 11:17:27 +02:00
237d5156b6
fix(ITypedQueryBuilder): Add correct return type and add note about Psalm bug
...
Signed-off-by: provokateurin <kate@provokateurin.de >
2026-02-25 09:52:48 +01:00
40c39270c0
fix((ITypedQueryBuilder): Fix chained calls of non-select methods
...
Signed-off-by: provokateurin <kate@provokateurin.de >
2026-02-25 09:51:59 +01:00
161c91e1fd
feat(DB): Add ITypedQueryBuilder
...
Signed-off-by: provokateurin <kate@provokateurin.de >
2026-02-23 14:06:11 +01:00
f3778bc9c7
fix(propagator): Improve lock behavior of propagator
...
Fix possible dead locks when running the propagator caused by two
requests updating the same amount rows in transactions.
- Lock rows always in the same deterministic order by sorting the
path_hash first
- On all database outside of sqlite, also do first a SELECT FOR UPDATE
to lock all the rows used in batch UPDATE calls, afterward to decrease
the risk of two requests trying to lock the same rows
Signed-off-by: Carl Schwan <carlschwan@kde.org >
2026-02-09 12:10:56 +01:00
b4dfdf6492
refactor: Prefer using IFunctionBuilder than createFunction
...
Signed-off-by: Carl Schwan <carlschwan@kde.org >
2026-01-23 16:58:38 +01:00
7c870a8f67
fix(db)!: Deprecate JSON fields due to problems with querying and selecting
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2025-11-18 11:58:33 +01:00
1dc363581f
fix: get all available previews on Oracle
...
Split the DB requests in chunk of 1000 and use INNER JOIN instead of IN
as this is better supported on all DB.
Signed-off-by: Carl Schwan <carl.schwan@nextcloud.com >
2025-10-23 14:10:15 +02:00
1eff9e5c90
feat(querybuilder): Remove deprecated IQueryBuilder::execute
...
This won't work when we update to doctrine DBAL 4 and all usages in
server were ported away.
Signed-off-by: Carl Schwan <carl.schwan@nextcloud.com >
2025-10-13 17:02:04 +02:00
5981b7eb51
chore: apply new CSFixer rules
...
Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de >
# Conflicts:
# apps/settings/lib/SetupChecks/PhpOpcacheSetup.php
2025-07-01 16:26:50 +02:00
db94e10af0
fix: Prevent breaking change in IQueryBuilder
...
Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de >
2024-10-17 18:31:44 +02:00
ee02e3246d
feat(AppFramework): Add full support for date / time / datetime columns
...
This adds support for all Doctrine supported types, for the column types only the immutable variants needed to be added.
But especially those types are the important ones, as our **Entity** class works by detecting changes through setters.
Meaning if it is mutable, changes like `$entity->date->modfiy()` can not be detected, so the immutable types make more sense here.
Similar the parameter types needed to be added.
`Enity` and `QBMapper` needed to be adjusted so they support (auto map) those types, required when insert or update an entity.
Also added more tests, especially to make sure the mapper really serializes the values correctly.
Co-authored-by: Ferdinand Thiessen <opensource@fthiessen.de >
Co-authored-by: Côme Chilliet <91878298+come-nc@users.noreply.github.com >
Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de >
2024-10-17 18:31:42 +02:00
b45f2420fe
fix: fix share reminder job for oracle
...
Signed-off-by: Robin Appelman <robin@icewind.nl >
2024-09-18 19:24:44 +02:00
ff0cab5956
Merge pull request #47852 from nextcloud/sharding-code-fixes
2024-09-16 11:39:58 +02:00
027fc052e7
fix: Adjust types of IQueryBuilder to properly allow joining with sub-query
...
Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de >
2024-09-10 17:51:27 +02:00
da59fd4389
fix: misc code fixes around db sharding
...
Signed-off-by: Robin Appelman <robin@icewind.nl >
2024-09-09 16:59:59 +02:00
b21a399d1a
fix: implement sharding compatible cleanup for various bits
...
Signed-off-by: Robin Appelman <robin@icewind.nl >
2024-08-28 10:27:14 +02:00
62f8b6517f
feat: implement distributing partitioned queries over multiple shards
...
Signed-off-by: Robin Appelman <robin@icewind.nl >
2024-08-28 10:21:19 +02:00
c09ec95255
feat: track expected output columns in query builder
...
Signed-off-by: Robin Appelman <robin@icewind.nl >
2024-08-28 10:18:52 +02:00
af6de04e9e
style: update codestyle for coding-standard 1.2.3
...
Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de >
2024-08-25 19:34:58 +02:00
eeb6ddb176
fix(db): Deprecate IExpressionBuilder::or() and IExpressionBuilder::and() without parameters
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2024-07-19 11:21:16 +02:00
e45465781f
fix(db): Deprecate getState() as per upstream
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2024-07-19 11:21:15 +02:00
bd383627a7
fix(db): Deprecate using table alias for DELETE and UPDATE
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2024-07-19 11:21:13 +02:00
f92352eda4
fix(db): Deprecate getQueryPart() and resetQueryPart() methods that will be removed with Doctrine/DBAL 4
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2024-07-19 11:21:10 +02:00
9de6190ec4
feat: allow running QueryBuilder queries on different connections
...
Signed-off-by: Robin Appelman <robin@icewind.nl >
2024-07-15 22:41:04 +02:00
dae7c159f7
chore: Add SPDX header
...
Signed-off-by: Andy Scherzinger <info@andy-scherzinger.de >
2024-05-24 13:11:22 +02:00
6d291ac260
chore: Add missing parameter to docblock tag psalm-taint-sink
...
Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com >
2024-04-22 16:38:08 +02:00
15a7aa51c5
fix(dbal): Fix types in query builder methods for parameters
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2023-10-18 07:09:08 +02:00
c4ed7f9d21
fix(dbal): Doctrine\DBAL\Connection::PARAM_* types are deprecated
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2023-10-06 15:29:24 +02:00
5a1fcdb272
fix(dbal): Migrate to Doctrine\DBAL\ParameterTypes
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2023-08-23 09:08:08 +02:00
d55a7c619d
Fix typos in lib/public subdirectory
...
Found via `codespell -q 3 -S l10n -L jus ./lib/public`
Signed-off-by: luz paz <luzpaz@github.com >
Update lib/public/Accounts/IAccount.php
Signed-off-by: luz paz <luzpaz@github.com >
Signed-off-by: Simon L <szaimen@e.mail.de >
Co-Authored-By: Côme Chilliet <91878298+come-nc@users.noreply.github.com >
2023-05-10 11:56:34 +02:00
f5c361cf44
composer run cs:fix
...
Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com >
2023-01-20 11:45:08 +01:00
6e0123a1d0
Revert "add case statement to sql function builder"
...
This reverts commit 2a68819a67robin@icewind.nl >
2022-08-16 12:07:13 +02:00
9b52663a81
Revert "make expression build return IQueryFunction instead of string"
...
This reverts commit 813b50ed42robin@icewind.nl >
2022-08-16 12:07:09 +02:00
2a68819a67
add case statement to sql function builder
...
Signed-off-by: Robin Appelman <robin@icewind.nl >
2022-06-02 15:52:12 +02:00
813b50ed42
make expression build return IQueryFunction instead of string
...
this allows passing the expressions to further expressions without them being escaped as column names
Signed-off-by: Robin Appelman <robin@icewind.nl >
2022-06-02 15:52:08 +02:00
be4faebc47
Adjust docs to the same as the implementation
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2022-05-23 12:56:47 +02:00
9ec0cb0a90
Fix psalm issues related to the user backend
...
- Reflect the actual return value returned by the implementation in the
the interface. E.g. IUser|bool -> IUser|false
- Remove $hasLoggedIn parameter from private countUser implementation.
Replace the two call with the equivalent countSeenUser
- getBackend is nuallable, add this to the interface
- Use backend interface to make psalm happy about call to undefined
methods. Also helps with getting rid at some point of the old
implementActions
Signed-off-by: Carl Schwan <carl@carlschwan.eu >
2022-05-20 17:14:58 +02:00
a4e120c203
tell mysql to ignore the sort index for search queries
...
Signed-off-by: Robin Appelman <robin@icewind.nl >
2022-04-22 13:42:33 +02:00
7817845538
Add a metadata service to store file metadata
...
Signed-off-by: Carl Schwan <carl@carlschwan.eu >
2022-04-13 14:06:29 +02:00
efebbacca4
Add octetLength and charLength to function builder, and tests
...
Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com >
2022-03-24 20:35:02 +00:00
c870bd1968
Do chuncked job deletion
...
This is helpful in cases where we are deleting tons jobs at the same
time in a gallera cluster. This doesn't happen often but this can create
issues.
Test plan:
1. Use https://github.com/nextcloud/quota_warning/pull/88
2. Change max to 1
3. Enabled/Disable quota_warning app and see jobs getting sucessfully
added and removed
Signed-off-by: Carl Schwan <carl@carlschwan.eu >
2022-03-17 21:41:58 +01:00
fccb98c8b6
Merge pull request #30379 from nextcloud/feature/add-comments-reactions
...
Add comments reactions
2022-01-21 15:08:12 +01:00
d850dc0220
Remove order from groupConcat as it is not working everywhere
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2022-01-21 08:39:39 -03:00
f071b4dfbb
Fix groupConcat and ordering on Oracle
...
Signed-off-by: Vitor Mattos <vitor@php.rio >
2022-01-21 08:39:39 -03:00
afe5b6dd8a
Prevent query error when use subquery
...
Signed-off-by: Vitor Mattos <vitor@php.rio >
2022-01-21 08:37:06 -03:00
Ferdinand Thiessen
Carl Schwan
Côme Chilliet
Daniel Kesselberg
provokateurin
Joas Schilling
Carl Schwan
Robin Appelman
John Molakvoæ
Andy Scherzinger
Simon L
Carl Schwan
Joas Schilling
Vitor Mattos