Export old MySQL post table to MarkDown files

blog-to-markdown.py

import json
import os

with open('oldblog.json') as f:
  data = json.load(f)

sorted_pages = sorted(data, key=lambda k: int(k['id']))
posts = (x for x in sorted_pages if x['page_status'] in 'published')

for post in posts:
  print post['id'] + " " + post['page_title']

  filename = "blog/%s/%s.md" % (post['page_datetime'][:4], post['page_url'])
  if not os.path.exists(os.path.dirname(filename)):
    os.makedirs(os.path.dirname(filename))
  
  file = open(filename,"w") 
 
  file.write("---\n")
  file.write("title: %s\n" % post['page_title'].replace(':','-').encode('utf-8', 'ignore'))
  file.write("type: article" + "\n")
  file.write("tags: %s\n" % post['page_category'])
  file.write("date: %s\n" % post['page_datetime'])
  if post['page_header_image']:
    headImage = post['page_header_image'].replace('/assets/uploads/', '/_assets/img/blog/imported/')
    file.write("leadImage: %s\n" % headImage)
  file.write("---\n")
  file.write("%s\n" % post['page_content'].encode('utf-8', 'ignore'))
   
  file.close()