/examples/api_jsonutil/resources/artistMember.cfc

http://github.com/atuttle/Taffy · ColdFusion CFScript · 102 lines · 97 code · 5 blank · 0 comment · 0 complexity · 6afabea63a2d3613d0344751515c70e7 MD5 · raw file

  1. <cfcomponent extends="taffy.core.resource" taffy_uri="/artist/{id}">
  2. <cffunction name="get" access="public" output="false">
  3. <cfargument name="id" type="numeric" required="true" />
  4. <cfset var q = ""/>
  5. <cfquery name="q" datasource="cfartgallery">
  6. select * from artists where artistId = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.id#" />
  7. </cfquery>
  8. <cfreturn representationOf(q).withStatus(200) />
  9. </cffunction>
  10. <cffunction name="put" access="public" output="false">
  11. <cfargument name="id" type="numeric" required="true" />
  12. <cfargument name="firstname" type="string" required="false" default="" />
  13. <cfargument name="lastname" type="string" required="false" default="" />
  14. <cfargument name="address" type="string" required="false" default="" />
  15. <cfargument name="city" type="string" required="false" default="" />
  16. <cfargument name="state" type="string" required="false" default="" />
  17. <cfargument name="postalcode" type="string" required="false" default="" />
  18. <cfargument name="email" type="string" required="false" default="" />
  19. <cfargument name="phone" type="string" required="false" default="" />
  20. <cfargument name="fax" type="string" required="false" default="" />
  21. <cfargument name="thepassword" type="string" required="false" default="" />
  22. <cfset var q = "" />
  23. <cfquery name="q" datasource="cfartgallery">
  24. update artists
  25. set artistid=artistid
  26. <cfif len(arguments.firstname)>
  27. ,firstname = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.firstname#" />
  28. </cfif>
  29. <cfif len(arguments.lastname)>
  30. ,lastname = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.lastname#" />
  31. </cfif>
  32. <cfif len(arguments.address)>
  33. ,address = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.address#" />
  34. </cfif>
  35. <cfif len(arguments.city)>
  36. ,city = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.city#" />
  37. </cfif>
  38. <cfif len(arguments.state)>
  39. ,state = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.state#" />
  40. </cfif>
  41. <cfif len(arguments.postalcode)>
  42. ,postalcode = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.postalcode#" />
  43. </cfif>
  44. <cfif len(arguments.email)>
  45. ,email = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.email#" />
  46. </cfif>
  47. <cfif len(arguments.phone)>
  48. ,phone = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.phone#" />
  49. </cfif>
  50. <cfif len(arguments.fax)>
  51. ,fax = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.fax#" />
  52. </cfif>
  53. <cfif len(arguments.thepassword)>
  54. ,thepassword = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.thepassword#" />
  55. </cfif>
  56. where artistid = <cfqueryparam cfsqltype="cf_sql_numeric" value="#arguments.id#" />
  57. </cfquery>
  58. <cfreturn noData().withStatus(200) />
  59. </cffunction>
  60. <cffunction name="post" access="public" output="false">
  61. <cfargument name="firstname" type="string" required="false" default="" />
  62. <cfargument name="lastname" type="string" required="false" default="" />
  63. <cfargument name="address" type="string" required="false" default="" />
  64. <cfargument name="city" type="string" required="false" default="" />
  65. <cfargument name="state" type="string" required="false" default="" />
  66. <cfargument name="postalcode" type="string" required="false" default="" />
  67. <cfargument name="email" type="string" required="false" default="" />
  68. <cfargument name="phone" type="string" required="false" default="" />
  69. <cfargument name="fax" type="string" required="false" default="" />
  70. <cfargument name="thepassword" type="string" required="false" default="" />
  71. <cfset var q = "" />
  72. <cfquery name="q" datasource="cfartgallery">
  73. insert into artists (firstname,lastname,address,city,state,postalcode,email,phone,fax,thepassword)
  74. values (
  75. <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.firstname#" />
  76. ,<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.lastname#" />
  77. ,<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.address#" />
  78. ,<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.city#" />
  79. ,<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.state#" />
  80. ,<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.postalcode#" />
  81. ,<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.email#" />
  82. ,<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.phone#" />
  83. ,<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.fax#" />
  84. ,<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.thepassword#" />
  85. )
  86. </cfquery>
  87. <cfreturn noData().withStatus(201) />
  88. </cffunction>
  89. <cffunction name="delete" access="public" output="false">
  90. <cfargument name="id" type="numeric" required="true" />
  91. <cfset var q = "" />
  92. <cfquery name="q" datasource="cfartgallery">
  93. delete from artists where artistid = <cfqueryparam cfsqltype="cf_sql_numeric" value="#arguments.id#" />
  94. </cfquery>
  95. <cfreturn noData().withStatus(200) />
  96. </cffunction>
  97. </cfcomponent>