Fixing build to work on new workstation.

Files Effected

• /trunk/squidhead/tools/riaforge/index.cfm (M)

Removed cfdump/cfabort combo that was occasionally called.

Files Effected

• /squidhead/tools/refresh/index.cfm (M)
• /squidhead/cfc/base/database.cfc (M)

Fix Bug: default value not getting set right for non required fields

Files Effected

• /squidhead/steps/cfc_dao_gateway.cfm (M)

Fix bug: Simple applications were getting created with reference to "destory" insread of "destroy".

Files Effected

• /squidhead/templates/cfmltemplates/simple/objectTemplate.cfm (M)

Fix Bug: default value not getting set right for non required fields

Files Effected

• /squidhead/steps/cfc_dao_gateway.cfm (M)

Improved messaging for linked objects. Now only the updated table will display a message instead of all of them because the message was too generic.

Files Effected

• /squidhead/templates/cfmltemplates/fkCrazy/objectTemplate.cfm (M)
• /squidhead/templates/customtagtemplates/fkCrazy/formTemplate.cfm (M)

Fixed Bug 25 : http://squidhead.riaforge.org/index.cfm?event=page.issueedit&issueid=63B7DB81-F255-09CA-8F1035ED2FBECDFF. Select arguments were not being qualified with brackets in certain MSSQL stored procs.

Files Effected

• /squidhead/cfc/mssql/sqlstoredproc.cfc (M)

Added documentation and error handling around the fact that MySql requires mode requires that the account have access to mysql.proc.

Files Effected

• /squidhead/error_exception.cfm (M)
• /squidhead/docs/installation.cfm (A)

Updated a bit of documentation.

Files Effected

• /squidhead/docs/index.cfm (M)
• /squidhead/docs (M)

Fixed bug in MSSQL stored proc creation routine, which caused an error to be thrown whenever joined tables were used.

Files Effected

• /squidhead/cfc/mssql/sqlstoredproc.cfc (M)

Fixed bug caused by lazily replacing all commas with a comma and a break.

Files Effected

• /squidhead/cfc/mysql/sqlstoredproc.cfc (M)

Added smallmoney datatype to constants.

Files Effected

• /squidhead/cfc/base/constants.cfc (M)

Fixed bug in column escaping. Bug was causing creation of linking tables to fail.

Files Effected

• /squidhead/cfc/mssql/sqlstoredproc.cfc (M)

Fixed issue with multiple output variables in MSSQL. Basically Squidhead correctly put more than output variable into a structure, but didn't change the function output type to structure.

Files Effected

• /squidhead/cfc/base/database.cfc (M)

Fixed issue with multiple output variables in MSSQL. Basically Squidhead correctly put more than output variable into a structure, but didn't change the function output type to structure.

Files Effected

• /squidhead/steps/cfc_dao_gateway.cfm (M)

Increasing the timeout on the application refresher.

Files Effected

• /squidhead/tools/refresh/index.cfm (M)

Fixed issue with multiple output variables in Oracle. The previous fix for MSSQL broke things for Oracle.

Files Effected

• /squidhead/cfc/oracle/database.cfc (M)

Fixed issue with multiple output variables in Oracle. The previous fix for MSSQL broke things for Oracle.

Files Effected

• /squidhead/cfc/base/database.cfc (M)

Removed cfdump/cfabort combo that was occasionally called.

Files Effected

• /squidhead/tools/refresh/index.cfm (M)
• /squidhead/cfc/base/database.cfc (M)

Files Effected

• /squidhead/tools/cfcDoc/index.cfm (M)

Fixed a series of bugs preventing Squidhead from running in Linux. Mostly related to casing of components.

Files Effected

• /squidhead/cfc/oracle/sqlstoredprocactive.cfc (A)
• /squidhead/cfc/oracle/SQLStoredProcActive.cfc (D)
• /squidhead/cfc/oracle/foreignKey.cfc (D)
• /squidhead/cfc/mysql/foreignkey.cfc (A)
• /squidhead/Application.cfc (M)
• /squidhead/cfc/oracle/SQLStoredProc.cfc (D)
• /squidhead/cfc/mysql/sqlstoredproc.cfc (A)
• /squidhead/cfc/base/SQLStoredProcActive.cfc (D)
• /squidhead/cfc/base/sqlstoredprocactive.cfc (A)
• /squidhead/cfc/base/SQLStoredProc.cfc (D)
• /squidhead/cfc/functionhelper.cfc (A)
• /squidhead/cfc/stepTracker.cfc (D)
• /squidhead/cfc/antBuilder.cfc (D)
• /squidhead/cfc/cfstoredproc.cfc (A)
• /squidhead/cfc/mssql/SQLStoredProcActive.cfc (D)
• /squidhead/cfc/mssql/sqlstoredprocactive.cfc (A)
• /squidhead/cfc/mssql/foreignKey.cfc (D)
• /squidhead/cfc/mssql/SQLStoredProc.cfc (D)
• /squidhead/cfc/mysql/SQLStoredProcActive.cfc (D)
• /squidhead/cfc/mysql/sqlstoredprocactive.cfc (A)
• /squidhead/cfc/mysql/foreignKey.cfc (D)
• /squidhead/cfc/oracle/foreignkey.cfc (A)
• /squidhead/cfc/mysql/SQLStoredProc.cfc (D)
• /squidhead/cfc/oracle/sqlstoredproc.cfc (A)
• /squidhead/cfc/base/sqlstoredproc.cfc (A)
• /squidhead/cfc/functionHelper.cfc (D)
• /squidhead/cfc/steptracker.cfc (A)
• /squidhead/cfc/antbuilder.cfc (A)
• /squidhead/cfc/CFstoredProc.cfc (D)
• /squidhead/cfc/mysql/help.cfc (M)
• /squidhead/cfc/mssql/foreignkey.cfc (A)
• /squidhead/cfc/mssql/sqlstoredproc.cfc (A)

Fixing bug where generated application would not run in Linux becasue of case issue with Application.cfm file.

Files Effected

• /squidhead/steps/cfms.cfm (M)
• /squidhead/config/facebook_linux.cfm (A)

Fixed bug where MYSQL select method was ommiting prefix _ characters.

Files Effected

• /squidhead/cfc/mysql/sqlstoredproc.cfc (M)

Added precision and scale to the metadata in order to properly handle decimal data.

Files Effected

• /squidhead/cfc/mysql/sqlstoredprocactive.cfc (M)
• /squidhead/cfc/mysql/database.cfc (M)
• /squidhead/cfc/mysql/sqlstoredproc.cfc (M)
• /squidhead/cfc/mysql/help.cfc (M)
• /squidhead/cfc/base/database.cfc (M)
• /squidhead/cfc/mssql/sqlstoredproc.cfc (M)

Added configuration "settings" "IgnoreXMLCache". This feature tells squidhead to stop looking at the XML cache. It speeds up table analysis at the cost of the features of the XML cache. If you don't know what they are, then you can safely set this to true. Hopefully someday I can improve the performance of the XML cache, rendering this feature obsolete.

Files Effected

• /squidhead/config/cigar.cfm (M)
• /squidhead/cfc/base/database.cfc (M)
• /squidhead/config/defaultPreLoad.cfm (M)

Fixing bug which caused Squidhead to truncate decimal values.

Files Effected

• /squidhead/steps/cfc_dao_gateway.cfm (M)
• /squidhead/cfc/mssql/sqlstoredprocactive.cfc (M)
• /squidhead/cfc/mssql/sqlstoredproc.cfc (M)

Adding proper decimal support to Oracle. That was shockingly easy.

Files Effected

• /squidhead/cfc/cfstoredproc.cfc (M)
• /squidhead/cfc/oracle/help.cfc (M)

Added Oracle application to the list of applications that gets unit tested by default.

Files Effected

• /squidhead/tools/refresh/index.cfm (M)
• /squidhead/build.xml (M)

Fixed bug in CFUnit tests that caused it not to work with Oracle.

Files Effected

• /squidhead/steps/cfunit.cfm (M)

Altered the format of generated cfstoredproc calls. It was based on a suggestion by Nathan Mische http://www.mischefamily.com/nathan/. Instead of having the conditional decide whether or not the proc would pass null, the change pipes the conditional right into the null parameter. Thanks Nathan, that's very elegant.

Files Effected

• /squidhead/cfc/cfstoredproc.cfc (M)

Refactored database analysis for performance. Reduced the cost of comparing to the XMLCache by about 50%. This should lead to a 25% to 33% reduction in time for builds depending on your configuration.

Files Effected

• /squidhead/cfc/base/database.cfc (M)

Made a change that prevented Squidhead from creating lists of linking tables in the business object of a table linked by a linking table. Why? Well since those linking tables don't really store information in their own right, why include them.

Files Effected

• /squidhead/steps/cfc_business_dynamic.cfm (M)

Added Oracle database inspection.

Files Effected

• /squidhead/cfc/oracle/foreignKey.cfc (A)
• /squidhead/cfc/oracle/database.cfc (A)
• /squidhead/cfc/oracle (A)
• /squidhead/cfc/oracle/table.cfc (A)
• /squidhead/cfc/oracle/help.cfc (A)
• /squidhead/cfc/oracle/constants.cfc (A)

Fixed bug caused by ORACLE timestamp meaning something very different from other database timestamps.

Files Effected

• /squidhead/cfc/base/database.cfc (M)

Checking in ORACLE code. It doesn't work just yet. I have to spend some time thinking about how to implement this feature.

Files Effected

• /squidhead/cfc/oracle/SQLStoredProcActive.cfc (A)
• /squidhead/cfc/oracle/SQLStoredProc.cfc (A)
• /squidhead/config/blog_oracle.cfm (A)
• /squidhead/cfc/base/database.cfc (M)

Seemingly have Oracle Stored procedure creation working.

Files Effected

• /squidhead/cfc/oracle/SQLStoredProc.cfc (M)
• /squidhead/cfc/oracle/database.cfc (M)
• /squidhead/cfc/oracle/help.cfc (M)

Seemingly have Oracle Stored procedure creation working.

Files Effected

• /squidhead/cfc/oracle/package.cfc (A)

Made a few changed to make Oracle work.

Files Effected

• /squidhead/steps/cfc_dao_gateway.cfm (M)

Perfecting Oracle support.

Files Effected

• /squidhead/cfc/oracle/SQLStoredProc.cfc (M)
• /squidhead/steps/cfc_dao_gateway.cfm (M)

Made changes to support Oracle.

Files Effected

• /squidhead/cfc/base/constants.cfc (M)
• /squidhead/cfc/base/database.cfc (M)

Made changes to support Oracle.

Files Effected

• /squidhead/steps/cfunit.cfm (M)

Made changes to support Oracle.

Files Effected

• /squidhead/steps/cfc_dao_gateway.cfm (M)

Files Effected

• /squidhead/cfc/oracle/SQLStoredProc.cfc (M)
• /squidhead/cfc/oracle/database.cfc (M)

Oracle components pass all unit tests. Squidhead now officially supports Oracle. Queue bug reports in 3....2...1....

Files Effected

• /squidhead/cfc/oracle/SQLStoredProcActive.cfc (M)
• /squidhead/steps/cfunit.cfm (M)
• /squidhead/templates/customtagtemplates/default/formTemplate.cfm (M)
• /squidhead/cfc/oracle/SQLStoredProc.cfc (M)
• /squidhead/templates/customtagtemplates/fkCrazy/formTemplate.cfm (M)
• /squidhead/config/blog_oracle.cfm (M)
• /squidhead/steps/cfc_dao_gateway.cfm (M)
• /squidhead/cfc/oracle/help.cfc (M)
• /squidhead/cfc/base/SQLStoredProc.cfc (M)
• /squidhead/config/defaultPreLoad.cfm (M)
• /squidhead/cfc/oracle/package.cfc (M)

Made DAO's and gateway's take db parameters as init arguments. But they are defaulted to application values so as not to break backwards compatibility.

Files Effected

• /squidhead/cfc/function.cfc (M)
• /squidhead/templates/cfmltemplates/fkCrazy/applicationTemplate.cfm (M)
• /squidhead/templates/cfmltemplates/simple/applicationTemplate.cfm (M)
• /squidhead/templates/cfmltemplates/simple/objectTemplate.cfm (M)
• /squidhead/templates/customtagtemplates/simple/formTemplate.cfm (M)
• /squidhead/steps/cfc_dao_gateway.cfm (M)
• /squidhead/templates/cfmltemplates/default/applicationTemplate.cfm (M)

Added coldspringGenerateConfig step. Squidhead now generates Coldspring config files.

Files Effected

• /squidhead/steps/buildDirectories.cfm (M)
• /squidhead/config/blog_mysql.cfm (M)
• /squidhead/config/defaultPostLoad.cfm (M)
• /squidhead/steps/coldspringGenerateConfig.cfm (A)

Files Effected

• /squidhead/tools/cfcDoc/index.cfm (M)

Fixed bug that caused updates to child rows to fail due to a missing DAO reference.

Files Effected

• /squidhead/steps/cfc_business_dynamic.cfm (M)

Fixed a bug that caused delete procs for tables with an active column to deactivate all rows, not just the target row.

Files Effected

• /squidhead/cfc/mysql/SQLStoredProcActive.cfc (M)

Fixed a bug that caused insert and update procs in MySQL for tables with an active column to overwrite all rows, not just the target row.

Files Effected

• /squidhead/cfc/mysql/SQLStoredProcActive.cfc (M)
• /squidhead/cfc/mysql/SQLStoredProc.cfc (M)

Added more generated comments to the dynamic business objects.

Files Effected

• /squidhead/steps/cfc_business_dynamic.cfm (M)
• /squidhead/config/wrdscommunity.cfm (M)

Fixed bug where unique constraints were not honored for tables in Mysql in active/deactive mode.

Files Effected

• /squidhead/cfc/mysql/SQLStoredProcActive.cfc (M)

Fixed bug where order by was not working properly in stored procedures in MySQL.

Files Effected

• /squidhead/cfc/mysql/SQLStoredProcActive.cfc (M)
• /squidhead/cfc/mysql/SQLStoredProc.cfc (M)
• /squidhead/cfc/base/database.cfc (M)

Added option in fkCrazy template to alter the value of the submit button.

Files Effected

• /squidhead/templates/customtagtemplates/fkCrazy/formTemplate.cfm (M)

Added table or object name to the class of edit forms. So that you can create css based on your objects.

Files Effected

• /squidhead/templates/customtagtemplates/fkCrazy/formTemplate.cfm (M)

Made sure that ui cflocations in fkcrazy template were using appendToken to false.

Files Effected

• /squidhead/templates/cfmltemplates/fkCrazy/objectTemplate.cfm (M)

Fixed bug caused by direct reference in baseBusiness Object to the form scope, instead of the passed in reference to the form scope.

Files Effected

• /squidhead/templates/baseCFCs/default/baseBusiness.cfc (M)
• /squidhead/templates/baseCFCs/fkCrazy/baseBusiness.cfc (M)

Added checksumming feature to table analysis. Now certain operations only run when they need to be on a table by table basis. For example if you don't change any tables, then the auto generated stored procedures don't have to be altered, and the custom tags (which are based on the tables not the procs) don't need to be altered. This can be overridden by using the force refresh option, deleting the tables.xml file, or deleting the checksum for a particular table from the tables.xml file. This results in about a 25% reduction in run time for a moderately complex table. More if you have a lot of foreign keys, less if you don't.

Files Effected

• /squidhead/steps/customtags.cfm (M)
• /squidhead/config/wrdscommunity.cfm (M)
• /squidhead/cfc/base/database.cfc (M)
• /squidhead/steps/sqlWriteStoredProcs.cfm (M)

Made a change to allow foreignKeySelector custom tag to handle non-nullable fields gracefully.

Files Effected

• /squidhead/templates/basecustomtags/foreignKeySelector.cfm (M)

Added documentation on how Squidhead reacts to certain database features including foreign keys and unique constraints.

Files Effected

• /squidhead/docs/img/oneToMany.jpg (A)
• /squidhead/build.xml (M)
• /squidhead/docs/databaseFeatures.cfm (A)
• /squidhead/docs/img/manyToMany.jpg (A)
• /squidhead (M)
• /squidhead/docs/img/dropDowns.jpg (A)
• /squidhead/docs/img/uniqueContstraint.jpg (A)
• /squidhead/docs/img (A)
• /squidhead/tools/releasenotesBuilder/getHistory.cfm (A)
• /squidhead/customtags/navDoc.cfm (M)
• /squidhead/docs/img/foriegnkeys.jpg (A)

Added Riaforge publisher. Added SVN History publisher. Should be last step to one step build.

Files Effected

• /squidhead/tools/releasenotesBuilder/pulldownfromRIAForge.cfm (A)
• /squidhead/tools/releasenotesBuilder/index.cfm (M)
• /squidhead/tools/releasenotesBuilder/publishToRiaForge.cfm (A)
• /squidhead/tools/releasenotesBuilder/getHistory.cfm (D)

Updated pdfgenerator

Files Effected

• /squidhead/tools/pdfgenerator/index.cfm (M)

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.