Import Textpattern to Jekyll

A python script to import blog posts from textpattern to Jekyll

Requires: web.py

Update 2023-10-31: copied code from gist to inline. No other changes.

import os
import web
import codecs
 
db = web.database(dbn=os.environ.get('DATABASE_ENGINE', 'mysql'),
                          db='textpatterndb', user="root", passwd="BANANA")
def main():
    QUERY = """SELECT Title, id,
                    url_title,
                    Posted,
                    Body,
                    concat(Category1, case when Category2 <> '' then concat(' ', Category2) else '' end) as Categories, \
                    comments_count
             FROM textpattern
             WHERE Status = '4' OR
                   Status = '5';
    """
    results = db.query(QUERY)
 
    for r in results:
        content = r.Body
        slug = r.url_title
        name = '-'.join([r.Posted.strftime("%Y-%m-%d"), slug]) + ".textile"
        os.makedirs('/tmp/_posts')
 
        f = codecs.open('/tmp/_posts/%s' % name, 'w', "utf-8")
        f.write('---\n')
        f.write('layout: post\n')
        f.write('title: %s\n' % r.Title.replace('/', '-'))
        f.write('categories: %s\n' % r.Categories.replace('/', '-'))
        f.write('permalink: %s\n' % slug)
        f.write('---\n\n')
        f.write(content)
        f.close()
 
if __name__ ==  '__main__':
    main()