Most of the changes here have to do with Foreign Keys and the FKCrazy template. Squidhead can now detect many to many relationships across [table]To[table] assuming that their are foreign keys in the tableToTable table and they are named the same as the primary keys in joined tables. It allows you to add and delete those relationships. If you actually read this, and this doesn't make sense drop me a line. I'll record another video to explain it. (I really don't know how to explain it.) If you are using the FKCrazy template, make sure you replace the baseBusiness.cfc.

Unique constraints are now recognized by Squidhead. If there is a unique constraint on a table, it writes a read by column procedure automatically, and can be used in business object instantiation.

Made sure that all columns in a stored procedure is referenced wrapped in qualifying terms.

Updated a fair amount of documentation

Refactored a few things to make code base more miantainable.

Fixed bugs related to cfimage anf fonts on different OS's

Added a new feature with foriegn keys: child autowiring. It's a bit hard to explain but let me try explain. Let's say you have a table entry and table comment. Comment contains a foreign key to entry, denoting that comments are many to one children of entry. When you view the read method for entry, the child comments will be displayed. Additionally the option to add a comment to entry with the comment form will be displayed. If you actually read this, and it doesn't make sense drop me a line, it's a really cool feature that's hard to explain.

To experiment with child autowiring, add the following to your config file:

Note the changes are include swapping cfc_business_dynamic in for cfc_business and chaning the application template to "fkCrazy" cause it really is fkCrazy to do this. If you are going against an already made squidhead application make sure that you do one of two things: delete your business cfc directory or change all of the inheritance so that the top level business objects inherit from their lower counterparts.

Only necessary for MYSQL users

Made image crud work for MySQL. Requires IsImage to be manually set on the blob column in the XML disk cache. This can be found in the tables.xml in your generated application's sql folder.

Configuration generator works for MySQL now.

Default configs have been slightly tweaked to work better.

Doc's slightly updated.

Ignore release. Testing publishing mechanism.

No different for users than 155.

Added a little extra CRUD for images. Made refreshing the application a default step.

Fixed more bugs with MySQL support. Added more user feedback on adds and updated to the UI and custom tag layer.

By adding MySql support I attracted Mac users to give Squidhead a try. Russ Johnson found a number of bugs that crop on a Mac. Most were because I missed a few "\"'s that should have been "/"'s. Plus I might have discovered a CFImage bug on CF 8 for Mac OSX.

Thanks, Russ, for finding the bugs, and forcing me to get my Mac Mini up an running.

New features:

• MySql 5.0 Support
• It creates Ant Build files for common tasks
• It can run CFUnit tests that it creates during its build
• It now will use CF8 rich elements it the generated crud *
• It now handles images *
• It's now a little easier to extend
  • It's easy to add steps.
  • It's possible to add application templates
• Modified XML configuration allows developer to override certain defaults like form field labels.
• New Configuration Builder
• New Shiny Web 2.0 looks (Okay, not a feature per see.)
• Cheesey Web 2.0 Logos created for every application.

* CF 8 features can be turned off if application will not be running on a CF8 server.

Deprecated Features:

• Simple Applications (They are still available, but they won't be updated)

Removed Features:

• Threading (Speed Enhancements weren't enough to justify added complexity)

Requirements:

• Squidhead: ColdFusion 8
• Database: Microsoft SQL 2000 or 2005; MySql 5.0
• Generated Application Using MSSQL: ColdFusion 7 or 8
• Generated Application Using MySql: ColdFusion 8

Notes:

• For the most part, your old config files will still work. However the more changes you made the more likely they are to have problems.

Old versions of Squidhead still available at http://www.numtopia.com/squidhead.

Overzealous refactoring led to bugs when a stored procedure returned multiple results.

Mostly bug fixes. Who knew adding threading would be so hard.

Also fixed an issue with stored procedures with "fake table names." Basically when "usp__action isn't a table, it was throwing an error. This is wrong behavior.

A whole bunch of little things:

Forced Squidhead application scope to refresh on everypage call.

Forced Squidhead application to be unique to the file path on the server.

Added better comments for generated functions.

Added optional CF8 threading for performance improvement. Only happens if config['settings']['useColdFusion8Features'] = TRUE. Which is set by default to false.