Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 202099 - dev-perl/SQL-Translator (New Package)
Summary: dev-perl/SQL-Translator (New Package)
Status: RESOLVED NEEDINFO
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High enhancement (vote)
Assignee: Gentoo Linux bug wranglers
URL:
Whiteboard:
Keywords: EBUILD
Depends on:
Blocks:
 
Reported: 2007-12-13 00:22 UTC by Alex J. Ivasyuv
Modified: 2007-12-13 05:39 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments
SQL-Translator-0.0899.ebuild ( devel ) (SQL-Translator-0.0899.ebuild,573 bytes, text/plain)
2007-12-13 00:23 UTC, Alex J. Ivasyuv
Details
SQL-Translator-0.08001.ebuild ( stable ) (SQL-Translator-0.08001.ebuild,564 bytes, text/plain)
2007-12-13 00:23 UTC, Alex J. Ivasyuv
Details

Note You need to log in before you can comment on or make changes to this bug.
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