#include <stdio.h>
#include "test.h"

EXEC SQL BEGIN DECLARE SECTION;
    char dbname[1024];
    char db[15];
    char usr[15];
    char pas[15];
    char insertStmt[100];
    char sqlStmt[100];
    int par_val;
EXEC SQL END DECLARE SECTION;

static void handle_error(void);
int main()
{

   EXEC SQL WHENEVER SQLERROR DO handle_error();
   ECPGdebug(1,stderr);
   strncpy(db,dbase,15);
   strncpy(usr,user,15);
   strncpy(pas,pass,15);
   EXEC SQL CONNECT TO :db AS con1  USER :usr USING :pas;

   /* strncpy(insertStmt,"INSERT INTO osoba VALUES(5, 'Adrian', 'Zawadzki')",50);

   EXEC SQL EXECUTE IMMEDIATE :insertStmt;
   EXEC SQL COMMIT;*/

   strncpy(sqlStmt,"SELECT id_uczestnik, imie, nazwisko FROM kurs.uczestnik WHERE id_uczestnik = ?", 50);
   EXEC SQL PREPARE s1 FROM :sqlStmt;
   par_val = 1; 
   EXEC SQL EXECUTE s1 INTO :id, :fname, :lname USING :par_val; 
   
   fprintf(stderr, "ok\n");
   return 0;
}


static void handle_error(void)
{
   fprintf(stderr, "%s\n", sqlca.sqlerrm.sqlerrmc);
   EXEC SQL WHENEVER SQLERROR CONTINUE;
   /* EXEC SQL ROLLBACK RELEASE; */
}