Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

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

by jaylaw64 (Novice)
on May 06, 2013 at 19:16 UTC ( #1032380=perlquestion: print w/replies, xml ) Need Help??
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 ...

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1032380]
Front-paged by Corion
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (5)
As of 2018-02-22 21:16 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (299 votes). Check out past polls.