On 6/9/06, Michael Traher <[EMAIL PROTECTED]> wrote: > > I'm wondering if there is a CRUD generator out there that is more > lightweight than say Reactor or PLUM?
Ok, last post for me for a bit, really: I've seen a couple of "DAO" generators, but I'm nut sure if that's what you mean. I think so tho... lemmme check delicious... umm.. old, but maybe this: *http://tinyurl.com/gxrzy *Here's what I do, and comments are welcome. Probably lots of folks do it this way too (or did in the past, more likely ;). I pass a structure of fields, that match DB columns, and a table name to a function that does a "DESCRIBE #table#". It loops through the fields, using the data returned from the DB, so I know if nulls are acceptable, if it's a varchar or a numeric, how long is the max, etc., all maintained in the db), then I cfparam it all up in a query and execute. Now I know it's not very good for tons of inserts and updates (although it's been fast enough when I've tried it), but how do people feel about this method? If anyone feels anything at all. I bet you could use an existing thing like Plumb to build DAO and just use the DAO, instead of all the nifty Plumb features, but I don't know. Is a DAO "better" than the aformentioned function? I would think on enterprise stuff, probably, as good ones do nifty cache stuff and whatnot... It's been so easy using my function, (basically a custom cfinsert tag), I haven't bothered to look into DAO too much. Webservices are sounding interesting tho, as they're not CF-centric, neh?... Hrm... Well, enough nonsense, I gotta get ready to cook some hot-dogs. Mmmm... hot dogs... (also my first wysiwyg web page editor, IIRC..) :D What I'm thinking would be useful is something that would generate a basic > form and a CFC with CRUD methods for table. No XML config, no setters and > getters just pass the form as an argument collection. > > After the basic code was generated you would and most likely would want to > change it, but a lot of tedious typing would be done. > > I have googled for a while, but just wondered if anyone knows of a tool > like > this? > > -- > Mike T > Blog http://www.socialpoints.com/ > This e-mail may contain privileged and confidential information and/or > copyright material and is intended for the use of the addressee only. If > you > receive this e-mail by mistake please advise the sender immediately by > using > the reply facility in your e-mail software and delete this e-mail from > your > computer system. You may not deliver, copy or disclose its contents to > anyone else. Any unauthorised use may be unlawful. Any views expressed in > this e-mail are those of the individual sender and may not necessarily > reflect the views of The Collinson Group Ltd and/or its subsidiaries. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243123 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
