大仙帮小弟看看代码，如何将代码简化一下

2014-02-08 02:11:04 284 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

shevchenko2010 墨衍会员 · AI 创作全网分发关注 + 加入社区

maxwell与steady state thermal 通过workbench耦合仿真文章目录maxwellsteady state thermal maxwell 1加入maxwell并打开 2导入模型 3选择求解器类型：涡流求解器eddy current 4修改模型名字不能带_等特殊符号 5为模型赋材料 6设立3D边界，各边电流进出方向为0其余方向300 7设置激励条件，可设置电流大小，相位，方向 8设置集肤深度，选取中间铜导体的体然后设置，如何设置看帮助文档 9求解设置迭代步数收敛精度交流电频率 10验证条件满足计算 11求解发现无法求解，删除ai 阅读详情

with open('data_pps.xml','r') as file:

    data = file.read()

conn = sqlite3.connect('SQLite_pps.db')

c = conn.cursor()

c.execute('''select keyword from mydata where level = 2''')

cc = c.fetchall() #从数据库中获取字段

list_keywords = []

for oo in cc:

    list_keywords.append(oo[0].encode("utf-8"))

#return list_keywords

    #pp = oo[0].encode('utf-8')

#***********************************************************************************************************************

"""筛选掉二级标签，保留数据标签"""

for i in data.split('</goods>')[:-1]:

    city_name = i.split('<city_name>')[-1].split('</city_name>')[0].decode('utf-8')

    site_url = i.split('<site_url>')[-1].split('</site_url>')[0].decode('utf-8')

    title = i.split('<title>')[-1].split('</title>')[0].decode('utf-8')

    goods_url = i.split('<goods_url>')[-1].split('</goods_url>')[0].decode('utf-8')

    desc = i.split('<desc>')[-1].split('</desc>')[0].decode('utf-8')

    #class = i.split('<class>')[-1].split('</class>')[0].decode('utf-8')

    img_url = i.split('<img_url>')[-1].split('</img_url>')[0].decode('utf-8')

    original_price = i.split('<original_price>')[-1].split('</original_price>')[0].decode('utf-8')

    sale_price = i.split('<sale_price>')[-1].split('</sale_price>')[0].decode('utf-8')

    sale_rate = i.split('<sale_rate>')[-1].split('</sale_rate>')[0].decode('utf-8')

    sales_num = i.split('<sales_num>')[-1].split('</sales_num>')[0].decode('utf-8')

    start_time = i.split('<start_time>')[-1].split('</start_time>')[0].decode('utf-8')

    site_name = i.split('<site_name>')[-1].split('</site_name>')[0].decode('utf-8')

    close_time = i.split('<close_time>')[-1].split('</close_time>')[0].decode('utf-8')

    merchant_name = i.split('<merchant_name>')[-1].split('</merchant_name>')[0].decode('utf-8')

    merchant_tel = i.split('<merchant_tel>')[-1].split('</merchant_tel>')[0].decode('utf-8')

    spend_start_time = i.split('<spend_start_time>')[-1].split('</spend_start_time>')[0].decode('utf-8')

    spend_close_time = i.split('<spend_close_time>')[-1].split('</spend_close_time>')[0].decode('utf-8')

    merchant_addr = i.split('<merchant_addr>')[-1].split('</merchant_addr>')[0].decode('utf-8')

    hot_area = i.split('<hot_area>')[-1].split('</hot_area>')[0].decode('utf-8')

    longitude = i.split('<longitude>')[-1].split('</longitude>')[0].decode('utf-8')

    latitude = i.split('<latitude>')[-1].split('</latitude>')[0].decode('utf-8')

    c.execute('''insert into api_data(city_name,site_url,title,goods_url,desc,img_url,original_price,sale_price,sale_rate,

                                        sales_num,start_time,close_time,merchant_name,merchant_tel,spend_start_time,spend_close_time,

                                        merchant_addr,hot_area,longitude,latitude,site_name)

                                        values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)''',

             (city_name,site_url,title,goods_url,desc,img_url,original_price,sale_price,sale_rate,

                                        sales_num,start_time,close_time,merchant_name,merchant_tel,spend_start_time,spend_close_time,

                                        merchant_addr,hot_area,longitude,latitude,site_name))

conn.commit()

print "Write data sucess!!"