Generation Tool, Version 1.5+
MediaFirm's CFMX / MS SQL Server Tool is released for general use and
available for download.
Download: http://www.switch-box.org/CFSQLTool/download License is GNU-GPL,
Open Source, without $ charge.
The download is a zip of about 200K. -- There is lots of code to explore.
This tool sets a milestone for code generation! It is packed with features
that will save many hours of coding and debugging.
CFSQLTool is a set wizards for CF and SQL code generation and execution
using SQL Server meta-data from tables, views and stored procedures
- generates CFC, cffunctions and CF namespace variables
- generates SQL and executes stored procedures
- general purpose SQL batch tool for running SQL scripts.
Code generators require CFMX and SQL Server 2000. It uses CFFactory for
data source name selection. The SQL Batcher feature can run with any CF
data source. Minimum system is Windows 2000, IIS, CFMX 6.1 developer
edition and SQL Server MSDE.
The wizards include:
SQL Batcher - something like Query Analyzer but uses CFQuery.
Table Wrapper - CFC generator with cffunctions for CRUD List and Actor
using CFquery.
Table Wrapper application - Generates a CF application that uses the
table wrapper CFC
Stored Procedure Suite - Generates CRUD stored procedures and loads
procedures to DB, better than Query Analyzer
Stored Procedure Wizard - Show, Run, Drop Procedures.
Generates CF name spaces
defined by procedure variables
Generates a CFC for stored procedures
with cffunctions used cfstoredproc
Table Defined Name Spaces -
bangs out a collection of CF variable names defined by SQL Server data
definitions
There are several pages of documentation including a SQL name spaces style
guide.
Below is an image of the Table Wrapper Wizard Selector form. Its allows
designing a suite of queries that generates a CFC using simple check boxes.
It shows more detail about the table's constraints than other DB IDE
tools. The wizard counts generation iterations. This makes it easy to
design multiple queries that can be cut and pasted into the Wrapper CFC.
The Stored Procedure Suite Wizard uses a similar selector form, but
generates stored procedures instead. If you do stored procedures, it will
not believe how easy it is do them with this tool!
SQL Batcher is a versatile tool just because it is easy to run SQL and see
a CFDump of the results. SQL Batcher will load and run a .SQL batch file.
In the download is an example contacts DB SQL batch file that SQL Batcher
can run to build a contacts data base with tables and views. It runs the
same in Query Analyzer as it does with SQL Batcher. The result report,
counts each batch block, reports the execution time, code block executed
and results.
219d07a2.jpg
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
