标签搜索

Zblog迁移至Typecho,Python脚本

Lan
Lan
2021-06-30 / 1 评论 / 8 阅读 / 正在检测是否收录...

注意,迁移之前一定要全部备份。
我在迁移评论的时候不小心把旧博客的评论表数据给清空了,还好有数据备份。
文章迁移脚本
此脚本需要先将分类表手动迁移,注意ID以及名称要和原来的一致

# -*- coding: utf-8 -*-
"""
-------------------------------------------------
@ Author :Lan
@ Blog :www.lanol.cn
@ Date : 2021/6/29
@ Description:I'm in charge of my Code
-------------------------------------------------
"""
import time

import pymysql

HOST = "数据库HOST地址"
USER = "数据库用户名"
PASSWORD = "数据库密码"
PORT = 数据库端口
db = pymysql.connect(HOST, USER, PASSWORD, "旧数据库名称", PORT, charset='utf8')
selectSql = "select * from zbp_post where log_cateID!=0 and log_ID!=436"
cursor = db.cursor()
cursor.execute(selectSql)
source = cursor.fetchall()
db.close()
db = pymysql.connect(HOST, USER, PASSWORD, "新数据库名称", PORT, charset='utf8')
cursor = db.cursor()
a = 1
for i in source:
    cid = i[0]
    title = i[9].replace("'", '"')
    slug = i[0]
    created = i[12]
    modified = i[12]
    text = i[11].replace('{#ZC_BLOG_HOST#}', '新的博客地址')
    order = 0
    authorid = 1
    template = None
    type = 'post'
    status = 'publish'
    password = ''
    commentsNum = i[13]
    allowComment = 1
    allowPing = 1
    allowFeed = 1
    parent = 0
    views = i[14]
    agree = 0
    try:

        insertSql = f"INSERT INTO typecho_contents VALUES({cid},'{title}','{slug}','{created}','{modified}','{text}','{order}','{authorid}',NULL,'{type}','{status}','{password}','{commentsNum}','{allowComment}','{allowPing}','{allowFeed}','{parent}','{views}','{agree}') "
        cursor.execute(insertSql)
        insertSql = f"Insert into typecho_relationships values('{cid}','{i[1]}')"
        cursor.execute(insertSql)
        db.commit()
        print(f'{cid}迁移成功')
    except:
        print(f'{cid}迁移失败')
db.commit()
db.close()

评论数据迁移脚本

# -*- coding: utf-8 -*-
"""
-------------------------------------------------
@ Author :Lan
@ Blog :www.lanol.cn
@ Date : 2021/6/29
@ Description:I'm in charge of my Code
-------------------------------------------------
"""

import pymysql
import time

HOST = "数据库HOST地址"
USER = "数据库用户名"
PASSWORD = "数据库密码"
PORT = 数据库端口
db = pymysql.connect(HOST, USER, PASSWORD, "旧数据库名称", PORT, charset='utf8')
selectSql = "select * from zbp_comment"
cursor = db.cursor()
cursor.execute(selectSql)
source = cursor.fetchall()
db.close()
db = pymysql.connect(HOST, USER, PASSWORD, "新数据库名称", PORT, charset='utf8')
cursor = db.cursor()
for i in source:
    cid = i[1]
    created = i[10]
    author = i[6]
    authorId = i[5]
    ownerid = i[5]
    mail = i[7]
    url = i[8]
    ip = i[11]
    agent = i[12]
    text = i[9]
    type = 'comment'
    status = 'approved'
    parent = i[4]
    try:
        insertSql = f"Insert into typecho_comments values (NULL ,'{cid}','{created}','{author}','{authorId}','{ownerid}','{mail}','{url}'" \
                    f",'{ip}','{agent[:100]}','{text}','{type}','{status}','{parent}')"
        cursor.execute(insertSql)
        db.commit()
    except:
        print(f'{cid}迁移失败')
db.commit()
db.close()
1

评论 (1)

取消
  1. 头像
    Lan 作者
    Android · Google Chrome

    画图

    回复