don't set result_namespace if it's 'Result'

[dbsrgits/DBIx-Class-Schema-Loader.git] / lib / DBIx / Class / Schema / Loader / DBI / MSSQL.pm

diff --git a/lib/DBIx/Class/Schema/Loader/DBI/MSSQL.pm b/lib/DBIx/Class/Schema/Loader/DBI/MSSQL.pm
index 10af9bd..71d49d4 100644 (file)
--- a/lib/DBIx/Class/Schema/Loader/DBI/MSSQL.pm
+++ b/lib/DBIx/Class/Schema/Loader/DBI/MSSQL.pm
@@ -6,7 +6,11 @@ use base 'DBIx::Class::Schema::Loader::DBI::Sybase::Common';
 use Carp::Clan qw/^DBIx::Class/;
 use Class::C3;
 
-our $VERSION = '0.05003';
+__PACKAGE__->mk_group_accessors('simple', qw/
+    case_sensitive_collation
+/);
+
+our $VERSION = '0.06000';
 
 =head1 NAME
 
@@ -25,6 +29,36 @@ usage information.
 
 =cut
 
+sub _is_case_sensitive {
+    my $self = shift;
+
+    return $self->case_sensitive_collation ? 1 : 0;
+}
+
+sub _setup {
+    my $self = shift;
+
+    $self->next::method;
+
+    my $dbh = $self->schema->storage->dbh;
+
+    my ($collation_name) = $dbh->selectrow_array(<<'EOS');
+SELECT collation_name
+FROM sys.databases
+WHERE name = DB_NAME()
+EOS
+
+    my ($sensitivity) = $collation_name =~ /(C\w)_[A-z]+\z/;
+
+    $self->case_sensitive_collation($sensitivity eq 'CS' ? 1 : 0);
+}
+
+sub _lc {
+    my ($self, $name) = @_;
+
+    return $self->case_sensitive_collation ? $name : lc($name);
+}
+
 sub _tables_list {
     my ($self, $opts) = @_;
 
@@ -32,9 +66,9 @@ sub _tables_list {
     my $sth = $dbh->prepare(<<'EOF');
 SELECT t.table_name
 FROM information_schema.tables t
-WHERE t.table_schema = ?
+WHERE lower(t.table_schema) = ?
 EOF
-    $sth->execute($self->db_schema);
+    $sth->execute(lc $self->db_schema);
 
     my @tables = map @$_, @{ $sth->fetchall_arrayref };
 
@@ -50,7 +84,7 @@ sub _table_pk_info {
     my @keydata;
 
     while (my $row = $sth->fetchrow_hashref) {
-        push @keydata, lc $row->{COLUMN_NAME};
+        push @keydata, $self->_lc($row->{COLUMN_NAME});
     }
 
     return \@keydata;
@@ -59,15 +93,17 @@ sub _table_pk_info {
 sub _table_fk_info {
     my ($self, $table) = @_;
 
-    my ($local_cols, $remote_cols, $remote_table, @rels);
+    my ($local_cols, $remote_cols, $remote_table, @rels, $sth);
     my $dbh = $self->schema->storage->dbh;
-    my $sth = $dbh->prepare(qq{sp_fkeys \@FKTABLE_NAME = '$table'});
-    $sth->execute;
+    eval {
+        $sth = $dbh->prepare(qq{sp_fkeys \@fktable_name = '$table'});
+        $sth->execute;
+    };
 
-    while (my $row = $sth->fetchrow_hashref) {
+    while (my $row = eval { $sth->fetchrow_hashref }) {
         my $fk = $row->{FK_NAME};
-        push @{$local_cols->{$fk}}, lc $row->{FKCOLUMN_NAME};
-        push @{$remote_cols->{$fk}}, lc $row->{PKCOLUMN_NAME};
+        push @{$local_cols->{$fk}}, $self->_lc($row->{FKCOLUMN_NAME});
+        push @{$remote_cols->{$fk}}, $self->_lc($row->{PKCOLUMN_NAME});
         $remote_table->{$fk} = $row->{PKTABLE_NAME};
     }
 
@@ -99,7 +135,7 @@ wHERE lower(ccu.table_name) = @{[ $dbh->quote(lc $table) ]} AND constraint_type
     my $constraints;
     while (my $row = $sth->fetchrow_hashref) {
         my $name = $row->{constraint_name};
-        my $col  = lc $row->{column_name};
+        my $col  = $self->_lc($row->{column_name});
         push @{$constraints->{$name}}, $col;
     }