75 Commits (master)

Author	SHA1	Message	Date
Joas Schilling	7c870a8f67	fix(db)!: Deprecate JSON fields due to problems with querying and selecting ... Signed-off-by: Joas Schilling <coding@schilljs.com>	1 month ago
Carl Schwan	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>	2 months ago
Carl Schwan	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>	3 months ago
Ferdinand Thiessen	db94e10af0	fix: Prevent breaking change in IQueryBuilder ... Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>	1 year ago
Ferdinand Thiessen	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>	1 year ago
Robin Appelman	b45f2420fe	fix: fix share reminder job for oracle ... Signed-off-by: Robin Appelman <robin@icewind.nl>	1 year ago
Ferdinand Thiessen	027fc052e7	fix: Adjust types of IQueryBuilder to properly allow joining with sub-query ... Signed-off-by: Ferdinand Thiessen <opensource@fthiessen.de>	1 year ago
Robin Appelman	da59fd4389	fix: misc code fixes around db sharding ... Signed-off-by: Robin Appelman <robin@icewind.nl>	1 year ago
Robin Appelman	b21a399d1a	fix: implement sharding compatible cleanup for various bits ... Signed-off-by: Robin Appelman <robin@icewind.nl>	1 year ago
Robin Appelman	62f8b6517f	feat: implement distributing partitioned queries over multiple shards ... Signed-off-by: Robin Appelman <robin@icewind.nl>	1 year ago
Robin Appelman	c09ec95255	feat: track expected output columns in query builder ... Signed-off-by: Robin Appelman <robin@icewind.nl>	1 year ago
Daniel Kesselberg	af6de04e9e	style: update codestyle for coding-standard 1.2.3 ... Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de>	1 year ago
Joas Schilling	eeb6ddb176	fix(db): Deprecate `IExpressionBuilder::or()` and `IExpressionBuilder::and()` without parameters ... Signed-off-by: Joas Schilling <coding@schilljs.com>	1 year ago
Joas Schilling	e45465781f	fix(db): Deprecate `getState()` as per upstream ... Signed-off-by: Joas Schilling <coding@schilljs.com>	1 year ago
Joas Schilling	bd383627a7	fix(db): Deprecate using table alias for DELETE and UPDATE ... Signed-off-by: Joas Schilling <coding@schilljs.com>	1 year ago
Joas Schilling	f92352eda4	fix(db): Deprecate `getQueryPart()` and `resetQueryPart()` methods that will be removed with Doctrine/DBAL 4 ... Signed-off-by: Joas Schilling <coding@schilljs.com>	1 year ago
Robin Appelman	9de6190ec4	feat: allow running QueryBuilder queries on different connections ... Signed-off-by: Robin Appelman <robin@icewind.nl>	1 year ago
Andy Scherzinger	dae7c159f7	chore: Add SPDX header ... Signed-off-by: Andy Scherzinger <info@andy-scherzinger.de>	2 years ago
Côme Chilliet	6d291ac260	chore: Add missing parameter to docblock tag psalm-taint-sink ... Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com>	2 years ago
Joas Schilling	15a7aa51c5	fix(dbal): Fix types in query builder methods for parameters ... Signed-off-by: Joas Schilling <coding@schilljs.com>	2 years ago
Joas Schilling	c4ed7f9d21	fix(dbal): Doctrine\DBAL\Connection::PARAM_* types are deprecated ... Signed-off-by: Joas Schilling <coding@schilljs.com>	2 years ago
Joas Schilling	5a1fcdb272	fix(dbal): Migrate to Doctrine\DBAL\ParameterTypes ... Signed-off-by: Joas Schilling <coding@schilljs.com>	2 years ago
Simon L	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>	3 years ago
Côme Chilliet	f5c361cf44	composer run cs:fix ... Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com>	3 years ago
Robin Appelman	9b52663a81	Revert "make expression build return IQueryFunction instead of string" ... This reverts commit 813b50ed42. Signed-off-by: Robin Appelman <robin@icewind.nl>	3 years ago
Robin Appelman	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>	4 years ago
Joas Schilling	be4faebc47	Adjust docs to the same as the implementation ... Signed-off-by: Joas Schilling <coding@schilljs.com>	4 years ago
Carl Schwan	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>	4 years ago
Robin Appelman	a4e120c203	tell mysql to ignore the sort index for search queries ... Signed-off-by: Robin Appelman <robin@icewind.nl>	4 years ago
Carl Schwan	7817845538	Add a metadata service to store file metadata ... Signed-off-by: Carl Schwan <carl@carlschwan.eu>	4 years ago
Carl Schwan	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>	4 years ago
Vitor Mattos	afe5b6dd8a	Prevent query error when use subquery ... Signed-off-by: Vitor Mattos <vitor@php.rio>	4 years ago
Joas Schilling	5bb49feef8	Allow NULL as well for limit, not integer only ... Signed-off-by: Joas Schilling <coding@schilljs.com>	4 years ago
Christoph Wurst	130ab63ca1	Bump doctrine/dbal from 3.0.0 to 3.1.3 ... Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>	4 years ago
John Molakvoæ (skjnldsv)	215aef3cbd	Update php licenses ... Signed-off-by: John Molakvoæ (skjnldsv) <skjnldsv@protonmail.com>	5 years ago
Lukas Reschke	4e7b82169c	executeUpdate is also deprecated ... Ref 1089ad5d9e/lib/private/DB/QueryBuilder/QueryBuilder.php (L312-L323) Signed-off-by: Lukas Reschke <lukas@statuscode.ch>	5 years ago
Christoph Wurst	865661ed75	Rename IQueryBuilder::executeUpdate to IQueryBuilder::executeStatement ... Because executeUpdate wasn't a great name. And in DBAL they also use executeStatement more consistently now. Ref https://github.com/doctrine/dbal/issues/4607 Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>	5 years ago
Roeland Jago Douma	c3f1eb4f7f	Remove Redundantcasts ... For #25839 Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>	5 years ago
Roeland Jago Douma	76a6328d10	Add executeQuery and executeUpdate ... Names shamelessly copied from Doctrine itself. Internally it is still using the same flow. But I added some checks around it. This should make static analysis a bit more happy. Which in turn makes me more happy. Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>	5 years ago
Robin Appelman	47dd8e54b5	allow non string join conditions in query builder ... Signed-off-by: Robin Appelman <robin@icewind.nl>	5 years ago
Lukas Reschke	d7590a6190	Add expression taint source and sanitizer ... Signed-off-by: Lukas Reschke <lukas@statuscode.ch>	5 years ago
Christoph Wurst	2c9cdc1cdb	Add our own DB exception abstraction ... Right now our API exports the Doctrine/dbal exception. As we've seen with the dbal 3 upgrade, the leakage of 3rdparty types is problematic as a dependency update means lots of work in apps, due to the direct dependency of what Nextcloud ships. This breaks this dependency so that apps only need to depend on our public API. That API can then be vendor (db lib) agnostic and we can work around future deprecations/removals in dbal more easily. Right now the type of exception thrown is transported as "reason". For the more popular types of errors we can extend the new exception class and allow apps to catch specific errors only. Right now they have to catch-check-rethrow. This is not ideal, but better than the dependnecy on dbal. Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>	5 years ago
Christoph Wurst	8b64e92b92	Bump doctrine/dbal from 2.12.0 to 3.0.0 ... Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>	5 years ago
Christoph Wurst	9ce3ea3368	Update license headers ... Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>	5 years ago
Roeland Jago Douma	fe46149560	Psalm fixes ... Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>	5 years ago
Daniel Kesselberg	0e3ddf1b27	Add explicit typecast for $value. ... Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de>	5 years ago
Daniel Kesselberg	64b10f61df	Update signature for set ... also ILiteral and IQueryFunction are valid. Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de>	5 years ago
J0WI	68ce17e59b	Unify links to php.net ... Update all links to https://www.php.net/ Signed-off-by: J0WI <J0WI@users.noreply.github.com>	5 years ago
Christoph Wurst	2a054e6c04	Update the license headers for Nextcloud 20 ... Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>	5 years ago
Daniel Kesselberg	10ac844448	Update documentation for QueryBuilder::set ... Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de>	5 years ago