Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
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
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?
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 avoiding work at the Monastery: (17)
As of 2015-07-28 17:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (258 votes), past polls