RE: [CFCDev] Better way than dao, gateway, bean

[tom.schreck]

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: cfcdev@cfczone.org 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 cfcdev@cfczone.org 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/cfcdev@cfczone.org     ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org 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/cfcdev@cfczone.org