#include "querydb.h"

int main (int argc, char *argv[])
{
	MYSQL mysql;
	char route [1024];
	unsigned int id,len;
	
	struct datastruct *d;

	d = NULL;

	open_user_connection (&mysql, MYSQL_HOST);

	if (!route_from_routeid(&mysql,atoi(argv[1]),route,&len))  exit (1) ;

	printf ("route : #%s#%u\n",route,len);
	
	if (!routeid_from_route(&mysql,route,&id,&len))  exit (1) ;
	
	printf ("id : #%u#%u\n",id,len);
	
	printf ("\n\n");
	
	if (!get_routes_by_time (&mysql, 12, 18, 918599677, 924730177, &d))  exit (1) ;
	
	printf ("TEST: %p\n",d);
	printf ("TEST: %u\n",d->src);
	
	display_routes(d);
	
	mysql_close(&mysql);

	return (0);
};