This is very true chris. Our files and columns are very smart, except very very hard to read. Im getting better at it though, but an alias would be nice.
Except I just realized what I am sure must be a very big barrier. In a lot of our files, we are not using autoincrementing primary keys. Some files have an integer primary key, but some dont have one at all. Anyone know how this would work with reactor? Regardless, I know we will be able to use it for some of our new systems (ones that dont have to integrate) and for our mysql systems, but using this over existing files would be pretty difficult im afraid. Any thoughts? On 3/14/06, Chris Blackwell <[EMAIL PROTECTED]> wrote: > And even if there are no relationships you can simply define it in > you're reactor.xml file and give it an alias, which sounds like it will > be perfect given your table naming convention > > <object name="xy_tblSomething" alias="Something"/> > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan > Guill > Sent: 14 March 2006 16:36 > To: [email protected] > Subject: Re: [Reactor For CF] What does it take to support a new > database? > > Ah, okay, that makes a lot of sense. And now that you mention it, i > remember reading that it does lazy-load. Also, i couldnt find any > code anywhere that was looping or pulling the different tables, so > that makes a whole lot of sense. > > So, it doesnt have to be in your reactor.xml file if it doesnt have a > relationship, you just ask for it by name and it will create the > objects necessary. > > Perfect really... > > On 3/14/06, Daniel Short <[EMAIL PROTECTED]> wrote: > > Hi Ryan, > > > > I believe that (and I may be mistaken) Reactor only creates objects as > > they're requested. So the first time you request an a gateway for > > tablelUser, you get all of it's objects. If you never request a > gateway for > > tableFooBar, then the objects don't get created. > > > > Someone *please* correct me if I'm wrong on that one :) > > > > Dan > > > > > Yes, I saw way too much good stuff ;) > > > > > > Question: Is there any way to tell reactor specifically > > > which tables to pull in? In as/400 land, our databases are > > > essentally libraries, and for instance our production library > > > has thousands of tables, which I would not want to pull in an > > > object for all of them. Unfortunately, because we are > > > integrating and sharing data with other rpg programs that > > > live on the box, there is no way to segregate things in the > > > libraries. We do have a two charachter prefix on all of the > > > tables of a particular system though, so if we could do > > > something with that, that would work too. > > > > > > > > > > > > -- Reactor for ColdFusion Mailing List -- [email protected] > > -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ > > > > > > > > > -- > Ryan Guill > A Deep Blue > [EMAIL PROTECTED] > www.ryanguill.com > (270) 217.2399 > got google talk? Chat me at [EMAIL PROTECTED] > > The Coldfusion Open Application Library - COAL - > http://coal.ryanguill.com > > Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/ > > www.ryanguill.com/ > The Roman Empire: www.ryanguill.com/blog/ > > > > -- Reactor for ColdFusion Mailing List -- [email protected] > -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ > > > > > > > > > -- Reactor for ColdFusion Mailing List -- [email protected] > -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ > > > -- Ryan Guill A Deep Blue [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/ www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
