use strict;
use warnings;
use base 'DBIx::Class::Schema::Loader::DBI';
-use Carp::Clan qw/^DBIx::Class::Schema::Loader/;
+use Carp::Clan qw/^DBIx::Class/;
use Class::C3;
+our $VERSION = '0.04999_11';
+
=head1 NAME
DBIx::Class::Schema::Loader::DBI::mysql - DBIx::Class::Schema::Loader::DBI mysql Implementation.
package My::Schema;
use base qw/DBIx::Class::Schema::Loader/;
- __PACKAGE__->load_from_connection(
- relationships => 1,
- );
+ __PACKAGE__->loader_options( debug => 1 );
1;
=cut
+# had to override here because MySQL apparently
+# doesn't support '%' syntax. Perhaps the other
+# drivers support this syntax also, but I didn't
+# want to risk breaking some esoteric DBD::foo version
+# in a maint release...
+sub _tables_list {
+ my $self = shift;
+
+ my $dbh = $self->schema->storage->dbh;
+ my @tables = $dbh->tables(undef, $self->db_schema, undef, undef);
+ s/\Q$self->{_quoter}\E//g for @tables;
+ s/^.*\Q$self->{_namesep}\E// for @tables;
+
+ return @tables;
+}
+
sub _table_fk_info {
my ($self, $table) = @_;
my $dbh = $self->schema->storage->dbh;
- my $table_def_ref = $dbh->selectrow_arrayref("SHOW CREATE TABLE $table")
+ my $table_def_ref = $dbh->selectrow_arrayref("SHOW CREATE TABLE `$table`")
or croak ("Cannot get table definition for $table");
my $table_def = $table_def_ref->[1] || '';
if(!exists($self->{_cache}->{_mysql_keys}->{$table})) {
my %keydata;
my $dbh = $self->schema->storage->dbh;
- my $sth = $dbh->prepare("SHOW INDEX FROM $table");
+ my $sth = $dbh->prepare("SHOW INDEX FROM `$table`");
$sth->execute;
while(my $row = $sth->fetchrow_hashref) {
next if $row->{Non_unique};
my @uniqs;
my $keydata = $self->_mysql_table_get_keys($table);
- foreach my $keyname (%$keydata) {
+ foreach my $keyname (keys %$keydata) {
next if $keyname eq 'PRIMARY';
push(@uniqs, [ $keyname => $keydata->{$keyname} ]);
}
return \@uniqs;
}
+sub _extra_column_info {
+ no warnings 'uninitialized';
+ my ($self, $info) = @_;
+ my %extra_info;
+
+ if ($info->{mysql_is_auto_increment}) {
+ $extra_info{is_auto_increment} = 1
+ }
+ if ($info->{mysql_type_name} =~ /\bunsigned\b/i) {
+ $extra_info{extra}{unsigned} = 1;
+ }
+ if ($info->{mysql_values}) {
+ $extra_info{extra}{list} = $info->{mysql_values};
+ }
+# XXX we need to distinguish between DEFAULT CURRENT_TIMESTAMP and DEFAULT 'foo'
+# somehow, but DBI column_info doesn't preserve quotes.
+ if ($info->{COLUMN_DEF} =~ /^CURRENT_TIMESTAMP\z/i) {
+ $extra_info{default_value} = \'CURRENT_TIMESTAMP';
+ }
+
+ return \%extra_info;
+}
+
=head1 SEE ALSO
L<DBIx::Class::Schema::Loader>, L<DBIx::Class::Schema::Loader::Base>,
L<DBIx::Class::Schema::Loader::DBI>
+=head1 AUTHOR
+
+See L<DBIx::Class::Schema::Loader/CONTRIBUTORS>.
+
+=head1 LICENSE
+
+This library is free software; you can redistribute it and/or modify it under
+the same terms as Perl itself.
+
=cut
1;