diff options
Diffstat (limited to 'src/interfaces/ecpg/test/expected/sql-quote.c')
| -rw-r--r-- | src/interfaces/ecpg/test/expected/sql-quote.c | 230 |
1 files changed, 230 insertions, 0 deletions
diff --git a/src/interfaces/ecpg/test/expected/sql-quote.c b/src/interfaces/ecpg/test/expected/sql-quote.c new file mode 100644 index 0000000..05841bd --- /dev/null +++ b/src/interfaces/ecpg/test/expected/sql-quote.c @@ -0,0 +1,230 @@ +/* Processed by ecpg (regression mode) */ +/* These include files are added by the preprocessor */ +#include <ecpglib.h> +#include <ecpgerrno.h> +#include <sqlca.h> +/* End of automatic include section */ +#define ECPGdebug(X,Y) ECPGdebug((X)+100,(Y)) + +#line 1 "quote.pgc" +#include <stdio.h> +#include <stdlib.h> +#include <string.h> + + +#line 1 "regression.h" + + + + + + +#line 5 "quote.pgc" + + +int main() { + /* exec sql begin declare section */ + + + +#line 9 "quote.pgc" + char var [ 25 ] ; + +#line 10 "quote.pgc" + int i , loopcount ; +/* exec sql end declare section */ +#line 11 "quote.pgc" + + + ECPGdebug(1, stderr); + { ECPGconnect(__LINE__, 0, "ecpg1_regression" , NULL, NULL , NULL, 0); } +#line 14 "quote.pgc" + + + { ECPGsetcommit(__LINE__, "on", NULL);} +#line 16 "quote.pgc" + + /* exec sql whenever sql_warning sqlprint ; */ +#line 17 "quote.pgc" + + /* exec sql whenever sqlerror stop ; */ +#line 18 "quote.pgc" + + + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "create table \"My_Table\" ( Item1 int , Item2 text )", ECPGt_EOIT, ECPGt_EORT); +#line 20 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 20 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 20 "quote.pgc" + + + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "set standard_conforming_strings to off", ECPGt_EOIT, ECPGt_EORT); +#line 22 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 22 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 22 "quote.pgc" + + + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "show standard_conforming_strings", ECPGt_EOIT, + ECPGt_char,(var),(long)25,(long)1,(25)*sizeof(char), + ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT); +#line 24 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 24 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 24 "quote.pgc" + + printf("Standard conforming strings: %s\n", var); + + /* this is a\\b actually */ + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into \"My_Table\" values ( 1 , 'a\\\\\\\\b' )", ECPGt_EOIT, ECPGt_EORT); +#line 28 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 28 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 28 "quote.pgc" + + /* this is a\\b */ + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into \"My_Table\" values ( 1 , E'a\\\\\\\\b' )", ECPGt_EOIT, ECPGt_EORT); +#line 30 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 30 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 30 "quote.pgc" + + + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "set standard_conforming_strings to on", ECPGt_EOIT, ECPGt_EORT); +#line 32 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 32 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 32 "quote.pgc" + + + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "show standard_conforming_strings", ECPGt_EOIT, + ECPGt_char,(var),(long)25,(long)1,(25)*sizeof(char), + ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT); +#line 34 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 34 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 34 "quote.pgc" + + printf("Standard conforming strings: %s\n", var); + + /* this is a\\\\b actually */ + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into \"My_Table\" values ( 2 , 'a\\\\\\\\b' )", ECPGt_EOIT, ECPGt_EORT); +#line 38 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 38 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 38 "quote.pgc" + + /* this is a\\b */ + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into \"My_Table\" values ( 2 , E'a\\\\\\\\b' )", ECPGt_EOIT, ECPGt_EORT); +#line 40 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 40 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 40 "quote.pgc" + + + { ECPGtrans(__LINE__, NULL, "begin"); +#line 42 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 42 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 42 "quote.pgc" + + /* declare C cursor for select * from \"My_Table\" */ +#line 43 "quote.pgc" + + + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "declare C cursor for select * from \"My_Table\"", ECPGt_EOIT, ECPGt_EORT); +#line 45 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 45 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 45 "quote.pgc" + + + /* exec sql whenever not found break ; */ +#line 47 "quote.pgc" + + + for (loopcount = 0; loopcount < 100; loopcount++) + { + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "fetch C", ECPGt_EOIT, + ECPGt_int,&(i),(long)1,(long)1,sizeof(int), + ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, + ECPGt_char,(var),(long)25,(long)1,(25)*sizeof(char), + ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT); +#line 51 "quote.pgc" + +if (sqlca.sqlcode == ECPG_NOT_FOUND) break; +#line 51 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 51 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 51 "quote.pgc" + + printf("value: %d %s\n", i, var); + } + + { ECPGtrans(__LINE__, NULL, "rollback"); +#line 55 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 55 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 55 "quote.pgc" + + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "drop table \"My_Table\"", ECPGt_EOIT, ECPGt_EORT); +#line 56 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 56 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 56 "quote.pgc" + + + { ECPGdisconnect(__LINE__, "ALL"); +#line 58 "quote.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 58 "quote.pgc" + +if (sqlca.sqlcode < 0) exit (1);} +#line 58 "quote.pgc" + + + return 0; +} |