:category: blog
:slug: {slug}
:author: Ken Cochrane
:title: {title}
{content}
"""
db = connect(host="127.0.0.1", user="******", passwd="", db="blog")
dict_curr = DictCursor(db)
dict_curr.execute("select * from blog_entries")
results = dict_curr.fetchall()
for result in results:
slug = result.get("slug", None)
title = result.get("title", None)
orig_tags = result.get("tags", "")
blog_date = result.get("pub_date")
content = result.get("body")
format = result.get("format", "REST")
if format == "REST":
ext = "rst"
else:
ext = "html"
output_file = os.path.join(OUTPUT_DIR, FILE_NAME.format(slug=slug, ext=ext))
tags = ",".join(orig_tags.split(" "))
print(title)
import twik.db as db
import config_db_con
from MySQLdb.cursors import DictCursor
con = db.connections.get_con()
cur = DictCursor(con)
cur.callproc('user_data_byemail', ('*****@*****.**',))
r = cur.fetchall()
print r
cur.close()
db.connections.release_con(con)
