Merge pull request #2 from mooreds/issue_32_put_breaks_on_escaped_chars

restsql · restsql · commit efc8a597a36d · 2013-03-04T18:02:19.000-08:00
test case that illuminates issue 32
diff --git a/src/resources/xml/service/testcase/json/TestUpdate_SingleTable_SingleRow_ByBody_Escaped_Chars.xml b/src/resources/xml/service/testcase/json/TestUpdate_SingleTable_SingleRow_ByBody_Escaped_Chars.xml
@@ -0,0 +1,47 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<tc:testcase xmlns:tc="http://restsql.org/schema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+	xsi:schemaLocation="http://restsql.org/schema ServiceTestCaseDefinition.xsd ">
+	<setup>
+		<sql>INSERT INTO actor (actor_id,first_name,last_name) VALUES (1000,'John','Smith')</sql>
+		<sql>INSERT INTO actor (actor_id,first_name,last_name) VALUES (1001,'Sally','Johnson')</sql>
+	</setup>
+	<step name="execute">
+		<request method="PUT" uri="res/SingleTable" contentType="application/json" accept="application/xml">
+			<body>
+<![CDATA[
+{ "actors": [
+		{ "id": "1000", "first_name": "_Jack", "surname": "%3CDaniels" },
+		{ "id": "1001", "first_name": "_Jack", "surname": "Smith" }
+	]
+}
+]]>
+			</body>
+		</request>
+		<response>
+			<body>
+<![CDATA[
+<writeResponse rowsAffected="2" />
+]]>
+			</body>
+		</response>
+	</step>
+
+	<step name="verify">
+		<request method="GET" uri="res/SingleTable?first_name=_Jack" accept="application/json" />
+		<response>
+			<body>
+<![CDATA[
+{ "actors": [
+		{ "id": 1000, "first_name": "_Jack", "surname": "%3CDaniels" },
+		{ "id": 1001, "first_name": "_Jack", "surname": "Smith" }
+	]
+}
+]]>
+			</body>
+		</response>
+	</step>
+
+	<teardown>
+		<sql>DELETE FROM actor where actor_id between 1000 and 1100</sql>
+	</teardown>
+</tc:testcase>
