Rose experts, I am a newbie and trying to grasp fundamentals. My experience with RoseDBObject has been much better than that with DBIC so far. I have got Rose working under win32, MySQL using the Loader and am performing single table queries successfully. Moving onto relationships, I seem to be struggling (and I'm not talking about girls here; they are much harder to fathom) but before I pester people further, I would be grateful for a few quickfire answers to my novice type questions:
If I define a relationship from table1 to table2, do I also need to define the reverse relationship from table2 to table1? I have changed my table names and field names to match the default conventions, in the hope that this would minimise my work. In particular I was hoping that it would mean that the Loader would be able to work out and define my relationships, even though I am on MySQL. It doesn't seem to do this. Is this because I was hopelessly optimistic or because I've done something wrong? [Actually, the more I think about this question, the more I believe that the Loader couldn't sort out many_to_many relationships but perhaps the other 3 types should be possible?] I am rather amateur when it comes to OO methodology. If I don't use Loader to define my table classes, then it appears that I have to create a whole load of .pm files, one per table. Or if I do use Loader, then I have to create a directory and an Extra.pm file for each table (for MySQL relationships). My experience with performance is miminal but in my travels, I have noticed that one of the worst things for it is opening and reading files. However, I see that some documentation examples seem to show multiple packages being defined within a single .pm module. This might just be the way the documentation is written to avoid too much clutter, though - not sure. Is it feasible to replace all those table .pm files or the Extra.pm files with a single .pm file? thanks for your help, James Masters. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
