Updates to the DAO, Bean and Gateway generator

Man, I love this generator! I've added in some functionality so that it will also generate a generic form for add/update. I've also linked up with the xslsl so that it will capitalize the first letter in get accessor/mutator functions so it's setId instead of setid. I'm picky like that :)

I had never played around with xlst before and had no idea you could do some of the incredible things you're doing with it. Thanks for the code!

Oh, I also figured out that the generator didn't handle BigInt's, so I modified the cfswitch statement in the field.getFieldArgType function:

well, I guess it didn't like the code in that last message:

cfcase value="2,4,5,-5,6,-6,8"> cfset cfargtype = "numeric"> /cfcase>

cfcase value="93"> cfset cfargtype = "date"> /cfcase>

cfcase value="-1,1,12"> cfset cfargtype = "string"> /cfcase>

cfcase value="-7"> cfset cfargtype = "boolean"> /cfcase>

cfcase value="-4"> cfset cfargtype = "binary"> /cfcase>

cfdefaultcase> cfset cfargtype = "any,#getfieldtype()#"> /cfdefaultcase>

Thanks for the update, I will get that included in the downloadable version. I didnt know you could do all the things you can do with XSL until I started developing this. Mind sending me that XSL you used to capitalize the first letter?

fwscott and the "at sign" comcast.net

Hi,

These are the changes I had to make to get primary keys in postgresql 8 to work and to get anything to work for oracle:

Right - that didn't work as well as I hoped. I'll post the patch to Francis.

Hiya, I really like the CFC Generator you've built! I've looked at a few free ones and this one generates code that I can understand and dosen't force any other practises on you. The only hiccup I've found so far is that I think it's not generating a boolean null for it's CFC's. I added to my CFC's and it all sprang to life.

Thanks!

Barny

Sorry, that should be: < cfset variables.BooleanNull = "" />

Thanks Barney, soon there will be a new release with various fixes that people have found and either posted here or emailed me. I will make sure this is included as well.

I'm getting this error: Query Of Queries runtime error. Comparison Exception: While executing "=" Unsupported Type Comparison Exception: Comparator operator "=" does not support comparison between following types: Left hand side expression type = "LONG". Right hand side expression type = "STRING". The error occurred in C:\CFusionMX7\wwwroot\cfccreator\table.cfc: line 185 Called from C:\CFusionMX7\wwwroot\cfccreator\table.cfc: line 149 Called from C:\CFusionMX7\wwwroot\cfccreator\table.cfc: line 12 Called from C:\CFusionMX7\wwwroot\cfccreator\index.cfm: line 52

183 : select * from indexqry 184 : WHERE 185 : NON_UNIQUE = #PreserveSingleQuotes(comparestrprimary)# 186 : 187 :

Great tool! All it needs is a form generator, like what Marlon said he had done in his comment. I love how it's database type independent... as it should be. I have seen other tools that only work in SQL Server. Another interesting upgrade would be a stored procedure generator/user, although that might be a little bit harder to implement.

Hi there, I've been using this for ages with MSSQL and it works great. However I seem to have found a glitch with MySQL. When it reads the date field in the summary it displays it fine however in the code it says the following:

Which actually reflects throughout all the code and causes various problems. Just thought I'd mention it, feel free to ignore me. ;)

I'm getting same error as Jason Lim on September 20th. Did this get resolved? If so, how?

Congrats for this great time saver CFC DAO generator. Please answer one question: our appl haves several tables with several PK and FK(until 7!!!!). CFCCreator works for this type of model? Thanx in advance.

Hi Francis, I just started messing around with the generator, and the design patterns are right on the dot. So first of all, congrats, this is a great tool. I also found a particularity with MySQL 5.0 and above. The primary key that the jdbc drivers bring back in the index query for MySQL, set the NON_UNIQUE flag to true. Therefore, I had to switch the code around from:

TO:

This succesffully generated everything else. Hope this works

Good to hear you were able to fix things Luis.

But I just wanted to let you know that there are some nice ORM tools for ColdFusion now that are being actively developed.

Take a look at http://www.remotesynthesis.com/blog/index.cfm/2005/12/6/Arf-ObjectBreeze-Reactor-and-More

None of these existed when I first created my tool... I dont even use my tool most of the time now.

Thanks, Francis!! Which one do you recommend. I like the fact that I can customize the created code.

luis

I have only tried Arf! and Reactor.

Reactor is basically a factory built on top of a .xsl generator like mine. This keeps all the Coldfusion generated files in a standard CF inheritance format.

Arf! generates files but the factory weaves the generated methods into a class.

I havent really done timing tests on Reactor since v.5 or so but in my initial tests, the more joins an object has, the slower it ran. However, Arf! seemed to always have a specific overhead but didnt increase like Reactor did. Reactor's slowdown at the time seemed to revolve around the amount of query objects that needed to be created.

In the end, my current big project I went with a heavily revamped version of Arf! but I may be changing this because Reactor seems to have an active community and Im thinking it will get more development attention than Arf! because Joe is really pushing MG 1.1/2.0.

To sum it up... I think both are great frameworks and if you want to go with something that currently has some drive to it, go with Reactor. If you want to go with something that has lots of room to tweak performance, go with Arf.

Thanks Francis, will give them a try. As far as using the generated objects in your cfc creator, do you have any examples of the implementation?

Thanks

Love your code generator, wish I knew about it earlier. I like yours much better than Arf or Reactor. I was able to customize it to produce just what I wanted and it now saves me at least 50% of my time. Thanks.

This is way cool. Within a day I was able to move my master, detail, and editing forms into your xsl and it generates the forms. The only problem I am experiencing is that my forms contains the "space" html element. How can I preserve the spaces html element to display? Thanks.

Glad you are liking it Don... When you say a "space" element, are you referring to nbsp; ?

Yes, I am referring to nbsp;.

you can try using....

<xsl:text disable-output-escaping="yes"<&:nbsp;</xsl:text>

not sure if my escaping will work or not... check out the link attached to the comment

Thanks. I tried the suggestion and it worked one out of 6 times. Therefore I will use and search and replace with &;nbsp;. Thanks again.

Great tool, I like the flexibility and speed of it; although there are a few bugs, but reading through the comments I was able to apply all the fixes. One thing though that I haven't seen it mentioned is that when I ran it on my dev machine (ubuntu linux) it complained about not being able to find the xsl files... This was due to some "/"s here and there. Once I corrected them on the index.cfm it all went smoothly. I know it's just a small deatail but you could add a bit of code to obtain the file separator on the current file system and avoid this hassle.

But nevertheless I'm really loving this tool.

Great tool!

I found one thing in the create method of the XXXDAO_ Microsoft_SQL_Server.cfc where it generates the NULL values null="#arguments.xxx.isNullxxx()#" the arguments.X does not match the argument that's referenced/passed in - i.e. comes out as arguments.category - when the argument that is passed in is called categoryBean.

I'm sure you know of this already - !

kp

Ok - ignore my last comment - when looking into the source I see that the 'Bean' is there - so i'll try and regenerate it and see if it does that again.

OK - so it wasn't just me - Line 28 (character 433) of createcrud.xsl didn't have the 'Bean' keyword after it - I've changed it in the xsl file and all should be golden!

The cfc creator is great but i was wondering about the gateway side of things. I notice it is instantiating an object for each row in the recordset, and this is incredibly slow to run.

I am building a system which has recordsets which need return 50,000 + records, and page though them. Gateways, as an array of objects is incredibly slow.

How does anyone else deal with this issue (apart from returning a query which I don't really want to do).

Im not an expert on this but would you need to get all 50,000 records at once? If not, you could add two parameters to your gateway functions... maybe startID and maxRecords. Then your service layer or whatever could handle the paging for you.

Or create some type of Iterator (maybe cached so the database only gets hit once) that loads a query and lazy loads the object as they are displayed. Then you could iterate through the objects as needed but if the page request only displayed 100 at a time, it would only create 100 objects. Perhaps even implement object pooling for the iterator so only one bean will ever exist and gets repopulated once the "next()" is called on the iterator.

I noticed you are using several 'evaluates'...it looks to me like you could eliminate most of them (although not the one for the setter functions) by simply accessing the structures differently. For example:

could be:

variables.beanconfig[arguments.beanConfigValue]

For sure Joe!

The things that old(er) code shows ;)

However, the xsl included is really for showing what can be done... not really what should be done. Customize it however you like.

Hey there, I'm hoping you can provide some insight. I downloaded the CFCcreator this week and have been playing with it on CF 6.1 with my SQL Server database. The first few tables it created just fine. Most other tables tho, are returning this error:

Query Of Queries runtime error. Unsupported type comparison. The error occurred in C:\CFusionMX\wwwroot\cfccreator_original\cfccreator\table.cfc: line 185 Called from C:\CFusionMX\wwwroot\cfccreator_original\cfccreator\table.cfc: line 12 Called from C:\CFusionMX\wwwroot\cfccreator_original\cfccreator\index.cfm: line 52 Called from C:\CFusionMX\wwwroot\cfccreator_original\cfccreator\table.cfc: line 185 Called from C:\CFusionMX\wwwroot\cfccreator_original\cfccreator\table.cfc: line 12 Called from C:\CFusionMX\wwwroot\cfccreator_original\cfccreator\index.cfm: line 52

183 : select * from indexqry 184 : WHERE 185 : NON_UNIQUE = #PreserveSingleQuotes(comparestrprimary)#

At first I thought it was one of my customizations (I mucked with the XSL files a little) but after reinstalling from the original .ZIP, it was still doing it. If you have any advice (or can just point me to the line in the README that I skipped *g*) that'd be a big help.

Cheers. -Nolan

I've got this error. Any one knows what this means?? I try changing the type but it still go down to the same problem.

The argument BEAN passed to function update() is not of type test2.CFC.MCQ_QNS

Name:		Required
Email:		Required your email address will not be publicly displayed.