Squidhead 2.0.00695

Operating systemsOS : Windows / Linux / Mac OS
Program licensingScript Licensing : Apache License
CreatedCreated : Sep 25, 2010
Size downloadDownloads : 2
Program licensing
Thank you for voting...

The component works with MySQL 5, Microsoft Sql ...

The component works with MySQL 5, Microsoft Sql Server 2000/2005 and Oracle 10g.
All tables must have identity (MSSQL), auto increment (MySQL) or a sequence (Oracle).
Most important functions of Squidhead by Terrence Ryan:

• It introspects a Database

• It analyzes the tables and views

• It creates INSERT, SELECT, UPDATE, DELETE, SEARCH and LIST stored procedures for every TABLE.

• It creates LIST and SEARCH stored_procedure for every VIEW.

• If there are foreign keys, it creates SELECT_WITH_FK, LIST_WITH_FK, and LIST_FORIEGNKEY_LABELS stored procedure.

• It adds them to the database.

• It assigns the proper GRANT permissions

build Unit Tests.

• Run Unit Tests

• Build Ant Script

• Build Documentation

• Build Coldspring Configs

• It analyzes all of the stored procedures not just the ones the process creates

• It creates two sets of CFC's: GATEWAY and DAO

• It creates the calls for each stored procedure

• It creates the to wrap the storedprocedure in.

• It adds each combo within the appropriate CFC per table.

• It places any operation with SELECT, DELETE, UPDATE, AND INSERT in the title within the DAO CFC'S.

• It places all other actions to the GATEWAY CFC's.

• It writes the CFC's to disk.

• It writes Custom Tag components to produce nuggets of Editing and Listing functions.

• It strings all of these together to produce a simplistic CRUD application.
Demands:

• ColdFusion 8 or higher

• Requires account with ability to create and drop objects
Limitations:

• Fields named "createdOn", "updatedOn" will be automatically set (Can be changed in configuration)

• Field named "createdBy" will only be set on create method

• A bit field named 'active' will alter behvior of table. It will deactivate instead of delete records. (Can be changed in config)

• All stored procedures should be named "usp_[tableName]_[action]"

• Action can contain underscore.
News in the current Squidhead 2.0.00695 version:

• Fixing build to work on new workstation.

Squidhead 2.0.00695 scripting tags: build, stored, application generation, procedure, creates, generate, procedures, database introspection, stored procedure, named, squidhead. What is new in Squidhead 2.0.00695 software script? - Unable to find Squidhead 2.0.00695 news. What is improvements are expecting? Newly-made Squidhead 2.1 will be downloaded from here. You may download directly. Please write the reviews of the Squidhead. License limitations are unspecified.