Our Contact DAO will talk to the datasource object we declared and do a few queries. Notice that this object is a singleton and has some dependency injection.
coldbox create model name=ContactDAO persistence=singleton --open
Then spice it up
component accessors="true" singleton{ // Dependency Injection property name="dsn" inject="coldbox:setting:contacts" function init(){ return this; } query function getAll(){ var sql = "SELECT * FROM contacts"; return queryExecute( sql, {}, { datasource: dsn.name } ); } query function getContact(required contactID){ var params = { contactID: { value: arguments.contactID, cfsqltype: "numeric" } }; var sql = "SELECT * FROM contacts where contactID = :contactID"; return queryExecute( sql, params, { datasource: dsn.name } ); } ... ALL OTHER METHODS HERE FOR CRUD .... }
Last updated 5 years ago