³ò !íãKc @sòddkZddkZddkZddklZyddkZWn#ej oddklZnXd„Z d„Z dd„Z dd„Z d „Z d „Zd „Zd „Zd „Zd„Zd„Zd„Zd„Zd„ZdS(iÿÿÿÿN(tquote(tdbapi2cCsÍy¬g}g}tid|ƒ}t|_|iƒ}|idƒxZ|D]R}|i|didƒiddƒƒ|i|didƒiddƒƒqKW||fSWnt j o}|GHnXdS(Ns system/%s.dws2select keywords, name from doorway where status>-1itutf_8s ti( tsqlite3tconnecttstrt text_factorytcursortexecutetappendtdecodetreplacet Exception(tnametkeywordstnamesRRtrowtmsg((s2/var/www/shopping/data/www/11autoparts.com/core.pytinfKwd s   &*cCsˆtid|ƒ}|iƒ}|id|ƒg}x|D]}|i|dƒq=Wx|D]}|id|ƒq_W|iƒdS(Ns system/%s.dws5select keywords from doorway where status=-1 limit %dis/update doorway set status=0 where keywords="%s"i(RRRR R tcommit(RtcountRRRRtkeyword((s2/var/www/shopping/data/www/11autoparts.com/core.pytunFreezes  icCsiyHtid|ƒ}|iƒ}|id||fƒ|iƒdSWntj o}|GHnXdS(Ns system/%s.dws0update doorway set status=%s where keywords="%s"i(RRRR RR (RRtstatusRRR((s2/var/www/shopping/data/www/11autoparts.com/core.pyt activeKwd&s  cCsiyHtid|ƒ}|iƒ}|id||fƒ|iƒdSWntj o}|GHnXdS(Ns system/%s.dws-update doorway set upd=%s where keywords="%s"i(RRRR RR (RRtupdRRR((s2/var/www/shopping/data/www/11autoparts.com/core.pytupdKwd0s  cCsAt|ƒ\}}||jot||fSntggfSdS(N(RtTruetFalse(RtpageRR((s2/var/www/shopping/data/www/11autoparts.com/core.pyt isItValid:s cCstyStid|ƒ}|iƒ}|id|ƒx|D]}|d}q:W|SWntj o}|GHnXdS(Ns system/%s.dws.select status from doorway where keywords="%s"i(RRRR R (RRRRRRR((s2/var/www/shopping/data/www/11autoparts.com/core.pyt isItActiveAs cCstyStid|ƒ}|iƒ}|id|ƒx|D]}|d}q:W|SWntj o}|GHnXdS(Ns system/%s.dws+select upd from doorway where keywords="%s"i(RRRR R (RRRRRtupdateR((s2/var/www/shopping/data/www/11autoparts.com/core.pytisItUpdLs cCstyStid|ƒ}|iƒ}|id|ƒx|D]}|d}q:W|SWntj o}|GHnXdS(Ns system/%s.dws,select keywords from doorway where name="%s"i(RRRR R (RRRRRtresR((s2/var/www/shopping/data/www/11autoparts.com/core.pyt getByPageWs cCstyStid|ƒ}|iƒ}|id|ƒx|D]}|d}q:W|SWntj o}|GHnXdS(Ns system/%s.dws0select requests from doorway where keywords="%s"i(RRRR R (RRRRRtreqR((s2/var/www/shopping/data/www/11autoparts.com/core.pytgetReqbs cCszyYd}tid|ƒ}|iƒ}|idƒx|D]}||d7}q<W|SWntj o}|GHnXdS(Nis system/%s.dwsselect requests from doorway(RRRR R (RR%RRRR((s2/var/www/shopping/data/www/11autoparts.com/core.pyt getAllReqms  cCstyStid|ƒ}|iƒ}|id|ƒx|D]}|d}q:W|SWntj o}|GHnXdS(Ns system/%s.dws,select last from doorway where keywords="%s"i(RRRR R (RRRRRtlastR((s2/var/www/shopping/data/www/11autoparts.com/core.pytgetLastys cCs‹yjd}tid|ƒ}|iƒ}|idƒx-|D]%}|d|jo|d}q<q<W|SWntj o}|GHnXdS(Nis system/%s.dwsselect last from doorway(RRRR R (RR(RRRR((s2/var/www/shopping/data/www/11autoparts.com/core.pyt getAllLast„s  cCs{ttiƒƒ}yHtid|ƒ}|iƒ}|id||fƒ|iƒdSWntj o}|GHnXdS(Ns system/%s.dws.update doorway set last=%s where keywords="%s"i(tintttimeRRRR RR (RRR(RRR((s2/var/www/shopping/data/www/11autoparts.com/core.pytsetLast‘s  cCs|t||ƒd}yHtid|ƒ}|iƒ}|id||fƒ|iƒdSWntj o}|GHnXdS(Nis system/%s.dws2update doorway set requests=%s where keywords="%s"(R&RRRR RR (RRR%RRR((s2/var/www/shopping/data/www/11autoparts.com/core.pytincrReqœs  (tosR,tglobturllibRRt ImportErrort pysqlite2RRRRRRR R"R$R&R'R)R*R-R.(((s2/var/www/shopping/data/www/11autoparts.com/core.pyss&$