- updated to 1.64
see /usr/share/doc/packages/perl-SQL-Translator/Changes
FEATURES
1.64 - 2023-12-22
* support EXCLUDE constraints in Postgres (thansk @KES777)
* Improve enums in the PostgrSQL family (thanks @nrdvana)
* Add index length options for MySQL (thanks @abeverley)
* you can pass fields for an index now as { name => $name, prefix_length => 9001 }
FIXES
* fix spurious on_update/on_delete in diffs (thanks @nrdvana)
* CI improvements (thanks @eserte)
* AUTOINCREMENT is now correctly parsed for SQLite (thanks @nrdvana)
OBS-URL: https://build.opensuse.org/request/show/1136588
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-SQL-Translator?expand=0&rev=37
- updated to 1.63
see /usr/share/doc/packages/perl-SQL-Translator/Changes
1.63 - 2023-02-23
* sqlt-diff: Change producer_args to sqlt_args for better self-documentation
NOTE - using producer_args will now throw a deprecation warning
FEATURES
* A lot of new functionality for the Oracle producer (thanks @hazardv)
* Support DB commments in the following producers: PG, JSON, YAML. Also in the sqlite parser (thanks @djerius)
* Support INCLUDE on indices for Pg (producer + parser)
* Postgres producer now supports materialized views via $extra->{materialized}
FIXES
* Postgres producer genrates correct constraint names for schema-namespaced tables
* Postgres DBI parser now returns scalarref SQL instead of strings for defaults (thanks @nrdvana)
* Postgres producer drops NOT NULL constraints more correctly (thanks @uehara-delta)
* binaries now have their perl set by EUMM (thanks @toddr)
OBS-URL: https://build.opensuse.org/request/show/1070470
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-SQL-Translator?expand=0&rev=35
* Allow passing an arrayref to SQLT->filename (lost in Mooification)
* Fix stupid missing version number in SQL::Translator::Schema::Object
* Relicense under Perl 5 terms
* Remove SQL::Translator::Schema::Graph as announced in 0.11011
* Remove a number of no longer needed deps
* Fix missing dep (List::MoreUtils)
* Convert SQL::Translator, ::Schema and ::Schema::* to Moo
* Fix leaks by weakening circular references between schema objects
* Make MySQL producer add NULL after every nullable field, conforming to SQL
standard, and avoiding MySQL bugs
- remove sqlite.patch which was declined upstream
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-SQL-Translator?expand=0&rev=11
* Add "if exists" to drop view statements in Pg.
* Fix MySQL producer to properly quote all table names on output (patch from geistteufel)
* Correctly create and parse FK constraints in SQLite
* Correct postgis geography type insertion and linebreak fix for multiple geometry/geography columns
* made PostgreSQL producer consistent with other producers in terms of
quoting and allowing functions in constraints and indices
* Add distinction of autoinc and regular primary keys to the GraphViz producer
* Fix odd invocation of Test::More::pass() in t/36-filters.t (RT#64728)
* Quote everything in SQL Server
* Turn off constraints before dropping tables in SQL Server
* Make true unique constraints if needed in SQL Server
* Fixed Producer::PostgresSQL to output array type after type size,
i.e. varchar(64)[] rather than varchar[](64)
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-SQL-Translator?expand=0&rev=7
