Text Processing Practice Experiment: 54 SERP Types to SQLite yy084

    /*
    make sqlite from s.e.r.p.
    */
   
    int fileno (FILE *);
    FILE *f;
    #define jmp (yy_start) = 1 + 2 *
    int mode;
    int v,w,x,y,z;
    int utf8,tag;
    int datelen,querylen,urllen,desclen;
    int desc1len,desc2len;
    int url1len,url2len;
    int c;
    char desc[255];
    char url[255];
    char date[255];
    char *a;
    int puts(const char*);
    int setenv (const char *, const char *, int);
    int printf(const char *__restrict, ...);
    int dprintf(int, const char *__restrict, ...);
    #include <time.h>
    char *strptime(const char *s, const char *f, struct tm *tm);
    struct tm t;
    void bzero(void *s, size_t n);
    int CDp8iULPuCinsert(int xyz) 
    {
    fwrite("INSERT or IGNORE INTO t1 VALUES(",1,32,stdout);
    printf("%03d,'",xyz);
    fwrite(getenv("query"),1,querylen,stdout); 
    fwrite("','",1,3,yyout);
    for(x=0;x<9;x++)putc(date[x],yyout);
    fwrite("','",1,3,yyout);
    return 0;
    }
   %s MODE1 MODE2 MODE3 MODE4 MODE5 MODE6 MODE7 MODE9 
   %s MODE10 MODE11 MODE13 MODE14 MODE15 MODE16 MODE17 
   %s MODE18 MODE19 MODE20 MODE21 MODE22 MODE23 MODE24 
   %s MODE25 MODE26 MODE27 MODE28 MODE29 MODE30 MODE31
   %s MODE32 MODE33 MODE34 MODE35 MODE36 MODE37 MODE38
   %s MODE39 MODE40 MODE41 MODE42 MODE43 MODE44 MODE45
   %s MODE46 MODE47 MODE48 MODE49 MODE50 MODE51 MODE52
   %s MODE53 MODE54
   %s MODE13_DESC MODE35_RM
   %s MODE40_DESC MODE40_URL MODE43_DESC 
   %option nounput noinput noyywrap 
   %%
   TWVGHkppk6Q6cODqP7Kqdate:\"[^\"]+ {
    y=0;for(x=26;x<37;x++){date[y]=yytext[x];y++;}
    y=0;for(x=26;x<37;x++){yytext[y]=yytext[x];y++;}
    yytext[yyleng]=0;
    /* datelen is 10 */
    setenv("date",yytext,1); 
    }
   TWVGHkppk6Q6cODqP7Kqquery:\"[^\"]+ {
    y=0;for(x=27;x<yyleng;x++){yytext[y]=yytext[x];y++;}
    yytext[yyleng]=0;
    setenv("query",yytext,1);
    querylen=y;
    }
   TWVGHkppk6Q6cODqP7Kqmode:\"[^\"]+ {
    y=0;for(x=26;x<yyleng;x++){yytext[y]=yytext[x];y++;}
    yytext[yyleng]=0;
    mode=atoi(yytext);
    /* switch statement */

    }
   ^HTTP\/1.[01][ ]200[ ]O[Kk]\r {utf8=0;tag=0;
    datelen=0;urllen=0;desclen=0;desc1len=0;desc2len=0;
    v=0;w=0;x=0;y=0;z=0;}
   
   
   
    /*````````````csplit end```````````*/
   
   .|\n 
   %%
    int main(int argc,char *argv[]){
    if(argc>2)
    {
    printf("TWVGHkppk6Q6cODqP7Kqmode:\"%s\"\n",argv[1]); 
    fwrite("TWVGHkppk6Q6cODqP7Kqquery:\"",1,27,stdout);
    if(*argv){++argv;++argv;};
    while((a=*argv++)){x++;printf("%s",a);if((argc-x)>2)putc(32,stdout);};
    fwrite("\"\n",1,2,stdout);
    printf("TWVGHkppk6Q6cODqP7Kqdate:\"%ld\"\n",time(0));
    goto x;
    }
    if(argc==1)c=1;
    if(argc==1)fwrite("PRAGMA foreign_keys=OFF;\n",1,25,stdout);
    if(argc==1)fwrite("BEGIN TRANSACTION;\n",1,19,stdout);
    if(argc==1)fwrite("CREATE TABLE IF NOT EXISTS t1(site INTEGER,query TEXT,gmt TEXT,url TEXT PRIMARY KEY,desc TEXT);\n",1,96,stdout);
    yylex();
    if(argc==1)fwrite("COMMIT;\n",1,8,stdout);
    x:
    exit(0);
    }