Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- int main(int argc, char *argv[]){
- FILE *file = fopen(argv[1], "r");
- FILE *final = fopen(argv[argc-1], "w");
- char conninfo[200] = { "\0" };
- createConnInfo(conninfo);
- PGconn *conn = PQconnectdb(conninfo);
- if (!showLog(conn)){
- return 1;
- };
- char tableName[50] = { "\0" };
- createTableName(argv[1], tableName);
- char dropTableCommand[200] = { "\0" };
- dropTable(tableName, dropTableCommand);
- char createTableCommand[1000] = { "\0" };
- createTable(file, tableName, createTableCommand);
- char selectTableCommand[200] = { "\0" };
- selectTable(tableName, selectTableCommand);
- switch(argc){
- case ZERO:ONE:THREE:
- break;
- case CREATE_TABLE:
- doSQL(conn, dropTableCommand);
- doSQL(conn, createTableCommand);
- insert(conn, file, tableName);
- doSQL(conn, selectTableCommand);
- break;
- case PRINT_HTML:
- openHTML(final);
- PQPrint(conn, final, argv[argc-2]);
- closeHTML(final);
- break;
- default:
- break;
- }
- PQfinish(conn);
- return 0;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement