PostgreSQL Source Code git master
Loading...
Searching...
No Matches
Data Structures | Macros | Functions
sql-dynalloc2.c File Reference
#include <ecpglib.h>
#include <ecpgerrno.h>
#include <sqlca.h>
#include <stdio.h>
#include <stdlib.h>
Include dependency graph for sql-dynalloc2.c:

Go to the source code of this file.

Data Structures

struct  sqlca_t
 

Macros

#define ECPGdebug(X, Y)   ECPGdebug((X)+100,(Y))
 
#define POSTGRES_SQLCA_H
 
#define PGDLLIMPORT
 
#define SQLERRMC_LEN   150
 
#define sqlca   (*ECPGget_sqlca())
 

Functions

struct sqlca_t * ECPGget_sqlca (void)
 
int main (void)
 

Macro Definition Documentation

◆ ECPGdebug

#define ECPGdebug (   X,
  Y 
)    ECPGdebug((X)+100,(Y))

Definition at line 7 of file sql-dynalloc2.c.

◆ PGDLLIMPORT

#define PGDLLIMPORT

Definition at line 20 of file sql-dynalloc2.c.

◆ POSTGRES_SQLCA_H

#define POSTGRES_SQLCA_H

Definition at line 14 of file sql-dynalloc2.c.

◆ sqlca

#define sqlca   (*ECPGget_sqlca())

Definition at line 71 of file sql-dynalloc2.c.

◆ SQLERRMC_LEN

#define SQLERRMC_LEN   150

Definition at line 24 of file sql-dynalloc2.c.

Function Documentation

◆ ECPGget_sqlca()

struct sqlca_t * ECPGget_sqlca ( void  )

Definition at line 108 of file misc.c.

109{
110 struct sqlca_t *sqlca;
111
112 pthread_once(&sqlca_key_once, ecpg_sqlca_key_init);
113
114 sqlca = pthread_getspecific(sqlca_key);
115 if (sqlca == NULL)
116 {
117 sqlca = malloc(sizeof(struct sqlca_t));
118 if (sqlca == NULL)
119 return NULL;
120 ecpg_init_sqlca(sqlca);
121 pthread_setspecific(sqlca_key, sqlca);
122 }
123 return sqlca;
124}
sqlca_key
static pthread_key_t sqlca_key
Definition misc.c:58
ecpg_init_sqlca
void ecpg_init_sqlca(struct sqlca_t *sqlca)
Definition misc.c:67
ecpg_sqlca_key_init
static void ecpg_sqlca_key_init(void)
Definition misc.c:102
sqlca_key_once
static pthread_once_t sqlca_key_once
Definition misc.c:59
fb
static int fb(int x)
Definition preproc-init.c:92
pthread_setspecific
void pthread_setspecific(pthread_key_t key, void *val)
Definition pthread-win32.c:24
pthread_getspecific
void * pthread_getspecific(pthread_key_t key)
Definition pthread-win32.c:29
malloc
#define malloc(a)
Definition snowball_runtime.h:50
sqlca
#define sqlca
Definition sqlca.h:59
sqlca_t
Definition sqlca.h:20

◆ main()

int main ( void  )

Definition at line 94 of file sql-dynalloc2.c.

95{
96 /* exec sql begin declare section */
97
98
99
100
101
102
103#line 9 "dynalloc2.pgc"
104 int * ip1 = 0 ;
105
106#line 10 "dynalloc2.pgc"
107 char ** cp2 = 0 ;
108
109#line 11 "dynalloc2.pgc"
110 int * ipointer1 = 0 ;
111
112#line 12 "dynalloc2.pgc"
113 int * ipointer2 = 0 ;
114
115#line 13 "dynalloc2.pgc"
116 int colnum ;
117/* exec sql end declare section */
118#line 14 "dynalloc2.pgc"
119
120 int i;
121
122 ECPGdebug(1, stderr);
123
124 /* exec sql whenever sqlerror do sqlprint ( ) ; */
125#line 19 "dynalloc2.pgc"
126
127 { ECPGconnect(__LINE__, 0, "ecpg1_regression" , NULL, NULL , NULL, 0);
128#line 20 "dynalloc2.pgc"
129
130if (sqlca.sqlcode < 0) sqlprint ( );}
131#line 20 "dynalloc2.pgc"
132
133
134 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "set datestyle to postgres", ECPGt_EOIT, ECPGt_EORT);
135#line 22 "dynalloc2.pgc"
136
137if (sqlca.sqlcode < 0) sqlprint ( );}
138#line 22 "dynalloc2.pgc"
139
140
141 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "create table test ( a int , b text )", ECPGt_EOIT, ECPGt_EORT);
142#line 24 "dynalloc2.pgc"
143
144if (sqlca.sqlcode < 0) sqlprint ( );}
145#line 24 "dynalloc2.pgc"
146
147 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into test values ( 1 , 'one' )", ECPGt_EOIT, ECPGt_EORT);
148#line 25 "dynalloc2.pgc"
149
150if (sqlca.sqlcode < 0) sqlprint ( );}
151#line 25 "dynalloc2.pgc"
152
153 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into test values ( 2 , 'two' )", ECPGt_EOIT, ECPGt_EORT);
154#line 26 "dynalloc2.pgc"
155
156if (sqlca.sqlcode < 0) sqlprint ( );}
157#line 26 "dynalloc2.pgc"
158
159 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into test values ( null , 'three' )", ECPGt_EOIT, ECPGt_EORT);
160#line 27 "dynalloc2.pgc"
161
162if (sqlca.sqlcode < 0) sqlprint ( );}
163#line 27 "dynalloc2.pgc"
164
165 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into test values ( 4 , 'four' )", ECPGt_EOIT, ECPGt_EORT);
166#line 28 "dynalloc2.pgc"
167
168if (sqlca.sqlcode < 0) sqlprint ( );}
169#line 28 "dynalloc2.pgc"
170
171 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into test values ( 5 , null )", ECPGt_EOIT, ECPGt_EORT);
172#line 29 "dynalloc2.pgc"
173
174if (sqlca.sqlcode < 0) sqlprint ( );}
175#line 29 "dynalloc2.pgc"
176
177 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into test values ( null , null )", ECPGt_EOIT, ECPGt_EORT);
178#line 30 "dynalloc2.pgc"
179
180if (sqlca.sqlcode < 0) sqlprint ( );}
181#line 30 "dynalloc2.pgc"
182
183
184 ECPGallocate_desc(__LINE__, "mydesc");
185#line 32 "dynalloc2.pgc"
186
187if (sqlca.sqlcode < 0) sqlprint ( );
188#line 32 "dynalloc2.pgc"
189
190 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "select * from test", ECPGt_EOIT,
191 ECPGt_descriptor, "mydesc", 1L, 1L, 1L,
192 ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT);
193#line 33 "dynalloc2.pgc"
194
195if (sqlca.sqlcode < 0) sqlprint ( );}
196#line 33 "dynalloc2.pgc"
197
198 { ECPGget_desc_header(__LINE__, "mydesc", &(colnum));
199
200#line 34 "dynalloc2.pgc"
201
202if (sqlca.sqlcode < 0) sqlprint ( );}
203#line 34 "dynalloc2.pgc"
204
205 { ECPGget_desc(__LINE__, "mydesc", 1,ECPGd_indicator,
206 ECPGt_int,&(ipointer1),(long)1,(long)0,sizeof(int), ECPGd_data,
207 ECPGt_int,&(ip1),(long)1,(long)0,sizeof(int), ECPGd_EODT);
208
209#line 35 "dynalloc2.pgc"
210
211if (sqlca.sqlcode < 0) sqlprint ( );}
212#line 35 "dynalloc2.pgc"
213
214 { ECPGget_desc(__LINE__, "mydesc", 2,ECPGd_indicator,
215 ECPGt_int,&(ipointer2),(long)1,(long)0,sizeof(int), ECPGd_data,
216 ECPGt_char,&(cp2),(long)0,(long)0,(1)*sizeof(char), ECPGd_EODT);
217
218#line 36 "dynalloc2.pgc"
219
220if (sqlca.sqlcode < 0) sqlprint ( );}
221#line 36 "dynalloc2.pgc"
222
223
224 printf("Result (%d columns):\n", colnum);
225 for (i=0;i < sqlca.sqlerrd[2];++i)
226 {
227 if (ipointer1[i]) printf("NULL, ");
228 else printf("%d, ",ip1[i]);
229
230 if (ipointer2[i]) printf("NULL, ");
231 else printf("'%s', ",cp2[i]);
232 printf("\n");
233 }
234 ECPGfree_auto_mem();
235 printf("\n");
236
237 ECPGdeallocate_desc(__LINE__, "mydesc");
238#line 51 "dynalloc2.pgc"
239
240if (sqlca.sqlcode < 0) sqlprint ( );
241#line 51 "dynalloc2.pgc"
242
243 { ECPGtrans(__LINE__, NULL, "rollback");
244#line 52 "dynalloc2.pgc"
245
246if (sqlca.sqlcode < 0) sqlprint ( );}
247#line 52 "dynalloc2.pgc"
248
249 { ECPGdisconnect(__LINE__, "CURRENT");
250#line 53 "dynalloc2.pgc"
251
252if (sqlca.sqlcode < 0) sqlprint ( );}
253#line 53 "dynalloc2.pgc"
254
255 return 0;
256}
ECPGdisconnect
bool ECPGdisconnect(int lineno, const char *connection_name)
Definition connect.c:693
ECPGconnect
bool ECPGconnect(int lineno, int c, const char *name, const char *user, const char *passwd, const char *connection_name, int autocommit)
Definition connect.c:260
ECPGdeallocate_desc
bool ECPGdeallocate_desc(int line, const char *name)
Definition descriptor.c:756
ECPGget_desc
bool ECPGget_desc(int lineno, const char *desc_name, int index,...)
Definition descriptor.c:234
ECPGallocate_desc
bool ECPGallocate_desc(int line, const char *name)
Definition descriptor.c:800
ECPGget_desc_header
bool ECPGget_desc_header(int lineno, const char *desc_name, int *count)
Definition descriptor.c:84
ECPGst_normal
@ ECPGst_normal
Definition ecpgtype.h:97
ECPGt_EOIT
@ ECPGt_EOIT
Definition ecpgtype.h:62
ECPGt_int
@ ECPGt_int
Definition ecpgtype.h:44
ECPGt_NO_INDICATOR
@ ECPGt_NO_INDICATOR
Definition ecpgtype.h:64
ECPGt_EORT
@ ECPGt_EORT
Definition ecpgtype.h:63
ECPGt_descriptor
@ ECPGt_descriptor
Definition ecpgtype.h:59
ECPGt_char
@ ECPGt_char
Definition ecpgtype.h:43
ECPGd_indicator
@ ECPGd_indicator
Definition ecpgtype.h:77
ECPGd_EODT
@ ECPGd_EODT
Definition ecpgtype.h:88
ECPGd_data
@ ECPGd_data
Definition ecpgtype.h:74
sqlprint
void sqlprint(void)
Definition error.c:334
ECPGdo
bool ECPGdo(const int lineno, const int compat, const int force_indicator, const char *connection_name, const bool questionmarks, const int st, const char *query,...)
Definition execute.c:2291
ECPGtrans
bool ECPGtrans(int lineno, const char *connection_name, const char *transaction)
Definition misc.c:160
i
int i
Definition isn.c:77
ECPGfree_auto_mem
void ECPGfree_auto_mem(void)
Definition memory.c:140
printf
#define printf(...)
Definition port.h:266
sqlca
#define sqlca
Definition sql-dynalloc2.c:71
ECPGdebug
#define ECPGdebug(X, Y)
Definition sql-dynalloc2.c:7

References ECPGallocate_desc(), ECPGconnect(), ECPGd_data, ECPGd_EODT, ECPGd_indicator, ECPGdeallocate_desc(), ECPGdebug, ECPGdisconnect(), ECPGdo(), ECPGfree_auto_mem(), ECPGget_desc(), ECPGget_desc_header(), ECPGst_normal, ECPGt_char, ECPGt_descriptor, ECPGt_EOIT, ECPGt_EORT, ECPGt_int, ECPGt_NO_INDICATOR, ECPGtrans(), fb(), i, printf, sqlca, and sqlprint().