Commit Graph

37 Commits

Author SHA1 Message Date
Christoph Kluge
37f4ed7770 add additional indices for sorting performance 2024-10-09 17:52:46 +02:00
Christoph Kluge
582dc8bf46 add energy column index 2024-09-30 18:29:46 +02:00
Christoph Kluge
6367c1ab4d Merge branch 'dev' into 275_tag_scope_jobview_rework 2024-09-17 14:32:06 +02:00
Christoph Kluge
d5382aec4f Merge branch 'dev' into 275_add_tag_scope 2024-09-05 16:44:41 +02:00
Christoph Kluge
7ea4086807 Rework sqlite indices in v8 migration 2024-09-05 15:06:38 +02:00
Christoph Kluge
cff60eb51c increase server timeout limit, improve and add db indices
- change energy footprint key to string
2024-08-27 17:43:48 +02:00
Christoph Kluge
31765ce0ef Merge branch 'dev' into 275_add_tag_scope 2024-08-23 14:52:42 +02:00
a8a27c9b51 Add project index to job table 2024-08-19 12:11:53 +02:00
5e074dad10
Resolve error in migration 2024-08-15 12:39:14 +02:00
5c99f5f8bb
Only add footprint columns if not 0 2024-08-15 12:35:11 +02:00
ba2f406bc0
Extend sqlite db migration 2024-08-15 09:41:54 +02:00
Christoph Kluge
9b5c6e3164 fix StartJobTest, add tag_scope to migration 2024-08-05 10:37:42 +02:00
Christoph Kluge
e14d6a81fe fix: fix db migration to v8, changes key name to cpu_load 2024-07-11 17:24:33 +02:00
97c807cd33
Add migration for footprint 2024-06-28 16:49:24 +02:00
Michael Schwarz
ce792426e6 Disable foreign key check while updating database 2024-03-14 09:15:15 +01:00
105b7eabf0 Add migration and introduce dirty flag handling 2024-03-08 10:47:32 +01:00
dd887cbb1f Do all tag queries with query builder
Fix bug in mysql database initialization.
Fixes #231
2024-03-06 13:47:52 +01:00
b5a7249ad5 Fix sqlite migration for configuration 2023-06-30 09:15:58 +02:00
dd80d5af9e Change config value datatype
Fixes #167
2023-06-29 14:55:38 +02:00
eb626db9c2 Debug compression service 2023-06-27 14:29:56 +02:00
d1e3e06b10 Add insert timestamp to tag, jobtag
Fixes #43
2023-06-27 09:41:06 +02:00
Michael Schwarz
a183c23e25 Fix truncate call on mysql and provide step 4 migrations for mysql 2023-06-07 16:49:08 +02:00
Michael Schwarz
df240c2394 Fix database migration order 2023-06-07 11:45:58 +02:00
e444b83149 Fix errors 2023-06-05 16:07:01 +02:00
5ca4bdbd91 Remove VACUUM 2023-06-05 16:01:14 +02:00
8b6a1c8045 Add migration for job table contraints 2023-06-05 15:58:07 +02:00
2de85b0120 Add composite indexes 2023-06-01 15:40:37 +02:00
7491ae9e3c Fix typo in DB schema 2023-05-04 17:26:33 +02:00
5404be3ca7 Add unique constrain on job table 2023-05-04 16:04:57 +02:00
Jan Eitzinger
500ae29d25 Synchronize DB Schema with json schema
Rework tests
2023-04-21 12:59:27 +02:00
Christoph Kluge
8bd72ce807 Small fixes after full file review
- Remove unnecessary field 'project' from GQl and regenerate
- Add newlines to file ends
- Fix command-line manager user addition
2023-02-23 12:33:14 +01:00
Christoph Kluge
d0d578a1e6 Fix user.projects up migration file 2023-02-22 10:17:40 +01:00
Christoph Kluge
822c8b570c Remove exists checks from sql migrations to v3 2023-02-21 18:05:29 +01:00
Christoph Kluge
acbef39045 Fix header, add migration for user.projects column 2023-02-21 17:33:27 +01:00
63f8555af7 Add migration support for mysql 2023-02-21 14:45:59 +01:00
a4f5b139f9 Remove hardcoded index generation 2023-02-21 11:36:23 +01:00
8ffb562d6b Introduce db migration support 2023-02-21 10:57:22 +01:00