def delete():
id = request.args.get('id')#request.args[id]
session = DBSession()
blogs = session.query(Blogs).filter_by(id = id).first()
session.delete(blogs)
session.commit()
session.close()
flash('删除成功!')
return redirect(location='/blogs')
def delete():
id = request.args.get("id") # request.args[id]
session = DBSession()
online = session.query(Online).filter_by(id=id).first()
session.delete(Online)
session.commit()
session.close()
flash("删除成功!")
return redirect(location="/online")
def delete():
id = request.args.get('id')#request.args[id]
session = DBSession()
print id
#session.query(User).filter_by(name='user1')
merchant = session.query(Merchant).filter_by(id = id).first()
session.delete(merchant)
session.commit()
session.close()
flash('删除成功!')
return redirect(location='/merchant')
def praise():
id = request.form.get("id")
session = DBSession()
online = session.query(Online).filter_by(id=id).scalar()
online.praise = Online.praise + 1
session.commit()
session.close()
return jsonify(code=0, praise=Online.praise)
def detail():
id = request.args["id"]
session = DBSession()
online = session.query(Online).filter_by(id=id).scalar()
Online.views = Online.views + 1
session.commit()
session.close()
return render_template("online/content.html", Online=Online)
def praise():
id = request.form.get('id')
session = DBSession()
blogs = session.query(Blogs).filter_by(id=id).scalar()
blogs.praise = blogs.praise+1
session.commit()
session.close()
return jsonify(code=0,praise =blogs.praise )
def add():
if request.method == "GET":
return render_template("online/add.html", id=uuid.uuid4().__str__())
form = request.form
online = Online()
online.id = form.get("id")
session = DBSession()
session.add(Online)
session.commit()
session.close()
flash("添加成功！")
return render_template("online/add.html")
def detail():
id = request.args['id']
session = DBSession()
blogs = session.query(Blogs).filter_by(id=id).scalar()
blogs.views = blogs.views+1
filelist = Resource.query.filter_by(bs_id=blogs.id)
session.commit()
session.close()
return render_template('blogs/content.html',blogs=blogs,filelist = filelist)
def add():
if request.method == 'GET':
articlelist = ArticleType.getlist()
return render_template('blogs/add.html',id= uuid.uuid4().__str__(),articlelist=articlelist)
form = request.form
blogs = Blogs()
blogs.title = form.get('title')
blogs.content = form.get('content')
blogs.synopsis = form.get('synopsis')
blogs.classify = form.get('classify')
blogs.state = form.get('state')
blogs.user_id = g.user.id
session = DBSession()
session.add(blogs)
session.commit()
session.close()
flash('添加成功！')
return render_template('blogs/add.html')
def add():
if request.method == 'GET':
return render_template('merchant/add.html')
#merchant = addMerchantFrom()
form = request.form
merchant = Merchant()
print merchant.id
merchant.name = form.get('name')
merchant.link_name = form.get('link_name')
merchant.address = form.get('address')
merchant.mobile = form.get('mobile')
merchant.qq = form.get('qq')
merchant.we_chat = form.get('we_chat')
merchant.mail = form.get('mail')
session = DBSession()
state = session.add(merchant)
session.commit()
session.close()
#print merchant.id
retult=None
flash('添加成功！')
return render_template('merchant/add.html',retult=retult)
def update():
print 123
if request.method == "GET":
id = request.args["id"]
online = DBSession().query(Online).filter_by(id=id).first()
return render_template("online/update.html", online=online)
print 1234
form = request.form
id = form.get("id")
session = DBSession()
online = session.query(Online).filter_by(id=id).scalar()
online.title = form.get("title")
online.content = form.get("content")
online.classify = form.get("classify")
online.state = form.get("state")
online.synopsis = form.get("synopsis")
session.commit()
session.close()
flash("修改成功！")
return redirect(location="/online")
def index():
session = DBSession()
# onlines = session.query(Online)
session.commit()
session.close()
return render_template("online/index.html")
def update():
if request.method=='GET':
id = request.args['id']
merchant = DBSession().query(Merchant).filter_by(id=id).first()
return render_template('merchant/update.html',merchant = merchant)
form = request.form
old = form['old']
print old
merchant = Merchant()
merchant.id = old
merchant.name = form.get('name')
merchant.link_name = form.get('link_name')
merchant.address = form.get('address')
merchant.mobile = form.get('mobile')
merchant.qq = form.get('qq')
merchant.we_chat = form.get('we_chat')
merchant.mail = form.get('mail')
session = DBSession()
state = session.merge(merchant,load=True)
session.commit()
session.close()
#print merchant.id
retult=None
flash('修改成功！')
return redirect(location='/merchant')
def update():
if request.method=='GET':
id = request.args['id']
articlelist = ArticleType.getlist()
blogs = DBSession().query(Blogs).filter_by(id=id).first()
return render_template('blogs/update.html',blogs = blogs,articlelist=articlelist)
form = request.form
id = form.get('id')
session = DBSession()
blogs = session.query(Blogs).filter_by(id=id).scalar()
blogs.title = form.get('title')
blogs.content = form.get('content')
blogs.classify = form.get('classify')
blogs.state = form.get('state')
blogs.synopsis = form.get('synopsis')
session.commit()
session.close()
flash('修改成功！')
return redirect(location='/blogs')
