ӭjXdZddlmZmZmZmZmZmZmZm Z ddl Z ddl Z ddl Z ddl Z eeZdZej#ddZej#ddZej#d d Zej#d d Zej#d dZej#ddgdZej#ddgdZej#ddgdZej#ddgdZej#ddgdZej#ddZej#ddgdZej#ddgd Zej#d!dgd"Zej#d#d$Z ed%k(r-e!d&e!d'e!d(ejEd)d*d+,yy)-u8 极简文件浏览和下载服务器 使用Flask实现 )Flask send_filerender_template_stringrequest make_responseredirecturl_forjsonifyNc  tjdd}tj|_ |S#t$r}|j d}~wwxYw#t$rp}ddl}ddl}|jjj}|jj}td|d|d||jd}~wwxYw)Nz\\ll\D\xtrssvjj\dpd.dbgN@)timeoutr错误 [函数: , 行号: u]: 连接数据库失败: )sqlite3connectRow row_factory Exceptionclose tracebackinspect currentframef_codeco_namef_linenoprint print_exc)connerr func_nameline_nos /pubsv5000-260516发布到2类ok优化ajax前.pyget_db_connectionr"s8$G";;      JJL   ((*1199 &&(11   :gY>XYZX[\] s3,AA AA  AA C A+CC /c tjjdd}g}tjdD]}tj j d|}tj j|rW|j|tj j|dz dz |tj j|dtj j|s|jd|dd|tj j|d|d k(r|jd n|jd d d}d}|tjjd<t!|||S)Nsorttime.namesizepathmtime📁 r#DIRr*c(|djSNr*lowerxs r!zindex..A6!2keyc |dSNr-r4s r!r6zindex..C7r8Tr:reverseu 文件服务器

文件列表

排序: 按时间 按字母 pub
{% for file in files %} {% endfor %}
文件名 大小 修改时间
{% if file.size != 'DIR' %} {{ file.name }} {% else %} {{ file.name }} {% endif %} {% if file.size == 'DIR' %}目录{% else %}{{ "%.2f"|format(file.size) }} MB{% endif %} {{ file.mtime|strftime }}
cTtjdtj|SN%Y-%m-%d %H:%M:%Sr&strftime localtime timestamps r!strftime_filterzindex..strftime_filterx}}0$..2KLLr8rE)filessort_by)rargsgetoslistdirr,joinisfileappendgetsizegetmtimeisdirr%app jinja_envfiltersr)rLrKfilenamefilepathhtmlrIs r!indexr](s<llvv.G EJJsO77<<X. 77>>( # LL 1D84? ))(3   WW]]8 $ LLz+ ))(3  $$& 2 3 +T :/ DdM)8CMM*% !$eW EEr8z/c tjj|sdStjj dd}g}tj |D],}tjj||}tjj|ru|j|tjj|dz dz tjj||tjj|dtjj|s|jd|ddtjj||tjj|d/|dk(r|jd n|jd d d}d}|tjjd<t!||||S)Nr%r&r(r)r.r#r/r*c(|djSr1r2r4s r!r6z"browse_directory..r7r8r9c |dSr<r=r4s r!r6z"browse_directory..r>r8Tr?u 文件服务器 - {{ dirname }}
← 返回上级

目录: {{ dirname }}

排序: 按时间 按字母
{% for file in files %} {% endfor %}
文件名 大小 修改时间
{% if file.size != 'DIR' %} {{ file.name }} {% else %} {{ file.name }} {% endif %} {% if file.size == 'DIR' %}目录{% else %}{{ "%.2f"|format(file.size) }} MB{% endif %} {{ file.mtime|strftime }}
cTtjdtj|SrBrDrGs r!rIz)browse_directory..strftime_filterrJr8rE)rKdirnamerL)u"

404

目录不存在

)rOr,rVrrMrNrPrQrRrSrTrUr%rWrXrYr)rbrLrKrZr[r\rIs r!browse_directoryrdss 77== !99llvv.G EJJw'77<<2 77>>( # LL 1D84? Wh7))(3   WW]]8 $ LLz+ Wh7))(3  ($& 2 3 +T :0 DfM)8CMM*% !$eWg VVr8z/download/c^tjj|sdSt|dS)NT) as_attachmentu"

404

文件不存在

rc)rOr,rRr)r[s r! download_filerhs% 77>>( #99 XT 22r8z/play/c tjj|sdStjj|dj }|dk(r/ t |dd5}|j }ddddddifSd d ddddddddd }|j|d}t||S#1swY500

读取文件失败: 

z audio/mpegz video/mp4z audio/wavz audio/mp4z audio/oggz video/webmz image/jpegz image/pngz image/gif) z.mp3z.mp4z.wavz.m4az.oggz.webmz.jpgz.jpegz.pngz.gifzapplication/octet-stream)mimetyperg) rOr,rRsplitextr3openreadrrNr)r[extfcontentr mime_typesrrs r! play_filerzs 77>>( #99 ''  8 $Q ' - - /C g~ Fhg6!&&(7C.+!>> >  J~~c#=>H X 11+76 F84@#E E Fs6B>&B27B>2B;7B>> CCCC/listpubc ddl}|jjj}|jj}d}d}d} t j jdd}t j jdd}t j jdd}tt j jdd } | d krd } tt j jd d } | d krd } | d kDrd } | d z | z} t}d} tddd5} tj| }|jdijdd} dddd}g}g}|r(|jd|jd|zdz|dk(r|jd|rddj|z}d} d|z}|j||}|j!d}|dkDr || zd z | znd }|dk(r d|zdz}n$|dk(r d|zdz}n|dk(r d|zd z}nd|zdz}|j#| | g|j||}|j%}d!}t'|||| | ||| ||" |r |j)|r |j)|r |j)SS#1swY]xYw#YexYw#YxYw#YHxYw#Y 0 AND (pub = 0 OR pub = 3 OR pub = 4)z WHERE z AND zSELECT COUNT(*) FROM adsa SELECT rowid, tts, ttscnt, totsrts, name, pub, pub2wxcflag, pubstartdt, pubenddt, asrstartdt, asrenddt, bilidt, trsenddt, pubsetdt_of_v, pubenddt_of_v FROM ads a ORDER BY CASE WHEN pub = 2 THEN 0 WHEN pub = 1 THEN 1 WHEN pub IS NULL THEN 3 ELSE 2 END, rowid DESC LIMIT ? OFFSET ? rowidz[ ORDER BY rowid DESC LIMIT ? OFFSET ? createtimez` ORDER BY createtime DESC LIMIT ? OFFSET ? uQ_ pub 列表
← 返回主页
{% if search_keyword %} 清除 {% endif %}
按状态 按rowid 按时间 | all 可发表+待发表
共 {{ total_count }} 条，第 {{ page }}/{{ total_pages }} 页
{% if page > 1 %} 首页 上一页 {% endif %} {% set start_page = page - 2 if page - 2 > 1 else 1 %} {% set end_page = page + 2 if page + 2 < total_pages else total_pages %} {% for p in range(start_page, end_page + 1) %} {% if p == page %} {{ p }} {% else %} {{ p }} {% endif %} {% endfor %} {% if page < total_pages %} 下一页 末页 {% endif %}
完成后设置：
{% for ad in ads %}
rowid tts ttscnt totsrts pub
{{ ad[0] }} {{ ad[1] }} {{ ad[2] }} {{ ad[3] }}
{% if ad[1] == 0 %} {{ ad[5] }} {% elif ad[5] == 1 %} {{ ad[5] }} {% else %} {{ ad[5] }} {% endif %}
{{ ad[4] }}
pub2v pub2v2 pub2culture
{% if ad[7] %}pubstart: {{ ad[7][:16] }}{% endif %} {% if ad[8] %}pubend: {{ ad[8][:16] }}{% endif %} {% if ad[9] %}asr: {{ ad[9][:16] }}{% endif %} {% if ad[10] %}asrend: {{ ad[10][:16] }}{% endif %} {% if ad[11] %}bili: {{ ad[11][:16] }}{% endif %} {% if ad[12] %}trs: {{ ad[12][:16] }}{% endif %} {% if ad[13] %}pubset: {{ ad[13][:16] }}{% endif %} {% if ad[14] %}pubendv: {{ ad[14][:16] }}{% endif %}
{% endfor %} ) adsrL global_flagr total_pages total_count page_sizesearch_keyword filter_byr r]: 操作失败: u&

500

数据库查询失败: rp)rrrrrrrMrNintr"rttomlloadrSrQexecutefetchoneextendfetchallrrrrrr)rrr rcursor1cursor2rLrrrroffsetrrwconfig where_clauseparams conditionsr count_queryrqueryrr\rrs r!listpubrsl$$&--55I""$--G DGGQ ,,""684!))(B7LL$$Xu5 7<<##FA./ !8D ((56 r>I s?I(i'!"  j#8A1$jj26::=!L 9     m , MM#.4 5  #   d e $w||J'??L  4|CKll;7G!**,Q/KEPRSO{Y.2y@YZ  h &'& "'E< &'&"'E0 $&'&"'E2&'&"'E2  y&)*,,uf- I V &dWR])-;T_kt3AYX          e98  ,  `   + E   :gY>OPQsST7s$?DD             #E             s  CK8&K48K,K4AK8*K=BK8K#"K*5K1K KKK8K K8#K'*K.1K58 N /N0N 1N8M  M M$$M(.M??NN  NO"N$#O"$N(&O".N?>O"?OO" OO"OO"z /setpub_ajaxPOST)methodsc ddl}|jjj}|jj}d}d} t t jjdd}t t jjdd}t}|jd||f}|j|jd|f}|j}|r|dn|}td|d|r |j|r |jSS#YxYw#YSxYw#t$r} ddl} t#d|d |d | | j%td t'| d d fcYd} ~ |r |jn#YnxYw|r |jS#YSxYwSd} ~ wwxYw#|r |jn#YnxYw|r |jw#YwxYwwxYw)Nradid pub_value&UPDATE ads SET pub = ? WHERE rowid = ?#SELECT pub FROM ads WHERE rowid = ?T)successnew_pubr r]: Frmessagerq)rrrrrrrformrNr"rcommitrr rrrrrstr) rrr rcursorrrrowrrrs r! setpub_ajaxrds$$&--55I""$--G D F7<<##FA./ ((a89  "FTXHYZ CdWMoo#a&Y4G<=          C   :gYc!EF5SV<=sBB         C         sB9D7D)D0)D-0D47 GAF<GGFF#F44F8<GGG<GG<GG<#G43G<4G86G<z /pub2v_ajaxc ddl}|jjj}|jj}d}d} t t jjdd}t}|jd|f}|j}|s7tddddf|r |j|r |jSS|d}||nd}|dk(s|d k(rdd lm}|jj!d } |jd | |f}|j#td d| ddd|r |j|r |jSS|dk(rX|jd|f}|j#td dd|r |j|r |jSStdd|dddf|r |j|r |jSS#YIxYw#YSxYw#YxYw#YSxYw#YqxYw#YSxYw#YDxYw#YSxYw#t$$r} ddl} t)d|d|d| | j+tdt-| ddfcYd} ~ |r |jn#YnxYw|r |jS#YSxYwSd} ~ wwxYw#|r |jn#YnxYw|r |jw#YwxYwwxYw)NrrrF记录不存在rrcdatetimerCzCUPDATE ads SET pubsetdt_of_v = ?,pubenddt_of_v=NULL WHERE rowid = ?T已设置发布时间rrpubsetdtz&UPDATE ads SET pub = 1 WHERE rowid = ?已设置为待处理状态当前状态(pub=)不支持此操作r rrrqrrrrrrrrrNr"rrr rrnowrErrrrrr rrr rrrr current_pubr current_timerrs r! pub2v_ajaxrs0$$&--55I""$--G D F,7<<##FA./ "CdWMoou9JKLcQ4       ;!f %0%223FGL\\"gjvx|i}~F KKMt8O]ijmkm]nop       'A \\"JTGTF KKMt8UVW       u;L[MYl9mnoqtt                   C   :gYc!EF5SV<=sBB         C         A'H?2HHA/H? HH.5H?&H#9H* H?!H14H8H HHH #H'*H.1H58H<? K AKK  K J!!J%+J<<KK  K LK! L!K%#L+K<;L<L>Lz /pub2v2_ajaxc &ddl}|jjj}|jj}d}d} t t jjdd}t}|jd|f}|j}|s7tddddf|r |j|r |jSS|d}||nd}|dk(s|d k(rdd lm}|jj!d } |d z} |jd | |f}|j#tdd|d| | d|r |j|r |jSS|dk(r\d} |jd| |f}|j#tdd| d|r |j|r |jSStdd|dddf|r |j|r |jSS#YUxYw#YSxYw#YxYw#YSxYw#YqxYw#YSxYw#YDxYw#YSxYw#t$$r} ddl} t)d|d|d| | j+tdt-| ddfcYd} ~ |r |jn#YnxYw|r |jS#YSxYwSd} ~ wwxYw#|r |jn#YnxYw|r |jw#YwxYwwxYw)NrrrFrrrcrrrrCnz$UPDATE ads SET pub=? WHERE rowid = ?Tu已设置发布状态,pub:z->)rrrrrrrrr rrrqr) rrr rrrrrrrrrrs r! pub2v2_ajaxrs\$$&--55I""$--G D F27<<##FA./ "CdWMoou9JKLcQ@       G!f %0%223FGL"C'G\\"H7TX/ZF KKMt9ST_S``bcjbk7lzABC"       +A G\\"JWVZO\F KKMt8Ubijk       u;L[MYl9mnoqtt                   C   :gYc!EF5SV<=sBB         C         sA'I 2HHA7I H!$H(69I 2H/H6I -H=IHH!H%(H,/H36H:=II KAKKKJ--J17KK KKLK-,L-K1/L7LLL  Lz/pub2culture_ajaxc ddl}|jjj}|jj}d}d} t t jjdd}t}|jd|f}|j}|s7tddddf|r |j|r |jSS|d}||nd}|dk(s|d k(rdd lm}|jj!d } |jd | |f}|j#td d| ddd|r |j|r |jSS|dk(rX|jd|f}|j#td dd|r |j|r |jSStdd|dddf|r |j|r |jSS#YIxYw#YSxYw#YxYw#YSxYw#YqxYw#YSxYw#YDxYw#YSxYw#t$$r} ddl} t)d|d|d| | j+tdt-| ddfcYd} ~ |r |jn#YnxYw|r |jS#YSxYwSd} ~ wwxYw#|r |jn#YnxYw|r |jw#YwxYwwxYw)NrrrFrrrcrrrrCzFUPDATE ads SET pubsetdt_of_v = ?, pubenddt_of_v = NULL WHERE rowid = ?Trrrz'UPDATE ads SET pub = 24 WHERE rowid = ?rrrrr rrrqrrs r!pub2culture_ajaxrs7$$&--55I""$--G D F,7<<##FA./ "CdWMoou9JKLcQ4       ;!f %0%223FGL\\"jmy{mABF KKMt8O]ijmkm]nop       'A \\"KdWUF KKMt8UVW       u;L[MYl9mnoqtt                   C   :gYc!EF5SV<=sBB         C         rz/setpubc  ddl}|jjj}|jj}d}d} t t jjdd}t jjdd}|st jr@tt j|r |j|r |jSStd|r |j|r |jSSt |}tdtd|td|d td |t}|jd |f}|j}|r|d} td | ntd |d|jd||f}|j } td| |j#td|jd |f}|j}|r6|d} td| | |k(r tdn!td|d| ntd|dtdt jr@tt j|r |j|r |jSSt j$jdd} t j$jdd} t j$jdd}t j$jdd}d| zd z|z}| r|d!| zz }t'|d"k7r|d#t'|zz }t||r |j|r |jSS#YxYw#YSxYw#YxYw#YSxYw#YxYw#YSxYw#YFxYw#YSxYw#t($rp}ddl}td$|d%|d&||j-d'|d(d)fcYd}~|r |jn#YnxYw|r |jS#YSxYwSd}~wwxYw#|r |jn#YnxYw|r |jw#YwxYwwxYw)*Nrrrrr{u === setpub 操作日志 ===zadid: zpub_value_str: ''z pub_value: ru更新前 pub 值: u警告：未找到 rowid=u 的记录ruUPDATE 语句影响的行数: u事务已提交u更新后 pub 值: uSUCCESS: pub 值更新成功u*WARNING: pub 值未更新成功！期望: u , 实际: u#ERROR: 更新后查询不到 rowid=u"=== setpub 操作日志结束 === r%r}r~rrrrjz/listpub?sort=z&filter=z&search=1z&page=r rr

500

操作失败: rprq)rrrrrrrrrNreferrerrrrr"rrrowcountrrMrrrr)rrr rrr pub_value_strrr original_pub affected_rowsrrLrrr redirect_urlrrs r!setpubr8s$$&--55I""$--G D FT7<<##FA./ ((b9  0 01D       MJ'B       I &  -/ tfo  q12 I;'(!"CdWMoo q6L ' ~6 7 -dV:> ?FTXHYZ  .}o>?   CdWMoo !fG 'y1 2)#45B9+ZX_W`ab 7vZH I 34   G,,-*       /,,""684 ))(B7LL$$Xu5 ||*''1J>J  J7 7L t9  Hs4y0 0L %                   <   :gY>OPQsST.qc6;;         <         sA3O>NN$# O0N+N3E9ON:$O6B>O7O  ON!$N(+N03N7:N?O O O Q /Q QQP((P,2QQ QQR Q('R (Q,*R 2RR RR z/pub//c ddl}|jjj}|jj}d}d} t }|j d||f}|jtjr@ttj|r |j|r |jSSttd|r |j|r |jSS#YTxYw#YSxYw#Y'xYw#YSxYw#t$rp}ddl}td|d|d||j!d|dd fcYd}~|r |jn#YnxYw|r |jS#YSxYwSd}~wwxYw#|r |jn#YnxYw|r |jw#YwxYwwxYw) Nrrrr rrrrprqrrrrrr"rrrrrrr rrrr) rpuberrrr rrrrs r!pubrs$$&--55I""$--G D F "FPT V    G,,-        *+             <   :gY>OPQsST.qc6;;         <         sAD!D4DDD/DDD DD F&/FFFE..E28F  F FFGF.-G.F20G8G G G  Gz /batch_pubc ddl}|jjj}|jj}d}d} t j jd}tt j jdd}|st jr@tt j|r |j|r |jSSttd|r |j|r |jSSt}|jd|Dcgc]}|t|fc}}|j!t#dt%|d|t jr@tt j|r |j|r |jSSttd|r |j|r |jSS#Y?xYw#YSxYw#YxYw#YSxYwcc}w#YwxYw#YSxYw#YJxYw#YSxYw#t&$rp}ddl} t#d |d |d || j+d |d dfcYd}~|r |jn#YnxYw|r |jS#YSxYwSd}~wwxYw#|r |jn#YnxYw|r |jw#YwxYwwxYw)Nrad_idsrrrru 批量更新 u 条记录，pub 设置为 r ru]: 批量操作失败: u#

500

批量操作失败: rprq)rrrrrrrgetlistrrNrrrr r" executemanyrrlenrrr) rrr rrrrrrrs r! batch_pubrs$$&--55I""$--G D F)%%h/ ((a89  0 010       9GI./.       3!"!!"JDJ KFD)SY!7F KM  c&k]*Ei[QR   G,,-        *+            3!L&      B   :gY>UVWUXYZ4QCtJ??KJJ!J22J6:J??KK:KK:KK:!K21K:2K64K:z/setpub2wxcflag_globalc  ddl}|jjj}|jj} t t jjdd}dd|ii}tddd5}tj||dddttd S#1swYxYw#t$r:}ddl}t!d |d |d ||j#d |ddfcYd}~Sd}~wwxYw)Nrpub2wxcflag_globalrrrwrlrmrr rrrrprq)rrrrrrrrrNrtrdumprr rrrr)rrr rrrwrrs r!setpub2wxcflag_globalrs$$&--55I""$--G< !1!12F!JK],>?@ *cG 4 IIfa 5 *++ 5 4 <   :gY>OPQsST.qc6;; 8D>Dz/setpub2wxcflag/c Bddl}|jjj}|jj}d}d} t t jjdd}t}|jd||f}|jddl m }m}||d|r |j|r |jSS#YxYw#YSxYw#t $rp} ddl} t%d|d|d| | j'd | d d fcYd} ~ |r |jn#YnxYw|r |jS#YSxYwSd} ~ wwxYw#|r |jn#YnxYw|r |jw#YwxYwwxYw) Nrrz.UPDATE ads SET pub2wxcflag = ? WHERE rowid = ?)rr rr rrrrprq)rrrrrrrrrNr"rrflaskrr rrrrr) rrrr rrrrr rrs r!setpub2wxcflagr s$$&--55I""$--G D F',,**=!<= !"NQ\^bPcd  , *+          <   :gY>OPQsST.qc6;;         <         sA,C*7C C#C #C'* E#3/E"E##E&*D;;D?EEE##E&&F*E;:F;E?=FFFFFz/resetpub/c ddl}|jjj}|jj}d}d} t }|j d|f}|jtjr@ttj|r |j|r |jSSttd|r |j|r |jSS#YTxYw#YSxYw#Y'xYw#YSxYw#t$rp}ddl}td|d|d||j!d|dd fcYd}~|r |jn#YnxYw|r |jS#YSxYwSd}~wwxYw#|r |jn#YnxYw|r |jw#YwxYwwxYw) Nrz&UPDATE ads SET pub = 0 WHERE rowid = ?rr rrrrprqr)rrrr rrrrs r!resetpubr2s$$&--55I""$--G D F "FP    G,,-        *+             <   :gY>OPQsST.qc6;;         <         sAD D3DDD.DDD DD F%/FFFE--E17FF FFGF-,G-F1/G7GGG  G__main__u文件服务器启动中...u#访问地址: http://localhost:5000u按 Ctrl+C 停止服务器z0.0.0.0iF)hostportdebug)#__doc__rrrrrrrr r rOr&rr__name__rWr"router]rdrhrzrrrrrrrrrrrrrunr=r8r!rsoonn  Ho23TFTFn WWWWt &'3(3 "#2$2D:Z Z z>F8,%-%P=6(+3,3l>F8,9-9x 1323l9vh'[([| ()#*#L<&*0+0f #fX6<7<. '&:$;$N !"###J z '( /0 &'GGUG3 r8