connect-test6.c File Reference

#include <ecpglib.h>
#include <ecpgerrno.h>
#include <sqlca.h>
#include <stdlib.h>
#include <string.h>
#include <stdio.h>

Include dependency graph for connect-test6.c:

Go to the source code of this file.

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

Functions
int	main (void)

Macro Definition Documentation

ECPGdebug

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

Definition at line 7 of file connect-test6.c.

Function Documentation

main()

int main

(

void

)

Definition at line 32 of file connect-test6.c.

{
/* exec sql begin declare section */
       
       
       
       
 
#line 17 "test6.pgc"
 int val1output = 2 ;
 
#line 18 "test6.pgc"
 int val1 = 1 ;
 
#line 19 "test6.pgc"
 char val2 [ 6 ] = "data1" ;
 
#line 20 "test6.pgc"
 char * stmt1 = "SELECT * from test1 where a = $1 and b = $2" ;
/* exec sql end declare section */
#line 21 "test6.pgc"
 
 
    ECPGdebug(1, stderr);
 
    /* Connect to the database */
    { ECPGconnect(__LINE__, 0, "ecpg1_regression" , NULL, NULL , "myconn", 0); }
#line 26 "test6.pgc"
 
 
    /* Test 1: Try to get descriptor on a disconnected connection */
    printf("Test 1: Try to get descriptor on a disconnected connection\n");
    { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "create table test1 ( a int , b text )", ECPGt_EOIT, ECPGt_EORT);}
#line 30 "test6.pgc"
 
    { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into test1 ( a , b ) values ( 1 , 'data1' )", ECPGt_EOIT, ECPGt_EORT);}
#line 31 "test6.pgc"
 
 
    ECPGallocate_desc(__LINE__, "indesc");
#line 33 "test6.pgc"
 
    ECPGallocate_desc(__LINE__, "outdesc");
#line 34 "test6.pgc"
 
 
    { ECPGprepare(__LINE__, NULL, 0, "foo2", stmt1);}
#line 36 "test6.pgc"
 
 
    { ECPGset_desc(__LINE__, "indesc", 1,ECPGd_data,
    ECPGt_int,&(val1),(long)1,(long)1,sizeof(int), ECPGd_EODT);
}
#line 38 "test6.pgc"
 
    { ECPGset_desc(__LINE__, "indesc", 2,ECPGd_data,
    ECPGt_char,(val2),(long)6,(long)1,(6)*sizeof(char), ECPGd_EODT);
}
#line 39 "test6.pgc"
 
 
    { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_execute, "foo2", 
    ECPGt_descriptor, "indesc", 1L, 1L, 1L, 
    ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, 
    ECPGt_descriptor, "outdesc", 1L, 1L, 1L, 
    ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT);}
#line 41 "test6.pgc"
 
 
    { ECPGtrans(__LINE__, NULL, "rollback");}
#line 43 "test6.pgc"
 
    { ECPGdisconnect(__LINE__, "CURRENT");}
#line 44 "test6.pgc"
 
    { ECPGget_desc(__LINE__, "outdesc", 1,ECPGd_data,
    ECPGt_int,&(val1output),(long)1,(long)1,sizeof(int), ECPGd_EODT);
}
#line 45 "test6.pgc"
 
    printf("sqlca.sqlcode = %ld\n", sqlca.sqlcode);
 
    /* Test 2: Try to deallocate all on a non-existent connection */
    printf("Test 2: deallocate all with non-existent connection\n");
    { ECPGdeallocate_all(__LINE__, 0, "nonexistent");}
#line 50 "test6.pgc"
 
    printf("sqlca.sqlcode = %ld\n", sqlca.sqlcode);
 
    /* Test 3: deallocate on disconnected connection */
    printf("Test 3: deallocate all on disconnected connection\n");
    { ECPGdeallocate_all(__LINE__, 0, NULL);}
#line 55 "test6.pgc"
 
    printf("sqlca.sqlcode = %ld\n", sqlca.sqlcode);
 
    /* Test 4: Use prepared statement from non-existent connection */
    printf("Test 4: Use prepared statement from non-existent connection\n");
    { ECPGprepare(__LINE__, "nonexistent", 0, "stmt1", "SELECT 1");}
#line 60 "test6.pgc"
 
    /* declare cur1 cursor for $1 */
#line 61 "test6.pgc"
 
    { ECPGdo(__LINE__, 0, 1, "nonexistent", 0, ECPGst_normal, "declare cur1 cursor for $1", 
    ECPGt_char_variable,(ECPGprepared_statement("nonexistent", "stmt1", __LINE__)),(long)1,(long)1,(1)*sizeof(char), 
    ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, ECPGt_EORT);}
#line 62 "test6.pgc"
 
    printf("sqlca.sqlcode = %ld\n", sqlca.sqlcode);
 
    printf("All tests completed !\n");
 
    return 0;
}

References ECPGallocate_desc(), ECPGconnect(), ECPGd_data, ECPGd_EODT, ECPGdeallocate_all(), ECPGdebug, ECPGdisconnect(), ECPGdo(), ECPGget_desc(), ECPGprepare(), ECPGprepared_statement(), ECPGset_desc(), ECPGst_execute, ECPGst_normal, ECPGt_char, ECPGt_char_variable, ECPGt_descriptor, ECPGt_EOIT, ECPGt_EORT, ECPGt_int, ECPGt_NO_INDICATOR, ECPGtrans(), fb(), printf, and sqlca.