xref: /PHP-5.6/ext/interbase/tests/005.phpt (revision 4dc99457)
1--TEST--
2InterBase: transactions
3--SKIPIF--
4<?php include("skipif.inc"); ?>
5--FILE--
6<?php /* $Id$ */
7
8    require("interbase.inc");
9
10    ibase_connect($test_base);
11
12    @ibase_query("create table test5 (i integer)");
13    @ibase_query("delete from test5");
14    ibase_close();
15
16
17    echo "default transaction:\n";
18
19/*
20Difference between default and other transactions:
21default committed when you call  ibase_close().
22Other transaction doing rollback.
23
24If you not open default transaction with
25ibase_trans, default transaction open
26when you call ibase_query(), ibase_prepare(),
27ibase_blob_create(), ibase_blob_import()  first time.
28*/
29
30/*
31simple default transaction test without ibase_trans()
32*/
33
34    ibase_connect($test_base);
35
36    echo "empty table\n";
37
38	/*  out_table call ibase_query()
39      and ibase_query() start default transaction */
40    out_table("test5");
41
42    /* in default transaction context */
43    ibase_query("insert into test5 (i) values (1)");
44
45    echo "one row\n";
46    out_table("test5");
47
48    ibase_rollback(); /* default rolled */
49
50    echo "after rollback table empty again\n";
51    out_table("test5");  /* started new default transaction */
52
53    ibase_query("insert into test5 (i) values (2)");
54
55    ibase_close(); /* commit here! */
56
57    ibase_connect($test_base);
58
59    echo "one row\n";
60    out_table("test5");
61    ibase_close();
62
63/*
64default transaction on default link
65First open transaction on link will be default.
66$tr_def_l1 may be omitted. All queryes without link and trans
67parameters run in this context
68*/
69
70    $link_def = ibase_connect($test_base);
71
72    $tr_def_l1 = ibase_trans(IBASE_READ); /* here transaction start */
73
74    /* all default */
75	$res = ibase_query("select * from test5");
76
77    echo "one row\n";
78    out_result($res,"test5");
79
80    ibase_free_result($res);
81
82    /* specify transaction context...  */
83	$res = ibase_query($tr_def_l1, "select * from test5");
84
85    echo "one row... again.\n";
86    out_result($res,"test5");
87
88    ibase_free_result($res);
89
90    /* specify default transaction on link  */
91	$res = ibase_query($link_def, "select * from test5");
92
93    echo "one row.\n";
94    out_result($res,"test5");
95
96    ibase_free_result($res);
97
98    ibase_rollback($link_def); /* just for example */
99
100    ibase_close();
101
102/*
103three transaction on default link
104*/
105    ibase_connect($test_base);
106
107	$res = ibase_query("select * from test5");
108
109    echo "one row\n";
110    out_result($res,"test5");
111
112    ibase_free_result($res);
113
114	$tr_1 = ibase_query("SET TRANSACTION");
115	$tr_2 = ibase_query("SET TRANSACTION READ ONLY");
116	$tr_3 = ibase_trans(IBASE_READ+IBASE_COMMITTED+IBASE_REC_VERSION+IBASE_WAIT);
117	$tr_4 = ibase_trans(IBASE_READ+IBASE_COMMITTED+IBASE_REC_NO_VERSION+IBASE_NOWAIT);
118
119    /* insert in first transaction context...  */
120    /* as default */
121    ibase_query("insert into test5 (i) values (3)");
122    /* specify context */
123    ibase_query($tr_1, "insert into test5 (i) values (4)");
124
125	$res = ibase_query("select * from test5");
126
127    echo "two rows\n";
128    out_result($res,"test5");
129
130    ibase_free_result($res);
131
132	$res = ibase_query($tr_1, "select * from test5");
133
134    echo "two rows again\n";
135    out_result($res,"test5");
136
137    ibase_free_result($res);
138
139	ibase_commit();
140    ibase_commit($tr_1);
141
142	$tr_1 = ibase_trans();
143  	 ibase_query($tr_1, "insert into test5 (i) values (5)");
144
145	/* tr_2 is IBASE_READ + IBASE_CONCURRENCY + IBASE_WAIT */
146	$res = ibase_query($tr_2, "select * from test5");
147
148    echo "one row in second transaction\n";
149    out_result($res,"test5");
150
151    ibase_free_result($res);
152
153	/* tr_3 is IBASE_COMMITTED + IBASE_REC_VERSION + IBASE_WAIT */
154	$res = ibase_query($tr_3, "select * from test5");
155
156    echo "three rows in third transaction\n";
157    out_result($res,"test5");
158
159    ibase_free_result($res);
160
161 	/* tr_4 IBASE_COMMITTED + IBASE_REC_NO_VERSION + IBASE_NOWAIT */
162 	$res = ibase_query($tr_4, "select * from test5");
163
164 	 echo "three rows in fourth transaction with deadlock\n";
165    out_result_trap_error($res,"test5");
166
167    ibase_free_result($res);
168
169	 ibase_rollback($tr_1);
170    ibase_close();
171/*
172transactions on second link
173*/
174    $link_1 = ibase_pconnect($test_base);
175    $link_2 = ibase_pconnect($test_base);
176
177	$tr_1 = ibase_trans(IBASE_DEFAULT, $link_2);  /* this default transaction also */
178	$tr_2 = ibase_trans(IBASE_COMMITTED, $link_2);
179
180	$res = ibase_query($tr_1, "select * from test5");
181
182    echo "three rows\n";
183    out_result($res,"test5");
184
185    ibase_free_result($res);
186
187    ibase_query($tr_1, "insert into test5 (i) values (5)");
188
189	$res = ibase_query($tr_1, "select * from test5");
190
191    echo "four rows\n";
192    out_result($res,"test5");
193
194    ibase_free_result($res);
195
196    ibase_commit($tr_1);
197
198	$res = ibase_query($tr_2, "select * from test5");
199
200    echo "four rows again\n";
201    out_result($res,"test5");
202
203    ibase_free_result($res);
204
205    ibase_close($link_1);
206    ibase_close($link_2);
207
208    echo "end of test\n";
209?>
210--EXPECT--
211default transaction:
212empty table
213--- test5 ---
214---
215one row
216--- test5 ---
2171
218---
219after rollback table empty again
220--- test5 ---
221---
222one row
223--- test5 ---
2242
225---
226one row
227--- test5 ---
2282
229---
230one row... again.
231--- test5 ---
2322
233---
234one row.
235--- test5 ---
2362
237---
238one row
239--- test5 ---
2402
241---
242two rows
243--- test5 ---
2442
2453
246---
247two rows again
248--- test5 ---
2492
2504
251---
252one row in second transaction
253--- test5 ---
2542
255---
256three rows in third transaction
257--- test5 ---
2582
2593
2604
261---
262three rows in fourth transaction with deadlock
263--- test5 ---
2642
2653
2664
267errmsg [lock conflict on no wait transaction deadlock ]
268---
269three rows
270--- test5 ---
2712
2723
2734
274---
275four rows
276--- test5 ---
2772
2783
2794
2805
281---
282four rows again
283--- test5 ---
2842
2853
2864
2875
288---
289end of test
290
291