flask搭建个人博客

from sqlalchemy import Table, func from model.tt_user import User from common.create_connect import extendsModel FactorySession,FactoryModel,md=extendsModel() class Article(FactoryModel): __table__=Table('tt_article',md,autoload=True) # 定义操作 #指定分页limit限制和最新显示offset select * from user limit param1 offset param2 ; 从（param2+1）条数据开始，取 param1条数据 def find_with_nickname(self,start,count): result=FactorySession.query(Article,User.nickname).join(User,User.userid==Article.userid)\ .filter(Article.hidden==0,Article.drafted==1,Article.checked==1)\ .order_by(Article.articleid.asc()).limit(count).offset(start).all() return result #将数据库表映射到对象 #获取文章数量 def find_view_artilce_count(self): count=FactorySession.query(Article).filter(Article.hidden==0,Article.drafted==1,Article.checked==1).count() return count #根据文章类型获取文章 def find_article_by_type(self,type,start,count): result=FactorySession.query(Article,User.nickname).filter(Article.hidden==0,Article.drafted==1,Article.checked==1,Article.type==type)\ .order_by(Article.articleid.asc()).limit(count).offset(start).all() #按文章类型将所有文章查出来 return result #根据文章类型获取不同文章类型的数量 def get_diffrent_articelcount_by_type(self,type): articel_count = FactorySession.query(Article).filter(Article.hidden == 0, Article.drafted == 1, Article.checked == 1,Article.type==type).count() return articel_count #根据文章标题搜索 def serach_by_headline(self,headline,start,count): result = FactorySession.query(Article, User.nickname).filter(Article.hidden == 0, Article.drafted == 1, Article.checked == 1, Article.headline.like('%'+headline+'%') ) \ .order_by(Article.articleid.asc()).limit(count).offset(start).all() # 按文章类型将所有文章查出来 return result #统计搜索标题的总数量 def getcount_by_headline(self,headline): articel_count = FactorySession.query(Article).filter(Article.hidden == 0, Article.drafted == 1, Article.checked == 1, Article.headline.like('%'+headline+'%')).count() return articel_count #最新文章推荐 def get_new_article(self): #倒叙输出文章 result=FactorySession.query(Article.articleid,Article.headline)\ .filter(Article.hidden==0,Article.drafted==1,Article.checked==1,Article.recommended==1)\ .order_by(Article.articleid.desc()).limit(9).all() return result #最多阅读文章 def get_max_readed_articel(self): result = FactorySession.query(Article.articleid, Article.headline) \ .filter(Article.hidden == 0, Article.drafted == 1, Article.checked == 1, Article.recommended == 1) \ .order_by(Article.readcount.desc()).limit(9).all() # 倒叙输出文章 return result #特别推荐从推荐随机生成文章 def get_random_article(self): result = FactorySession.query(Article.articleid, Article.headline) \ .filter(Article.hidden == 0, Article.drafted == 1, Article.checked == 1, Article.recommended == 1) \ .order_by(func.rand()).limit(9).all() # 倒叙输出文章 return result #将上述三个结果一次返回 def get_three_result(self): new= self.get_new_article() max=self.get_max_readed_articel() random=self.get_random_article() return new,max,random #根据文章id搜索文章 def get_article_by_id(self,id): result = FactorySession.query(Article).filter(Article.hidden == 0, Article.drafted == 1, Article.checked == 1, Article.articleid == id).all() return result #每阅读一次文章阅读量加一 def update_read_count(self,articleid): result = FactorySession.query(Article).filter(Article.articleid==articleid).first() result.readcount += 1 FactorySession.commit() ''' def test_function(self): result = FactorySession.query(Article.headline).filter(Article.userid == 3).first() return result ''' """测试函数 if __name__=='__main__': article = Article() #result1 = article.get_diffrent_articelcount_by_type(4) #result1=article.test_function() #result1=article.get_article_by_id(50) #result1=article.get_new_article() #print(result1) #result=article.update_read_count(1) print(article.get_random_article()[0]) """