def updateAr(id): title = request.form['title'] sortedValue = request.form['sorted'] if( db.sorted().getSortid(sortedValue)): sortedValue = db.sorted().getSortid(sortedValue) else: return 'False' content = request.form['content'] date = request.form['date'] if(not (title and sortedValue and content)): return 'False' if(db.blog().updateArticle(id,title,date,content,sortedValue)): return 'True' else: return 'False'
def addsort(): arg = request.args sort = arg['sort'] if(db.sorted().addSort(sort)): return 'True' else: return 'False'
def article(id): article = db.blog().getArticlebyid(id) categroy = db.sorted().getSort() if('username' in session): return render_template('article.html',username=session['username'],categroy=categroy,article=article) else: return render_template('article.html',categroy=categroy,article=article)
def addarticle(): title = request.form['title'] sortedValue = request.form['sorted'] if( db.sorted().getSortid(sortedValue)): sortedValue = db.sorted().getSortid(sortedValue) else: return 'False' content = request.form['content'] #content = content.replace('\n','<br/>') #content = content.replace(' ',' ') date = request.form['date'] if(not (title and sortedValue and content)): return 'False' if(db.blog().addArticle(title,session['username'],date,content,sortedValue)): return 'True' else: return 'False'
def getcategory(): category = db.sorted().getSort().all() a = {} b = 0 for i in category: a[b] = i.name b += 1 c=json.dumps(a) return c
def sort(id,num=1): sort = 'sort' categroy = db.sorted().getSort() count = db.blog().getCount(id) pagenum = (count/(pagecount+1))+1 if (num==1): article = db.blog().getSortArticle(id).limit(pagecount).all() else: article = db.blog().getSortArticle(id).limit(pagecount).offset((num-1)*pagecount).all() x = min(6,pagenum + 1) y = min(pagenum + 1,num + 4) if('username' in session): return render_template('list.html',username=session['username'],categroy=categroy,article=article,count=pagenum,page=num,x=x,y=y,sort=sort,id=id) else: return render_template('list.html',categroy=categroy,article=article,count=pagenum,page=num,x=x,y=y,sort=sort,id=id)
def update(id): categroy = db.sorted().getSort() article = db.blog().getArticlebyid(id) sort = db.sorted().getSortname(article.sorted).name return render_template('update.html',username=session['username'],categroy=categroy,article=article,sorted=sort)
def write(): categroy = db.sorted().getSort() article = db.blog().getallArticle() return render_template('write.html',username=session['username'],categroy=categroy,article=article)