/examples/api_jsonxml/resources/artistMember.cfc
ColdFusion CFScript | 81 lines | 77 code | 4 blank | 0 comment | 0 complexity | 2db92f4569057f07d44e9ddeb99bde8d MD5 | raw file
1<cfcomponent extends="taffy.core.resource" taffy:uri="/artist/{id}" hint="some hint about this resource"> 2 3 <cffunction name="get" access="public" output="false"> 4 <cfargument name="id" type="numeric" required="true" /> 5 <cfset var q = ""/> 6 <cfset var col = "" /> 7 <cfset var rtn = StructNew() /> 8 <cfquery name="q" datasource="cfartgallery"> 9 select * from artists where artistId = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.id#" /> 10 </cfquery> 11 <cfif q.recordCount gt 0> 12 <cfloop list="#q.ColumnList#" index="col"> 13 <cfset rtn[col] = q[col][1] /> 14 </cfloop> 15 <cfreturn representationOf(rtn).withStatus(200) /> 16 <cfelse> 17 <cfreturn noData().withStatus(404) /> 18 </cfif> 19 </cffunction> 20 21 <cffunction name="put" access="public" output="false"> 22 <cfargument name="id" type="numeric" required="true" /> 23 <cfargument name="firstname" type="string" required="false" default="" /> 24 <cfargument name="lastname" type="string" required="false" default="" /> 25 <cfargument name="address" type="string" required="false" default="" hint="some hint about this parameter" /> 26 <cfargument name="city" type="string" required="false" default="" /> 27 <cfargument name="state" type="string" required="false" default="" /> 28 <cfargument name="postalcode" type="string" required="false" default="" /> 29 <cfargument name="email" type="string" required="false" default="" /> 30 <cfargument name="phone" type="string" required="false" default="" /> 31 <cfargument name="fax" type="string" required="false" default="" /> 32 <cfargument name="thepassword" type="string" required="false" default="" /> 33 <cfset var q = "" /> 34 <cfquery name="q" datasource="cfartgallery"> 35 update artists 36 set artistid=artistid 37 <cfif len(arguments.firstname)> 38 ,firstname = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.firstname#" /> 39 </cfif> 40 <cfif len(arguments.lastname)> 41 ,lastname = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.lastname#" /> 42 </cfif> 43 <cfif len(arguments.address)> 44 ,address = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.address#" /> 45 </cfif> 46 <cfif len(arguments.city)> 47 ,city = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.city#" /> 48 </cfif> 49 <cfif len(arguments.state)> 50 ,state = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.state#" /> 51 </cfif> 52 <cfif len(arguments.postalcode)> 53 ,postalcode = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.postalcode#" /> 54 </cfif> 55 <cfif len(arguments.email)> 56 ,email = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.email#" /> 57 </cfif> 58 <cfif len(arguments.phone)> 59 ,phone = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.phone#" /> 60 </cfif> 61 <cfif len(arguments.fax)> 62 ,fax = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.fax#" /> 63 </cfif> 64 <cfif len(arguments.thepassword)> 65 ,thepassword = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.thepassword#" /> 66 </cfif> 67 where artistid = <cfqueryparam cfsqltype="cf_sql_numeric" value="#arguments.id#" /> 68 </cfquery> 69 <cfreturn noData().withStatus(200) /> 70 </cffunction> 71 72 <cffunction name="delete" access="public" output="false"> 73 <cfargument name="id" type="numeric" required="true" /> 74 <cfset var q = "" /> 75 <cfquery name="q" datasource="cfartgallery"> 76 delete from artists where artistid = <cfqueryparam cfsqltype="cf_sql_numeric" value="#arguments.id#" /> 77 </cfquery> 78 <cfreturn noData().withStatus(200) /> 79 </cffunction> 80 81</cfcomponent>