All Ghost article to Hexo md

blog.py

#!/usr/bin/env python
# -*- coding: utf-8 -*-

import sqlite3
import time, datetime
import sys
reload(sys)
sys.setdefaultencoding('utf-8')

cx = sqlite3.connect("/path/to/ghost.db")
cu = cx.cursor()
cu.execute("select title, slug, markdown, published_at from posts")
cx.commit()

arr = list(cu.fetchall())

path = "/path/"

def save(filename, contents):
    fh = open(filename, 'w')
    fh.write(contents)
    fh.close()

for cell in arr:
	content = """---\ntitle: """ + cell[0] + """\ndate: """ + time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(cell[3]/1000)) + """\n---\n""" + cell[2]
	save(path+cell[1]+'.md', content)