3 ms·
// yy078 part 2 of 2 putc(44,stdout); fwrite(yytext,1,yyleng-18,yyout); putc(44,stdout); len++; } } ^[ ]{4}\42channelI
by 1vuio0pswjnm7 3y ago
// yy078 part 2 of 2
putc(44,stdout);
fwrite(yytext,1,yyleng-18,yyout);
putc(44,stdout);
len++;
}
}
^[ ]{4}\42channelId\42:[ ]\42UC[-A-Z0-9a-z_]{22}\42, {
if(itag>0)
if(csv)
{
for(x=18;x<yyleng-1;++x)
if(yytext[x]!=34)putc(yytext[x],stdout);
}
if(itag>0)
if(sql)
{
putchar(39);
for(x=18;x<yyleng-2;++x)
if(yytext[x]!=34)putc(yytext[x],stdout);
putchar(39);
}
if(itag>0)putc(44,stdout);
}
\42viewCount\42:[ ]\42[0-9]+\42, {
if(itag>0)
if(views==0)
{
for(x=14;x<yyleng;++x)
if(yytext[x]!=34)putc(yytext[x],stdout);
views++;
}
}
\42author\42:[ ]\42[^\n]+\42, {
if(itag>0)
if(!sql)if(csv)
{
ch = 0;
for(x=10;x<yyleng-1;x++)
{
if(yytext[x]==92)ch=yytext[x];
if(yytext[x]==34&&ch!=0){putc(34,stdout);ch = 0;};
if(yytext[x]!=34&&yytext[x]!=92&&ch!=0){putc(ch,stdout);putc(yytext[x],stdout);ch = 0;};
if(ch==0&&yytext[x]!=92)putc(yytext[x],stdout);
}
putc(10,stdout);
}
if(itag>0)
if(!csv)if(sql)
{
ch = 0;
putchar(39);
for(x=11;x<yyleng-2;x++)
{
if(yytext[x]==92)ch=yytext[x];
if(yytext[x]==34&&ch!=0){ch = 0;};
if(ch==0&&yytext[x]!=92&&yytext[x]!=39)putc(yytext[x],stdout);
}
on();
}
}
.|\n
%%
int main(int argc,char* argv[])
{
if(argv[2])append++;
if((!argc)||(!argv[1]))goto help;
if((argv[1][0]!=99)&&
(argv[1][0]!=115))goto help;
if(argv[1][0]==99){csv++;if(!append)fwrite("ts,utc,itag,vid,title,dur,len,cid,views,author\n",1,47,stdout);if(append)putc(10,stdout);}
if(argv[1][0]==115){sql++;fwrite("PRAGMA foreign_keys=OFF;\n",1,25,stdout);fwrite("BEGIN TRANSACTION;\n",1,19,stdout);
fwrite("CREATE TABLE IF NOT EXISTS t1(ts INT,utc TEXT,itag INT,vid TEXT UNIQUE PRIMARY KEY,title TEXT,dur TEXT,len INT,cid TEXT,views INT,author TEXT);\n",1,144,stdout);}
yylex();
if(sql)fwrite("COMMIT;\n",1,8,stdout);
exit(0);
help:
fputs("usage: yy078 {c,s}\n",stderr);
fputs("c csv\n",stderr);
fputs("s sql\n",stderr);
exit(0);
}