Remote Synthesis
Search my blog:
Viewing By Entry / Main
Dec 02, 2008

New Version of Illudium Code Generator - Generate All Tables At Once

Yes, you read that right; there is indeed a new version (Build 13 ) of my Illudium PU-36 Code Generator available on the Google Code site (http://code.google.com/p/cfcgenerator). I have finally implemented one of the most requested features - the ability to automatically generate all tables in a DSN at once. However, I made it better and more usable I think.

First of all, for anyone who has heard me talk about how I was working on rewriting the whole application for the next release, that didn't happen. As most of you know, there hasn't been a release in about 8 months and that overly ambitious goal is in large part why. I haven't given up on that goal as I think it is still necessary, but I decided to implement this feature using the existing codebase as I have some very different ideas for future versions.

Generate All Tables for a DSN
In order to generate all tables for a DSN, you first need to choose a save location (be careful what you choose though as this feature will automatically begin saving files to the chosen location when you click generate). After choosing a save location, you can check the "Generate All Tables Same Settings?" option. When this is chosen, it will first automatically save the files for the selected table to the save location.

Next it will open a small dialog showing the next table on the list and a text box with a new path name which automatically replaces the last item in the prior path with the current table name. You can use the default new path or change the path to whatever you like. This allows you to run through all the tables without needing to save all items into the same directory for instance.

You can choose to cancel the process which will stop processing all remaining tables or you can skip any particular table you don't want to export. As you click submit through all the tables, they will be automatically saved with all the previously settings to the path you specify.

Hopefully all you folks who emailed me about this feature will be happy (and if you love Illudium and it saves you time, feel free to visit my wishlist). I also plan on adding the "save all" for the currently generated table but I have to modify the current layout to accomodate the button somewhere. It's coming...hopefully soon. Feel free to comment or email me if you encounter any issues with the new feature.

Comments
Justin
Wow! Very, very nice. After figuring out custom templates, illudium is invaluable. .


Brian Rinaldi
Just an FYI, there is a bug in the current build whereby the last table is skipped (thanks lola for finding this). It has been fixed in Subversion and a new build will be posted this evening.


Henry Ho
SWEET! Thank you!


Brian Rinaldi
I uploaded a build that fixes the issue described in my prior comment.


Tom Chiverton
Rar ! Cheers Brian !


Jorge Loyo
Thank you Brian, This is awesome... May I just add something? Would it be too difficult to implement the ability to define the save path for each file in the template in either the YAC or the actual generator (perhaps in the new and slick popup)? This is simply because the Services, DAOs, Gateways and Config.xml's may not all be in the same location and would need a different returntype... Again, thank you for your time and effort to help out the community. -- Jorge Loyo


Brian Rinaldi
@Jorge, you already have that ability. Set the save path to the root of your site say /webroot/mysite/ and then change the cfc path accordingly like com.users.user and com.categories.category. The generator turns the cfc path into a folder path as well (as you would expect). So user is saved in /webroot/mysite/com/users/user.cfc and category in /webroot/mysite/com/categories/category.cfc. This is why I didn't see a way of implementing this feature without the dialog box, because I needed the new path information.


Jorge Loyo
Brian, You are right, I do see the returntype changing for all files accordingly, however, this is what i meant: I have in my yac.xml a service, bean and gateway/dao and these files I actually save on a different location. I save my user.cfc, userGateway.cfc and userDAO.cfc in the following location: myapp/model/user/ But I save my userService.cfc in the following location: myapp/services/ and my config files (coldspring.xml, mach-ii.xml, etc) in the follwing location: myapp/config Is this possible now? Sorry if I missed it. Again thank you for this awesome tool


Brian Rinaldi
@Jorge - no, that isn't available now. That is another one of those features that is requested often. I will look into it for an upcoming release.


Jorge Loyo
Thank you sir... You da man!!


Nathan Stanford
Is there a chance of getting a version that does not use Flex? as I can not update my computer at work and it will not work for me there. Thanks, Nathan P.S. I really do like this and hope I can use it at work.


jarthel
I just tried the latest version and in my usage (using Oracle DB), it skipped the 1st table (generate all tables function).


Write your comment



(it will not be displayed)