X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FLoader%2Fmysql.pm;fp=lib%2FDBIx%2FClass%2FLoader%2Fmysql.pm;h=23e90f82885240aace2e4e9432d706c41d1ae1ed;hb=4a79bee13f3be3b58491cbfc4e95245cdc49688c;hp=0000000000000000000000000000000000000000;hpb=a78e3fed4e27d4e1b447ed425c14d82426e53e19;p=dbsrgits%2FDBIx-Class-Schema-Loader.git

diff --git a/lib/DBIx/Class/Loader/mysql.pm b/lib/DBIx/Class/Loader/mysql.pm
new file mode 100644
index 0000000..23e90f8
--- /dev/null
+++ b/lib/DBIx/Class/Loader/mysql.pm
@@ -0,0 +1,111 @@
+package DBIx::Class::Loader::mysql;
+
+use strict;
+use base 'DBIx::Class::Loader::Generic';
+use DBI;
+use Carp;
+
+=head1 NAME
+
+DBIx::Class::Loader::mysql - DBIx::Class::Loader mysql Implementation.
+
+=head1 SYNOPSIS
+
+  use DBIx::Class::Loader;
+
+  # $loader is a DBIx::Class::Loader::mysql
+  my $loader = DBIx::Class::Loader->new(
+    dsn       => "dbi:mysql:dbname",
+    user      => "root",
+    password  => "",
+    namespace => "Data",
+  );
+  my $class = $loader->find_class('film'); # $class => Data::Film
+  my $obj = $class->retrieve(1);
+
+=head1 DESCRIPTION
+
+See L<DBIx::Class::Loader>.
+
+=cut
+
+sub _db_classes {
+    return qw/DBIx::Class::PK::Auto::MySQL/;
+}
+
+# Very experimental and untested!
+sub _relationships {
+    my $self   = shift;
+    my @tables = $self->tables;
+    my $dbh    = $self->find_class( $tables[0] )->storage->dbh;
+    my $dsn    = $self->{_datasource}[0];
+    my %conn   =
+      $dsn =~ m/\Adbi:\w+(?:\(.*?\))?:(.+)\z/i
+      && index( $1, '=' ) >= 0
+      ? split( /[=;]/, $1 )
+      : ( database => $1 );
+    my $dbname = $conn{database} || $conn{dbname} || $conn{db};
+    die("Can't figure out the table name automatically.") if !$dbname;
+
+    foreach my $table (@tables) {
+        my $query = "SHOW CREATE TABLE ${dbname}.${table}";
+        my $sth   = $dbh->prepare($query)
+          or die("Cannot get table definition: $table");
+        $sth->execute;
+        my $table_def = $sth->fetchrow_arrayref->[1] || '';
+        
+        my (@cols) = ($table_def =~ /CONSTRAINT `.*` FOREIGN KEY \(`(.*)`\) REFERENCES `(.*)` \(`(.*)`\)/g);
+
+        while (scalar @cols > 0) {
+            my $column = shift @cols;
+            my $remote_table = shift @cols;
+            my $remote_column = shift @cols;
+            
+            eval { $self->_belongs_to_many( $table, $column, $remote_table, $remote_column) };
+            warn qq/\# belongs_to_many failed "$@"\n\n/ if $@ && $self->debug;
+        }
+        
+        $sth->finish;
+    }
+}
+
+sub _tables {
+    my $self = shift;
+    my $dbh = DBI->connect( @{ $self->{_datasource} } ) or croak($DBI::errstr);
+    my @tables;
+    foreach my $table ( $dbh->tables ) {
+        my $quoter = $dbh->get_info(29);
+        $table =~ s/$quoter//g if ($quoter);
+        push @tables, $1
+          if $table =~ /\A(\w+)\z/;
+    }
+    $dbh->disconnect;
+    return @tables;
+}
+
+sub _table_info {
+    my ( $self, $table ) = @_;
+    my $dbh = DBI->connect( @{ $self->{_datasource} } ) or croak($DBI::errstr);
+
+    # MySQL 4.x doesn't support quoted tables
+    my $query = "DESCRIBE $table";
+    my $sth = $dbh->prepare($query) or die("Cannot get table status: $table");
+    $sth->execute;
+    my ( @cols, @pri );
+    while ( my $hash = $sth->fetchrow_hashref ) {
+        my ($col) = $hash->{Field} =~ /(\w+)/;
+        push @cols, $col;
+        push @pri, $col if $hash->{Key} eq "PRI";
+    }
+
+    $dbh->disconnect;
+    return ( \@cols, \@pri );
+}
+
+=head1 SEE ALSO
+
+L<DBIx::Class::Loader>
+
+=cut
+
+1;