Thanks for the feedback. To avoid overwriting any changes, I recommend putting your customizations in a CFC that extends the CFC that cfcPowerTools produces. This way you separate your customizations from code that's automatically generated. You gain the ability to easily manage modifications without loosing code you've added manually.
I have not used Ruby on Rails, but I have heard from a developer who's using cfcPowerTools and he sees a lot of similarities between cfcPowerTools and Ruby on Rails. Thanks - Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marlon Moyer Sent: Thursday, August 18, 2005 11:34 AM To: [email protected] Subject: Re: [CFCDev] Better way than dao, gateway, bean 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Ü}Ç^½ÇÜΉÞ
