--- /dev/null
+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;