4 ms·
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);
}
- 1vuio0pswjnm7 2y agoThe switch statement switch(mode){ case 1: jmp MODE1;break; /* ddg 001 */ case 2: jmp MODE2;break; /* google 002 */ case 3: jmp MODE3;break; /* qwant 003 */ case 4: jmp MODE4;break; /* startpage 004 */ case 5: jmp MODE5;break; /* github 005 */ case 6: jmp MODE6;break; /* google news 006 */ case 7: jmp MODE7;break; /* mojeek 007 */ case 10: jmp MODE10;break; /* f-droid 010 */ case 11: jmp MODE11;break; /* bing 011 */ case 13: jmp MODE13;break; /* yandex 013 */ case 14: jmp MODE14;break; /* tailsx 014 */ case 15: jmp MODE15;break; /* google scholar 015 */ case 16: jmp MODE16;break; /* ecosia 016 */ case 17: jmp MODE17;break; /* wiby.me 017 */ case 18: jmp MODE18;break; /* marginalia 018 */ case 19: jmp MODE19;break; /* yahoo 019 */ case 20: jmp MODE20;break; /* youtube 020 */ case 21: jmp MODE21;break; /* wikipedia 021 */ case 22: jmp MODE22;break; /* pubmed 022 */ case 23: jmp MODE23;break; /* brave 023 */ case 24: jmp MODE24;break; /* mwmbl 024 */ case 25: jmp MODE25;break; /* crossref 025 */ case 26: jmp MODE26;break; /* aol 026 */ case 27: jmp MODE27;break; /* sec 027 */ case 28: jmp MODE28;break; /* itunes 028 */ case 29: jmp MODE29;break; /* fyyd 029 */ case 30: jmp MODE30;break; /* ghostarchive 030 */ case 31: jmp MODE31;break; /* metacritic 031 */ case 32: jmp MODE32;break; /* reddit 032 */ case 33: jmp MODE33;break; /* ftc 033 */ case 34: jmp MODE34;break; /* minisearch 034 */ case 35: jmp MODE35;break; /* yep 035 */ case 36: jmp MODE36;break; /* crowdview 036 */ case 37: jmp MODE37;break; /* gibiru 037 */ case 38: jmp MODE38;break; /* 4get 038 */ case 39: jmp MODE39;break; /* wiktionary 039 */ case 40: jmp MODE40;break; /* greppr 040 */ case 41: jmp MODE41;break; /* amazon 041 */ case 42: jmp MODE42;break; /* cornell lii 042 */ case 43: jmp MODE43;break; /* edgar 043 */ case 44: jmp MODE44;break; /* voidlinux 044 */ case 45: jmp MODE45;break; /* archlinux 045 */ case 46: jmp MODE46;break; /* ecfr 046 */ case 47: jmp MODE47;break; /* edgar browse 047 */ case 48: jmp MODE48;break; /* alibaba 048 */ case 49: jmp MODE49;break; /* ahmia 049 */ case 50: jmp MODE50;break; /* yippy 050 */ case 51: jmp MODE51;break; /* ask 051 */ case 52: jmp MODE52;break; /* webcrawler 052 */ case 53: jmp MODE53;break; /* aliexpress 053 */ case 54: jmp MODE54;break; /* judyrecords 054 */ default: break; }