search

dbsrgits / dbix-class-schema-loader

Official GitHub remote for git.shadowcat.co.uk DBIx-Class-Schema-Loader.git
http://dbix-class.org/
11 stars 34 forks source link

DBIx::Class::Schema::Loader::DBI::DB2 Class // Getting relationship fail [rt.cpan.org #100287] #34

Open rabbiveesh opened 1 year ago

rabbiveesh commented 1 year ago

Migrated from rt.cpan.org#100287 (status was 'new')

Requestors:

From frank.biermann@gad.de on 2014-11-12 12:01:49 :

Hello Support Team,

I would like to make the following proposal.

In the function _table_fk_info we should select the fields with rtrim. 
Some schema have subsequent blanks and later on key values do not exist in 
the object hashref.

=> Searching for relationship will fail.

SELECT tc.constname, sr.reftabschema, sr.reftabname,
       kcu.colname, rkcu.colname, kcu.colseq,
       sr.deleterule, sr.updaterule

to

SELECT tc.constname, rtrim(sr.reftabschema), sr.reftabname,
       kcu.colname, rkcu.colname, kcu.colseq,
       sr.deleterule, sr.updaterule

Kind regards

Frank Biermann