LevenBlog1.0升级至2.0简易脚本存档

作者:leven 日期:2008-09-16 19:54:00

字体大小: 小中大

LevenBlog1.0升级至2.0简易脚本存档.系统升级一段时间了,把升级用的python脚本保存一份.以防丢失.

脚本非常简单.因为上个系统就我一个人用,所以有些地方完全不用考虑升级了.只升级了我自己数据库中有数据的表(除了user).user部分因为没开发用户注册也不用更新了.

#!/usr/bin/env python
#coding=GBK
import pyodbc
import sqlite3
def Update(olddb,newdb):
con=pyodbc.connect(olddb)
ncon=sqlite3.connect(newdb)
cur=con.cursor()
ncur=ncon.cursor()
print "开始升级archive表"
insql="select * from LBlog_Archive"
outsql="insert into [lb_archive]([year],[month],[num]) values(?,?,?)"
result=cur.execute(insql).fetchall()
for r in result:
ncur.execute(outsql,(r[1],r[2],r[3]))
ncon.commit()
print "升级archive表成功"
print "开始升级comment表"
insql="select * from LBlog_Comment"
outsql="insert into [lb_comment]([blogid],[title],[content],[posttime],[user],[ip],[mail]) values(?,?,?,?,?,?,?)"
result=cur.execute(insql).fetchall()
for r in result:
r[2]=r[2].replace("images/","/skins/default/images/")
ncur.execute(outsql,(r[3],r[1],r[2],r[7],r[4],"127.0.0.1",r[5]))
ncon.commit()
print "升级comment表成功"
print "开始升级file表"
insql="select * from LBlog_Files";
outsql="insert into [lb_file](name,path,type,hits,time,intro) values(?,?,?,?,?,?)"
result=cur.execute(insql).fetchall()
for r in result:
ncur.execute(outsql,(r[1],r[3].replace("-",""),r[4],r[6],"2008-08-08 08:08:08",r[2]))
ncon.commit()
print "升级file表成功"
print "开始升级friendlink表"
insql="select * from LBlog_Link"
outsql="insert into [lb_friendlink]([name],[intro],[url],[order],[image],[isimg],[isshow],[isindex]) values(?,?,?,?,?,?,?,?)"
result=cur.execute(insql).fetchall()
for r in result:
ncur.execute(outsql,(r[1],r[3],r[2],r[8],r[4],int(r[6]),int(r[5]),int(r[7])))
ncon.commit()
print "升级friendlink表成功."
print "开始升级tag表"
insql="select * from LBlog_Tag"
outsql="insert into [lb_tag]([name],[intro],[num]) values(?,?,?)"
result=cur.execute(insql).fetchall()
for r in result:
ncur.execute(outsql,(r[1],r[2],r[3]))
ncon.commit()
print "升级tag表成功"
print "开始升级category表"
insql="select * from LBlog_Category"
outsql="insert into [lb_category]([name],[info],[order],[isurl],[url],[image],[view],[num]) values(?,?,?,?,?,?,?,?)"
result=cur.execute(insql).fetchall()
cdic={0:0}
for r in result:
ncur.execute(outsql,(r[1],r[2],r[3],int(r[6]),r[4],r[5],0,r[10]))
id=ncur.execute("select last_insert_rowid()").fetchone()[0]
cdic[r[0]]=int(id)
ncon.commit()
print "升级category表成功."
print "开始升级blog表."
insql="select * from LBlog_Content"
outsql="insert into [lb_blog]([categoryid],[title],[intro],[content],[posttime],[postuser],[hits],[commentnum],[tracknum],[tags],[edittime],[edituser],[come],[comeurl]) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
result=cur.execute(insql).fetchall()
for r in result:
r[4]=r[4].replace("File.aspx?FileID=","/blog/file/").replace("images/download.gif","/skins/default/images/download.gif")
r[5]=r[5].replace("File.aspx?FileID=","/blog/file/").replace("images/download.gif","/skins/default/images/download.gif")
ncur.execute(outsql,(cdic[r[1]],r[3],r[4],r[5],r[7],r[2],r[10],r[8],r[9],r[6],r[20],r[21],r[13],r[14]))
ncon.commit()
print "升级Blog表完成."
print "更新统计数据"
blognum=ncur.execute("select count([id]) from [lb_blog]").fetchall()[0][0]
commentnum=ncur.execute("select count([id]) from [lb_comment]").fetchall()[0][0]
tagnum=ncur.execute("select count([id]) from [lb_tag]").fetchall()[0][0]
outsql="update [lb_state] set [blognum]=?,[commentnum]=?,tagnum=?"
ncur.execute(outsql,(blognum,commentnum,tagnum))
ncon.commit()
print "统计数据更新成功"
con.close()
ncon.close()
print "升级完成."
if __name__ == "__main__":
Update("Driver={Microsoft Access Driver (*.mdb)};Dbq=E:\\Data.mdb","E:\\Database.db3")

文章来自: 本站原创

引用通告: 查看所有引用 | 我要引用此文章

Tags: levenblog blog python 数据库 sqlite

评论: 0 | 引用: 0 | 查看次数: 351

发表评论

Processed in 218.750 m(s) , 5 queries , LevenBlog默认模板 Design By Leven
湘ICP备06010945号

用户名:
密　码:	游客发言不需要密码.
验证码:
内　容:
选　项:	评论自带签名启用HTML提交加入邮件列表

	虽然发表评论不用注册，但是为了保护您的发言权，建议您注册帐号. 字数限制 500 字 \| HTML代码允许关闭 \| 评论可修改关闭

LevenBlog1.0升级至2.0简易脚本存档

作者:leven 日期:2008-09-16 19:54:00

Recent Article

Category

Calendar

User Panel

Statistics

Recent Comments

Archive

Search

Links

Support