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)