http://www.perlmonks.org?node_id=1032380

jaylaw64 has asked for the wisdom of the Perl Monks concerning the following question:

We have a bug tracking system that uses an Oracle database as the backend server. The DB admin has exported two views of the data. There are read-only, so we can do SQL queries. To modify the database we have to go through GUI or command line tools so that no one disturbs the database.

I'm working on a Catalyst app where I would like to suck the field definitions out of this view, just as if it were a table. Just one big flat definition. I have my own database where I'll store relationships to these items by their primary key which is an integer.

Is there a way to get DBIX::Class::Loader / make_schema_at to generate the definition of this? I would be using it as a Catalyst Result class.

  • Comment on Using DBIX::Class::Schema::Loader on an Oracle View

Replies are listed 'Best First'.
Re: Using DBIX::Class::Schema::Loader on an Oracle View
by Anonymous Monk on May 07, 2013 at 00:34 UTC
    What happened when you tried?   Show us a small code-snippet ...