Tom, I've checked out cfcPowerTools. It is very good code, but it's not what I'm looking for. I want the database change to be recognized automatically. I don't want to have to fire up a generator that will regenerate cfc code and possible overwrite mods that I've done to it. Bill's right, I want Ruby on Rails for CF. :)
On 8/18/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > You should check out cfcPowerTools. cfcPowerTools is a web based interface > to your CFCs. With cfcPowerTools you can do the following: > > > > Generate a CFC from database table > Generate a database table from a CFC > Batch generate CFCs from multiple database tables > Generate Data Access Object (DAO) – a CFC that handles all database > interactions > Generate data entry form (right now just HTML form, I'm working on XML and > Flash forms) > Generate XML support document that maintains all additional meta data > Graphical interface to your CFC Library – a tree view of all of you CFCs > organized by package > Automatic getter/setter creation for each property > Create concrete CFCs > Create relationships between CFCs (relationship is also reflected in > database backend) > Supports round trip editing – you can toggle between manual modifications > and cfcPowerTools without loosing code > Automatically creates .bak file of your CFC before applying any > modifications to CFC > Interface with CFCs stored on multiple ColdFusion servers (either CF 6.1 or > 7) > > > > cfcPowerTools makes you more productive. Literally in a matter of minutes > you can have fully functional CFC, DAO, data entry form, and a database > table. > > Use the batch CFC generation functionality and you can convert multiple > database tables into functional CFCs in minutes! cfcPowerTools produces > consistent, predictable, and reliable code. > > > > Revisions to your database layer and subsequent DAO layer can be handled by > cfcPowerTools. > > > > cfcPowerTools is available at www.cfcpowertools.com. You can download > cfcPowerTools for a 30 day trial. > > > > Thanks > > > > Tom Schreck > > > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Marlon Moyer > Sent: Thursday, August 18, 2005 10:35 AM > To: [email protected] > Subject: [CFCDev] Better way than dao, gateway, bean > > > > > I've been using dao's, gateways, & beans for several months now. > > Initially it seemed like a very good solution to separating out code > > and it seemed like maintenance would be easier. Nowadays I'm not so > > sure that this is the case. Recently I had a project where I was > > creating a pdf form report. I had 4 revisions brought to me where > > extra fields were requested. The work flow went something like this: > > > > 1. Add/change fields in database > > 2. Add/change fields in bean (getter/setters, initialization code, > > validation code) > > 3. Add/change fields in gateway (selects) > > 4. Add/change fields in dao (select,insert, update) > > 5. Add/change fields in manager object that supplied the fields to the > > fdf generator. > > > > X 4 > > > > > > The amount of maintenance work hasn't diminished at all. It's > > increased! Recently I've been playing around with a bean creator made > > by Francis Scott. It queries the database for the table structure and > > will automagically create the DAO, gateway, and an input form. It > > works great, and you can easily use these as a base to create the rest > > of your needed code. Obviously, you'll need to create more specific > > functions in the gateway and input forms. What I was pondering was > > how to make this automatic. How could I create a cfc that, given a > > datasource and a table name, would automagically create a structure > > for that table, dynamically create the crud methods and simple gateway > > methods. You'd then extend this cfc to add additional functionality. > > The downside I see to this is that you'll be relying on loops inside > > queries to save all of the data. But the upside is that table changes > > would be immediately recognized once you reinstatiate your cfc. > > > > Also, I'm starting to lean more towards a TO vs a bean. Validation > > inside the bean seems clunky. Form data comes as a struct. Why not > > process it as a struct. A separate validation CFC seems to be a > > better fit. Again, this could extend another base cfc that would > > automatically understand basic database validations such as max length > > of varchar, valid numeric values for numeric type fields, nullable > > fields. Then on top of this, you could add your own business logic > > type of validations. > > > > Enough rambling for now. I think I'll try putting this together. > > > > Marlon > > > > > > > > -- > > Marlon > > > > "A mulatto, an albino, a mosquito, my libido" > > > > > > ---------------------------------------------------------- > > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject of the > email. > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > > > CFCDev is supported by New Atlanta, makers of BlueDragon > > http://www.newatlanta.com/products/bluedragon/index.cfm > > > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > > > > ---------------------------------------------------------- > > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject of the > email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > CFCDev is supported by New Atlanta, makers of BlueDragon > http://www.newatlanta.com/products/bluedragon/index.cfm > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] -- Marlon "A mulatto, an albino, a mosquito, my libido" b‹šë.nÇ+‰·�¶‡ qׯN‹§²æìr¸›zǧu©Þ™¨¥¶‡ qׯq÷3¢w¨® "¶a{ +v˧²æìr¸›yÇÜuëÚ²Ø^²æãyËh~Ø^zf¢”!B ëâ²»§o … š'{ 0q÷3¢w¨®§vË©¦ŠíyÖòUÇ¢Ëbž 0ÁÇñ†‹-Šx ¢`…7¯ŠË.¦š+µç[È×°ÙZžÖ¦jG«²‡Á–烨(žm§ÿðà ÞÁ«ej{Zr‰¿¦º ¹Ëlý¹nyÚÚ‚‰ÿŠw^ÅÇæv«r¯z‡í…à…7¯–+-ŠÆ¯j)ZnWš· 0™¨¥j·!Š÷œ¢oÜ}Ç^½ÇÜΉޢ¸
