upstream/nextcloud
1
0
Fork 0
mirror of https://github.com/nextcloud/server.git synced 2026-06-16 20:19:48 -04:00
Code Issues Projects Releases Packages Wiki Activity Actions 16
83872 commits 1016 branches 1221 tags 8.7 GiB
Commit graph

265 commits

Author SHA1 Message Date
Marcel Klehr
0e06d645d4 Update core/Migrations/Version30000Date20240429122720.php 
Co-authored-by: julien-nc <julien-nc@posteo.net>
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2024-05-14 11:38:41 +02:00
Marcel Klehr
a045e0c47a fix: fix migration 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2024-05-14 11:38:41 +02:00
Marcel Klehr
ef61c50f4b fix: address review comments 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2024-05-14 11:38:40 +02:00
Marcel Klehr
928d04fbbd fix: oc_taskProcessing_tasks.identifier: notnull = false 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2024-05-14 11:38:40 +02:00
Marcel Klehr
00894e2420 feat: first pass at TaskProcessing API 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2024-05-14 11:38:39 +02:00
Andy Scherzinger
1df96b0417
chore: Add SPDX header 
Signed-off-by: Andy Scherzinger <info@andy-scherzinger.de>
 2024-05-10 11:07:50 +02:00
Varun Patil
84017a9ad7 fix(core): add fs_name_hash index to migration 
Signed-off-by: Varun Patil <varunpatil@ucla.edu>
 2024-04-30 12:24:23 -07:00
Joas Schilling
92fc12918e
fix(migrations): Help developers to add description and copyright info 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2024-03-05 12:56:38 +01:00
Johannes Merkel
21e8aadc1f
fix(db): remove redundant indices in properties 
Signed-off-by: Johannes Merkel <mail@johannesgge.de>
 2024-02-18 21:02:42 +01:00
Maxence Lange
a845e0f73a
Update core/Migrations/Version29000Date20240124132202.php 
Co-authored-by: Joas Schilling <213943+nickvergessen@users.noreply.github.com>
Signed-off-by: Maxence Lange <maxence@artificial-owl.com>
 2024-01-25 10:33:47 -01:00
Maxence Lange
31e8ed42a1
Update core/Migrations/Version29000Date20240124132201.php 
Co-authored-by: Joas Schilling <213943+nickvergessen@users.noreply.github.com>
Signed-off-by: Maxence Lange <maxence@artificial-owl.com>
 2024-01-25 10:33:39 -01:00
Maxence Lange
8362025643 better indexes 
Signed-off-by: Maxence Lange <maxence@artificial-owl.com>
 2024-01-24 20:01:56 -01:00
Maxence Lange
6daea857ab fixes 
Signed-off-by: Maxence Lange <maxence@artificial-owl.com>
d

Signed-off-by: Maxence Lange <maxence@artificial-owl.com>
 2024-01-15 15:45:13 -01:00
Maxence Lange
f7d0c74b10 lazy AppConfig 
Signed-off-by: Maxence Lange <maxence@artificial-owl.com>
 2024-01-15 15:45:13 -01:00
Joas Schilling
6056928dc6
feat(comments): Add a meta data column for comments 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2023-12-14 14:32:00 +01:00
Louis Chemineau
e621396139
Comment legacy file_metadata table migrations 
Signed-off-by: Louis Chemineau <louis@chmn.me>
 2023-12-07 13:31:09 +01:00
Julius Härtl
1cfc8a2e03
Revert "perf: Add partial index on configvalue of preferences table" 
This reverts commit 0ccf84bb31.

Signed-off-by: Julius Härtl <jus@bitgrid.net>
 2023-12-06 15:21:48 +01:00
Julius Härtl
0ccf84bb31
perf: Add partial index on configvalue of preferences table 
Signed-off-by: Julius Härtl <jus@bitgrid.net>
 2023-11-30 20:51:48 +01:00
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>
 2023-11-23 10:36:13 +01:00
Louis Chemineau
95938d32d9
Add migration from the old to new metadata tables 
Signed-off-by: Louis Chemineau <louis@chmn.me>
 2023-11-16 09:21:55 +01:00
Marcel Klehr
b45007f38f
Merge branch 'master' into enh/text-processing-iprovider2 2023-11-09 13:46:18 +01:00
Joas Schilling
960b95bb8e
fix(migration): Fix files metadata migration 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2023-11-09 06:59:42 +01:00
Marcel Klehr
8c0c426538
Merge branch 'master' into enh/text-processing-iprovider2 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-11-08 11:52:47 +01:00
Maxence Lange
e62e9e3dbf IFilesMetadata 
Signed-off-by: Maxence Lange <maxence@artificial-owl.com>
 2023-11-07 00:21:38 -01:00
Marcel Klehr
1476a7216a fix(TextProcessing/ migration): add check whether new column exists already 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-11-06 12:57:57 +01:00
Marcel Klehr
181f819e41 enh(TextProcessing): Add IProvider2 
- allow providers to obtain current task's userId
- allow providers to expose average task runtime

Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-11-03 16:22:54 +01:00
Git'Fellow
a075c85eef
Return only if changed 
Signed-off-by: Git'Fellow <12234510+solracsf@users.noreply.github.com>
 2023-11-01 17:17:44 +01:00
Git'Fellow
91c92f533e
fix: add index on migration only if needed 
Signed-off-by: Git'Fellow <12234510+solracsf@users.noreply.github.com>
 2023-11-01 17:12:45 +01:00
Marcel Klehr
68bb4a066c fix(TextToImage\Migration): Fix typo 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-10-23 12:49:50 +02:00
Marcel Klehr
9ee72633cf enh(Text2Image): Expose expected completion time 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-10-20 13:54:36 +02:00
Marcel Klehr
73da7f20d3 fix(Text2Image): Add number_of_images to migration 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-10-20 13:53:06 +02:00
Marcel Klehr
ca9a28ab51 fix(TextToImage): Fix notnull column to allow for empty strings on orcale 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-10-18 13:31:01 +02:00
Marcel Klehr
e5efbc88d8 enh(TextToImage): Address review comments 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-10-18 13:21:50 +02:00
Marcel Klehr
c8cab9d2fd Implement TextToImage OCP API 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-10-18 13:21:50 +02:00
Julien Veyssier
41b19cf969
allow anon text processing scheduling 
add a textprocessing_tasks index
convert anotations to method attributes
refactor TP manager
add mapper methods

Signed-off-by: Julien Veyssier <julien-nc@posteo.net>
 2023-08-07 13:27:53 +02:00
Julien Veyssier
601679bd25
use DB type constants 
Signed-off-by: Julien Veyssier <julien-nc@posteo.net>
 2023-08-02 12:37:36 +02:00
Marcel Klehr
a0eaed0296
Fix typo 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-08-02 12:37:36 +02:00
Marcel Klehr
ad3f353335
Migration: Drop llm_tasks table and add textprocessing_tasks 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-08-02 12:37:36 +02:00
Marcel Klehr
0909657ea0 LLM Migration: Return null if nothing changed 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-07-07 13:39:10 +02:00
Marcel Klehr
f6f8cb4331 LLM OCP API: Add identifier param 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-07-07 13:39:10 +02:00
Marcel Klehr
cb0f918d21 Add tasks::last_updated column and vacate tasks after a week 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-07-07 13:39:10 +02:00
Marcel Klehr
795b097122 LLM OCP API: Implement ocs API 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-07-07 13:39:10 +02:00
Marcel Klehr
9e9fc1d99b Fix Copyright 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-07-07 13:39:10 +02:00
Marcel Klehr
6fc4cb63ef LLM OCP API: Add db migration 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-07-07 13:39:10 +02:00
Faraz Samapoor
04b12d9d27 Uses PHP8's constructor property promotion. 
Signed-off-by: Faraz Samapoor <fsa@adlas.at>
 2023-06-23 22:50:49 +03:30
Marcel Klehr
e774708482 fix(systemtags): Keep non-existing index 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-06-22 10:12:15 +02:00
Marcel Klehr
ee9ad9c9de fix(systemtags): Move index creation from new migration to existing original migration 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-06-22 09:49:53 +02:00
Marcel Klehr
fcf1c3033b fix(systemtags): Add missing systemtags index 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-06-21 15:20:30 +02:00
Robin Appelman
db43d90387
add new index in repair step instead of on-migrate 
Signed-off-by: Robin Appelman <robin@icewind.nl>
 2023-04-28 15:08:08 +02:00
Robin Appelman
f5e2b0b22f
allow storing multiple mounts for the same rootid in the mount cache 
currently `[$userId, $rootId]` is used as the unique key for storing mounts in the mount cache,
however there are cases where the same rootid is mounted in multiple places for a user which currently leads to not all of those mounts being added to the cache.

Previously this didn't matter as the mount cache was only used to list users with access to a specific file, so a user having access to the file multiple times didn' change anything.

With 24 the mount cache is used for more cases and multiple mounts for the same id becomes relevant.
While I think there isn't a real negative effect atm besides missing the optimized path we should ensure that the mounts are properly listed

Signed-off-by: Robin Appelman <robin@icewind.nl>
 2023-04-28 15:08:08 +02:00
Louis
7ab44b2d28
Merge pull request #37146 from nextcloud/artonge/feat/migrate_metadata_to_value 
Migrate metadata JSON column to new value TEXT column
 2023-04-04 10:23:54 +02:00
Louis Chemineau
1a6709cf43 Migrate metadata as JSON to value as STRING 
Signed-off-by: Louis Chemineau <louis@chmn.me>
 2023-04-03 14:06:28 +02:00
Louis Chemineau
bda66f9fb6 Add parent index on filecache 
Signed-off-by: Louis Chemineau <louis@chmn.me>
 2023-03-20 15:02:23 +00:00
Simon L
96500cf5a4 add a safeguard for Version23000Date20210721100600.php 
Signed-off-by: Simon L <szaimen@e.mail.de>
 2023-01-27 13:10:44 +01:00
Côme Chilliet
f5c361cf44
composer run cs:fix 
Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com>
 2023-01-20 11:45:08 +01:00
Marcel Klehr
adfe367106
PublickKeyTokenProvider: Fix password update routine with password hash 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2023-01-04 08:30:53 +01:00
Joas Schilling
4d98128e9a
Fix migration parameter handling 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2022-10-13 10:36:05 +02:00
Arthur Schiwon
b4f6329a83 fix querybuilder instance recuse 
...and execute delete query

Signed-off-by: Arthur Schiwon <blizzz@arthur-schiwon.de>
 2022-10-13 08:31:33 +00:00
Christopher Ng
7f5ef4dcf7 Delete theming background preferences 
Signed-off-by: Christopher Ng <chrng8@gmail.com>
 2022-10-13 08:31:33 +00:00
Joas Schilling
7599cbb529 New code being new 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2022-10-13 08:31:33 +00:00
Joas Schilling
6e4a90ba36 Fix SQL errors 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2022-10-13 08:31:33 +00:00
Christopher Ng
107a974b36 Fix missing background on upgrade 
Signed-off-by: Christopher Ng <chrng8@gmail.com>
 2022-10-13 08:31:32 +00:00
timm2k
14d3b6f021
Update Version24000Date20220404230027.php 
Signed-off-by: timm2k <timm2k@gmx.de>
 2022-09-15 07:58:32 +02:00
Marcel Klehr
047cc708d4 DB mounts table: Add index for mount_provider_class 
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
 2022-08-01 14:27:34 +02:00
Vitor Mattos
c59b0c2ff7
Add comments expire date 
https://github.com/nextcloud/spreed/pull/7327

Signed-off-by: Vitor Mattos <vitor@php.rio>
 2022-06-15 11:58:29 -03:00
Vincent Petry
7f660674de
Add new share attributes column 
To store more extended permissions in the future.

Signed-off-by: Vincent Petry <vincent@nextcloud.com>
 2022-06-08 08:46:23 +02:00
Joas Schilling
d2633c3ad6
Fix older migrations to the version pattern 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2022-04-25 09:39:56 +02:00
Joas Schilling
5cacc594a0
Add missing index 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2022-04-25 09:38:31 +02:00
Julius Härtl
f4135c72f5
Merge pull request #31047 from nextcloud/enh/preferences-index 
Additional index on oc_preferences to make queries without a user filter faster
 2022-04-21 09:59:04 +02:00
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>
 2022-04-19 12:37:36 +02:00
Carl Schwan
7817845538 Add a metadata service to store file metadata 
Signed-off-by: Carl Schwan <carl@carlschwan.eu>
 2022-04-13 14:06:29 +02:00
Joas Schilling
3031eb1c07
Update Version24000Date20211222112246.php 2022-03-15 16:30:28 +01:00
Robin Appelman
cfb7923e08
store mountprovider for each mount in the mounts table 
this enabled more fine grained filesystem setup

Signed-off-by: Robin Appelman <robin@icewind.nl>
 2022-02-23 18:02:33 +01:00
Vincent Petry
6f32be1cf6
Merge pull request #31042 from nextcloud/enh/direct_edit_index 
Add index for direct editing cleanup job
 2022-02-10 18:00:29 +01:00
Joas Schilling
b765f79368
Allow apps to specify if their background job can be delayed 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2022-02-07 13:54:54 +01:00
Julius Härtl
415294e345
Add index for direct editing cleanup job 
Signed-off-by: Julius Härtl <jus@bitgrid.net>
 2022-02-07 09:25:27 +01:00
Joas Schilling
fcb3e9a071
Add a primary key to ratelimit_entries table 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2022-01-28 16:55:16 +01:00
Vitor Mattos
9a2736bbc9
Fix column size to work with Oracle. Add unit tests 
Signed-off-by: Vitor Mattos <vitor@php.rio>
 2022-01-21 08:37:07 -03:00
Vitor Mattos
9efbc9c1d5
Add comments reactions 
Signed-off-by: Vitor Mattos <vitor@php.rio>
 2022-01-21 08:37:04 -03:00
Julius Härtl
99b2cf8339
Add hashed attribute column for indexed job existence check 
Signed-off-by: Julius Härtl <jus@bitgrid.net>
 2022-01-18 14:01:24 +01:00
Carl Schwan
6312c0df69
Check style update 
Signed-off-by: Carl Schwan <carl@carlschwan.eu>
 2022-01-13 00:19:07 +01:00
Christoph Wurst
ed84f07784
Add missing index for propertypath only queries against properties 
Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
 2021-12-23 15:51:50 +01:00
Christopher Ng
c85f78db69 Migrate profile_config id column to bigint 
Signed-off-by: Christopher Ng <chrng8@gmail.com>
 2021-12-14 00:14:13 +00:00
Christopher Ng
c85ab47a11 Use bigint for autoincremented column 
Signed-off-by: Christopher Ng <chrng8@gmail.com>
 2021-12-14 00:12:40 +00:00
Julius Härtl
c92ac34711 Use proper app id (settings instead of core) 
Signed-off-by: Julius Härtl <jus@bitgrid.net>
 2021-12-13 19:20:10 +00:00
Joas Schilling
99006be126 Lowercase all core=>email values 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2021-12-13 19:20:10 +00:00
Pytal
92d3520106
Merge pull request #29996 from zordsdavini/patch-1 2021-12-09 14:56:06 -08:00
Pytal
ac5bc2277e Update core/Migrations/Version23000Date20211203110726.php 
Co-authored-by: John Molakvoæ <skjnldsv@users.noreply.github.com>
Signed-off-by: Christopher Ng <chrng8@gmail.com>
 2021-12-09 16:32:53 +00:00
Christopher Ng
e224401a62 Fix relation "user_id" already exists migration error 
Signed-off-by: Christopher Ng <chrng8@gmail.com>
 2021-12-03 20:29:53 +00:00
Joas Schilling
536a812de4
Add an index for selecting the next job 
Signed-off-by: Joas Schilling <coding@schilljs.com>
 2021-12-01 23:57:40 +01:00
Robin Appelman
5155f2b0c5
Merge pull request #28541 from nextcloud/path-prefix-index2 
add a prefix index to filecache.path, attempt 2
 2021-10-19 14:41:23 +00:00
Christopher Ng
309354852f Profile backend 
Signed-off-by: Christopher Ng <chrng8@gmail.com>
 2021-10-19 04:59:35 +00:00
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>
 2021-10-08 18:39:22 +02:00
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>
 2021-10-08 18:38:25 +02:00
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>
 2021-10-07 16:11:49 +02:00
Carl Schwan
6958d8005a
Add admin privilege delegation for admin settings 
This makes it possible for selected groups to access some settings
pages.

Signed-off-by: Carl Schwan <carl@carlschwan.eu>
 2021-09-29 21:43:31 +02:00
Lukas Reschke
474a5b55d3 Implement review feedback 
Signed-off-by: Lukas Reschke <lukas@statuscode.ch>
 2021-09-13 11:01:35 +02:00
Lukas Reschke
358eaba7dd
Apply suggestions from code review 
Signed-off-by: Lukas Reschke <lukas@statuscode.ch>

Co-authored-by: Joas Schilling <213943+nickvergessen@users.noreply.github.com>
 2021-09-13 10:43:01 +02:00
Lukas Reschke
471167019c Implement PR review feedback 
Signed-off-by: Lukas Reschke <lukas@statuscode.ch>
 2021-09-07 18:03:34 +02:00
Lukas Reschke
a915372c56 phpcs 
Signed-off-by: Lukas Reschke <lukas@statuscode.ch>
 2021-09-06 17:50:23 +02:00