Joe, I would suggest all calls to get db schema actually be made thru a interface as opposed to the actual database specific cfc. So as new databases are added each one would have its own driver cfc. This way people can easily build new driver cfcs that plug into the interface cfc which retrieves schema information.
I wrote a small CFC that inserts, updates and deletes extended properties to the SQl Server column definitions. This allows you to extend the SQL Server schema however you want and use this information when you generate the code. I think this would be a nice addition. I believe Oracle and others offer the same feature of extending column information so the calls could have an interface cfc which would insulate the code generator or developer. Thanks, Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joseph Flanigan Sent: Wednesday, March 10, 2004 3:10 PM To: [EMAIL PROTECTED] Subject: Re: [CFCDev] CFC Code generator Does Oracle support ANSI SQL INFORMATION_SCHEMA views? The views are a non-conforming requirement of the standard, which means the DBMS companies do not have to support. I do not have Oracle. Perhaps when the code is released, people who have Oracle and other DBMS can collaborate on improvements. It should would be nice to have a tool that could build wrapper code that worked across DBMS platforms. Joseph At 12:36 PM 3/10/2004, you wrote: >I thought the tool was great.... does it support oracle tables and >procs? > > > >Joseph Flanigan wrote: > >>DBX - excellent tool! Recommend it to others myself. Like the user >>interface. In my tool, I choose not to use a tree to list DB objects >>because in nearly every case, the node would be expanded. Instead, the >>tool uses selects and color the different objects. Also, it makes sorting >>by name across object types easier. >> >>As far as Information_Schema over procedures? Some of the tool uses >>sysobjects and sp_help. But since Info_Schema is in the ANSI standard, my >>thought where other DBMS would use. Also, it there was a compelling >>reason to have other DBMS, the functions can be modified to have similar >>results. So using information schema allows separating the code >>generation from the DB. >> >>Source. GPL/Open Souce. >> >>Collaboration. You bet. >> >>Joseph >> >>At 01:01 AM 3/10/2004, you wrote: >> >>>Hello, >>> >>>Thought I'd take this off the list for a moment. I was wondering a >>>few >>>things: >>> >>>First, whether or not you had seen my own application, DBX, for >>>SQLServer / CF development. It can be found at >>>www.websolete.com/exchange.cfm , with some screenshots at >>>www.websolete.com/images/dbx_screenshots . Sort of my 'baby', and I >>>work on it constantly. It is also an app for which I've had >>>earmarked for CFC generation for a while, but have never spent the >>>time on. A while back, I was approached by someone regarding his own >>>CFC generator application, but apparently that has never come to >>>pass, as its been a long while since I've heard from him (the app in >>>question was to be commercial, IIRC). >>> >>>Third, perhaps I didn't poke around enough, but is your code open >>>source? I didn't see where to download based off the url you gave, >>>and was wondering whether using your code in other applications, >>>namely my own, was within the license model you have. I see that >>>you're using INFORMATION_SCHEMA to grab the db schemata, and while it >>>works, it's a bit old hat from what I understand. My own uses >>>standard catalog procedures, with some minor twists, on the premise >>>that their use will be better preserved in subsequent versions of >>>SQLServer (recommedned by MS over INFORMATION_SCHEMA. >>> >>>At any rate, curious regarding the licensing or whether you're >>>interested in any collaborative effort. >>> >>>Regards, >>>Kevin Miller >>>Websolete.com >>> >>> >>>-----Original Message----- >>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >>>Behalf Of Joseph Flanigan >>>Sent: Wednesday, March 10, 2004 3:59 AM >>>To: [EMAIL PROTECTED] >>>Subject: Re: [CFCDev] CFC Code generator >>> >>> >>>Ok. I think this Code Generator is ready enough for this group to >>>comment on. >>> >>>http://www.switch-box.org/cfsqltool/ >>> >>>This tool uses database objects and names to define CF namespaces and >>>scripts to use for communicating with the database. >>> >>>The tool has several wizards. For CFC generation, please look at the >>>user stored procedure wizard and the table CRUD wizard. >>> >>>The database is SQL Server. The tool uses MS's version of ANSI >>>Standard INFORMATION_SCHEMA views . I am not familiar enough with >>>other DBMSs implementations of these views to say how the tool will >>>work with them. But, since the tool uses a CFC, INFORMATION_SCHEMA, >>>perhaps the functions can be changed for other DBMS. In the tool's >>>documents is a version of INFORMATION_SCHEMA.cfc. >>> >>>The Table CRUD wizard option selector is especially interesting. >>> >>>3-click-coding. >>> >>>Joseph >>> >>> >>> >>>------------------------------------------ >>>Switch_box >>>www.Switch-box.org >>>MediaFirm, Inc. >>>PO Box 2171 >>>Loveland, CO 80539 >>> >>>[EMAIL PROTECTED] >>> >>>---------------------------------------------------------- >>>You are subscribed to cfcdev. To unsubscribe, send an email to >>>[EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the >>>message of the email. >>> >>>CFCDev is run by CFCZone (www.cfczone.org) and supported >>>by Mindtool, Corporation (www.mindtool.com). >>> >>>An archive of the CFCDev list is available at >>>www.mail-archive.com/[EMAIL PROTECTED] >> >> >> >>------------------------------------------ >>Switch_box >>www.Switch-box.org >>MediaFirm, Inc. >>PO Box 2171 >>Loveland, CO 80539 >> >>[EMAIL PROTECTED] >>---------------------------------------------------------- >>You are subscribed to cfcdev. To unsubscribe, send an email to >>[EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the >>message of the email. >> >>CFCDev is run by CFCZone (www.cfczone.org) and supported >>by Mindtool, Corporation (www.mindtool.com). >> >>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' in the >message >of the email. > >CFCDev is run by CFCZone (www.cfczone.org) and supported >by Mindtool, Corporation (www.mindtool.com). > >An archive of the CFCDev list is available at >www.mail-archive.com/[EMAIL PROTECTED] ------------------------------------------ Switch_box www.Switch-box.org MediaFirm, Inc. PO Box 2171 Loveland, CO 80539 [EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). 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' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
