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)