aboutsummaryrefslogtreecommitdiffstats
path: root/tests/lib/DB/QueryBuilder
Commit message (Collapse)AuthorAgeFilesLines
* Merge pull request #47852 from nextcloud/sharding-code-fixesJohn Molakvoæ2024-09-161-2/+2
|\
| * fix: misc code fixes around db shardingsharding-code-fixesRobin Appelman2024-09-092-14/+14
| | | | | | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* | refactor: Add void return type to PHPUnit test methodsChristoph Wurst2024-09-157-87/+87
|/ | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* test(phpunit): skip sharding tests on 32bitArthur Schiwon2024-08-292-0/+6
| | | | Signed-off-by: Arthur Schiwon <blizzz@arthur-schiwon.de>
* chore: Apply php:cs recommendationsLouis Chemineau2024-08-282-3/+3
| | | | Signed-off-by: Louis Chemineau <louis@chmn.me>
* feat: implement distributing partitioned queries over multiple shardsRobin Appelman2024-08-282-1/+133
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* feat: add option to automatically partition queries by specific tablesRobin Appelman2024-08-282-0/+290
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* style: update codestyle for coding-standard 1.2.3Daniel Kesselberg2024-08-253-5/+5
| | | | Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de>
* fix(db): Deprecate `IExpressionBuilder::or()` and ↵Joas Schilling2024-07-191-1/+6
| | | | | | `IExpressionBuilder::and()` without parameters Signed-off-by: Joas Schilling <coding@schilljs.com>
* feat: allow running QueryBuilder queries on different connectionsRobin Appelman2024-07-151-31/+58
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* chore: Add SPDX headerAndy Scherzinger2024-05-135-84/+13
| | | | Signed-off-by: Andy Scherzinger <info@andy-scherzinger.de>
* fix(tests): Make PostgreSQL unit tests less flacky by orderingJoas Schilling2024-01-251-1/+1
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* lazy AppConfigMaxence Lange2024-01-151-0/+1
| | | Signed-off-by: Maxence Lange <maxence@artificial-owl.com>
* tests(DB): Add test for date time comparisons in query builderJulius Härtl2023-12-291-0/+86
| | | | Signed-off-by: Julius Härtl <jus@bitgrid.net>
* tests(oci): Test where statement on longtext columnJulius Härtl2023-01-311-0/+18
| | | | | | | | Signed-off-by: Julius Härtl <jus@bitgrid.net> test: try with just passing the type to eq which should also cast Signed-off-by: Julius Härtl <jus@bitgrid.net>
* Revert "add case statement to sql function builder"Robin Appelman2022-08-161-17/+0
| | | | | | This reverts commit 2a68819a67045d87a369a8a6413f153b3b2bea5f. Signed-off-by: Robin Appelman <robin@icewind.nl>
* add case statement to sql function builderRobin Appelman2022-06-021-0/+17
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* Merge pull request #31609 from nextcloud/fix/migrate-away-from-iloggerCôme Chilliet2022-03-291-16/+16
|\ | | | | Migrate from ILogger to LoggerInterface in lib/private
| * Migrate from ILogger to LoggerInterface where needed in the testsCôme Chilliet2022-03-241-16/+16
| | | | | | | | Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com>
* | Avoid select with no FROM clause for Oracle in testsCôme Chilliet2022-03-241-0/+4
| | | | | | | | Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com>
* | Add octetLength and charLength to function builder, and testsCôme Chilliet2022-03-241-0/+46
|/ | | | Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com>
* Fix column size to work with Oracle. Add unit testsVitor Mattos2022-01-211-2/+9
| | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Prevent query error when use subqueryVitor Mattos2022-01-211-1/+8
| | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Merge pull request #30508 from nextcloud/fix/psaml-binCarl Schwan2022-01-131-2/+1
|\ | | | | Fix psalm not running
| * Check style updateCarl Schwan2022-01-131-2/+1
| | | | | | | | Signed-off-by: Carl Schwan <carl@carlschwan.eu>
* | Unit testsVitor Mattos2022-01-071-6/+54
|/ | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Add a test with integerJoas Schilling2022-01-041-4/+90
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Test with real dataJoas Schilling2022-01-031-7/+12
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Add unit testVitor Mattos2022-01-031-7/+33
| | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Add unit test and orderBy parameterVitor Mattos2022-01-031-0/+26
| | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Bump doctrine/dbal from 3.0.0 to 3.1.3Christoph Wurst2021-10-221-7/+3
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Add a unit test to check for casting a IQueryFunctionJoas Schilling2021-07-071-0/+34
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Bump nextcloud/coding-standard from 0.3.0 to 0.5.0dependabot-preview[bot]2021-02-182-19/+19
| | | | | | | | | | Bumps [nextcloud/coding-standard](https://github.com/nextcloud/coding-standard) from 0.3.0 to 0.5.0. - [Release notes](https://github.com/nextcloud/coding-standard/releases) - [Changelog](https://github.com/nextcloud/coding-standard/blob/master/CHANGELOG.md) - [Commits](https://github.com/nextcloud/coding-standard/compare/v0.3.0...v0.5.0) Signed-off-by: dependabot-preview[bot] <support@dependabot.com> Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* DB: warn on parameter number constraintsArthur Schiwon2021-01-111-6/+82
| | | | Signed-off-by: Arthur Schiwon <blizzz@arthur-schiwon.de>
* Bump doctrine/dbal from 2.12.0 to 3.0.0Christoph Wurst2021-01-083-18/+22
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* allow selecting multiple columns with SELECT DISTINCTRobin Appelman2020-11-161-0/+38
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* Don't leave cursors open when tests failJoas Schilling2020-11-092-16/+64
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Change PHPDoc type hint from PHPUnit_Framework_MockObject_MockObject to ↵Morris Jobke2020-08-121-2/+2
| | | | | | \PHPUnit\Framework\MockObject\MockObject Signed-off-by: Morris Jobke <hey@morrisjobke.de>
* Remove dropped " ON " when join has no conditionJoas Schilling2020-06-081-6/+6
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Merge pull request #17833 from nextcloud/propagator-no-negative-sizesRoeland Jago Douma2019-12-041-0/+20
|\ | | | | dont set folder size to negative values during propagation
| * add LEAST and GREATER to db function builderRobin Appelman2019-11-261-0/+20
| | | | | | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* | Mode to modern phpunitRoeland Jago Douma2019-11-271-1/+1
| | | | | | | | Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>
* | Make phpunit8 compatibleRoeland Jago Douma2019-11-275-5/+5
|/ | | | Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>
* add MAX and MIN to functionbuilderRobin Appelman2019-09-061-0/+78
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* Use the defined func()->count() instead of manual countingJoas Schilling2018-11-081-1/+1
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Add count to function builderRobin Appelman2018-06-141-0/+10
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* dont keep shared database locks when running cli scriptsRobin Appelman2018-04-111-0/+21
| | | | | | For cli scripts we don't have the assumption that the universe will be cleaned up soon Signed-off-by: Robin Appelman <robin@icewind.nl>
* Merge pull request #7419 from Abijeet/feature-7175Morris Jobke2018-03-062-1/+13
|\ | | | | Fixes #7175 - Allow to search for email address in user management
| * reuse query builderRobin Appelman2018-01-121-1/+3
| | | | | | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
| * refactor user searchingRobin Appelman2017-12-201-0/+10
| | | | | | | | | | | | add additional user searching tests Signed-off-by: Robin Appelman <robin@icewind.nl>