package SQL::Translator::Parser::DBI;
# -------------------------------------------------------------------
-# $Id: DBI.pm,v 1.1 2003-10-03 00:21:41 kycl4rk Exp $
-# -------------------------------------------------------------------
-# Copyright (C) 2003 Ken Y. Clark <kclark@cpan.org>,
-# darren chamberlain <darren@cpan.org>
+# Copyright (C) 2002-2009 SQLFairy Authors
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License as
use DBI;
use SQL::Translator;
- my $dbh = DBI->connect(...);
+ my $dbh = DBI->connect('dsn', 'user', 'pass',
+ {
+ RaiseError => 1,
+ FetchHashKeyName => 'NAME_lc',
+ }
+ );
my $translator = SQL::Translator->new(
parser => 'DBI',
use SQL::Translator;
- my $translator = SQL::Translator->new(
- parser => 'DBI',
- dsn => 'dbi:mysql:FOO',
- db_user => 'guest',
- db_password => 'password',
+ my $translator = SQL::Translator->new(
+ parser => 'DBI',
+ parser_args => {
+ dsn => 'dbi:mysql:FOO',
+ db_user => 'guest',
+ db_password => 'password',
+ }
);
=head1 DESCRIPTION
This parser accepts an open database handle (or the arguments to create
-one) and queries the database directly for the information. The correct
-SQL::Translator::Parser::DBI class is determined automatically by
-inspecting $dbh->{'Driver'}{'Name'}.
+one) and queries the database directly for the information.
The following are acceptable arguments:
-=over
+=over 4
=item * dbh
-An open DBI database handle.
+An open DBI database handle. NB: Be sure to create the database with the
+"FetchHashKeyName => 'NAME_lc'" option as all the DBI parsers expect
+lowercased column names.
=item * dsn
=back
+There is no need to specify which type of database you are querying as
+this is determined automatically by inspecting $dbh->{'Driver'}{'Name'}.
+If a parser exists for your database, it will be used automatically;
+if not, the code will fail automatically (and you can write the parser
+and contribute it to the project!).
+
+Currently parsers exist for the following databases:
+
+=over 4
+
+=item * MySQL
+
+=item * SQLite
+
+=item * Sybase
+
+=item * PostgreSQL (still experimental)
+
+=back
+
+Most of these parsers are able to query the database directly for the
+structure rather than parsing a text file. For large schemas, this is
+probably orders of magnitude faster than traditional parsing (which
+uses Parse::RecDescent, an amazing module but really quite slow).
+
+Though no Oracle parser currently exists, it would be fairly easy to
+query an Oracle database directly by using DDL::Oracle to generate a
+DDL for the schema and then using the normal Oracle parser on this.
+Perhaps future versions of SQL::Translator will include the ability to
+query Oracle directly and skip the parsing of a text file, too.
+
=cut
# -------------------------------------------------------------------
use strict;
use DBI;
use vars qw($VERSION @EXPORT);
-$VERSION = sprintf "%d.%02d", q$Revision: 1.1 $ =~ /(\d+)\.(\d+)/;
+$VERSION = '1.99';
use constant DRIVERS => {
- sqlite => 'SQLite',
+ mysql => 'MySQL',
+ odbc => 'SQLServer',
+ oracle => 'Oracle',
+ pg => 'PostgreSQL',
+ sqlite => 'SQLite',
+ sybase => 'Sybase',
+ pg => 'PostgreSQL',
+ db2 => 'DB2',
};
use Exporter;
-use SQL::Translator::Utils qw(debug normalize_name);
-use SQL::Translator::Parser::DBI::SQLite;
+
+use SQL::Translator::Utils qw(debug);
use base qw(Exporter);
@EXPORT = qw(parse);
sub parse {
my ( $tr, $data ) = @_;
- $tr->debug( "in DBI\n" );
my $args = $tr->parser_args;
my $dbh = $args->{'dbh'};
my $dsn = $args->{'dsn'};
unless ( $dbh ) {
die 'No DSN' unless $dsn;
- $dbh = DBI->connect( $dsn, $db_user, $db_password, {RaiseError=>1} );
+ $dbh = DBI->connect( $dsn, $db_user, $db_password,
+ {
+ FetchHashKeyName => 'NAME_lc',
+ LongReadLen => 3000,
+ LongTruncOk => 1,
+ RaiseError => 1,
+ }
+ );
}
die 'No database handle' unless defined $dbh;
my $pkg = "SQL::Translator::Parser::DBI::$driver";
my $sub = $pkg.'::parse';
- $tr->debug( "Calling sub '$sub'\n" );
-
-# $tr->load( $pkg );
+ $tr->load( $pkg );
- {
+ eval {
no strict 'refs';
&{ $sub }( $tr, $dbh ) or die "No result from $pkg";
- }
+ };
+
+ $dbh->disconnect if defined $dbh;
+
+ die $@ if $@;
return 1;
}
=head1 SEE ALSO
-DBI.
+DBI, SQL::Translator.
=cut