Bug 202099

Summary:	dev-perl/SQL-Translator (New Package)
Product:	Gentoo Linux	Reporter:	Alex J. Ivasyuv <siegerstein>
Component:	New packages	Assignee:	Gentoo Linux bug wranglers <bug-wranglers>
Status:	RESOLVED NEEDINFO
Severity:	enhancement	Keywords:	EBUILD
Priority:	High
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---
Attachments:	SQL-Translator-0.0899.ebuild ( devel ) SQL-Translator-0.08001.ebuild ( stable )

Description Alex J. Ivasyuv 2007-12-13 00:22:26 UTC

http://sqlfairy.sourceforge.net
http://search.cpan.org/dist/SQL-Translator

SQL::Translator is a group of Perl modules that manipulate structured data definitions (mostly database schemas) in interesting ways, such as converting among different dialects of CREATE syntax (e.g., MySQL-to-Oracle), visualizations of schemas (pseudo-ER diagrams: GraphViz or GD), automatic code generation (using Class::DBI), converting non-RDBMS files to SQL schemas (xSV text files, Excel spreadsheets), serializing parsed schemas (via Storable, YAML and XML), creating documentation (HTML and POD), and more. New to version 0.03 is the ability to talk directly to a database through DBI to query for the structures of several databases.

For example, I use it to convert database from MySQL to PostgreSQL:

$ sqlt -f MySQL -t PostgreSQL books.sql > books-pg.sql

Attached two ebuild's: stable and develop

Require dev-per/Class-Base (New Package)

Comment 1 Alex J. Ivasyuv 2007-12-13 00:23:10 UTC

Created attachment 138373 [details]
SQL-Translator-0.0899.ebuild ( devel )

Comment 2 Alex J. Ivasyuv 2007-12-13 00:23:41 UTC

Created attachment 138374 [details]
SQL-Translator-0.08001.ebuild ( stable )

Comment 3 Jakub Moc (RETIRED) gentoo-dev

2007-12-13 05:39:17 UTC

Please review the following and explain why is this ebuild needed; thanks.

http://www.gentoo.org/proj/en/devrel/handbook/handbook.xml?part=3&chap=1#doc_chap2