def delcatagorys(): catagory=Catagory() requeststr = request.query_string ids=utils.getAjaxIds(unquote(requeststr)) for catagoryid in ids: catagory.deletecatagory(catagoryid) return(jsonify(msg='0000'))
def addcatagory():
catagory=Catagory()
requeststr = request.query_string
print unquote(requeststr)
params=utils.getparam(unquote(requeststr))
catagory.catagoryname=params['catagoryname']
catagory.belongto=params['belongto']
catagory.addcatagory()
return jsonify(msg='0000')
def editcatagory():
catagory=Catagory()
requeststr=request.query_string
params=utils.getparam(unquote(requeststr))
paramdict={}
paramdict["catagoryid"]=params['catagoryid']
paramdict["catagoryname"]=params['catagoryname']
paramdict["belongto"]=params['belongto']
catagory.updatecatagory(paramdict)
return jsonify(msg='0000')
def getcatagorys(): catagory=Catagory() pageIndexParam = request.form['pageIndex'] belongto=request.form['belongto'] query=Catagory.query ###条件查询#### if belongto: query=query.filter(Catagory.belongto == belongto) pageIndexParam=int(pageIndexParam)+1 total=len(query.all()) paginate = query.paginate(pageIndexParam, 10, False) catagorys = paginate.items catagorylist = [] for catagory in catagorys: catagorylist.append(catagory.to_json()) return (jsonify(rows=catagorylist,results=total))
def new_catagory():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
new_name = request.form['name']
new_catagory = Catagory(name=new_name,
user_id=login_session['user_id'])
session.add(new_catagory)
session.commit()
return redirect(url_for('show_catagory'))
else:
return render_template('new_catagory.html')
def addRecord(**args):
session = connectdb()
cat = session.query(Catagory).filter_by(name=args['cat'])
if cat.all():
catobj = cat.one()
else:
catobj = Catagory(args['cat'])
taskobj = Task(args['task'])
taskobj.cat = catobj
# if True:
# session.add(task)
# date = args['date'].today()
record = Record(args['date'], args['start_time'], args['big_or_not'])
record.task = taskobj
session.merge(
record
) # cat and task will save/update automatically and cascade due to the session's default setting?
my_db_commit(session)
session.close()
# session won't be persisted into the database until you call
# session.commit(). If you're not happy about the changes, you can
# revert all of them back to the last commit by calling
# session.rollback()
session = DBSession()
User1 = User(
name="sayed sohel",
email="*****@*****.**",
picture=
'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png'
)
session.add(User1)
session.commit()
Catagory2 = Catagory(name="Beverages")
session.add(Catagory2)
session.commit()
Item2 = Item(name="item2",
description="Item description goes here",
catagory=Catagory2)
session.add(Item2)
session.commit()
Item1 = Item(name="item1",
description="Item description goes here",
catagory=Catagory2)
