Adobe India dev summit 2009 announced!
Adobe Dev Summit, 2009 has been announced. The summit is on 4th August, 2009 at Lalit Ashok, Bangalore. You can sign up for a Gold pass, which is absolutely free. You can also sign up for a Platinum pass and get Flex Builder 3 Professional license for free.
What’s in it for you?
- See the new, improved and rocking LiveCycle Data Services 3 in action! If you are a Java developer, you wouldn’t want to miss this one!
- If you are a PHP/Java developer, get on the RIA expressway using the new Data Centric Development features on Adobe Flash Builder 4
- If you’re into enterprise-wide RIA development, things have just got hot! Check out the brand new version of ColdFusion with the sparkling new developer IDE – ColdFusion Builder.
- User Interfaces are a thing of the past now. Build User Experiences of tomorrow with Adobe Flash Catalyst. Quicker than ever!
- Sign up for a Platinum Pass and get the award winning Adobe Flex Builder 3 Professional license worth USD 699 FREE!
Please find more details and register here http://www.endtoend.in/ete2009/adobe/devsummit/mailer.html.
ColdFusion-ORM: Define Computed properties (formula attribute)
What are computed properties?
Consider the tables – Art and Artists. Art and Artists form a one-to-many relationship where one Artist has created many Art. Say, in each Artist object, you need a property that would contain the number of arts made by the Artist – use computed properties. The formula to compute the value of the property should be specified using the formula attribute of the cfproperty tag. The formula should be specified as a SQL that returns a single value. Note that computed properties do not map to any column in the table and are not persistent.
Task:
Example to demonstrate using computed properties in ColdFusion-ORM
Previous Related Posts:
Getting Started with ORM
ColdFusion-ORM: Using CRUD Functions
ColdFusion-ORM: Define One-to-Many and Many-to-one relationships
ColdFusion-ORM: Collections
Stuff that you would learn:
- how to define computed properties
- how to define the formula for computed properties
Steps to Run the example:
- This example needs the cfartgallery datasource. This is shipped with ColdFusion by default.
- Create a directory say "ormformula" under webroot.
- Create the following files – Application.cfc, Artists.cfc and index.cfm.
- Run the URL “http://<ip>:<port>/ormformula/index.cfm”
Application.cfc
component
{
//Name of the application
this.name = "ORM_Formula";
//ormenabled should be set to true so that ORM is enabled for this application
this.ormenabled = "true";
//Set the datasource that needs to be used by the ORM Functions. You can also set this in the ormsettings struct
this.datasource = "cfartgallery";
}
Artists.cfc
component persistent="true" entityname="Artists" table="Artists"
{
property name="id" column="ARTISTID" generator="increment";
property name="firstname";
property name="lastname";
property name="address";
property name="city";
property name="state";
property name="postalcode";
property name="email";
property name="phone";
property name="fax";
property name="thepassword";
/*
A property automatically becomes a computed property if formula attribute is specified.
A SQL that returns a single value should be input to the formula attribute. Note
that computed properties do not map to any column in the table and are not persistent.
In this example, the "numberOfArts" property will store the number of arts made by the
Artist.
Have a close look at the SQL that is used. In this SQL, if you specify any column name, by default,
hibernate assumes that the column is from the table to which this CFC maps to - here
Artists table. If you want to specify a column that belongs to another table, you should alias
them. Hence, here, in the where condition art.ArtistId=ArtistId, the latter 'ArtistId' would be
from the Artists table. For each Artists entity, Hibernate would then substitue 'ArtistId' with
the column-value for that entity. For example, for the entity with ArtistId=5, the SQL would be:
select Count(*) from Art art where art.ArtistId=5
*/
property name="numberOfArts" formula="select Count(*) from Art art where art.ArtistId=ArtistId";
}index.cfm
<!---
This example will teach you
- how to define computed properties
- how to define the formula for computed properties
--->
<cfset ormreload()>
<cfset artists = EntityLoad("Artists")>
<cfloop array="#artists#" index="artist">
<cfoutput>
#artist.getFirstName()# #artist.getLastName()# has <b>#artist.getNumberOfArts()#</b> arts<br>
</cfoutput>
</cfloop>ColdFusion ORM: ORM-CFC Generator Extension for Adobe ColdFusion Builder
When we started working on ColdFusion-ORM feature (me and Rupesh), the only way to provide ORM mapping was by using the hibernate XML file (hbm.xml). Later, we provided a way to specify the mapping in CFCs – ColdFusion-ORM would then take care of creating the hibernate mapping. This made life easier for the ColdFusion developers. Now we have the ORM-CFC Generator Extension in Adobe ColdFusion Builder which will generate ORM-CFCs automatically!
The Adobe CFC Generator can be downloaded from this location and the instructions to use it are here. The Adobe CFC Generator
- allows you to create ORM-CFCs from a set of tables.
- allows you to configure the ORM-CFCs – change the CFC-Name, change EntityName, change property-name, select/de-select columns, add relationships and join-conditions, etc.
- generates ORM-CFCs (of-course!)
- generates Service CFCs for each ORM-CFC that contain certain utility methods to work with the ORM-entities
Note that the Adobe CFC Generator is provided as a sample extension. When the extension is installed, the source-code for the extension can be found in the installed location. Using the source code, you can modify/customize the UI/ORM-cfcs/Service-cfcs to add additional functionality.
Check out this blog post – How Do I generate ORM CFC’s??? – A nice captivate demo which shows you how to install and use ORM-CFC Generator Extension. The CFBuilder team will be posting heavily on extensions in the coming days – do have an eye on that space.
Recent Comments