ó ›gÂDc@s<ddlTd„Zd„Zd„Zddd„ƒYZdS( i˙˙˙˙(t*cCs>d}x1|D])}|dkr,|d7}n||7}q W|S(s0Escape a string for insertion into an sql table.tt's\((tstringtouttc((s&/home/life/pwb/public_html/_blog/db.pytsql_escs    cCs{d}d}d}td|d|d|ƒ}|sHtGHtjdƒn|jƒ}|jdƒ|jƒ}|jƒ|S(NtpwbtowsklebytusertpasswdtdbisAselect title, body, time, blogid, tz from blog order by time desc(tconnecttnoconntsystexittcursortexecutetfetchalltclose(R R R tconntcurstblogs((s&/home/life/pwb/public_html/_blog/db.pytget_blog_entriess    cCsqtddddddƒ}|s6tGHtjdƒn|jƒ}|jd|ƒ|jƒ}|jƒ|dS( NR RR RR isHselect title, body, time, blogid, tz from blog where blogid='%d' limit 1i(R R RRRRRR(tblogidRRR((s&/home/life/pwb/public_html/_blog/db.pytget_blog_entrys   ttablecBs,eZd„Zd„Zd„Zd„ZRS(cCs§||_|jjƒ}|jdƒ|jƒ}g|_xftt|ƒƒD]R}i}||d|d<||d|d<||d|d<|jj|ƒqMWdS(Ns.select title, body, time, blogid, tz from blogittitleitbodyittime(R RRRtrowtxrangetlentappend(tselfR tdbcttabtiR((s&/home/life/pwb/public_html/_blog/db.pyt__init__(s    cCs t|jƒS(N(R titems(R"((s&/home/life/pwb/public_html/_blog/db.pyt__len__5scCs |j|S(N(R'(R"titem((s&/home/life/pwb/public_html/_blog/db.pyt __getitem__8scCs t|jƒS(N(titerR'(R"((s&/home/life/pwb/public_html/_blog/db.pyt__iter__;s(t__name__t __module__R&R(R*R,(((s&/home/life/pwb/public_html/_blog/db.pyR's  N((tMySQLdbRRRR(((s&/home/life/pwb/public_html/_blog/db.pyts