Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

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
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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1032380]
Front-paged by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (4)
As of 2014-11-01 09:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (229 votes), past polls