#! /usr/bin/env python

###########################################################
# Requirements:
#
# MySQL-python==1.2.5
#
###########################################################
# Usage:
#
# chmod +x export_blog_theme.py
# ./export_blog_theme.py > blog_theme.csv
#
###########################################################
# Author:
#
# Trinh Nguyen
# E: dangtrinhnt@gmail.com
# W: www.dangtrinh.com
#

import MySQLdb

DB_HOST = ''
DB_USER = ''
DB_PASS = ''
DB_NAME = ''


GET_TABLE_NAME_QUERY = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 'wp_%_options'"
GET_BLOG_THEME_QUERY = "SELECT option_name, option_value FROM {table_name} WHERE option_name IN ('siteurl', 'template')"

if __name__ == "__main__":
	db = MySQLdb.connect(host=DB_HOST, user=DB_USER, passwd=DB_PASS, db=DB_NAME)
	cur = db.cursor()

	# get table names
	cur.execute(GET_TABLE_NAME_QUERY)
	tables = cur.fetchall()

	for tbl in tables:
		query = GET_BLOG_THEME_QUERY.replace('{table_name}', tbl[0])
		cur.execute(query)
		res = cur.fetchall()
		print "%s,%s" % (res[0][1], res[1][1])

	db.close()