def migrateSections(sections):
for section in sections:
parent = section.parent
if not parent:
newParent = rootSection
else:
newParent = AlineaSection.select(AlineaSection.q.publicID == parent.id)[0]
newSection = AlineaSection(name=section.name)
rgt = AlineaNode.openHole(newParent)
newSection.set(lft=rgt, rgt=rgt + 1)
newSection.publicID = section.id
AlineaNode.clearCache()
print "%s - %s" % (newSection.publicID, newSection.name)
# Articles of section
for article in section.alineaArticles:
print " - %s : %s" % (article.id, article.title)
newArticle = AlineaArticle(
title=article.title,
data=article.data,
format=article.format,
date=article.date,
lastModified=article.date,
hits=0,
published=article.published,
html=article.html,
alineaUser=article.alineaUser,
)
rgt = AlineaNode.openHole(newSection)
newArticle.set(lft=rgt, rgt=rgt + 1, publicID=article.id)
AlineaNode.clearCache()
assert newArticle.publicID == article.id
# Comments of the article
for comment in article.comments:
newComment = AlineaComment(
author=comment.author,
email=comment.email,
url=comment.url,
ip=comment.ip,
comment=comment.comment,
date=comment.date,
)
rgt = AlineaNode.openHole(newArticle)
newComment.set(lft=rgt, rgt=rgt + 1, publicID=comment.id)
AlineaNode.clearCache()
print " - %s | %s" % (newComment.publicID, newComment.comment[:20])
