Login

    Register

Managed Hosting

PROJECT CATEGORIES

 

Squidhead
Project Home Blog Forums Known Issues Screenshots External Project Link Contact Project

Author: Terrence Ryan (All RIAForge projects by this author)
Last Updated: August 6, 2008 4:04 PM
Version: 2.0.00695
Views: 107,404
Downloads: 3,088
License: Apache License, Version 2

Description:

What does it do?
      
         * It inspects Database
         * It analyzes the tables and views
         * It creates INSERT, SELECT, UPDATE, DELETE and LIST stored procedures for every TABLE.
         * It creates LIST stored procedure for every VIEW.
         * It adds them to the database.
         * It assigns the proper GRANT permissions
      
      Then it does a second pass
      
         * It inspects the database
         * It analyses all of the stored procedures not just the ones the process creates
         * It creates two sets of CFC's: GATEWAY and DAO
         * It creates a DAO for each TABLE and VIEW.
         * It creates the <cfstoredProcedure> calls for each stored procedure
         * It creates the <cffunction> to wrap the storedprocedure in.
         * It adds each <cffunction> <cfstoredproc> 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.

Recent Blog Entries:

Requirements:

Microsoft SQL Server 2000 or Microsoft SQL Server 2005 ColdFusion MX 7

Issue Tracker:

ID ISSUE STATUS UPDATED
32 Application path is incorrect Open 02/03/10 6:10 PM
31 Comments within Stored Procedures Open 06/18/09 11:20 AM
30 Stored procedures not being created Open 03/30/09 10:01 PM
21 Font errors running v2.0.00123 Fixed 08/04/08 9:24 AM
26 Default Values for nullable Fields Open 04/08/08 11:26 AM

View All Issues

To enter issues for this (or any other) project, you must be logged in.