The NetBSD Project

CVS log for pkgsrc/databases/p5-SQL-Translator/distinfo

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / p5-SQL-Translator

Request diff between arbitrary revisions


Default branch: MAIN


Revision 1.26 / (download) - annotate - [select for diffs], Fri Aug 25 06:33:47 2023 UTC (3 months, 1 week ago) by wen
Branch: MAIN
CVS Tags: pkgsrc-2023Q3-base, pkgsrc-2023Q3, HEAD
Changes since 1.25: +4 -4 lines
Diff to previous 1.25 (colored)

Update to 1.63

Upstream 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)

Revision 1.25 / (download) - annotate - [select for diffs], Tue Oct 26 10:09:41 2021 UTC (2 years, 1 month ago) by nia
Branch: MAIN
CVS Tags: pkgsrc-2023Q2-base, pkgsrc-2023Q2, pkgsrc-2023Q1-base, pkgsrc-2023Q1, pkgsrc-2022Q4-base, pkgsrc-2022Q4, pkgsrc-2022Q3-base, pkgsrc-2022Q3, pkgsrc-2022Q2-base, pkgsrc-2022Q2, pkgsrc-2022Q1-base, pkgsrc-2022Q1, pkgsrc-2021Q4-base, pkgsrc-2021Q4
Changes since 1.24: +2 -2 lines
Diff to previous 1.24 (colored)

databases: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

The following distfiles could not be fetched (some may be only fetched
conditionally):

./databases/cstore/distinfo D6.data.ros.gz
./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz

Revision 1.24 / (download) - annotate - [select for diffs], Thu Oct 7 13:35:29 2021 UTC (2 years, 1 month ago) by nia
Branch: MAIN
Changes since 1.23: +1 -2 lines
Diff to previous 1.23 (colored)

databases: Remove SHA1 distfile hashes

Revision 1.23 / (download) - annotate - [select for diffs], Sun Sep 20 07:15:22 2020 UTC (3 years, 2 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2021Q3-base, pkgsrc-2021Q3, pkgsrc-2021Q2-base, pkgsrc-2021Q2, pkgsrc-2021Q1-base, pkgsrc-2021Q1, pkgsrc-2020Q4-base, pkgsrc-2020Q4, pkgsrc-2020Q3-base, pkgsrc-2020Q3
Changes since 1.22: +5 -5 lines
Diff to previous 1.22 (colored)

p5-SQL-Translator: update to 1.62.

1.62 - 2020-09-14
 * Update Pg support to allow version 12 (still supporting back to 7.4)

Revision 1.22 / (download) - annotate - [select for diffs], Sun Sep 6 22:10:05 2020 UTC (3 years, 3 months ago) by wiz
Branch: MAIN
Changes since 1.21: +5 -6 lines
Diff to previous 1.21 (colored)

p5-SQL-Translator: update to 1.61.

1.61 - 2020-04-19
 * Fixes for Sybase producer
 * Support CHECK (expr) for SQLite and MySQLoids
 * Avoid accidentally whole objects in YAML output
 * Prettify comment generation
 * Tyop fixes

Revision 1.21 / (download) - annotate - [select for diffs], Fri Sep 13 08:32:07 2019 UTC (4 years, 2 months ago) by wen
Branch: MAIN
CVS Tags: pkgsrc-2020Q2-base, pkgsrc-2020Q2, pkgsrc-2020Q1-base, pkgsrc-2020Q1, pkgsrc-2019Q4-base, pkgsrc-2019Q4, pkgsrc-2019Q3-base, pkgsrc-2019Q3
Changes since 1.20: +5 -5 lines
Diff to previous 1.20 (colored)

Update to 1.60

Upstream changes:
1.60 - 2019-05-29
 * No changes since 1.59_01

1.59_01 - 2019-04-28
 * Add support for parsing PostgreSQL dollar-quoted strings
 * Add support for materialized views in Oracle producer
 * switched JSON backend from JSON.pm to JSON::MaybeXS
 * Port Makefile.PL from Module::Install to Distar
 * Synchronise the version number across all modules

Revision 1.20 / (download) - annotate - [select for diffs], Wed Jan 10 08:42:53 2018 UTC (5 years, 10 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2019Q2-base, pkgsrc-2019Q2, pkgsrc-2019Q1-base, pkgsrc-2019Q1, pkgsrc-2018Q4-base, pkgsrc-2018Q4, pkgsrc-2018Q3-base, pkgsrc-2018Q3, pkgsrc-2018Q2-base, pkgsrc-2018Q2, pkgsrc-2018Q1-base, pkgsrc-2018Q1
Changes since 1.19: +5 -5 lines
Diff to previous 1.19 (colored)

p5-SQL-Translator: update to 0.11024.

0.11024 2018-01-09

 * Remove temporary diagnostics added in 0.11023_01

0.11023_02 2017-12-08

 * Make maybe_plan skip on unrecognised failures to load modules

0.11023_01 2017-12-07

 * Add diagnostics to t/postgresql-rename-table-and-field.t that's
   failing mysteriously on some smokers

Revision 1.19 / (download) - annotate - [select for diffs], Wed Dec 6 07:05:39 2017 UTC (6 years ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2017Q4-base, pkgsrc-2017Q4
Changes since 1.18: +5 -5 lines
Diff to previous 1.18 (colored)

p5-SQL-Translator: update to 0.11023.

0.11023 2017-12-05

 * Fix error handling for Test::PostgreSQL 1.20

0.11022 2017-12-04

 * Add support for monotonically increasing SQLite autoincs (GH#47)
 * Add support for CHECK constraint in SQLite producer (GH#57)
 * Add support for CHECK constraint in POD producer (GH#63)
 * Fix forgotten quoting in the MySQL DROP TABLE diff producer (GH#50)
 * Fix Pg grammar parsing of UUID, time, timetz columns (RT#100196, GH#52)
 * Add support for USING and WHERE on indexes in PostgreSQL producer
   and parser (RT#63814, GH#52)
 * Improve add_trigger consistency between producers (GH#48)
 * Add trigger 'scope' attribute support to JSON, YAML and XML producers,
   and XML and SQLite parsers (RT#119997)
 * Declare dependencies in deterministic order (RT#102859)
 * Multiple speedups of naive internal debugging mechanism (GH#54)
 * Remove dependency on List::MoreUtils ( http://is.gd/lmu_cac_debacle )
 * Fix parsing of strings with leading whitespace for MySQL, Oracle, PostgreSQL,
   SQLServer and SQLite
 * Fix parsing of MySQL column comments (RT#83380)
 * Fix multi-line comments in YAML, JSON and PostgreSQL producers
 * Fix identifier quoting in PostgreSQL diff producer
 * Fix incorrect type conversion from various BigInt AutoIncrement to the
   PostgreSQL-specific bigserial (GH#72)
 * Fix missing semicolons between PostGIS statements
 * Fix string and identifier quoting in PostGIS statements
 * Fix intermittent test failures (RT#108460)
 * Fix relying on exact serialisation for JSON/YAML tests (RT#121901)

Revision 1.18 / (download) - annotate - [select for diffs], Wed Jun 7 14:34:47 2017 UTC (6 years, 6 months ago) by ryoon
Branch: MAIN
CVS Tags: pkgsrc-2017Q3-base, pkgsrc-2017Q3, pkgsrc-2017Q2-base, pkgsrc-2017Q2
Changes since 1.17: +2 -1 lines
Diff to previous 1.17 (colored)

Fix build with Perl 5.26.0

Revision 1.17 / (download) - annotate - [select for diffs], Tue Nov 3 01:56:23 2015 UTC (8 years, 1 month ago) by agc
Branch: MAIN
CVS Tags: pkgsrc-2017Q1-base, pkgsrc-2017Q1, pkgsrc-2016Q4-base, pkgsrc-2016Q4, pkgsrc-2016Q3-base, pkgsrc-2016Q3, pkgsrc-2016Q2-base, pkgsrc-2016Q2, pkgsrc-2016Q1-base, pkgsrc-2016Q1, pkgsrc-2015Q4-base, pkgsrc-2015Q4
Changes since 1.16: +2 -1 lines
Diff to previous 1.16 (colored)

Add SHA512 digests for distfiles for databases category

Problems found with existing distfiles:
	distfiles/D6.data.ros.gz
	distfiles/cstore0.2.tar.gz
	distfiles/data4.tar.gz
	distfiles/sphinx-2.2.7-release.tar.gz
No changes made to the cstore or mariadb55-client distinfo files.

Otherwise, existing SHA1 digests verified and found to be the same on
the machine holding the existing distfiles (morden).  All existing
SHA1 digests retained for now as an audit trail.

Revision 1.16 / (download) - annotate - [select for diffs], Thu Aug 6 01:52:03 2015 UTC (8 years, 4 months ago) by wen
Branch: MAIN
CVS Tags: pkgsrc-2015Q3-base, pkgsrc-2015Q3
Changes since 1.15: +4 -4 lines
Diff to previous 1.15 (colored)

Update to 0.11021

Upstream changes:
0.11021 2015-01-29

 * Fix Oracle producer generating an unnecessary / at the end in case there
   are no triggers
 * Skip HTML tests if CGI is not installed (RT#98027)
 * Fix JSON and YAML tests if the defaults have been tweaked (RT#98824)
 * Fixes for parsing and producing identifiers and values that need
   quoting and escaping for SQLite, MySQL, PostgreSQL, SQLServer and
   Oracle (RT#90700, RT#31034)
 * Add support for ALTER TABLE ... ADD CONSTRAINT to Oracle parser
 * Add trigger support to Oracle parser (RT#62927)
 * Fix erroneous PostgreSQL floating point type translations (RT#99725)
 * Remove executable bit from Parser/JSON.pm (RT#100532)
 * Update the Free Software Foundation's address (RT#100531)
 * Provide default index names for SQLite (GH#45)
 * Fix SQLite diffing on perl 5.8.1
 * Fix multi-column indexes in Parser::DBI::PostgreSQL
 * Fix array data types in Parser::PostgreSQL (GH#49)
 * Fix multidimensional sizes in Parser::PostgreSQL

Revision 1.15 / (download) - annotate - [select for diffs], Sun Nov 23 12:36:55 2014 UTC (9 years ago) by wen
Branch: MAIN
CVS Tags: pkgsrc-2015Q2-base, pkgsrc-2015Q2, pkgsrc-2015Q1-base, pkgsrc-2015Q1, pkgsrc-2014Q4-base, pkgsrc-2014Q4
Changes since 1.14: +4 -4 lines
Diff to previous 1.14 (colored)

Update to 0.11020

Upstream changes:
0.11020 2014-09-02

 * Fix test failure if Test::PostgreSQL is installed but not working

0.11019 2014-09-02

 * Add Json and hstore types to Pg Parser (cloudinstustrie)
 * Fix DROP TABLE in SQL Server Producer
 * Fix Pg DBI parser test (Dagfinn Ilmari Mannsker)
 * Remove spurious warnings (Matt Phillips, Wallace Reis)
 * Fix MySQL producer for columns with scalar ref in 'ON UPDATE' (Wallace Reis)
 * Fix handling of views in MySQL DBI parser
 * Fix handling of renamed fields in SQLite diff (Peter Mottram)
 * Check numeric equality of default values in numeric-type fields (Wallace Reis)
 * Fix handling of renamed fields in renamed tables in Pg diff (Peter Mottram)

0.11018 2013-10-31

 * Revert "Fix AUTOINCREMENT in SQLite"

0.11017 2013-10-30

 * Apply quotes to fix tables that are reserved words, DBI::SQLServer (Jonathan C. Otsuka)
 * Add DECIMAL_DIGITS to field size for scale info, DBI::SQLServer (Jonathan C. Otsuka)
 * De-linkify XML namespace in docs (RT#81838)
 * Allow both single and double quotes for values in MySQL parser
 * Fix diff for altering two things per column - add ; at the end
 * Call all diff methods in list context (it can be merged later)
 * Fix Pg diff issue with drop constraint on primary keys
 * SQLite support for SET NULL, SET DEFAULT and NO ACTION in FK clauses
 * Clean up properly after Parser::DBI::PostgreSQL tests
 * Fix typos in error messages
 * Add SQL_TINYINT and SQL_BIGINT to the type map in
   SQL::Translator::Schema::Field
 * Add JSON parser and producer (Jon Jensen)
 * Clean up TTSchema doc some (Gavin Shelley)
 * Fix AUTOINCREMENT in SQLite (Rafael Porres Molina)

Revision 1.14 / (download) - annotate - [select for diffs], Fri Oct 19 08:08:25 2012 UTC (11 years, 1 month ago) by sno
Branch: MAIN
CVS Tags: pkgsrc-2014Q3-base, pkgsrc-2014Q3, pkgsrc-2014Q2-base, pkgsrc-2014Q2, pkgsrc-2014Q1-base, pkgsrc-2014Q1, pkgsrc-2013Q4-base, pkgsrc-2013Q4, pkgsrc-2013Q3-base, pkgsrc-2013Q3, pkgsrc-2013Q2-base, pkgsrc-2013Q2, pkgsrc-2013Q1-base, pkgsrc-2013Q1, pkgsrc-2012Q4-base, pkgsrc-2012Q4
Changes since 1.13: +4 -4 lines
Diff to previous 1.13 (colored)

Updating package for CPAN module SQL::Translator from 0.11010nb2 to
0.11016.

pkgsrc changes:
- adjust dependencies

Upstream changes:
# ----------------------------------------------------------
# 0.11016 2012-10-09
# ----------------------------------------------------------

* Allow passing an arrayref to SQLT->filename (lost in Mooification)

# ----------------------------------------------------------
# 0.11015 2012-10-05
# ----------------------------------------------------------

* Fix stupid missing version number in SQL::Translator::Schema::Object

# ----------------------------------------------------------
# 0.11014 2012-10-05
# ----------------------------------------------------------

* Relicense under Perl 5 terms

# ----------------------------------------------------------
# 0.11013_03 2012-09-25
# ----------------------------------------------------------

* Remove SQL::Translator::Schema::Graph as announced in 0.11011
* Remove a number of no longer needed deps

# ----------------------------------------------------------
# 0.11013_02 2012-09-23
# ----------------------------------------------------------

* Fix missing dep (List::MoreUtils)

# ----------------------------------------------------------
# 0.11013_01 2012-09-22
# ----------------------------------------------------------

* Convert SQL::Translator, ::Schema and ::Schema::* to Moo
* Fix leaks by weakening circular references between schema objects

# ----------------------------------------------------------
# 0.11013 2012-09-22
# ----------------------------------------------------------

* Make MySQL producer add NULL after every nullable field, conforming to SQL
  standard, and avoiding MySQL bugs

# ----------------------------------------------------------
# 0.11012 2012-07-02
# ----------------------------------------------------------

* Fix/update quoting in PostgreSQL producer
* Add missing quote function to SQLServer producer
* Fix incorrect Parser::DBI documentation (RT#60878)

# ----------------------------------------------------------
# 0.11011 2012-05-09
# ----------------------------------------------------------

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
*** INCOMPATIBLE CHANGES:
* SQLT no longer supports setting separate conflicting values for the now
  deprecated 'quote_table_names' and 'quote_field_names'. Instead their values
  are proxied to the new 'quote_identifiers'. If 'quote_identifiers' is
  supplied, the legacy settings are ignored (with a warning). If nothing is
  specified the default is TRUE as before. If only one is specified - default
  to its value for everything, and if both are specified with a conflicting
  value an exception is thrown.
* Partial quoting support has been added in SQLite. It is currently disabled by
  default, you need to request is explicitly with quote_identifiers => 1. In a
  future version of SQL::Translator *THIS DEFAULT BEHAVIOR WILL CHANGE*.
  If you do NOT WANT quoting, set quote_identifiers to a false value to
  protect yourself from changes in a future release.
* Bump the default MySQL parser version to MySQL 4.0
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
* script/sqlt-graph now accepts a --trace option
* Fixes to SQLite foreign keys production (patch from Johan Viklund)
  closes RT#16412, RT#44769
* ON DELETE/UPDATE actions for SQLite (patch from Lukas Thiemeier)
  closes RT#70734, RT#71283, RT#70378
* Fix data preservation on SQLite diffs involving adding/dropping columns
* Support for triggers in PostgreSQL producer and parser
* Correct Data Type in SQLT::Parser::DBI::PostgreSQL (patch from Andrew Pam)
* Fix index issue in SQLT::Parser::DBI::PostgreSQL
* Add column and table comments in SQLT::Parser::DBI::PostgreSQL(patch from Andrew Pam)
* Stop the DBI parser from disconnecting externally supplied DBI handles (RT#35868)
* Fixed alter_drop_constraint for foreign keys and applying multiple changes
  via alter_field to a column in Postgres Producer
* Added a working mechanism for naming foreign keys in the PostgreSQL producer
* Fix PostgreSQL ignoring default values with specified data type
* Fix PostgreSQL parser support for (N)::int defaults (patch by Tina MĀ¼ller)
* Fix possible name duplication in SQLlite producer
* Oracle does not accept ON DELETE/UPDATE RESTRICT (though it is the actual default)
  fix by not adding the ON DELETE/UPDATE clause at all
* Changed dependency on Digest::SHA1 to the core-bundled Digest::SHA (RT#67989)
* Support for double quoted and bit strings as default values in MySQL parser
* Improved VIEW support in MySQL parser
* Proper handling of CURRENT_TIMESTAMP default values in MySQL parser (RT#65844)
* Check in MySQL parser to avoid trying to parse a table defined twice in the same
  file as indices (and probably other things) get messed up
* Workaround for some MySQL quirks on primary key definitions
* Fix dropping primary keys in MySQL diffs (RT#62250, patch from Nick Bertrand)
* MySQL producer does not attempt to write out non-existent unique constraint names
* MySQL parser correctly differentiates between signed and unsigned integer column
  display sizes
* Replace Class::Accessor::Fast dependency with already-included Moo
* Entire codebase is now free of tabs and trailing whitespace
* Spellfixes (RT#68912)
* Fix Diagram Producer POD (RT#71397, RT#71398)
* Fix Diagram Producer to use correct binmode on output (RT#71399)
* Fix ignored option to script/sqlt-diagram (RT#5992)
* Fix t/17sqlfxml-producer.t failures due to whitespace differences introduced by
  environment config snippets (RT#70786)
* Fix assembly of Table objects with numbered columns being added out of order
  (RT#74771) (based on patch from Jonathan Otsuka)
* Fix syntax error in SQL::Translator::Producer::Latex (RT#74953)
* Deprecate SQL::Translator::Schema::Graph and the as_graph() schema method
* Bump minimum supported perl version to 5.8.1 (mostly due to Moo)

Revision 1.13 / (download) - annotate - [select for diffs], Tue Nov 22 11:17:47 2011 UTC (12 years ago) by hiramatsu
Branch: MAIN
CVS Tags: pkgsrc-2012Q3-base, pkgsrc-2012Q3, pkgsrc-2012Q2-base, pkgsrc-2012Q2, pkgsrc-2012Q1-base, pkgsrc-2012Q1, pkgsrc-2011Q4-base, pkgsrc-2011Q4
Changes since 1.12: +4 -4 lines
Diff to previous 1.12 (colored)

Update p5-SQL-Translator to 0.11010.

Changes from previous:
# ----------------------------------------------------------
# 0.11010 2011-10-05
# ----------------------------------------------------------

* Add "if exists" to drop view statements in Pg.

# ----------------------------------------------------------
# 0.11009 2011-09-02
# ----------------------------------------------------------

* Fix MySQL producer to properly quote all table names on output (patch from geistteufel)

# ----------------------------------------------------------
# 0.11008 2011-05-04
# ----------------------------------------------------------

* 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)

# ----------------------------------------------------------
# 0.11007 2010-11-30
# ----------------------------------------------------------

* Fix POD typo in SQL/Translator/Schema/Trigger.pm
* Add explicit Scalar::Util to the deplist for really old perls
* Add support for PostGIS Geometry and Geography data types in the Pg producer
* Some minor fixes to squash warnings on new perls
* Support a custom_type_name hint when creating enum types in PostgreSQL
* Fix sqlt options/pod mismatch (RT#58318)
* Oracle Producer multicolumn constraint support
* Add support for triggers in the MySQL producer
* Fix unstable order of View's in MySQL parser

Revision 1.12 / (download) - annotate - [select for diffs], Wed Aug 4 14:26:45 2010 UTC (13 years, 4 months ago) by sno
Branch: MAIN
CVS Tags: pkgsrc-2011Q3-base, pkgsrc-2011Q3, pkgsrc-2011Q2-base, pkgsrc-2011Q2, pkgsrc-2011Q1-base, pkgsrc-2011Q1, pkgsrc-2010Q4-base, pkgsrc-2010Q4, pkgsrc-2010Q3-base, pkgsrc-2010Q3
Changes since 1.11: +4 -4 lines
Diff to previous 1.11 (colored)

Updating databases/p5-SQL-Translator from 0.11005 to 0.11006

pkgsrc changes:
- adjust dependencies

Upstream changes:
# ----------------------------------------------------------
# 0.11006 2010-06-03
# ----------------------------------------------------------
* Fix Producer::Oracle varchar2 without size def (ORA-00906: missing right
  parenthesis)
* Fix Producer::Oracle translate float and double to float instead of number
* Fix Producer::Oracle generation of too long unique constraint names
* Fix Producer::SQLite when generating VIEWs with add_drop_table => 1
* Fix Producer::MySQL not quoting index names when requested (RT#56173)
* Fix Producer::MySQL wrapping extra ()s around VIEW SELECT-ors (RT#56419)
* Fix Field::default_value to behave like a real accessor (allow undef as
  an unsetting argument)
* Fix Mysql/Pg/SQLite/MSSQL producers to properly *not* quote numeric default
  values (RT#57059)
* Producer::Oracle tests now use Test::Differences
* Prettify output of SQLite producer (less bogus newlines)
* Augment SQLite and Pg producers to accept a perl-formatted (%d.%03d%03d)
  and regular no-leading-zero (X.X.X) *_version producer args

Revision 1.11 / (download) - annotate - [select for diffs], Wed Mar 3 18:15:54 2010 UTC (13 years, 9 months ago) by sno
Branch: MAIN
CVS Tags: pkgsrc-2010Q2-base, pkgsrc-2010Q2, pkgsrc-2010Q1-base, pkgsrc-2010Q1
Changes since 1.10: +4 -4 lines
Diff to previous 1.10 (colored)

Updating databases/p5-SQL-Translator from 0.11004 to 0.11005

Upstream changes:
# ----------------------------------------------------------
# 0.11005 2010-02-24
# ----------------------------------------------------------
* Fix Parser::DBI::Oracle reading too many tables (RT#49413)
* Fix Parser::MySQL tripping up on PRIMARY KEY ... USING (currently value is ignored) (RT#50468)
* Fix runaway debug trace (RT#52276)
* Fix Parser::PostgreSQL choking on commit; statements in DDL (#RT52277)
* Producer::Oracle now respects quote_field|table_names, and
  no longer does name munging of reserved table names
* Producer::Oracle now correctly outputs databse-unique index names

Revision 1.10 / (download) - annotate - [select for diffs], Mon Feb 22 21:41:18 2010 UTC (13 years, 9 months ago) by sno
Branch: MAIN
Changes since 1.9: +4 -4 lines
Diff to previous 1.9 (colored)

Updating databases/p5-SQL-Translator from 0.11003 to 0.11004

Upstream changes:
# ----------------------------------------------------------
# 0.11004 2010-02-14
# ----------------------------------------------------------
* Fix PG producer numeric precision regression (RT#49301)
* Add DB2 producer numeric/decimal precision output
* Fix Oracle producer creating numeric precision statements that the test case expects (no whitespace)
* Add Oracle producer creating drop view statements like PG producer does
* Fix SQL::Translator::Diff to use producer_args instead of producer_options

Revision 1.9 / (download) - annotate - [select for diffs], Sun Oct 11 12:18:22 2009 UTC (14 years, 1 month ago) by sno
Branch: MAIN
CVS Tags: pkgsrc-2009Q4-base, pkgsrc-2009Q4
Changes since 1.8: +4 -4 lines
Diff to previous 1.8 (colored)

Updating databases/p5-SQL-Translator from 0.11002 to 0.11003

Upstream changes:
# ----------------------------------------------------------
# 0.11003 2009-09-28
# ----------------------------------------------------------
* Pg parser fixes to deal properly with MATCH <type>
* Pg parser fixes to parse timestamp attributes correctly
* Fix broken default detection in script/sqlt (RT#27438)
* Fix dependency issues with LibXML and TT

Revision 1.8 / (download) - annotate - [select for diffs], Sat Sep 12 19:12:02 2009 UTC (14 years, 2 months ago) by sno
Branch: MAIN
CVS Tags: pkgsrc-2009Q3-base, pkgsrc-2009Q3
Changes since 1.7: +4 -4 lines
Diff to previous 1.7 (colored)

Updating package databases/p5-SQL-Translator from 0.11001 to 0.11002

pkgsrc changes:
  - Adjusting dependencies

Upstream changes:
0.11002 2009-08-30
  * Depend on fixed Parse::RecDescent
  * Added skip-tables and skip-tables-like options to Diagram

Revision 1.7 / (download) - annotate - [select for diffs], Wed Aug 19 09:19:41 2009 UTC (14 years, 3 months ago) by sno
Branch: MAIN
Changes since 1.6: +4 -4 lines
Diff to previous 1.6 (colored)

Updating package databases/p5-SQL-Translator from 0.09007 to 0.11001

pkgsrc changes:
  - Adding recommended dependencies
  - Adjusting dependencies according to META.yml

Upstream changes:
# ----------------------------------------------------------
# 0.11001 2009-08-18
# ----------------------------------------------------------
* Removed last use of Readonly
* Adjusted YAML dependency

# ----------------------------------------------------------
# 0.11000 2009-08-18
# ----------------------------------------------------------
* Re-add version numbers to files, else cpan's "upgrade" gets very confused
* Replaced code using Readonly, since most of the rest uses constant, and thats already a dep
* Moved YAML and XML::LibXML back to recommends, the tests for both now skip if not installed
* Bumped to 0.11000 to supercede 0.10 which has incorrect numbering scheme

# ----------------------------------------------------------
# 0.10 2009-08-13
# ----------------------------------------------------------
* Resolved the following RT bugs (thanks to everyone for reporting!):
25791   does not recognize PostgreSQL ON_ERROR_STOP
29265   sqlt-diagram: --natural-join needs Graph::Directed
37814   SQLite translator failing to parse schema
42548   Producer::PostgreSQL incorrectly inserts the size in
        'time(stamp)? with(out) time zone' fields
43173   SQL::Translator::Parser without versionnumber - will install
        old 0.09002
46805   (No subject)
47026   META.yml is not packaged due to MANIFEST.SKIP (easyfix)
32130   Move from XML::XPath to XML::LibXML::XPathContext
22261   MySQL parse
13915   missing optional prerequisite cause make test to fail
8847    Diagram.pm: BINMODE missing in printing of graphic file.
21065   GraphViz producer fails on tables named 'node'
35448   Producer::PostgreSQL types without size
22026   sqlt-diagram uses -f arg twice
47897   [PATCH] Fix uninitialized value within @_ in (uc|lc)
47668   Mysql Parser doesn't recognize key types
46448   sqlt-graph errors out on MySQL DDL with btree keys
47176   Add Foreign Key support to Parser::DBI::PostgreSQL.pm
48025   MySQL Producer: Case inconsistency between elements in
        @no_length_attr and $data_type
48569   sqlt-diagram fails to load SQLite schema
48596   SQL::Translator::Diff::schema_diff should produce a list in
        list context
44907   SQL::Translator::Producer::PostgreSQL produce() in list context
        should return a list of statements

Revision 1.6 / (download) - annotate - [select for diffs], Tue Jul 7 20:37:23 2009 UTC (14 years, 5 months ago) by sno
Branch: MAIN
Changes since 1.5: +4 -4 lines
Diff to previous 1.5 (colored)

Updating package for p5 module for SQL::Translator from 0.09006 to 0.09007

Upstream changes:
# ----------------------------------------------------------
# 0.09007 2009-06-25
# ----------------------------------------------------------
* Fixed Pg parser - caching the compiled P::RD schema is a *very*
  bad idea
* Fix MSSQL handling of ON UPDATE/DELETE RESTRICT
* Delay MSSQL FK constraint deployment until after all CREATE TABLE
  statements
* Coerce other engine's bytea/blob/clob datatypes to VarBinary

Revision 1.5 / (download) - annotate - [select for diffs], Mon Jun 15 19:44:04 2009 UTC (14 years, 5 months ago) by sno
Branch: MAIN
CVS Tags: pkgsrc-2009Q2-base, pkgsrc-2009Q2
Changes since 1.4: +4 -4 lines
Diff to previous 1.4 (colored)

pkgsrc changes:
  - Updating package of p5 module SQL::Translator from 0.09004 to 0.09006
  - Setting license to gnu-gpl-v2
  - Adjusting dependencies according to Makefile.PL

Upstream changes:
# ----------------------------------------------------------
# 0.09006 2009-06-10
# ----------------------------------------------------------
* Multiple test and dependency adhustments to make smokers happy
* Fix YAML producer wrt extra attribute
* Added support for "time(stamp) (p) with time zone" for Pg producer (mo)

# ----------------------------------------------------------
# 0.09005 2009-06-08
# ----------------------------------------------------------
* Add parser support for MySQL default values with a single quote
* Properly quote absolute table names in the MySQL producer
* Added semi-colon for (DROP|CREATE) TYPE statements in the Pg producer (wreis)
* Added CREATE VIEW subrules for mysql parser (wreis)
* ALTER TABLE/ALTER COLUMN/DROP DEFAULT support in Pg producer (mo)
* XML parser support for multi-event triggers
* SQLite producer support for multi-event triggers
* XML parser switched from XML::XPath to XML::LibXML
* Pg producer ALTER TABLE/COLUMN and DROP DEFAULT support
* MySQL producer skips length attribute for columns which do not support that
  attribute. Currently following column types are added to that list:
  date time timestamp datetime year
* Switch to Module::Install (mandates minimum perl 5.005)
* Major cleanup of GraphViz proucer
* Massive amount of fixes to SQLite/Pg/Mysql/MSSQL parsers/producers
  Fix most of the problems uncovered by the roundtrip test framework
  Some highlights:
    - Rewind exhausted globs before attempting a read
    - Do not add xml comment header if no_comments is set
    - table/field counts are held per schema object, not globally
    - no more variable table and column names in SQLite and MSSQL
    - VIEW support for Pg parser, also some cleanups
    - The way we generate Pg create view statements was not standards compliant
      (per RhodiumToad in #postgresql)
    - Disable MSSQL view/procedure production - they never worked in the first place
    - SQLite/MSSQL improvements:
      - Support parsing of all DROP clauses
      - Support parsing of field-level comments
      - When producing do not append table names to constraint/index names

Revision 1.4 / (download) - annotate - [select for diffs], Tue Feb 24 21:46:27 2009 UTC (14 years, 9 months ago) by he
Branch: MAIN
CVS Tags: pkgsrc-2009Q1-base, pkgsrc-2009Q1
Changes since 1.3: +4 -4 lines
Diff to previous 1.3 (colored)

Update from version 0.09002 to 0.09004.

Upstream changes:

# ----------------------------------------------------------
# 0.09004 2009-02-13
# ----------------------------------------------------------
* Add support for temporary tables in Pg (nachos)
* Create Trigger support for SQLite
* GraphViz producer improvements

# ----------------------------------------------------------
# 0.09003 2009-02-07
# ----------------------------------------------------------
  <BORKED RELEASE DELETED OFF CPAN>

Revision 1.3 / (download) - annotate - [select for diffs], Sat Dec 20 16:29:50 2008 UTC (14 years, 11 months ago) by he
Branch: MAIN
CVS Tags: pkgsrc-2008Q4-base, pkgsrc-2008Q4
Changes since 1.2: +4 -4 lines
Diff to previous 1.2 (colored)

Update from version 0.09001 to 0.09002.

Pkgsrc changes:
 o Canonicalize HOMEPAGE

Upstream changes:

# ----------------------------------------------------------
# 0.09002 2008-12-05
# ----------------------------------------------------------
* parsing MySQL CURRENT_TIMESTAMP as scalar ref so it can be produced without
  quotes (jgoulah)
* Add ignore_opts parser arg (to ignore table options) in Parser::MySQL
  (jgoulah)
* Skip tests for buggy Spreadsheet::ParseExcel versions (rbo)
* Add support for skip tables parser arg in Parser::DBI::MySQL (jgoulah)
* Changed behaviour of ::Producer::Oracle when returning an array of statements
  to make it compatible to DBI->do()
* Fixed a few bugs in ::Producer::Oracle
* Applied patch from jgoulah to support mysql's MERGE option
* Applied patch from rbo to add support of multiple database events on a trigger
* Applied patch from lukes to allow drop if exists in sqlite producer, with
  version >= 3.3
* Applied patch from rjbs with minor changes, now we support scalar refs in
  default values!
* Fixed SQLite producer to end index statements in newlines, in scalar context
* Decreed that all list context statements shall not end in ; or ;\n
* Fixed SQLite, Diff and MySQL producers to agree with Decree.
* Added support for CREATE VIEW + tests in the Pg producer (wreis)
* Added support for CREATE VIEW + tests in the sqlite producer (groditi)
* Added proper argument parsing and documentation to MySQL Parser and
  Producer (ribasushi)
* Using DROP VIEW instead of OR REPLACE clause in the Pg producer, as replace
  only allows replacement with identical set of columns (wreis)
* Added support for DROP VIEW and fixed CREATE VIEW statement in the sqlite
  producer (wreis)
* Removed source_db and target_db accessors from Diff (throwback
  to old version, only output_db is used)
* Support for longer varchar fields in MySQL

Revision 1.2 / (download) - annotate - [select for diffs], Fri Oct 31 16:08:02 2008 UTC (15 years, 1 month ago) by seb
Branch: MAIN
Changes since 1.1: +4 -4 lines
Diff to previous 1.1 (colored)

Update from version 0.09000 to version 0.09001

Changes:
# ----------------------------------------------------------
# 0.09001 2008-08-19
# ----------------------------------------------------------
* Added support for CREATE VIEW + tests in the mysql producer
(groditi)
* Added support for SET fields in the mysql producer + test (groditi)
* Added support for proper booleans in the mysql producer, when a
mysql version of at least 4.x is supplied
* Added support for proper enums under pg (as of 8.3), with pg
version check, and deferrable constraints
* Added support to truncate long constraint and index names in the
mysql producer, because of a change to DBIx::Class to produce such
long names in some cases.

Revision 1.1.1.1 / (download) - annotate - [select for diffs] (vendor branch), Mon Jul 14 09:35:11 2008 UTC (15 years, 4 months ago) by abs
Branch: TNF
CVS Tags: pkgsrc-base, pkgsrc-2008Q3-base, pkgsrc-2008Q3, cube-native-xorg-base, cube-native-xorg
Changes since 1.1: +0 -0 lines
Diff to previous 1.1 (colored)

Added databases/p5-SQL-Translator version 0.09000

SQL::Translator is a group of Perl modules that converts vendor-specific
SQL table definitions into other formats, such as other vendor-specific
SQL, ER diagrams, documentation (POD and HTML), XML, and Class::DBI
classes. The main focus of SQL::Translator is SQL, but parsers
exist for other structured data formats, including Excel spreadsheets
and arbitrarily delimited text files. Through the separation of
the code into parsers and producers with an object model in between,
it's possible to combine any parser with any producer, to plug in
custom parsers or producers, or to manipulate the parsed data via
the built-in object model. Presently only the definition parts of
SQL are handled (CREATE, ALTER), not the manipulation of data
(INSERT, UPDATE, DELETE).

Revision 1.1 / (download) - annotate - [select for diffs], Mon Jul 14 09:35:11 2008 UTC (15 years, 4 months ago) by abs
Branch: MAIN

Initial revision

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.




CVSweb <webmaster@jp.NetBSD.org>