def post(self):
new_item = Item(
request.json['name'],
request.json['description'],
request.json['quantity']
)
db.session.add(new_item)
db.session.commit()
return new_item
def add_item(user_id):
data = MultiDict(mapping=request.json)
name = data['name']
description = data['description']
url = data['url']
image_url = data['image_url']
item = Item(name, description, user_id, url, image_url)
db.session.add(item)
db.session.commit()
return jsonify({'name': name, 'description': description, 'url': url})
def admin():
form = addSKUForm()
if form.validate_on_submit():
item = Item(brand=form.brand.data,
country=form.country.data,
sku=form.SKU.data)
db.session.add(item)
db.session.commit()
flash('Item added to database', 'success')
return render_template('admin.html', form=form)
def add_item():
form = AddItemForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_item = Item(form.item_title.data, form.item_description.data,
form.item_comment.data)
db.session.add(new_item)
db.session.commit()
flash('New item, {}, added!'.format(new_item.item_title),
'success')
return redirect(url_for('items.index'))
else:
flash_errors(form)
flash('ERROR! Item was not added.', 'error')
return render_template('add_item.html', form=form)
def add():
username = usernameState(state)
user = session.query(User).filter_by(
email=login_session['email']).one_or_none()
category = session.query(Category).all()
if request.method == 'POST':
newItem = Item(
name=request.form['name'],
description=request.form['description'],
category_id=request.form['categories'],
user_id=user.id
)
session.add(newItem)
session.commit()
return redirect(url_for('home.index'))
return render_template(
'add.html',
category=category,
username=username,
STATE=state)
def add_item_post():
item_name = request.form.get('name')
item_price = float(request.form.get('price'))
if item_name:
# Check if item is unique.
item = Item.query.filter_by(name=item_name).first()
if item:
flash('Item already exists')
return redirect(url_for('main.add_item'))
# Check if our store user exists.
store = User.query.filter_by(email="store@admin").first()
if not store:
store = add_store()
item = Item(name=item_name, price=item_price)
store.items.append(item)
db.session.commit()
return redirect(url_for('main.add_item'))
def create_item():
data = request.get_json() or {}
token = data['token']
name = data['name']
text = data['text']
user_items = Item.query.filter_by(token=token).all()
for item in user_items:
if str(item.name) == name:
return bad_request('Please use a different item name')
new_item = Item(name=name, text=text, token=token)
db.session.add(new_item)
db.session.commit()
responce = Item.query.filter_by(token=token).all()
for item in responce:
if item.name == name:
return jsonify({'message': 'Item successfully created'}, {
'id': item.id,
'name': item.name,
'text': item.text
})
return
def cart_item_post():
resp = jsonify(success=True)
action = request.json['action']
item_name = request.json['name']
item_amount = request.json['amount']
# The add action either adds the item to the cart, or updates the amount.
if (action == "add"):
item = current_user.items.filter_by(name=item_name).first()
# Item already in user's cart, change the amount.
if item:
item.amount = item_amount
# Item is not in user's cart, add it.
else:
item = Item(name=item_name, amount=item_amount)
current_user.items.append(item)
# The remove action simply removes the item from the user's cart.
else:
item = current_user.items.filter_by(name=item_name).first()
if item:
current_user.items.remove(item)
db.session.delete(item)
db.session.commit()
return resp
from project import db
from project.models import Item
# create the database and the database table
db.create_all()
# insert item data
item1 = Item('Slow-Cooker Tacos', 'Delicious ground beef that has been simmering in taco seasoning and sauce. Perfect with hard-shelled tortillas!', 'alskdalksjd')
item2 = Item('Hamburgers', 'Classic dish elivated with pretzel buns.', 'alskdalksjd')
item3 = Item('Mediterranean Chicken', 'Grilled chicken served with pitas, hummus, and sauted vegetables.', 'alskdalksjd')
db.session.add(item1)
db.session.add(item2)
db.session.add(item3)
# commit the changes
db.session.commit()
#import from parent directory
import os, sys, inspect
currentdir = os.path.dirname(
os.path.abspath(inspect.getfile(inspect.currentframe())))
parentdir = os.path.dirname(currentdir)
sys.path.insert(0, parentdir)
from project import db
from project.models import Item
db.drop_all()
db.create_all()
with open('product-skus.txt', 'r') as skus:
for sku in skus:
item = Item(brand='lv', country='cn', sku=sku)
db.session.add(item)
db.session.commit()
with open('product-skus.txt', 'r') as skus:
for sku in skus:
item = Item(brand='lv', country='us', sku=sku)
db.session.add(item)
db.session.commit()
with open('product-skus.txt', 'r') as skus:
for sku in skus:
item = Item(brand='lv', country='au', sku=sku)
db.session.add(item)
db.session.commit()