Login

    Register

PROJECT CATEGORIES

 

Transfer Config V 1.0.1
Project Home Blog Known Issues Contact Project

Author: Rolando Lopez (All RIAForge projects by this author)
Last Updated: September 17, 2007 6:28 PM
Version: 1.0.1
Views: 5641
Downloads: 582
License: Apache License, Version 2

Description:

This application introspect a database by using the ColdFusion tag cfdbinfo and creates the Transfer ORM Config file based on setting you specify on the environment.xml file and the UI.

You can set a few config settings depending on what best works for you:

•UUID Convention - This is meant for SQL server that does not have UUID data type but instead we use char(35),so if you have this turned on every time a Char(35) is found will be interpreted as a UUID data type.
•Generate PK - ask transfer to generate the PK value for you.
•Collection Type - <array|struct> lets you choose wich collection type you want to use for the OneToMany relationships.
•Relationship type to use - In transfer you can pick whether to use the ManyToOne or OneToMany relationships and this will vary depending on your needs. As of now you can only select this as a general setting meaning whatever you pick it will be used on all the Objects created. However both relationships will always be created, it'll just comment out the other one. So if you want to change for one or the other after the file is created all you need to do is uncomment those lines.
•File name - By default I have the file named transferX.xml. The destination of the file you can change for each site in the environment.xml file mentioned below.

Enhancements and Fixes:
I just added version 1.0.1 of Transfer Config this includes the following fixes and enhancements:

•Fixed: App would break if database in use contained a table with no primary key defined.
•Enh: change app to be able to run in transferConfig subfolder (can be run directly under the root)
•Enh: added ability to pick DSN directly from the view/form. The way this will work depends on your settings:

oIf you have the Admin password for CF you can added to the environment.xml.cfm file and the CF Admin API will be used to get a list of DSN's.
oIf don’t have Admin privileges on the server, it will try to use the CF serviceFactory to get a list of the DSN’s.
oIf none of the previous two are an option, a text field will be used filled out by default with the DSN value you specified in the environment xml file.

•Other minor enhancements.

Requirements:

Coldfusion 8

Issue Tracker:

ID ISSUE STATUS UPDATED
8 Decorators Open 10/19/07 2:27 PM
7 Handling of no primary key Open 09/26/07 12:44 PM
6 If no DSN at startup, get an error page Open 09/26/07 12:40 PM
5 File paths are Windows-specific Open 09/26/07 12:38 PM
4 wrong case for createObject calls Open 09/25/07 12:30 PM

View All Issues

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