#include <stdio.h>
#include <string.h>
void txt2sql (FILE *ulaz, FILE *izlaz){
char insert[] = ("insert into count_global ( script_name,request_uri,referer,user_agent,remote,datum ) values ( '");
char razmak[] = ("','");
char kraj[]=("')");

char ActualURL, RequestedURL, Referer, UA, Remote, HitTime;

while (fscanf (ulaz, "%s%s%s%s%s%s",&ActualURL, &RequestedURL, &Referer, &UA, &Remote, &HitTime) != EOF)
{
                fprintf (izlaz, "%s%s%s%s%s%s%s%s%s%s%s%s%s\n",&insert, &ActualURL, &razmak, &RequestedURL, &razmak, &Referer, &razmak, &UA, &razmak, &Remote, &razmak, &HitTime, &kraj);
}
}




main (int brarg, char *arg[]){


FILE *txt; FILE *sql;
char *ja = arg[0], *ftxt = arg[1], *fsql=arg[2];


if (brarg < 2 || brarg > 3 ) printf ("Koristi: %s <ulazni fajl.txt>  <izlazni fajl.sql>  (ako ovakav fajl vec postoji bice prepisan)\n", ja);
else {

	if ((txt = fopen(ftxt, "r")) != NULL && ( sql = fopen(fsql, "w")) != NULL) {
	txt2sql (txt,sql); fclose (txt); fclose (sql);}
	else {
	printf ("%s: fajl imena %s nije pornadjen!!ili ne mogu da otvorim za upis fajl %s\n",ja, ftxt,fsql);
	exit (1);
	}


}
}