Releases: rotexsoft/Aura.SqlSchema
Releases · rotexsoft/Aura.SqlSchema
Maintenance Release
In ./src/SqliteSchema.php changed
protected function setRawCols(array &$cols, $schema, $table, $create)
to
protected function setRawCols(array &$cols, string $schema, string $table, string $create)
and
protected function addColFromRaw(array &$cols, array $val, $create)
to
protected function addColFromRaw(array &$cols, array $val, string $create)
Full Changelog: 3.1.0...3.1.1
New Major Release
- First version for rotexsoft/sqlschema
- changed Aura\SqlSchema to Rotexsoft\SqlSchema
- added BSD-3 License for rotexsoft/sqlschema enhancements
- more stricter type-hinting applied across the code-base
Contains these changes too:
- https://github.com/rotexdegba/Aura.SqlSchema/releases/tag/3.0.0
- https://github.com/rotexdegba/Aura.SqlSchema/releases/tag/3.0.1
Full Changelog: 2.x...3.1.0
Maintenance Release
- Added script to run tests against multiple versions of MySQL, Mariadb & Postgres
- Added logic to detect Mariadb10.11.6+ in the test setup which like Mysql 8.0+ makes a timestamp column (that wasn't explicitly declared as NOT NULL) to be nullable by default
Full Changelog: 3.0.0...3.0.1
PHP 8.1 Compatible Version
- Refactored code to work with PHP 8.1 with no errors or deprecation warnings.
- Updated Tests to work with PHPUnit 10 and reorganized some of the test setup code
- PHP 8.1 now min version
- Added rector as a dev dependency
- Added more strict typing all over the code base. Definitely no longer backward compatible with version 2.0.x
- Added code to make the package work with mariadb, leveraged some Atlas/Info code to get this done.
- Added code to make the package work with Postgresql, version 2.0.x was not working with Postgresql, leveraged some Atlas/Info code to get this done.
Tested in Rocky Linux 9 With Podman 4.6.1 with PHP 8.1.27 and the follwoing database versions with all tests passing (Didn't test Sql Server):
Mariadb 10.4.32
Mariadb 10.5.23
Mariadb 10.6.16
Mariadb 10.11.6
Mariadb 11.0.4
Mariadb 11.1.3
Mariadb 11.2.2
Mysql 5.6.51
Mysql 5.7.44
Mysql 8.0.36
Mysql 8.3.0
Postgres 12.17
Postgres 13.13
Postgres 14.10
Postgres 15.5
Postgres 16.1
Mysql Containers
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:5.6.51
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:5.7.44
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:8.0.36
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:8.3.0
Mariadb Containers
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.4.32
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.5.23
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.6.16
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.11.6
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:11.0.4
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:11.1.3
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:11.2.2
Postgres Containers
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:12.17
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:13.13
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:14.10
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:15.5
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:16.1
Full Changelog: https://github.com/rotexdegba/Aura.SqlSchema/commits/3.0.0