aboutsummaryrefslogtreecommitdiffstats
path: root/lib/private/DB/QueryBuilder/FunctionBuilder
Commit message (Collapse)AuthorAgeFilesLines
* fix(db): Fix md5 for oracle >= 20Joas Schilling2024-07-192-1/+5
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* chore: Add SPDX headerAndy Scherzinger2024-05-244-80/+8
| | | | Signed-off-by: Andy Scherzinger <info@andy-scherzinger.de>
* Revert "add case statement to sql function builder"Robin Appelman2022-08-161-11/+0
| | | | | | This reverts commit 2a68819a67045d87a369a8a6413f153b3b2bea5f. Signed-off-by: Robin Appelman <robin@icewind.nl>
* add case statement to sql function builderRobin Appelman2022-06-021-0/+11
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* Fix LENGTH function name across databasesCôme Chilliet2022-03-283-1/+13
| | | | Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com>
* Use OCTET_LENGTH which is more common than LENGTHBCôme Chilliet2022-03-242-1/+7
| | | | Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com>
* Add octetLength and charLength to function builder, and testsCôme Chilliet2022-03-242-0/+18
| | | | Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com>
* Unit testsVitor Mattos2022-01-071-1/+1
| | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Accept multipe args on concatVitor Mattos2022-01-064-6/+30
| | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Use quote functionJoas Schilling2022-01-041-6/+2
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Try escaping Oracle single quotesJoas Schilling2022-01-041-1/+1
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Add a test with integerJoas Schilling2022-01-044-12/+22
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Fix oracle LISTAGGJoas Schilling2022-01-031-1/+1
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Add unit testVitor Mattos2022-01-034-23/+11
| | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Add unit test and orderBy parameterVitor Mattos2022-01-034-9/+34
| | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Add group_concat aggregator functionVitor Mattos2022-01-033-0/+18
| | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Update php licensesJohn Molakvoæ (skjnldsv)2021-06-044-8/+4
| | | | Signed-off-by: John Molakvoæ (skjnldsv) <skjnldsv@protonmail.com>
* Update all license headers for Nextcloud 21Christoph Wurst2020-12-161-0/+1
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Add types to function builderJoas Schilling2020-11-164-43/+20
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Update parametersJoas Schilling2020-11-073-2/+28
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Make sure Oracle always casts everything in the best wayJoas Schilling2020-11-061-0/+43
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Format control structures, classes, methods and functionChristoph Wurst2020-04-101-1/+0
| | | | | | | | | | | | | | | To continue this formatting madness, here's a tiny patch that adds unified formatting for control structures like if and loops as well as classes, their methods and anonymous functions. This basically forces the constructs to start on the same line. This is not exactly what PSR2 wants, but I think we can have a few exceptions with "our" style. The starting of braces on the same line is pracrically standard for our code. This also removes and empty lines from method/function bodies at the beginning and end. Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Update license headersChristoph Wurst2019-12-054-4/+5
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* add LEAST and GREATER to db function builderRobin Appelman2019-11-262-0/+17
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* add count() as shortcut for count('*') in FunctionBuilderRobin Appelman2019-11-131-2/+3
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* add MAX and MIN to functionbuilderRobin Appelman2019-09-061-0/+8
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* Use the defined func()->count() instead of manual countingJoas Schilling2018-11-081-2/+3
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Add count to function builderRobin Appelman2018-06-141-0/+4
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* dont keep shared database locks when running cli scriptsRobin Appelman2018-04-111-0/+8
| | | | | | 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>
* refactor user searchingRobin Appelman2017-12-201-0/+4
| | | | | | add additional user searching tests Signed-off-by: Robin Appelman <robin@icewind.nl>
* Update license headersMorris Jobke2017-11-064-0/+10
| | | | Signed-off-by: Morris Jobke <hey@morrisjobke.de>
* Add brackets around concat statements so comparing the result works as intendedJoas Schilling2017-07-282-2/+2
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Add sub() to the query function builderRobin Appelman2017-04-121-0/+4
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* fix licence headersRobin Appelman2017-03-304-32/+36
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* Add function builder to the query builderRobin Appelman2017-03-304-0/+142
Signed-off-by: Robin Appelman <robin@icewind.nl>