X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FSchema%2FLoader%2FDBI.pm;h=e584e6d0b5b8d5c80fe7b9ebe742c6fc2a192c43;hb=b21abfcafc1430332b93a75843905c895a64bb78;hp=c0042cffd088f5a87d8fdfb988ed1acc91eacc8a;hpb=ccf9b8a69b4aedbaee445d2240bfbf6e9b061016;p=dbsrgits%2FDBIx-Class-Schema-Loader.git diff --git a/lib/DBIx/Class/Schema/Loader/DBI.pm b/lib/DBIx/Class/Schema/Loader/DBI.pm index c0042cf..e584e6d 100644 --- a/lib/DBIx/Class/Schema/Loader/DBI.pm +++ b/lib/DBIx/Class/Schema/Loader/DBI.pm @@ -324,11 +324,12 @@ sub _table_uniq_info { sub _table_comment { my ($self, $table) = @_; - my $comments_table = $self->table_comments_table; + my $comments_table = $table->clone; + $comments_table->name($self->table_comments_table); my ($comment) = try { $self->dbh->selectrow_array(<<"EOF") }; SELECT comment_text -FROM $comments_table +FROM @{[ $comments_table->sql_name ]} WHERE table_name = @{[ $self->dbh->quote($table->name) ]} EOF @@ -336,13 +337,14 @@ EOF } sub _column_comment { - my ($self, $table, $column_counter, $column_name) = @_; + my ($self, $table, $column_number, $column_name) = @_; - my $comments_table = $self->column_comments_table; + my $comments_table = $table->clone; + $comments_table->name($self->column_comments_table); my ($comment) = try { $self->dbh->selectrow_array(<<"EOF") }; SELECT comment_text -FROM $comments_table +FROM @{[ $comments_table->sql_name ]} WHERE table_name = @{[ $self->dbh->quote($table->name) ]} AND column_name = @{[ $self->dbh->quote($column_name) ]} EOF