Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

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?


Comment on Re^4: DBIx::Class questions
Replies are listed 'Best First'.
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

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2016-05-26 23:08 GMT
Find Nodes?
    Voting Booth?