Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re^4: DBIx::Class questions

by castaway (Parson)
on Oct 13, 2006 at 08:38 UTC ( #578084=note: print w/ replies, xml ) Need Help??


in reply to Re^3: DBIx::Class questions
in thread DBIx::Class questions

Yes, you should create a DBIx::Class file for each table, including the ones used to just link across, for a many-to-many (Funnily enough, theres a bridge method that creates many-to-many rels for you).

How are the system/role/user tables actually set up? Given a "system", using SQL, how do you find the point_of_contact? That might be the easiest way of translating it to DBIx::Class.

As for the elements, I don't know how they look like in the database either, can you maybe just post your create table statements, and we can go on from there?

C.


Comment on Re^4: DBIx::Class questions
Re^5: DBIx::Class questions
by jimbus (Friar) on Oct 13, 2006 at 12:33 UTC

    Unfortunately, I've invested more than a week into catalyst and trying to learn DBIx and have little to show for it. I'm at the point where I need to admit defeat and go with what I know... building psuedo-objects in my business logic layer and building my own plain, dirty sql tables and displaying with mod_perl and mason... at least I've progressed to the point that I know longer have my business logic wrapped up in my view code. :)

    Perhaps I'll try again later with something not so large and see if I can revisit this again later... but those sound like famous last words :(


    --Jimbus aka Jim Babcock
    Wireless Data Engineer and Geek Wannabe
    jim-dot-babcock-at-usa-dot-com

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://578084]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (16)
As of 2014-12-18 10:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (49 votes), past polls