def get_index(): session = connect_db() q = session.query(post).filter_by(is_index = 1) if q.count() == 0: return None else: return q.one()
def set_post_by_id(s): session = connect_db() if s.id: update = session.query(post).filter_by(id = s.id).one() update.title = s.title update.url = s.url update.link = s.link update.content = s.content update.formatted_content = markdown.markdown(s.content) update.modified_time = get_modified_time(8) update.is_page = int(s.is_page) update.is_isolated = int(s.is_isolated) update.is_index = 0 session.commit() else: new = post() new.title = s.title new.url = s.url new.link = s.link new.content = s.content new.formatted_content = markdown.markdown(s.content) new.created_time = get_modified_time(8) new.modified_time = get_modified_time(8) new.is_isolated = int(s.is_isolated) new.is_page = int(s.is_page) new.is_index = 0 session.add(new) session.commit()
def set_index(s): session = connect_db() try: update = session.query(post).filter_by(is_index = 1).one() except: update = post() session.add(update) update.title = s.title update.content = s.content update.formatted_content = markdown.markdown(s.content) update.modified_time = get_modified_time(8) update.created_time = get_modified_time(8) update.is_index = 1 update.is_isolated = 1 update.url = '/' session.commit()
def set_site_setting(s): session = connect_db() q = session.query(site_setting) if q.count() == 0: new = site_setting() new.site_name = s.site_name new.site_slogan = s.site_slogan new.author = s.author new.google_analytic_id = s.google_analytic_id session.add(new) session.commit() else: update = q.one() update.site_name = s.site_name update.site_slogan = s.site_slogan update.author = s.author update.google_analytic_id = s.google_analytic_id session.commit() return
def get_site_setting(): session = connect_db() q = session.query(site_setting) if q.count() == 0: return None return q.one()
def get_latest(): session = connect_db() return session.query(post).filter_by(is_index = 0).order_by(desc(post.created_time)).all()
def get_last_modified(): session = connect_db() return session.query(post).filter_by(is_index = 0).order_by(desc(post.modified_time)).all()
def get_all_no_isolated(): session = connect_db() return session.query(post).order_by(\ desc(post.created_time)).filter_by(is_isolated = 0, is_index = 0).all()
def get_post_by_id(id): session = connect_db() q = session.query(post).filter_by(id = id) if q.count() == 0: return None return q.one()
def get_post_by_url(url): session = connect_db() q = session.query(post).filter_by(url = url) if q.count() == 0: return None return q.one()
def remove_post(s): session = connect_db() u = session.query(post).filter_by(id = s.id).one() session.delete(u) session.commit()