53 Commits (addParameterTypingVersionsMapper)

Author	SHA1	Message	Date
Christoph Wurst	29161c0dfd	fix(db): Create replacement index where original index is missing ... Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>	8 months ago
Daniel Kesselberg	af6de04e9e	style: update codestyle for coding-standard 1.2.3 ... Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de>	1 year ago
Andy Scherzinger	5c49a54801	chore: Add SPDX header ... Signed-off-by: Andy Scherzinger <info@andy-scherzinger.de>	2 years ago
Johannes Merkel	06d076410a	feat(occ): add possibility to edit indices ... Signed-off-by: Johannes Merkel <mail@johannesgge.de>	2 years ago
Joas Schilling	aa5f037af7	chore: apply changes from Nextcloud coding standards 1.1.1 ... Signed-off-by: Joas Schilling <coding@schilljs.com> Signed-off-by: Benjamin Gaussorgues <benjamin.gaussorgues@nextcloud.com>	2 years ago
Joas Schilling	ab70bbd3ff	fix(db)!: Remove private legacy event because we can not keep it ... Signed-off-by: Joas Schilling <coding@schilljs.com>	2 years ago
Joas Schilling	86310a35b2	fix(db): Move missing core indices to typed event ... Signed-off-by: Joas Schilling <coding@schilljs.com>	2 years ago
Joas Schilling	00d483585b	fix: Add options to support all used features by core ... Signed-off-by: Joas Schilling <coding@schilljs.com>	2 years ago
Julius Härtl	925bcebcb6	feat: Add public event for missing indices ... Signed-off-by: Julius Härtl <jus@bitgrid.net>	2 years ago
Arthur Schiwon	e5160e0c1c	fix(db): no hardcoded table prefix is expected ... Signed-off-by: Arthur Schiwon <blizzz@arthur-schiwon.de>	2 years ago
Marcel Klehr	fcf1c3033b	fix(systemtags): Add missing systemtags index ... Signed-off-by: Marcel Klehr <mklehr@gmx.net>	3 years ago
Faraz Samapoor	b5cbba7fc1	Uses PHP8's constructor property promotion in core/Command/Db classes. ... Signed-off-by: Faraz Samapoor <fsa@adlas.at>	3 years ago
Robin Appelman	db43d90387	add new index in repair step instead of on-migrate ... Signed-off-by: Robin Appelman <robin@icewind.nl>	3 years ago
Louis Chemineau	bda66f9fb6	Add parent index on filecache ... Signed-off-by: Louis Chemineau <louis@chmn.me>	3 years ago
Marcel Klehr	047cc708d4	DB mounts table: Add index for mount_provider_class ... Signed-off-by: Marcel Klehr <mklehr@gmx.net>	3 years ago
Carl Schwan	b70c6a128f	Update core to PHP 7.4 standard ... - Typed properties - Port to LoggerInterface Signed-off-by: Carl Schwan <carl@carlschwan.eu>	4 years ago
Julius Härtl	7fbd93b2ad	Additional index on oc_preferences to make sure that gettingh values without a user filter is fast ... Signed-off-by: Julius Härtl <jus@bitgrid.net>	4 years ago
Louis Chemineau	970fb7ce65	Don't create cards_abiduri it if already exists ... Signed-off-by: Louis Chemineau <louis@chmn.me>	4 years ago
Louis Chemineau	405c5eb813	Add --dry-run option for db:add-missing-* cmd ... Signed-off-by: Louis Chemineau <louis@chmn.me>	4 years ago
Julius Härtl	415294e345	Add index for direct editing cleanup job ... Signed-off-by: Julius Härtl <jus@bitgrid.net>	4 years ago
Christoph Wurst	ed84f07784	Add missing index for propertypath only queries against properties ... Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>	4 years ago
Joas Schilling	536a812de4	Add an index for selecting the next job ... Signed-off-by: Joas Schilling <coding@schilljs.com>	4 years ago
Robin Appelman	695326534c	disable path prefix index on postgresql for now ... having the index work properly for the queries we need it for requires some additional options which dbal does not support at the momement. to prevent making it harder to add the correct index later on we don't create the index for now on postgresql Signed-off-by: Robin Appelman <robin@icewind.nl>	4 years ago
Robin Appelman	abd6b354ac	add a prefix index to filecache.path ... The reason that `filecache.path` hasn't had an index added is the mysql limitation of ~1kb for indexeded fields, which is to small for the `path`, however mysql supports indexing only the first N bytes of a column instead of the entire column, allowing us to add an index even if the column is to long. Because the index doesn't cover the entire column it can't be used in all situations where a normal index would be used, but it does cover the `path like 'folder/path/%'` queries that are used in various places. Sqlite and Postgresql don't support prefix indexes, but they also don't have the 1kb limit and DBAL handles the differences in index creation. Signed-off-by: Robin Appelman <robin@icewind.nl>	4 years ago
Robin Appelman	6502dfae34	add better index for finding unindexed paths ... for the following query 'SELECT "path" FROM "oc_filecache" WHERE ("storage" = $storage) AND ("size" < 0) ORDER BY "fileid" DESC LIMIT 1;' currently the database will in some cases decide to priorize the sort by fileid over the filter when picking what index to use, resulting in a much slower query. by creating an index that allows first sorting by fileid and also filter by storage and size this case will be greatly sped up Signed-off-by: Robin Appelman <robin@icewind.nl>	4 years ago
John Molakvoæ (skjnldsv)	215aef3cbd	Update php licenses ... Signed-off-by: John Molakvoæ (skjnldsv) <skjnldsv@protonmail.com>	5 years ago
Roeland Jago Douma	14ee17e5c5	Revert "add a prefix index to filecache.path"	5 years ago
Robin Appelman	b28f0a0e94	add a prefix index to filecache.path ... The reason that `filecache.path` hasn't had an index added is the mysql limitation of ~1kb for indexeded fields, which is to small for the `path`, however mysql supports indexing only the first N bytes of a column instead of the entire column, allowing us to add an index even if the column is to long. Because the index doesn't cover the entire column it can't be used in all situations where a normal index would be used, but it does cover the `path like 'folder/path/%'` queries that are used in various places. Sqlite and Postgresql don't support prefix indexes, but they also don't have the 1kb limit and DBAL handles the differences in index creation. Signed-off-by: Robin Appelman <robin@icewind.nl>	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	d89a75be0b	Update all license headers for Nextcloud 21 ... Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>	5 years ago
Julius Härtl	c77e259cfe	Add missing index on oc_cards and rename if it previously existed ... Signed-off-by: Julius Härtl <jus@bitgrid.net>	5 years ago
Robin Appelman	634c051be6	add size index for filecache ... improves performance of #23004 Signed-off-by: Robin Appelman <robin@icewind.nl>	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
Joas Schilling	ab21d69903	Add return value to all commands ... Signed-off-by: Joas Schilling <coding@schilljs.com>	6 years ago
Mario Danic	6e28c2807b	Add index to properties table ... Signed-off-by: Mario Danic <mario@lovelyhq.com>	6 years ago
Christoph Wurst	caff1023ea	Format control structures, classes, methods and function ... 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>	6 years ago
Christoph Wurst	1a9330cd69	Update the license headers for Nextcloud 19 ... Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>	6 years ago
Joas Schilling	720dc4e93d	Add optional column oc_comments.reference_id ... Signed-off-by: Joas Schilling <coding@schilljs.com>	6 years ago
Christoph Wurst	5bf3d1bb38	Update license headers ... Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>	6 years ago
Roeland Jago Douma	68748d4f85	Some php-cs fixes ... * Order the imports * No leading slash on imports * Empty line before namespace * One line per import * Empty after imports * Emmpty line at bottom of file Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>	6 years ago
Thomas Citharel	68cf47e947	Check and add index on principaluri for schedulingobjects table ... Signed-off-by: Thomas Citharel <tcit@tcit.fr>	6 years ago
Thomas Citharel	90e5850cc4	Add index on calendarid for calendarobject_props table ... Signed-off-by: Thomas Citharel <tcit@tcit.fr>	6 years ago
Joas Schilling	592093079f	Deduplicate index names ... Signed-off-by: Joas Schilling <coding@schilljs.com>	7 years ago
Joas Schilling	274658629d	Make sure all tables have named indexes ... Signed-off-by: Joas Schilling <coding@schilljs.com>	7 years ago
Roeland Jago Douma	16cc68a2fe	Add twofactor_providers_uid index ... Fixes #12943 Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>	7 years ago
Morris Jobke	4d20c4272f	Fix index names ... * see #11527	7 years ago
Roeland Jago Douma	b82cbe04df	Add uid_owner and uid_initiator share tabe indices ... Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>	7 years ago
Robin Appelman	91d3e48ab3	Add filecache index on mtime ... Gives searching by mtime and "recent" a proper index to use Signed-off-by: Robin Appelman <robin@icewind.nl>	8 years ago
Roeland Jago Douma	2f59f389d2	Add parent index to share table ... Fixes #9327 Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>	8 years ago
Roeland Jago Douma	80cc8d0028	Emit event when running ./occ db:add-missing-indices ... This allows apps to listen to this event in order to also update indecies there. Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>	8 years ago