def add_item(): form = ItemForm() if form.validate_on_submit(): item = Items(name=form.name.data, quantity=form.quantity.data, description=form.description.data, date_added=datetime.datetime.now()) db_session.add(item) db_session.commit() return redirect(url_for('success')) return render_template('index.html', form=form)
def add_item(): #raise form = ItemForm() if request.method == 'POST': if form.validate_on_submit(): item = Items(name=form.name.data, quantity=form.quantity.data, description=form.description.data, date_added=datetime.datetime.now()) db_session.add(item) db_session.commit() logging.warn(" after committ...") #return redirect(url_for('success')) return redirect('/success') return render_template('index.html', form=form)
def add_item(): form = ItemForm() if form.validate_on_submit(): item = Items( name=form.name.data, quantity=form.quantity.data, description=form.description.data, date_added=str(datetime.datetime.now()), ) db_session.add(item) db_session.commit() return redirect(url_for("success", _external=True)) return render_template("index.html", form=form)
def order(request): # 这里添加验证 不能全是0 网页上也要验证 orderTemp = Order(employee=Employee.objects.get(name=request.session['username'])) orderTemp.save() for stationery in Stationery.objects.all(): if request.POST.get(str(stationery.id)) != '0': item = Items(stationery=stationery, amount=request.POST[str(stationery.id)], order=orderTemp) item.save() # print request.POST.get(str(stationery.id)) ItemList = Items.objects.filter(order=orderTemp) return render(request, 'wenjuApp/result.html', {'ItemList': ItemList})
def item(): print "reached in item view" if request.method == 'GET': form = ItemForm(request.form) return render_template('forms/item.html', form=form) if request.method == 'POST': print "hii" itemlist = Items(request.form['itemname'], request.form['price'], request.form['description']) print itemlist db.session.add(itemlist) db.session.commit() return redirect(url_for('how'))
def add_item(): if request.method == 'GET': if (login_session['username'] is not None): categories = db.query(Category).all() return render_template('add_item.html', login_session=login_session, categories=categories) else: return render_template('login.html', error="You must be logged in to do that!") elif request.method == 'POST': if login_session['username'] is not None: categories = db.query(Category).all() item_name = request.form.get('item_name') price = request.form.get('price') description = request.form.get('description') category = request.form.get('category') new_category = request.form.get('new_category') if item_name is not None and item_name != '': item = Items(name=item_name) if price is not None and item.price != '': item.price = price if description is not None and description != '': item.description = description item.author = getUserInfo(login_session['user_id']) else: flash("You need to give an item!") return redirect(url_for('add_item')) if category is not None and category != '': c = db.query(Category).filter_by(name=category).first() item.category = c elif new_category is not None and new_category != '': c = db.query(Category).filter_by(name=new_category).first() if (c): flash("You cannot add a category that already exists!") return redirect(url_for('add_item')) new_category = Category(name=new_category) item.category = new_category db.add(new_category) else: flash("You need to provide a category!") return redirect(url_for('add_item')) db.add(item) db.commit() return redirect(url_for('index')) else: flash("Please log in to add items") return redirect(url_for('index'))
def newCategoryItem(): """add new items""" categories = session.query(Categories).all() if request.method == 'POST': newItem = Items(name=request.form['name'], description=request.form['description'], date=datetime.datetime.now(), category_id=request.form['category'], user_id=login_session['user_id']) session.add(newItem) session.commit() flash("New Item added: %s " % newItem.name) return redirect(url_for('showCatalog')) return render_template('addItem.html', categories=categories)
def addItem(): catalog = session.query(Category).all() if request.method == 'POST': newItemToAdd = Items(name=request.form['name'], description=request.form['description'], category=session.query(Category).filter_by( name=request.form['category']).one(), user_id=login_session['user_id']) session.add(newItemToAdd) session.commit() flash("Successfully Added New Item") return redirect(url_for('showCatalog')) else: return render_template('private_AddItem.html', catalog=catalog)
def add_todo(name, item): os.system('clear') todo_title() s = select([Category]) result = s.execute() for r in result: if r[1] == name: data = Items(category_id=r[0], items=item) session.add(data) session.commit() open_todo(name)
def addCatalogItem(): if not login_session.get('access_token'): return redirect('/') else: logged_in = True ownerId = login_session["user_id"] # Query all of the categories categories = session.query(Categories).order_by("categoryName").all() # POST methods actions if request.method == 'POST': # Set the name of the new restaurant into the dictionary new_item = Items(itemName=request.form['item_name'], itemDescription=request.form['item_description'], owner=ownerId, added=currentDateTime, modified=currentDateTime, status='A') # Add it to the session session.add(new_item) # Commit the addition to the database session.commit() addedItem = session.query(Items).order_by(Items.itemId.desc()).first() """Flash message that the item was successfully added. Add BOOTSTRAP css classes as the message category.""" flash('New item was successfully added! (%s)' % addedItem.itemName, 'badge badge-success') new_cat = request.form['item_category'] new_count = request.form['item_inventory'] new_price = request.form['item_price'] new_item_category = ItemCategories(categoryId=new_cat, itemId=addedItem.itemId) new_item_inventory = Inventory(itemId=addedItem.itemId, inventoryCount=new_count, itemPrice=new_price, lastUpdated=currentDateTime) session.add(new_item_category) session.add(new_item_inventory) session.commit() # Item Tags - Outside of scope of this project - Do later # Item Photo - Outside of scope of this project - Do later # Redirect the user back to the main Restaurants page return redirect(url_for('showMyItems')) # GET method actions else: # Display the Add New Restaurant form page return render_template('addItem_LoggedIn.html', categories=categories, email=login_session['email'], logged_in=logged_in)
def add_item(): form = ItemForm() # Only when posting if form.validate_on_submit(): # Populate item for insertion item = Items(name=form.name.data, quantity=form.quantity.data, description=form.description.data, date_added=datetime.datetime.now()) try: db_session.add(item) db_session.commit() return redirect(url_for('success')) except: #When failed, pressing the back key will keep the input boxes filled return "Go back and check if quantity is a number or not." return render_template('index.html', form=form)
def add_item(): form = ItemForm(request.form) if request.method=="POST" and form.validate_on_submit(): try: item = Items( name=form.name.data, quantity=form.quantity.data, description=form.description.data, date_added=datetime.datetime.now()) db_session.add(item) db_session.commit() return redirect(url_for('success')) except: return 'There was a problem adding an item' return render_template('index.html', form=form)
def add_item(): form = ItemForm() if form.validate_on_submit(): item = Items(id=random.randint(1, 5000), name=form.name.data, quantity=form.quantity.data, description=form.description.data, date_added=datetime.datetime.now()) db_session.add(item) db_session.commit() flash('Thank you for entering your item') return redirect(url_for('success')) # else: add some sort of error catching here return render_template('index.html', form=form)
def addItem(): categories = session.query(Category).all() if request.method == 'GET': return render_template('addItem.html', categories=categories) else: item_cat_name = request.form.get('category_select') print(item_cat_name) item_cat_id = getCatagoryId(item_cat_name) print(item_cat_id) newitem = Items() newitem.item_name = request.form['item_name'] newitem.item_description = request.form['item_description'] newitem.cat_item_id = item_cat_id newitem.item_cat_name = item_cat_name session.add(newitem) session.commit() return redirect(url_for('getAllCategories'))
def create(self, data): customers_id = data['customers_id'] items = data['items'] self.buy_at_most_ten_diferrent_books(items) price = self.apply_discount(items, customers_id) total = price.total discount = price.discount sales = Sales(customers_id, total, discount) db.session.add(sales) for item in items: new_items = Items(sales.id, item['books_id'], item['quantity']) sales.items.append(new_items) db.session.add(new_items) db.session.commit() return create_sales(sales)
def createItem(category): if request.method == 'POST': find_category = session.query(Categories).filter_by( category=category).first() item = Items(category_id=find_category.id, item=request.form['item'], description=request.form['description'], user_id=login_session['id']) session.add(item) session.commit() flash('%s has been succesfully added' % request.form['item']) return redirect( url_for('itemDetail', category=category, item=request.form['item'])) # GET request return render_template('newItem.html', category=category)
def newItem(category_id): session = DBSession() if 'username' not in login_session: return redirect('/login') category = session.query(Category).filter_by(id=category_id).one() if login_session['user_id'] != category.user_id: return """<script>function myFunction() {alert('You are not authorized to add items items to this catalog. Please create your own catalog in order to add items.');}</script><body onload='myFunction()'>""" if request.method == 'POST': newItem = Items(name=request.form['name'], description=request.form['description'], category_id=category.id, user_id=category.user_id) session.add(newItem) session.commit() flash('New %s Item Successfully Created' % (newItem.name)) return redirect(url_for('showItems', category_id=category_id)) else: return render_template('newitem.html', category_id=category_id)
def newItem(): if 'username' not in login_session: return 'Unauthorized Access!' else: categories = session.query(Categories).all() if request.method == 'POST': getuser = session.query(User).filter_by( username=login_session['username']).first() getuser_id = getuser.id new_item = Items(user_id=getuser_id, title=request.form.get('title', False), description=request.form.get( 'description', False), cat_id=request.form.get('id', False)) session.add(new_item) session.commit() flash('New item created!') return redirect(url_for('pcatalog')) else: return render_template('newItem.html', categories=categories)
def add_item(): form = ItemForm() if form.validate_on_submit(): item = Items(name=form.name.data, quantity=form.quantity.data, description=form.description.data, date_added=datetime.datetime.now()) db_session.add(item) db_session.commit() print("item: {}".format(item)) print("form.name.data: {}".format(form.name.data)) print("form.quantity.data: {}".format(form.quantity.data)) print("form.description.data: {}".format(form.description.data)) print("datetime.datetime.now(): {}".format(datetime.datetime.now())) print("\n--\n") print("success url: {}".format(url_for('success'))) print("xsuccess url: {}".format(url_for('success', _external=True))) print("redirect url: {}".format(str(redirect(url_for('success'))))) return redirect(url_for('success')) print("rendering template index.html...") return render_template('index.html', form=form)
def Additem(): # Check if user logged in give him adding permission if 'username' in login_session: Cat = session.query(Category).all() if request.method == 'GET': # Render template used to specify new item components return render_template('add-item.html', CatAll=Cat) # Add the new item with specified components else: Newitem = Items(name=request.form['name'], description=request.form['des'], category_id=request.form['Category'], user_id=login_session['user_id']) session.add(Newitem) session.commit() flash('New item added succesfully') return redirect(url_for('showMaster')) else: flash('Your aren' 't have permissions to this link') return redirect(url_for('showMaster'))
def get_firebase(self): name = click.prompt( click.style('Please enter username?', fg='cyan', bold=True)) jsonData = firebase.get('/todo-cli', name) for k in jsonData: #inserting category to database category = Category(category=k) session.add(category) session.commit() for i in jsonData[k]: s = select([Category]) result = s.execute() for r in result: if r[1] == k: data = Items(category_id=r[0], items=i) session.add(data) session.commit() session.close() click.secho('Done', fg='yellow', bold=True)
def add_item(): if request.method == 'POST': item_name = request.form.get('name') item_category = request.form.get('category') item_description = request.form.get('description') item_nutrition = request.form.get('nutrition') item_ingredients = request.form.get('ingredients') item_price = request.form.get('price') item_location = request.form.get('location') newItem = Items(name=item_name, category=item_category, description=item_description, nutrition=item_nutrition, ingredients=item_ingredients, price=item_price, location=item_location) session.add(newItem) session.commit() return jsonify({'response': success[0]})
def addItem(): if request.method == 'GET': # Make sure only logged in users can access this page if ('username' in login_session): return render_template('addItem.html', login_session=login_session) else: flash('Please login in order to add key/value pairs') return redirect(url_for('login')) elif request.method == 'POST': # Make sure only logged in users are adding key/value pairs if ('username' in login_session): key = request.form.get('key') value = request.form.get('value') item = db.query(Items).filter_by(key=key).first() # Make sure key is unique/not already added if item: flash('"%s" has already been added' % item.key) return redirect(url_for('addItem')) if key is not None and key != '': item = Items(key=key) if value is not None and value != '': item.value = value item.author = getUserInfo(login_session['user_id']) else: flash('You need to provide a proper Key/Value pair') return redirect(url_for('addItem')) db.add(item) db.commit() flash('Item Added!') return redirect(url_for('index')) else: flash('Please login in order to add key/value pairs') return redirect(url_for('login')) else: return redirect(url_for('index'))
def save(): category_id = request.form['category'] user_id = session.get('user_id') title = request.form['title'] description = request.form['description'] #validation error = None if title is None: error = 'Title is required' elif description is None: error = 'Description is required' if error is None: itm = Items(category_id=category_id, user_id=user_id, title=title, description=description) db_session.add(itm) db_session.commit() return redirect(url_for('index')) flash(error) return redirect(url_for('item.new'))
def newItem(): if 'username' not in login_session: print('you are not login') return redirect(url_for('showTop')) if request.method == 'POST': print( "%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%") print(request.form['item_name']) print(type(request.form['item_name'])) if request.form['item_name'] == '': flash('no item name is entered') return redirect(url_for('newItem')) if request.form['description'] == '': flash('no description is written') return redirect(url_for('newItem')) category_name = request.form['category'] item_name = request.form['item_name'] description = request.form['description'] user = session.query(User).filter( User.username == login_session['username']).first() category = session.query(Category.id).filter( Category.category_name == category_name).first() newItem = Items(item_name=item_name, registered_at=str(datetime.now()), category_id=category.id, description=description, registered_user_id=user.id) print(newItem) session.add(newItem) flash('New Item {} Successfully Created'.format(newItem.item_name)) session.commit() return redirect(url_for('showTop')) else: category_names = session.query(Category.category_name).order_by( asc(Category.category_name)).all() if category_names == []: category_names = str("No category is registered yet.") print(category_names) return render_template('reg_item.html', category_names=category_names)
def add_item(): form = form_add_item() items_py = [] for items_iter in Items.query.all(): items_py.append( (str(items_iter.id), str(items_iter.Naming), str(items_iter.Description), str(items_iter.Cat.name))) categs = [] for categs_iter in Cat.query.all(): categs.append((str(categs_iter.id), str(categs_iter.name))) form.item_categ.choices = categs if form.validate_on_submit(): item_name = str(form.item_name.data) item_desc = str(form.item_desc.data) item_categ = str(form.item_categ.data) for categ in Cat.query.all(): if int(categ.id) == int(item_categ): categ_is = categ break i1 = Items(item_name, item_desc, categ_is) db.session.add(i1) db.session.commit() # print ('New Category Added = {}').format(new_categ) message = "Item Added:" + i1.Naming flash(message) return render_template('item_added.html', title='Item_added', Items=items_py, categs=categs) return render_template('add_item.html', title='Add Item', form=form, Items=items_py, categs=categs)
def items(category): if request.method == 'POST': newItem = Items(item_name=request.form['name'], registered_at=str(datetime.now())) session.add(newItem) flash('New Item {} Successfully Created'.format(newItem.item_name)) session.commit() return redirect(url_for('showTop')) else: category_list = session.query(Category.category_name).order_by( asc(Category.category_name)).all() category = session.query(Category.id, Category.category_name).filter( Category.category_name == category).first() itemsJoin = session.query(Items, Category.category_name).join( Items, Items.category_id == Category.id).filter( Items.category_id == category.id).all() print(itemsJoin) print(type(itemsJoin)) num_items = session.query( Items.item_name).filter(Items.category_id == category.id).count() items = session.query(Items).filter( Items.category_id == category.id).all() if 'username' not in login_session: print('you are not login') return render_template('items_in_category.html', items=items, category_list=category_list, category=category.category_name, num_items=num_items) else: print('you are login') return render_template('items_in_categoryLogin.html', items=items, category_list=category_list, category=category.category_name, num_items=num_items)
category4 = Categories(name='news') category5 = Categories(name='stories') category6 = Categories(name='movies') session.add(category1) session.add(category2) session.add(category3) session.add(category4) session.add(category5) session.add(category6) session.commit() print 'Categories Added!' categories = session.query(Categories).all() id_c = '' for c in categories: if c.name == 'sports': id_c = c.id new_item = Items(title='Swimming', description='''Swimming is a great workout because you need to move your whole body against the resistance of the water. Swimming is a good all-round activity because it: keeps your heart rate up but takes some of the impact stress off your body builds endurance, muscle strength and cardiovascular fitness helps maintain a healthy weight, healthy heart and lungs tones muscles and builds strength provides an all-over body workout, as nearly all of your muscles are used during swimming.''', cat_id=id_c) session.add(new_item) session.commit()
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from models import Category, Base, Items engine = create_engine('sqlite:///catalog.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() # Adds items to the Items class/ table in the Models item1 = Items(item_name='Ball', item_description='Ball Ball Ball BallBall', cat_item_id='1', item_cat_name='Soccer') session.add(item1) session.commit() item2 = Items(item_name='Ball Basket', item_description='Ball Ball Ball Basket Ball', cat_item_id='2', item_cat_name='Basketball') session.add(item2) session.commit() item3 = Items(item_name='Bat', item_description='Bat Bat Bat Bat', cat_item_id='3', item_cat_name='Baseball') session.add(item3)
cat7=Category(name='Foosball') cat8=Category(name='Skating') cat9=Category(name='Hockey') session.add(cat1) session.add(cat2) session.add(cat3) session.add(cat4) session.add(cat5) session.add(cat6) session.add(cat7) session.add(cat8) session.add(cat9) item1=Items(name='jersey',category=cat1,description='dsfdsfdsfdsfdsfdsfdsfsdfdsf') item2=Items(name='short',category=cat1) item3=Items(name='footwear',category=cat1) item4=Items(name='goggles',category=cat2) item5=Items(name='basketball ',category=cat2) item6=Items(name='socks',category=cat2) item7=Items(name='glove',category=cat3) item8=Items(name='baseball cleats ',category=cat3) item9=Items(name='disc golf',category=cat4) item10=Items(name='flying discs',category=cat4)