Bug #105356 for DBIx-DataModel: Repeated table names in autogenerated schema

Thu Jun 18 19:32:09 2015 aireland [...] lbl.gov - Ticket created

Subject:	Repeated table names in autogenerated schema
Date:	Thu, 18 Jun 2015 16:20:36 -0700
To:	bug-DBIx-DataModel [...] rt.cpan.org
From:	Amelia Ireland <aireland [...] lbl.gov>

perl v5.16, DBIx::DataModel 2.46, Oracle DB via latest DBD::Oracle driver I've run DBIx::DataModel::Schema::Generator on a large Oracle database. Trying to use this schema resulting errors of the form: Error: won't overwrite @My::Schema::TableName::ISA as there are a number of repeated table names in the schema generated. I also got errors in the schema due to '/' characters in the table names, which conflict with the qw/ ... / used in the declaration: Table( qw/ classname tablename pk / )

Fri Jun 19 13:34:35 2015 aireland [...] lbl.gov - Correspondence added

Subject:	Re: [rt.cpan.org #105356] AutoReply: Repeated table names in autogenerated schema
Date:	Fri, 19 Jun 2015 10:33:50 -0700
To:	bug-DBIx-DataModel [...] rt.cpan.org
From:	Amelia Ireland <aireland [...] lbl.gov>

Additionally, a couple of tables have columns containing a hash (#) sign; perl gives the warning "Possible attempt to put comments in qw() list at..."

Fri Jun 19 16:00:01 2015 laurent.dami [...] free.fr - Correspondence added

Subject:	Re: [rt.cpan.org #105356] Repeated table names in autogenerated schema
Date:	Fri, 19 Jun 2015 21:59:47 +0200
To:	bug-DBIx-DataModel [...] rt.cpan.org
From:	Laurent Dami <laurent.dami [...] free.fr>

Le 19.06.2015 01:32, Amelia Ireland via RT a écrit : Show quoted text

> as there are a number of repeated table names in the schema generated. >

Thanks for the bug report. I don't understand how you can have repeated table names in the same Oracle schema. Can you please give some examples (showing table declarations) ? Thanks in advance, Laurent D.

Fri Jun 19 16:00:01 2015 The RT System itself - Status changed from 'new' to 'open'

Fri Jun 19 16:56:35 2015 aireland [...] lbl.gov - Correspondence added

Subject:	Re: [rt.cpan.org #105356] Repeated table names in autogenerated schema
Date:	Fri, 19 Jun 2015 13:56:03 -0700
To:	bug-DBIx-DataModel [...] rt.cpan.org
From:	Amelia Ireland <aireland [...] lbl.gov>

Unfortunately I am not at all familiar with the DB schema (and no documentation exists on it), and it's a massive, complicated database, which makes it more difficult to work with. Does DBIx::DataModel take into account links to other databases ( http://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN12083 )? If it is helpful, I can mail you the schema autogenerated by DBIx::Class and that generated by DBIx::DataModel for comparison. Unfortunately trying to convert the DBIx::Class schema into a DBIx::DM schema also failed... Thanks! On 19 June 2015 at 13:00, laurent.dami@free.fr via RT < bug-DBIx-DataModel@rt.cpan.org> wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=105356 > > > Le 19.06.2015 01:32, Amelia Ireland via RT a écrit :

> > as there are a number of repeated table names in the schema generated. > >

> Thanks for the bug report. > > I don't understand how you can have repeated table names in the same > Oracle schema. > Can you please give some examples (showing table declarations) ? > Thanks in advance, Laurent D. > >

Fri Jun 19 23:08:10 2015 laurent.dami [...] free.fr - Correspondence added

Subject:	Re: [rt.cpan.org #105356] Repeated table names in autogenerated schema
Date:	Sat, 20 Jun 2015 05:07:44 +0200
To:	bug-DBIx-DataModel [...] rt.cpan.org
From:	Laurent Dami <laurent.dami [...] free.fr>

Le 19.06.2015 22:56, Amelia Ireland via RT a écrit : Show quoted text

> Does DBIx::DataModel take into > account links to other databases ( > http://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN12083 > )?

Nothing is explicitly programmed to deal with database links; maybe it could just work out of the box, especially if local synonyms to remote DB objects are defined, but I have no experience at all with database links and cannot measure what is at stake. Show quoted text

> If it is helpful, I can mail you the schema autogenerated by DBIx::Class > and that generated by DBIx::DataModel for comparison.

Yes, that would help, please do.