ORM - Basics

The minimum required ORM Settings.

Application.cfc

<cfset this.name = "ORM-Basic" >
<cfset this.ormenabled="true">
<cfset this.datasource="cfartgallery">

Defining an ORM - CFC.

Artists.cfc

<cfcomponent persistent="true">
<cfproperty column="ARTISTID" generator="increment" name="id">
<cfproperty name="FIRSTNAME">
<cfproperty name="LASTNAME">
<cfproperty name="ADDRESS">
<cfproperty name="CITY">
<cfproperty name="STATE">
<cfproperty name="POSTALCODE">
<cfproperty name="EMAIL">
<cfproperty name="PHONE">
<cfproperty name="FAX">
<cfproperty name="thepassword">
</cfcomponent>

Usage.

Initialize ORM

<cfset ormreload()>

Save

<cfset ArtistObj = entityNew("Artists")>
<cfset ArtistObj.setFIRSTNAME("James")>
<cfset ArtistObj.setLASTNAME("Bond")>
<cfset ArtistObj.setCITY("London")>
<cfset EntitySave(ArtistObj)>
<cfset ORMFlush()>

Load

<cfset ArtistArr = EntityLoad("Artists")>
<cfdump var="#ArtistArr#">

LoadByPK

<cfset ArtistObj = EntityLoadByPK("Artists",1)>
<cfdump var="#ArtistObj#">

Reload

<cfset ArtistObj.setCITY("Liverpool")>
<cfset entityReload(ArtistObj)>
<cfdump var="#ArtistObj.getCITY()#">

Delete

<cfset ArtistObj = EntityLoadByPK("Artists",1)>
<cfset EntityDelete(ArtistObj)>