python过滤html标签_使用python过滤html标签 | 学步园

#!/usr/bin/env python

# -*- coding:utf-8 -*-

import MySQLdb

import sys

import re

conn = MySQLdb.connect(host='127.0.0.1',user='user',passwd='123456',db='hospital',charset='utf8')

cur = conn.cursor()

def update_level():

cur.execute("SELECT id,level FROM hospital where level like '(%)'")

for row in cur.fetchall():

sid=row[0]

ii=re.sub('\(|\)','',row[1])

sql = "update hospital set level=%s where id=%s"

print sid,ii

param = [ii,sid]

cur.execute(sql,param)

def update_detail():

dr = re.compile(r']+>',re.S)

cur.execute("SELECT id,details FROM hospital")

for row in cur.fetchall():

did = row[0]

detail=row[1]

dd = dr.sub('',detail)

sql="update hospital set details=%s where id=%s"

param = (dd,did)

cur.execute(sql,param)

print "Finished",did

def main():

#update_level()

update_detail()

if __name__ == '__main__':

main()