summaryrefslogtreecommitdiff
path: root/databases/p5-SQL-Translator
AgeCommit message (Collapse)AuthorFilesLines
2008-12-20Update from version 0.09001 to 0.09002.he2-8/+7
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
2008-10-31Update from version 0.09000 to version 0.09001seb2-9/+10
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.
2008-10-19Bump the PKGREVISION for all packages which depend directly on perl,he1-1/+2
to trigger/signal a rebuild for the transition 5.8.8 -> 5.10.0. The list of packages is computed by finding all packages which end up having either of PERL5_USE_PACKLIST, BUILDLINK_API_DEPENDS.perl, or PERL5_PACKLIST defined in their make setup (tested via "make show-vars VARNAMES=...").
2008-07-14Added databases/p5-SQL-Translator version 0.09000abs3-0/+49
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).