Skip Menu |
 

This queue is for tickets about the DBIx-DataModel CPAN distribution.

Report information
The Basics
Id: 105356
Status: open
Priority: 0/
Queue: DBIx-DataModel

People
Owner: Nobody in particular
Requestors: aireland [...] lbl.gov
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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>
Download (untitled) / with headers
text/plain 513b
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 / )
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>
Download (untitled) / with headers
text/plain 152b
Additionally, a couple of tables have columns containing a hash (#) sign; perl gives the warning "Possible attempt to put comments in qw() list at..."
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>
Download (untitled) / with headers
text/plain 338b
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.
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. > >
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>
Download (untitled) / with headers
text/plain 641b
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.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.