/*
 * reset.c
 * House of Mozart statistic database reset app (c) 2003 oliver
 *
 * GNU public license *FIXME*
 */

#include "reset.h"
#include <stdio.h>
#include <getopt.h>
#include <time.h>
#include <libpq-fe.h>

int main(int argc, char *argv[]) {
	PGconn *conn;
	char SQL_query[512];
	PGresult *res;

	conn = PQsetdbLogin(PGHOST, PGPORT, PGOPTIONS, PGTTY, DBNAME, LOGIN, PWD);


	if(CONNECTION_BAD == PQstatus(conn)) {
		fprintf(stderr, "Connection to database '%s' failed.\n %s", DBNAME, PQerrorMessage(conn));
		PQfinish(conn);
		return 1;
	}
	
	sprintf(SQL_query, "");
	res = PQexec(conn, SQL_query);

			
	if((NULL == res) || (PGRES_COMMAND_OK != PQresultStatus(res))) {
		printf("Unable to execute query: %s\n %s\n", SQL_query, PQerrorMessage(conn));
		PQclear(res);
		PQfinish(conn);
		return 1;
	}
	PQclear(res);

	PQfinish(conn);

	return 0;
}