xref: /PHP-5.6/ext/oci8/tests/xmltype_01.phpt (revision 8c3bf960)
1--TEST--
2Basic XMLType test
3--SKIPIF--
4<?php
5if (!extension_loaded("simplexml")) die("skip no simplexml extension");
6$target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
7require(dirname(__FILE__).'/skipif.inc');
8?>
9--FILE--
10<?php
11
12require(dirname(__FILE__)."/connect.inc");
13
14// Initialization
15
16$stmtarray = array(
17	"drop table xtt",
18	"create table xtt
19		   (xt_id number, xt_spec xmltype)
20		   xmltype xt_spec store as clob",
21	"insert into xtt (xt_id, xt_spec) values
22	  (1,
23	   xmltype('<?xml version=\"1.0\"?>
24		<Xt>
25		  <XtId>1</XtId>
26		  <Size>Big</Size>
27		  <Area>12345</Area>
28		  <Hardness>20</Hardness>
29		  <Lip>Curved</Lip>
30		  <Color>Red</Color>
31		  <Nice>N</Nice>
32		  <Compact>Tiny</Compact>
33		  <Material>Steel</Material>
34		</Xt>'))"
35);
36
37oci8_test_sql_execute($c, $stmtarray);
38
39function do_query($c)
40{
41	$s = oci_parse($c, 'select XMLType.getClobVal(xt_spec)
42				        from xtt where xt_id = 1');
43	oci_execute($s);
44	$row = oci_fetch_row($s);
45	$data = $row[0]->load();
46	var_dump($data);
47	return($data);
48}
49
50// Check
51echo "Initial Data\n";
52$data = do_query($c);
53
54// Manipulate the data using SimpleXML
55$sx = simplexml_load_string($data);
56$sx->Hardness = $sx->Hardness - 1;
57$sx->Nice = 'Y';
58
59// Insert changes using a temporary CLOB
60$s = oci_parse($c, 'update xtt
61					set xt_spec = XMLType(:clob)
62					where xt_id = 1');
63$lob = oci_new_descriptor($c, OCI_D_LOB);
64oci_bind_by_name($s, ':clob', $lob, -1, OCI_B_CLOB);
65$lob->writeTemporary($sx->asXml());
66oci_execute($s);
67$lob->close();
68
69// Verify
70echo "Verify\n";
71$data = do_query($c);
72
73// Cleanup
74
75$stmtarray = array(
76	"drop table xtt",
77);
78
79oci8_test_sql_execute($c, $stmtarray);
80
81echo "Done\n";
82
83?>
84--EXPECT--
85Initial Data
86string(250) "<?xml version="1.0"?>
87		<Xt>
88		  <XtId>1</XtId>
89		  <Size>Big</Size>
90		  <Area>12345</Area>
91		  <Hardness>20</Hardness>
92		  <Lip>Curved</Lip>
93		  <Color>Red</Color>
94		  <Nice>N</Nice>
95		  <Compact>Tiny</Compact>
96		  <Material>Steel</Material>
97		</Xt>"
98Verify
99string(249) "<?xml version="1.0"?>
100<Xt>
101		  <XtId>1</XtId>
102		  <Size>Big</Size>
103		  <Area>12345</Area>
104		  <Hardness>19</Hardness>
105		  <Lip>Curved</Lip>
106		  <Color>Red</Color>
107		  <Nice>Y</Nice>
108		  <Compact>Tiny</Compact>
109		  <Material>Steel</Material>
110		</Xt>
111"
112Done
113