Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C 1.03 KB | None | 0 0
  1. int main(int argc, char *argv[]){
  2.   FILE *file = fopen(argv[1], "r");
  3.   FILE *final = fopen(argv[argc-1], "w");
  4.   char conninfo[200] = { "\0" };
  5.   createConnInfo(conninfo);
  6.   PGconn *conn = PQconnectdb(conninfo);
  7.   if (!showLog(conn)){
  8.     return 1;
  9.   };
  10.   char tableName[50] = { "\0" };
  11.   createTableName(argv[1], tableName);
  12.   char dropTableCommand[200] = { "\0" };
  13.   dropTable(tableName, dropTableCommand);
  14.   char createTableCommand[1000] = { "\0" };
  15.   createTable(file, tableName, createTableCommand);
  16.   char selectTableCommand[200] = { "\0" };
  17.   selectTable(tableName, selectTableCommand);
  18.   switch(argc){
  19.     case ZERO:ONE:THREE:
  20.     break;
  21.     case CREATE_TABLE:
  22.       doSQL(conn, dropTableCommand);
  23.       doSQL(conn, createTableCommand);
  24.       insert(conn, file, tableName);
  25.       doSQL(conn, selectTableCommand);
  26.     break;
  27.     case PRINT_HTML:
  28.       openHTML(final);
  29.       PQPrint(conn, final, argv[argc-2]);
  30.       closeHTML(final);
  31.     break;
  32.     default:
  33.     break;
  34.   }
  35.   PQfinish(conn);
  36.   return 0;
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement