54{
55
56
57
58
59#line 22 "prepareas.pgc"
60 int ivar1 = 1 , ivar2 = 2 ;
61
62#line 23 "prepareas.pgc"
63 char v_include_dq_name [ 16 ] , v_include_ws_name [ 16 ] , v_normal_name [ 16 ] , v_query [ 64 ] ;
64
65#line 24 "prepareas.pgc"
66
67
68 strcpy(v_normal_name, "normal_name");
69 strcpy(v_include_dq_name, "include_\"_name");
70 strcpy(v_include_ws_name, "include_ _name");
71 strcpy(v_query, "insert into test values(?,?)");
72
73
74
75
76 {
ECPGconnect(__LINE__, 0,
"ecpg1_regression" , NULL, NULL , NULL, 0);
77#line 34 "prepareas.pgc"
78
80#line 34 "prepareas.pgc"
81
83#line 35 "prepareas.pgc"
84
86#line 35 "prepareas.pgc"
87
89#line 36 "prepareas.pgc"
90
92#line 36 "prepareas.pgc"
93
94 {
ECPGtrans(__LINE__, NULL,
"commit work");
95#line 37 "prepareas.pgc"
96
98#line 37 "prepareas.pgc"
99
101#line 38 "prepareas.pgc"
102
104#line 38 "prepareas.pgc"
105
106
107
108
109
111#line 43 "prepareas.pgc"
112
114#line 43 "prepareas.pgc"
115
116 printf(
"+++++ Test for prepnormal +++++\n");
117 printf(
"insert into test values(:ivar1,:ivar2)\n");
119 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
121 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
123#line 46 "prepareas.pgc"
124
126#line 46 "prepareas.pgc"
127
129
131#line 49 "prepareas.pgc"
132
134#line 49 "prepareas.pgc"
135
136 printf(
"+++++ Test for execute immediate +++++\n");
137 printf(
"execute immediate \"insert into test values(1,2)\"\n");
139#line 52 "prepareas.pgc"
140
142#line 52 "prepareas.pgc"
143
145
146
147
148
150#line 58 "prepareas.pgc"
151
153#line 58 "prepareas.pgc"
154
155 printf(
"+++++ Test for PREPARE ident FROM CString +++++\n");
156 printf(
"prepare ident_name from \"insert into test values(?,?)\"\n");
157 {
ECPGprepare(__LINE__, NULL, 0,
"ident_name",
"insert into test values(?,?)");
158#line 61 "prepareas.pgc"
159
161#line 61 "prepareas.pgc"
162
163 printf(
"execute ident_name using :ivar1,:ivar2\n");
165 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
167 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
169#line 63 "prepareas.pgc"
170
172#line 63 "prepareas.pgc"
173
175
177#line 66 "prepareas.pgc"
178
180#line 66 "prepareas.pgc"
181
182 printf(
"+++++ Test for PREPARE char_variable_normal_name FROM char_variable +++++\n");
183 printf(
"prepare :v_normal_name from :v_query\n");
184 {
ECPGprepare(__LINE__, NULL, 0, v_normal_name, v_query);
185#line 69 "prepareas.pgc"
186
188#line 69 "prepareas.pgc"
189
190 printf(
"execute :v_normal_name using :ivar1,:ivar2\n");
192 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
194 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
196#line 71 "prepareas.pgc"
197
199#line 71 "prepareas.pgc"
200
202
204#line 74 "prepareas.pgc"
205
207#line 74 "prepareas.pgc"
208
209 printf(
"+++++ Test for PREPARE char_variable_inc_dq_name FROM char_variable +++++\n");
210 printf(
"prepare :v_include_dq_name from :v_query\n");
211 {
ECPGprepare(__LINE__, NULL, 0, v_include_dq_name, v_query);
212#line 77 "prepareas.pgc"
213
215#line 77 "prepareas.pgc"
216
217 printf(
"execute :v_include_dq_name using :ivar1,:ivar2\n");
219 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
221 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
223#line 79 "prepareas.pgc"
224
226#line 79 "prepareas.pgc"
227
229
231#line 82 "prepareas.pgc"
232
234#line 82 "prepareas.pgc"
235
236 printf(
"+++++ Test for PREPARE char_variable_inc_ws_name FROM char_variable +++++\n");
237 printf(
"prepare :v_include_ws_name from :v_query\n");
238 {
ECPGprepare(__LINE__, NULL, 0, v_include_ws_name, v_query);
239#line 85 "prepareas.pgc"
240
242#line 85 "prepareas.pgc"
243
244 printf(
"execute :v_include_ws_name using :ivar1,:ivar2\n");
246 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
248 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
250#line 87 "prepareas.pgc"
251
253#line 87 "prepareas.pgc"
254
256
258#line 90 "prepareas.pgc"
259
261#line 90 "prepareas.pgc"
262
263 printf(
"+++++ Test for PREPARE CString_inc_ws_name FROM char_variable +++++\n");
264 printf(
"prepare \"include_ _name\" from :v_query\n");
265 {
ECPGprepare(__LINE__, NULL, 0,
"include_ _name", v_query);
266#line 93 "prepareas.pgc"
267
269#line 93 "prepareas.pgc"
270
271 printf(
"exec sql execute \"include_ _name\" using :ivar1,:ivar2\n");
273 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
275 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
277#line 95 "prepareas.pgc"
278
280#line 95 "prepareas.pgc"
281
283
285#line 98 "prepareas.pgc"
286
288#line 98 "prepareas.pgc"
289
290 printf(
"+++++ Test for PREPARE CString_normal_name FROM char_variable +++++\n");
291 printf(
"prepare \"norma_name\" from :v_query\n");
292 {
ECPGprepare(__LINE__, NULL, 0,
"normal_name", v_query);
293#line 101 "prepareas.pgc"
294
296#line 101 "prepareas.pgc"
297
298 printf(
"exec sql execute \"normal_name\" using :ivar1,:ivar2\n");
300 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
302 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
304#line 103 "prepareas.pgc"
305
307#line 103 "prepareas.pgc"
308
310
311
312
313
315#line 109 "prepareas.pgc"
316
318#line 109 "prepareas.pgc"
319
321#line 110 "prepareas.pgc"
322
324#line 110 "prepareas.pgc"
325
327#line 111 "prepareas.pgc"
328
330#line 111 "prepareas.pgc"
331
332
334#line 113 "prepareas.pgc"
335
337#line 113 "prepareas.pgc"
338
339 printf(
"+++++ Test for PREPARE ident(typelist) AS +++++\n");
340 printf(
"prepare ident_name(int,int) as insert into test values($1,$2)\n");
341 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_prepare,
"prepare $0 ( int , int ) as insert into test values ( $1 , $2 )",
342 ECPGt_const,
"ident_name",(
long)10,(
long)1,strlen(
"ident_name"),
344#line 116 "prepareas.pgc"
345
347#line 116 "prepareas.pgc"
348
349 printf(
"execute ident_name(:ivar1,:ivar2)\n");
351 ECPGt_const,
"ident_name",(
long)10,(
long)1,strlen(
"ident_name"),
353 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
355 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
357#line 118 "prepareas.pgc"
358
360#line 118 "prepareas.pgc"
361
364#line 120 "prepareas.pgc"
365
367#line 120 "prepareas.pgc"
368
369
371#line 122 "prepareas.pgc"
372
374#line 122 "prepareas.pgc"
375
376 printf(
"+++++ Test for PREPARE CString_normal_name(typelist) AS +++++\n");
377 printf(
"prepare \"normal_name\"(int,int) as insert into test values($1,$2)\n");
378 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_prepare,
"prepare $0 ( int , int ) as insert into test values ( $1 , $2 )",
379 ECPGt_const,
"normal_name",(
long)11,(
long)1,strlen(
"normal_name"),
381#line 125 "prepareas.pgc"
382
384#line 125 "prepareas.pgc"
385
386 printf(
"execute \"normal_name\"(:ivar1,:ivar2)\n");
388 ECPGt_const,
"normal_name",(
long)11,(
long)1,strlen(
"normal_name"),
390 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
392 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
394#line 127 "prepareas.pgc"
395
397#line 127 "prepareas.pgc"
398
401#line 129 "prepareas.pgc"
402
404#line 129 "prepareas.pgc"
405
406
408#line 131 "prepareas.pgc"
409
411#line 131 "prepareas.pgc"
412
413 printf(
"+++++ Test for PREPARE CString_include_ws_name(typelist) AS +++++\n");
414 printf(
"prepare \"include_ _name\"(int,int) as insert into test values($1,$2)\n");
415 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_prepare,
"prepare $0 ( int , int ) as insert into test values ( $1 , $2 )",
416 ECPGt_const,
"include_ _name",(
long)14,(
long)1,strlen(
"include_ _name"),
418#line 134 "prepareas.pgc"
419
421#line 134 "prepareas.pgc"
422
423 printf(
"execute \"include_ _name\"(:ivar1,:ivar2)\n");
425 ECPGt_const,
"include_ _name",(
long)14,(
long)1,strlen(
"include_ _name"),
427 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
429 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
431#line 136 "prepareas.pgc"
432
434#line 136 "prepareas.pgc"
435
438#line 138 "prepareas.pgc"
439
441#line 138 "prepareas.pgc"
442
443
445#line 140 "prepareas.pgc"
446
448#line 140 "prepareas.pgc"
449
450 printf(
"+++++ Test for PREPARE char_variable_normal_name(typelist) AS +++++\n");
451 printf(
"prepare :v_normal_name(int,int) as insert into test values($1,$2)\n");
452 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_prepare,
"prepare $0 ( int , int ) as insert into test values ( $1 , $2 )",
453 ECPGt_char,(v_normal_name),(
long)16,(
long)1,(16)*
sizeof(
char),
455#line 143 "prepareas.pgc"
456
458#line 143 "prepareas.pgc"
459
460 printf(
"execute :v_normal_name(:ivar1,:ivar2)\n");
462 ECPGt_char,(v_normal_name),(
long)16,(
long)1,(16)*
sizeof(
char),
464 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
466 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
468#line 145 "prepareas.pgc"
469
471#line 145 "prepareas.pgc"
472
475#line 147 "prepareas.pgc"
476
478#line 147 "prepareas.pgc"
479
480
482#line 149 "prepareas.pgc"
483
485#line 149 "prepareas.pgc"
486
487 printf(
"+++++ Test for PREPARE char_variable_include_ws_name(typelist) AS +++++\n");
488 printf(
"prepare :v_include_ws_name(int,int) as insert into test values($1,$2)\n");
489 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_prepare,
"prepare $0 ( int , int ) as insert into test values ( $1 , $2 )",
490 ECPGt_char,(v_include_ws_name),(
long)16,(
long)1,(16)*
sizeof(
char),
492#line 152 "prepareas.pgc"
493
495#line 152 "prepareas.pgc"
496
497 printf(
"execute :v_include_ws_name(:ivar1,:ivar2)\n");
499 ECPGt_char,(v_include_ws_name),(
long)16,(
long)1,(16)*
sizeof(
char),
501 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
503 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
505#line 154 "prepareas.pgc"
506
508#line 154 "prepareas.pgc"
509
512#line 156 "prepareas.pgc"
513
515#line 156 "prepareas.pgc"
516
517
519#line 158 "prepareas.pgc"
520
522#line 158 "prepareas.pgc"
523
524 printf(
"+++++ Test for EXECUTE :v_normal_name(const,const) +++++\n");
525 printf(
"prepare :v_normal_name from :v_query\n");
526 {
ECPGprepare(__LINE__, NULL, 0, v_normal_name, v_query);
527#line 161 "prepareas.pgc"
528
530#line 161 "prepareas.pgc"
531
532 printf(
"execute :v_normal_name(1,2)\n");
534 ECPGt_char,(v_normal_name),(
long)16,(
long)1,(16)*
sizeof(
char),
536#line 163 "prepareas.pgc"
537
539#line 163 "prepareas.pgc"
540
543#line 165 "prepareas.pgc"
544
546#line 165 "prepareas.pgc"
547
548
550#line 167 "prepareas.pgc"
551
553#line 167 "prepareas.pgc"
554
555 printf(
"+++++ Test for EXECUTE :v_normal_name(expr,expr) +++++\n");
556 printf(
"prepare :v_normal_name from :v_query\n");
557 {
ECPGprepare(__LINE__, NULL, 0, v_normal_name, v_query);
558#line 170 "prepareas.pgc"
559
561#line 170 "prepareas.pgc"
562
563 printf(
"execute :v_normal_name(0+1,1+1)\n");
565 ECPGt_char,(v_normal_name),(
long)16,(
long)1,(16)*
sizeof(
char),
567#line 172 "prepareas.pgc"
568
570#line 172 "prepareas.pgc"
571
574#line 174 "prepareas.pgc"
575
577#line 174 "prepareas.pgc"
578
579
581#line 176 "prepareas.pgc"
582
584#line 176 "prepareas.pgc"
585
586 printf(
"+++++ Test for combination PREPARE FROM and EXECUTE ident(typelist) +++++\n");
587 printf(
"prepare ident_name from :v_query\n");
588 {
ECPGprepare(__LINE__, NULL, 0,
"ident_name", v_query);
589#line 179 "prepareas.pgc"
590
592#line 179 "prepareas.pgc"
593
594 printf(
"execute ident_name(:ivar1,:ivar2)\n");
596 ECPGt_const,
"ident_name",(
long)10,(
long)1,strlen(
"ident_name"),
598 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
600 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
602#line 181 "prepareas.pgc"
603
605#line 181 "prepareas.pgc"
606
609#line 183 "prepareas.pgc"
610
612#line 183 "prepareas.pgc"
613
614
616#line 185 "prepareas.pgc"
617
619#line 185 "prepareas.pgc"
620
621 printf(
"+++++ Test for combination PREPARE FROM and EXECUTE CString_include_ws_name(typelist) +++++\n");
622 printf(
"prepare \"include_ _name\" from :v_query\n");
623 {
ECPGprepare(__LINE__, NULL, 0,
"include_ _name", v_query);
624#line 188 "prepareas.pgc"
625
627#line 188 "prepareas.pgc"
628
629 printf(
"execute \"include_ _name\"(:ivar1,:ivar2)\n");
631 ECPGt_const,
"include_ _name",(
long)14,(
long)1,strlen(
"include_ _name"),
633 ECPGt_int,&(ivar1),(
long)1,(
long)1,
sizeof(
int),
635 ECPGt_int,&(ivar2),(
long)1,(
long)1,
sizeof(
int),
637#line 190 "prepareas.pgc"
638
640#line 190 "prepareas.pgc"
641
644#line 192 "prepareas.pgc"
645
647#line 192 "prepareas.pgc"
648
649
651#line 194 "prepareas.pgc"
652
654#line 194 "prepareas.pgc"
655
656 {
ECPGtrans(__LINE__, NULL,
"commit work");
657#line 195 "prepareas.pgc"
658
660#line 195 "prepareas.pgc"
661
662
663 return 0;
664}
bool ECPGconnect(int lineno, int c, const char *name, const char *user, const char *passwd, const char *connection_name, int autocommit)
@ ECPGst_exec_with_exprlist
bool ECPGtrans(int lineno, const char *connection_name, const char *transaction)
bool ECPGprepare(int lineno, const char *connection_name, const bool questionmarks, const char *name, const char *variable)
bool ECPGdeallocate(int lineno, int c, const char *connection_name, const char *name)
static void check_result_of_insert(void)