Skip to content

Releases: rotexsoft/Aura.SqlSchema

Maintenance Release

23 Feb 00:38
Compare
Choose a tag to compare

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

22 Feb 20:20
a188450
Compare
Choose a tag to compare
  • 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:

Full Changelog: 2.x...3.1.0

Maintenance Release

13 Feb 21:33
Compare
Choose a tag to compare
  • 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

07 Feb 05:20
Compare
Choose a tag to compare
  • 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