def add_to_post(tag_id,post_id):
try:
tag_post = Tag_Post(None,post_id,tag_id)
Session.add(tag_post)
Session.commit()
except:
# Couldn't add tag to post - already exists!
# TODO: This should be logged to avoid future nasty bugs
pass
def init_data():
print "Initing box data"
query = Session.query(Box)
for rec in values:
if not query.get(rec[0]):
item = Box()
item.name = unicode(rec[1])
item.template = unicode(rec[2])
Session.add(item)
Session.commit()
def init_data():
print "Initing config data"
query = Session.query(Config)
for rec in values:
if not query.get(unicode(rec[0])):
config = Config()
config.id = unicode(rec[0])
config.value = unicode(rec[1])
Session.add(config)
Session.commit()
def init_data():
print "Initing media data"
query = Session.query(Media)
for rec in values:
if not query.get(rec[0]):
media = Media()
media.id = rec[0]
media.name = unicode(rec[1])
media.url = unicode(rec[2])
Session.add(media)
Session.commit()
def init_data():
print "Initing boxes data"
query = Session.query(Boxes)
for rec in values:
if not query.get(rec[0]):
item = Boxes()
item.box_id = rec[1]
item.status = rec[2]
item.order = rec[3]
Session.add(item)
Session.commit()
def init_data():
print "Initing page_type data"
query = Session.query(Page_Type)
for rec in values:
if not query.get(rec[0]):
page_type = Page_Type()
page_type.id = rec[0]
page_type.name = unicode(rec[1])
page_type.controller = unicode(rec[2])
page_type.action = unicode(rec[3])
page_type.param = unicode(rec[4])
Session.add(page_type)
Session.commit()
def init_data():
print "Initing social data"
query = Session.query(Social)
for rec in values:
if not query.get(rec[0]):
social = Social()
social.id = rec[0]
social.name = unicode(rec[1])
social.status = rec[2]
social.priority = rec[3]
social.url = unicode(rec[4])
social.media_id = rec[5]
Session.add(social)
Session.commit()
def init_data():
print "Initing page data"
query = Session.query(Page)
for rec in values:
if not query.get(rec[0]):
page = Page()
page.id = rec[0]
page.name = unicode(rec[1])
page.status = rec[2]
page.page_order = rec[3]
page.url = unicode(rec[4])
page.type = rec[5]
Session.add(page)
Session.commit()
def init_data():
print "Initing auth data"
query = Session.query(User)
for rec in user_values:
if not query.get(unicode(rec[0])):
user = User()
user.username = unicode(rec[1])
user.email = unicode(rec[2])
user._set_password(unicode(rec[3]))
user.name = unicode(rec[4])
Session.add(user)
Session.commit()
query = Session.query(Group)
for rec in group_values:
if not query.get(unicode(rec[0])):
group = Group()
group.name = unicode(rec[1])
Session.add(group)
Session.commit()
query = Session.query(Permission)
for rec in permission_values:
if not query.get(unicode(rec[0])):
permission = Permission()
permission.name = unicode(rec[1])
Session.add(permission)
Session.commit()
query = Session.query(User_Group)
for rec in user_group_values:
if not query.get(unicode(rec[0])):
user_group = User_Group()
user_group.user_id = unicode(rec[1])
user_group.group_id = unicode(rec[2])
Session.add(user_group)
Session.commit()
query = Session.query(Group_Permission)
for rec in group_permission_values:
if not query.get(unicode(rec[0])):
group_permission = Group_Permission()
group_permission.group_id = unicode(rec[1])
group_permission.permission_id = unicode(rec[2])
Session.add(group_permission)
Session.commit()
def save(post):
Session.add(post)
Session.commit()
def save(comment):
Session.add(comment)
Session.commit()
def save_tag(name):
tag = Tag(None,name.lower().strip())
Session.add(tag)
Session.commit()
