Below is a simple script for importing an article directly into mp-wp via the db inspired by lobbes' previous work on importing logs into mp-wp. It is a necessary step towards being able to import the entire Encyclopedia Britannica into mp-wp. I thought it might be useful for anyone wishing to automate creation of articles.
#!/usr/bin/python
import mysql.connector
import time
import json
from pprint import pprint
def add_article(cnx, article):
cursor = cnx.cursor()
content = article['content']
current_date = time.strftime("%Y-%m-%d %H:%M:%S",
(1910, 1, 1, 1, 3, 38, 1, 48, 0))
current_date_gmt = current_date
title = article['title']
post_url_relative = '-'.join(title.split())
query = '''INSERT INTO wpmp_posts(post_author, post_date,
post_date_gmt, post_content, post_title,
post_category, post_status, comment_status, ping_status,
post_name, post_modified, post_modified_gmt, post_parent,
guid, menu_order, post_type, comment_count,
post_excerpt, to_ping, pinged, post_content_filtered,
post_mime_type, post_password) VALUES (%s,%s,%s,%s,
%s,%s,%s,%s,
%s,%s,%s,%s,
%s,%s,%s,%s,
%s,%s,%s,%s,
%s,%s,%s) ; '''
cursor.execute(
query,
(0, current_date, current_date_gmt, content, title, 0, "publish",
"open", "open", post_url_relative, current_date,
current_date_gmt, 0, "", 0, "post", 0, "", "", "", "", "", "")
)
cnx.commit()
cnx = mysql.connector.connect(user='jwz', password='justwantedto',
host='127.0.0.1',
database='alethepedia')
json_file = '../data/encyclopedia.json'
with open(json_file) as json_data:
data = json.load(json_data)
add_article(cnx, data[0]['articles'][0])
cnx.close()