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
83fbc64c99
fix(IResult): Use more accurate conditional return type for fetchAll
...
Signed-off-by: provokateurin <kate@provokateurin.de >
2026-02-11 08:50:13 +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
6f0537b4e9
Merge pull request #56494 from nextcloud/carl/result-improv
...
Improve IResult
2025-11-20 15:38:17 +01:00
90f4b98424
refactor(IResult): Un-deprecate fetch and fetchAll
...
But still add a note that the new methods are preferred.
Signed-off-by: Carl Schwan <carl.schwan@nextcloud.com >
2025-11-19 10:53:03 +01:00
3682dbbf5e
feat(result): Update result wrapper with new doctrine methods
...
- fetch is replaced with fetchAssociative/fetchNumeric/fetchOne with
better type hinting
- Same with fetchAll
- And add iterateAssociative/iterateNumeric which are nicer to use than
a `while ($row = $result->fetch()) {}`
Signed-off-by: Carl Schwan <carl.schwan@nextcloud.com >
2025-11-18 17:45:13 +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
336cc3fa35
feat(Db): Use SnowflakeId for previews
...
Allow to get an id for the storing the preview on disk before inserting
the preview on the DB.
Signed-off-by: Carl Schwan <carl.schwan@nextcloud.com >
2025-10-28 17:50:03 +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
3fb0aa40cd
feat(db): add mapping for lock wait timeout
...
Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de >
2024-05-29 11:10:43 +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
06d076410a
feat(occ): add possibility to edit indices
...
Signed-off-by: Johannes Merkel <mail@johannesgge.de >
2024-02-27 11:03:08 +01: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
00d483585b
fix: Add options to support all used features by core
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2023-07-24 14:51:34 +02:00
bd0a149a4f
feat(dispatcher): Add typed event for "db:add-missing-primary-keys"
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2023-07-24 14:51:32 +02:00
2eded24eff
feat(dispatcher): Add typed event for "db:add-missing-columns"
...
Signed-off-by: Joas Schilling <coding@schilljs.com >
2023-07-24 14:51:32 +02:00
925bcebcb6
feat: Add public event for missing indices
...
Signed-off-by: Julius Härtl <jus@bitgrid.net >
2023-07-14 13:11:22 +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
Ferdinand Thiessen
Carl Schwan
Côme Chilliet
Daniel Kesselberg
provokateurin
Tobias Kaminsky
Carl Schwan
Joas Schilling
Robin Appelman
John Molakvoæ
Andy Scherzinger
Johannes Merkel
Julius Härtl
Simon L