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()