Jan Böhmer
|
cb01302ada
|
Test the backup tool in github actions
This ensures that the tool works for all database types
|
2024-06-18 23:04:44 +02:00 |
|
Jan Böhmer
|
e3dfbf0e95
|
Support postgres in the backup command
|
2024-06-18 23:02:33 +02:00 |
|
Jan Böhmer
|
3f471d0c73
|
Natsort MPN column in part datatables
|
2024-06-18 22:34:29 +02:00 |
|
Jan Böhmer
|
4a706ab707
|
Do not natsort description fields as these can become very long
|
2024-06-18 22:34:13 +02:00 |
|
Jan Böhmer
|
4946a9ab0d
|
Fixed SQL declaration of NatSortKey function
We do not need the delimiter declarations
|
2024-06-18 22:32:07 +02:00 |
|
Jan Böhmer
|
123372d93f
|
Allow to emulate natural sort on mysql platforms
|
2024-06-18 21:42:00 +02:00 |
|
Jan Böhmer
|
272fe0516b
|
Allow to emulate natural sorting on SQLite databases
|
2024-06-18 00:09:44 +02:00 |
|
Jan Böhmer
|
289c9126d0
|
Use Natural_SORT_KEY for natural sorting on MariaDB database which support that
This resolves issue #243 and #402
|
2024-06-17 23:29:38 +02:00 |
|
Jan Böhmer
|
0a482da93e
|
Use postgres native array_position function instead of our FIELD function and pass it as array literal instead of variadic function
Otherwise we will run into errors, that we can not give more than 100 arguments to a function
|
2024-06-17 23:13:04 +02:00 |
|
Jan Böhmer
|
8bb8118d9f
|
Use natural sorting for trees and others repository functions
|
2024-06-17 22:33:40 +02:00 |
|
Jan Böhmer
|
9db822eabd
|
Use natural sorting for string datatables columns when using postgres
The natural sorting solution is quite portable, so this should be possible for other database types too later
|
2024-06-17 21:38:16 +02:00 |
|
Jan Böhmer
|
8a42dfa154
|
Use the FIELD function on postgres for order by field value
|
2024-06-17 21:20:23 +02:00 |
|
Jan Böhmer
|
d7a7e22e5a
|
Fixed lessThanDesired Constraint for postgresql
|
2024-06-17 21:16:46 +02:00 |
|
Jan Böhmer
|
4f75e2641b
|
Define a custom FIELD function to sort tables by list of ids without the emulation via string operations
|
2024-06-16 23:46:40 +02:00 |
|
Jan Böhmer
|
d3dcefb645
|
Fixed total amount and less than desired filter on postgresql
|
2024-06-16 23:26:57 +02:00 |
|
Jan Böhmer
|
6d1553e8d8
|
Fixed problem with datatable column sorting on postgresql
|
2024-06-16 22:52:15 +02:00 |
|
Jan Böhmer
|
7ad2fab53d
|
Fixed exception related that Datetimeimmutables were used were doctrine expected mutable ones
this prevented the saving of parts from info providers
|
2024-06-13 23:41:35 +02:00 |
|
Jan Böhmer
|
6e9b337b49
|
Fixed regex function for postgres
|
2024-06-13 23:18:25 +02:00 |
|
Jan Böhmer
|
c58ff5861d
|
Replaced the non standard IFNULL function which postgres does not know with the COALSCE function
|
2024-06-13 23:01:53 +02:00 |
|
Jan Böhmer
|
33a5e70b70
|
Fixed phpunit tests for postgres
|
2024-06-13 22:19:17 +02:00 |
|
Jan Böhmer
|
07f1ce5822
|
Configure the postgres server to accept local connections without password
|
2024-06-13 00:00:51 +02:00 |
|
Jan Böhmer
|
d41996b365
|
Added SSH connection into test container for debugging
|
2024-06-12 23:33:05 +02:00 |
|
Jan Böhmer
|
d3c9b7eae1
|
Configure postgres to accept all connections without password for testing
|
2024-06-12 23:30:42 +02:00 |
|
Jan Böhmer
|
373a1ab0f4
|
Change the password of the postgres user
|
2024-06-12 23:24:37 +02:00 |
|
Jan Böhmer
|
58dd56a89f
|
Supply a password for the postgres database connection
|
2024-06-12 23:16:24 +02:00 |
|
Jan Böhmer
|
d7eadd9294
|
Use the builtin postgres user already defined in the github image
It hopefully requires no password
|
2024-06-12 23:13:20 +02:00 |
|
Jan Böhmer
|
853e29dd83
|
Removed sqlite database creation
This is not possible anymore for the sqlite driver and is unnesecarry as it is automatically created on migration
|
2024-06-10 23:47:28 +02:00 |
|
Jan Böhmer
|
0c1c46c045
|
Fixed MySQL version number
The 8.0 was to short to be detected as newer than 8.0.0. We need to specify the bugfix release to get proper results
|
2024-06-10 23:46:33 +02:00 |
|
Jan Böhmer
|
be97ea08a2
|
Specify a version number on the MySQL database URL, so that doctrine does not need to start a connection while cache clearing
|
2024-06-10 23:35:13 +02:00 |
|
Jan Böhmer
|
1c8b81ca2c
|
Run a SSH session in the github actions container for better debugging
|
2024-06-10 23:05:16 +02:00 |
|
Jan Böhmer
|
8266f230d7
|
For debugging disable fast failing of phpunit tests
|
2024-06-10 22:58:54 +02:00 |
|
Jan Böhmer
|
0b53542716
|
Added postgres to github tests actions
|
2024-06-10 22:52:11 +02:00 |
|
Jan Böhmer
|
eab1c7096c
|
Use the postgres migration code generated by the new doctrine orm versions
This now uses IDENTITY columns for ID columns, which makes their behavior more similar to the behavior of MySQL and SQLite
|
2024-06-10 22:38:46 +02:00 |
|
Jan Böhmer
|
8ee3aaf4f4
|
Added Sqlite migrations required by new doctrine/orm version and fixed migration duplication for sqlite
|
2024-06-10 21:54:15 +02:00 |
|
Jan Böhmer
|
427b8659c9
|
Added MySQL migrations required by the doctrine upgrades
The new ORM versions, do not have anymore column comments, so these got removed
|
2024-06-10 21:43:25 +02:00 |
|
Jan Böhmer
|
3c3af824cf
|
Merge branch 'doctrine-upgrade' into postgres
|
2024-06-10 21:26:00 +02:00 |
|
Jan Böhmer
|
d40ce470d3
|
Fixed some invalid class constant use in ResetAutoIncrementORMPurger
|
2024-06-10 21:25:51 +02:00 |
|
Jan Böhmer
|
07c7f07c35
|
Removed usage of partial flush which is not supported with the recent doctrine ORM version
|
2024-06-10 21:25:23 +02:00 |
|
Jan Böhmer
|
fe732ecf45
|
Fixed minor inspection issue
|
2024-06-10 21:16:46 +02:00 |
|
Jan Böhmer
|
971bb92a8c
|
Fixed error caused by ArrayType fields which is required by the webauthn bundle but was removed in doctrine/orm 4.0
We simple forward port the ArrayType class from orm 3.8 to fix this error
|
2024-06-10 21:11:11 +02:00 |
|
Jan Böhmer
|
777f6ba738
|
Fixed error caused by immutable datetime passed to mutable datetime doctrine type
|
2024-06-10 20:47:06 +02:00 |
|
Jan Böhmer
|
4d927c5870
|
Use a better exception format for UTCDateTimeType
|
2024-06-10 20:17:57 +02:00 |
|
Jan Böhmer
|
1830e9da3d
|
Fixed errors caused by change on how setParameters on query builder works
We replaced them by individual setParameter calls as this seems to be the easiest way to fix this
|
2024-06-10 00:08:53 +02:00 |
|
Jan Böhmer
|
5eb29746af
|
Revert "Fixed errors that query builder setParameters now expects an ArrayCollection instead of an array"
This reverts commit 78671b0bfe .
|
2024-06-10 00:04:22 +02:00 |
|
Jan Böhmer
|
afb816cc41
|
Use the getReference function in TimeTravel service instead of the removed getPartialReference()
This is probably the better choice anyway
|
2024-06-09 23:58:03 +02:00 |
|
Jan Böhmer
|
bd640c19a4
|
Fixed type of token object is now a property instead of array value in Field2
|
2024-06-09 23:55:12 +02:00 |
|
Jan Böhmer
|
0d445b6a21
|
Fixed some minor inspection issues caused by the doctrine upgrades
|
2024-06-09 23:51:41 +02:00 |
|
Jan Böhmer
|
78671b0bfe
|
Fixed errors that query builder setParameters now expects an ArrayCollection instead of an array
|
2024-06-09 23:51:11 +02:00 |
|
Jan Böhmer
|
60325e797d
|
Fixed the use of the removed ClassMetadataInfo constants
|
2024-06-09 23:45:22 +02:00 |
|
Jan Böhmer
|
7d9be5ae76
|
Fixed wrong casing of SQLitePlatform
|
2024-06-09 23:36:00 +02:00 |
|