def makePageFriendlyPost(post):
tz = lambda d: dthelper.utcToTimezone(targetTimezone=config.TIMEZONE, date=d)
parseFormat = "%Y-%m-%d %H:%M:%S%z"
return {
"id" : post["id"],
"title" : post["title"],
"authorId" : post["authorId"],
"author" : post["author"],
"slug" : post["slug"],
"permalink" : "/post/{0}/{1}/{2}".format(post["publishedYear"], post["publishedMonth"], post["slug"]),
"rawContent" : post["content"],
"renderedContent" : renderMarkdown(rawMarkdown=post["content"]),
"createdDateTime" : dthelper.formatDateTime(date=tz(post["createdDateTime"]), parseFormat=parseFormat),
"publishedDateTime" : "" if post["publishedDateTime"] == None else dthelper.formatDateTime(date=tz(post["publishedDateTime"]), parseFormat=parseFormat),
"publishedDate" : "" if post["publishedDateTime"] == None else dthelper.formatDate(date=tz(post["publishedDateTime"]), parseFormat=parseFormat),
"publishedDateUSFormat": "" if post["publishedDateTime"] == None else dthelper.formatDate(date=tz(post["publishedDateTime"]), outputFormat="%m/%d/%Y", parseFormat=parseFormat),
"publishedTime" : "" if post["publishedDateTime"] == None else dthelper.formatTime(date=tz(post["publishedDateTime"]), parseFormat=parseFormat),
"publishedTime12Hour" : "" if post["publishedDateTime"] == None else dthelper.formatTime(date=tz(post["publishedDateTime"]), outputFormat="%I:%M %p", parseFormat=parseFormat),
"publishedYear" : post["publishedYear"],
"publishedMonth" : post["publishedMonth"],
"postStatusId" : post["postStatusId"],
"status" : post["status"],
"tagList" : post["tagList"],
"tags" : "" if not post["tagList"] else post["tagList"].split(","),
"tagIdList" : post["tagIdList"],
"tagIds" : "" if not post["tagIdList"] else post["tagIdList"].split(","),
}
def createPost(title, author, slug, content, createdDateTime, tags, status, publishedDateTime=None, publishedYear=None, publishedMonth=None):
if len(title) < 3: return (False, "Title must be at least 3 characters", None)
if len(slug) < 3: return (False, "Slug must be at least 3 characters", None)
if len(content) < 3: return (False, "Content must be at least 3 characters", None)
if isinstance(tags, basestring):
tags = tags.split(",")
id = database.execute(sql="""
INSERT INTO post (
title
, authorId
, slug
, content
, createdDateTime
, postStatusId
, publishedDateTime
, publishedYear
, publishedMonth
) VALUES (
%s
, %s
, %s
, %s
, %s
, %s
, %s
, %s
, %s
)
""", parameters=(
title
, author["id"]
, slug
, content
, dthelper.formatDateTime(date=createdDateTime)
, status["id"]
, None if publishedDateTime is None else dthelper.formatDateTime(date=publishedDateTime)
, None if publishedYear is None else dthelper.getYear(date=publishedYear)
, None if publishedMonth is None else dthelper.getMonth(date=publishedMonth)
))
createUpdatePostTags(postId=id, tags=tags)
return newPostBean(
title = title,
authorId = author["id"],
slug = slug,
content = content,
createdDateTime = dthelper.parseDateTime(date=createdDateTime),
publishedDateTime= None if publishedDateTime is None else dthelper.parseDateTime(date=publishedDateTime),
publishedYear = None if publishedYear is None else dthelper.getYear(date=publishedYear),
publishedMonth = None if publishedMonth is None else dthelper.getMonth(date=publishedMonth),
postStatusId = status["id"],
tags = tags,
)
def publishPost(postId): database.execute(sql=""" UPDATE post SET postStatusId=(SELECT id FROM poststatus WHERE status='Published' LIMIT 1) , publishedDateTime=CASE WHEN publishedDateTime IS NULL THEN %s ELSE publishedDateTime END , publishedYear=CASE WHEN publishedYear IS NULL THEN %s ELSE publishedYear END , publishedMonth=CASE WHEN publishedMonth IS NULL THEN %s ELSE publishedMonth END WHERE id=%s """, parameters=( dthelper.formatDateTime(date=dthelper.utcNow()), dthelper.getYear(date=dthelper.utcNow()), dthelper.getMonth(date=dthelper.utcNow()), postId, )) return database.LAST_NUM_AFFECTED
def updatePost(id, title, slug, content, tags, status, publishedDateTime=None, publishedYear=None, publishedMonth=None):
if len(title) < 3: return (False, "Title must be at least 3 characters", None)
if len(slug) < 3: return (False, "Slug must be at least 3 characters", None)
if len(content) < 3: return (False, "Content must be at least 3 characters", None)
post = getPostById(id=id)
tags = tags.split(",")
if post:
post["title"] = title
post["slug"] = slug
post["content"] = content
post["tags"] = tags
post["status"] = status
post["postStatusId"] = getPostStatus(status=status)["id"]
post["publishedDateTime"] = None if publishedDateTime is None else dthelper.formatDateTime(date=publishedDateTime)
post["publishedYear"] = None if publishedYear is None else dthelper.getYear(date=publishedYear)
post["publishedMonth"] = None if publishedMonth is None else dthelper.getMonth(date=publishedMonth)
sql = """
UPDATE post SET
title=%s
, slug=%s
, content=%s
, publishedDateTime=%s
, publishedYear=%s
, publishedMonth=%s
, postStatusId=%s
WHERE id=%s
"""
parameters = (
post["title"],
post["slug"],
post["content"],
post["publishedDateTime"],
post["publishedYear"],
post["publishedMonth"],
post["postStatusId"],
id,
)
database.execute(sql=sql, parameters=parameters)
createUpdatePostTags(postId=id, tags=post["tags"])
return post
def makeAdminTableFriendlyPost(post):
tz = lambda d: dthelper.utcToTimezone(targetTimezone=config.TIMEZONE, date=d)
parseFormat = "%Y-%m-%d %H:%M:%S%z"
return {
"id" : post["id"],
"title" : post["title"],
"permalink" : "/post/{0}/{1}/{2}".format(post["publishedYear"], post["publishedMonth"], post["slug"]),
"publishedDateTime" : "" if post["publishedDateTime"] == None else dthelper.formatDateTime(date=tz(post["publishedDateTime"]), parseFormat=parseFormat),
"publishedDate" : "" if post["publishedDateTime"] == None else dthelper.formatDate(date=tz(post["publishedDateTime"]), parseFormat=parseFormat),
"publishedDateUSFormat": "" if post["publishedDateTime"] == None else dthelper.formatDate(date=tz(post["publishedDateTime"]), outputFormat="%m/%d/%Y", parseFormat=parseFormat),
"publishedTime" : "" if post["publishedDateTime"] == None else dthelper.formatTime(date=tz(post["publishedDateTime"]), parseFormat=parseFormat),
"publishedTime12Hour" : "" if post["publishedDateTime"] == None else dthelper.formatTime(date=tz(post["publishedDateTime"]), outputFormat="%I:%M %p", parseFormat=parseFormat),
"postStatusId" : post["postStatusId"],
"status" : post["status"],
"tagList" : post["tagList"],
"tagIdList" : post["tagIdList"],
}
def parseMarkdownFile(fileName, sourceTimezone):
with open(fileName) as markdownFile:
markdownContent = markdownFile.read()
#
# Parse the file
#
mode = "METADATA"
metadata = {}
content = []
for line in markdownContent.split("\n"):
if mode == "METADATA":
if line.find(":") == -1:
mode = "CONTENT"
if len(line.strip()):
content.append(line)
else:
split = line.split(":")
key = split[0].strip().lower()
if key == "tags":
value = [tag.strip() for tag in split[1].split(",")]
elif key == "date":
value = "{0}:{1}".format(split[1], split[2]).strip()
value = dthelper.formatDateTime(date=dthelper.timezoneToUtc(sourceTimezone=sourceTimezone, date=value, parseFormat="%Y-%m-%d %H:%M"), parseFormat="%Y-%m-%d %H:%M:%S%z")
metadata["publishedMonth"] = int(dthelper.getMonth(date=value, parseFormat=dthelper.REST_DATETIME_FORMAT))
metadata["publishedYear"] = int(dthelper.getYear(date=value, parseFormat=dthelper.REST_DATETIME_FORMAT))
else:
value = ":".join(split[1:]).strip()
metadata[key] = value
else:
content.append(line)
return (metadata, stipInvalidUnicodeCharacters("\n".join(content)))