So you want to create a CFWheels application? ( Part 3 )
This CFWheels series is heavily borrowed from Dan Wilson 's "So You Want to" series about Model Glue :Unity. This entry matches to this post . Previously in this series, we installed CFWheels , discussed some basic conventions over configuration and concepts in CFWheels, and added our basic flow...Published on
This CFWheels series is heavily borrowed from Dan Wilson's "So You Want to" series about Model Glue:Unity. This entry matches to this post. Previously in this series, we installed CFWheels, discussed some basic conventions over configuration and concepts in CFWheels, and added our basic flow and navigation. Our Contact-O-Matic is moving right along (this last sentence was borrowed from Dan's post.) In this segment of our regularly scheduled programming (again borrowed), we will setup a Contactomatic database with tables, add the contact form, and contact list.
Database Setup
CFWheels 0.9.3 supports SQL Server 7 or later, Oracle 10g or later, PostgreSQL, and MySQL 5. You will need to setup a database and a simple table. Here is my code for MySQL 5. Please post your creation code in the comments if you are using a different database system.
DROP TABLE IF EXISTS 'contactomatic'.'contacts';
CREATE TABLE 'contactomatic'.'contacts' (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'name' varchar(45) NOT NULL,
'type' varchar(45) NOT NULL,
PRIMARY KEY ('id')
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;Config
CFWheels simplifies alot of time consuming steps we have gotten use to in developing ColdFusion application using conventions (or assumptions) of our database and naming. Don't worry, we can override these assumptions/conventions if needed. Our first convention we encounter in CFWheels assumes our datasource name is the same as the webroot folder name. We will override that in config/development/settings.cfm . Place this code in that file.
<cfset set(dataSourceName="contactomatic")>Environment
We will make sure our CFWheels environment is pointing to development. Check the enviroment.cfm file in the config folder has this.
<cfset set(environment="development")>Model
The Model folder is where we will create cfc files that map to tables. One cfc per table. Since we created a contact table, we will create a contact.cfc and place this code in it:
<cfcomponent extends="Model" output="false">
</cfcomponent>New Action
We will add the new action in our contact.cfc file in the controller. Add this code to in the Controllers/contact.cfc .
<cffunction name="new">
<cfset newContact = model("contact").new() />
<cfset newContact.name = "Mike Henke" />
<cfset newContact.type = "Friend" />
<cfset newContact.save() />
<cfset renderNothing() />
</cffunction>URL Rewriting On = http://localhost/contact/newURL Rewriting Partial = http://localhost/index.cfm/contact/newURL Rewriting Off = http://localhost/index.cfm?controller=contact&action=newselect * from contacts
Pretty neat, look mamma no SQL!!! What we did was create an object called newContact to represent our Contact table, then added properties that map to our columns.
Create View
Lets drive on and create the new view page. It will have a form to add new contacts, but before we do that let's modify the new action by commenting out this code.
<!---
<cfset newContact.name = "Mike Henke" />
<cfset newContact.type = "Friend" />
<cfset newContact.save() />
<cfset renderNothing() />
--->
<cfoutput>
#includePartial("banner")#
<cfoutput>#flash("success")#</cfoutput>
#startFormTag(action="create")#
<div>#textField(objectName="newContact", property="name", label="Contact")#</div>
<div>#textField(objectName="newContact", property="type", label="Type")#</div>
<div>#submitTag()#</div>
#endFormTag()#
</cfoutput>includePartialstartFormTag()textField()textField()URL Rewriting On = http://localhost/contact/new
URL Rewriting Partial = http://localhost/index.cfm/contact/new
URL Rewriting Off = http://localhost/index.cfm?controller=contact&action=new
Adding Create Action
Lets add the create action in controllers/contact.cfc . Add this code:
<cfoutput>
#includePartial("banner")#
<cfoutput>#flash("success")#</cfoutput>
#startFormTag(action="create")#
<div>#textField(objectName="newContact", property="name", label="Contact")#</div>
<div>#textField(objectName="newContact", property="type", label="Type")#</div>
<div>#submitTag()#</div>
#endFormTag()#
</cfoutput>
Delete <cfset redirectTo(action="new")><cfset redirectTo(action="list")>List
Lets create our list action and view, then take a break and get a drink. We will go more indepth what we did in the next posts. Add this code in controllers/contract.cfc, it creates the sql and get a list of our contacts.
<cffunction name="list">
<cfset allContacts = model("contact").findAll() />
</cffunction><cfoutput>
#includePartial("banner")#
<cfoutput>#flash("success")#</cfoutput>
<cfif allContacts.recordcount EQ 0 >
-No Saved Contacts-<br />
<cfelse>
<table>
<tr>
<th>Name</th>
<th>Type</th>
</tr>
<cfloop query="allContacts">
<tr>
<td>#allContacts.name#</td>
<td>#allContacts.type#</td>
</tr>
</cfloop>
</table>
</cfif>
</cfoutput>
By now, you should have an appreciation for what CFWheels can do. You should be very impressed by the power of built in ORM and Conventions over Configuration. You should be proud of yourself for making it through these verbose tutorials. In the following series, we will add database access, some ajax and some other interesting pieces to our Contact-O-Matic (again this paragraph was borrowed heavy from Dan's post)
