def create_items():
for item in ITEMS:
new_item = Item(name=item['name'], description=item['description'],
user_id=item['user_id'], catalog_id=item['catalog_id'])
db.session.add(new_item)
db.session.commit()
def store(user_id):
"""
Store item to database.
params:
user_id: foreign key that should exists in table users.id
"""
form = ItemForm()
if not form.validate():
return ItemController.message(False, form.errors)
item = Item()
item.name = form.name.data.strip()
item.description = form.description.data
item.category_id = CategoryHash.decode(form.category_id.data)
item.user_id = user_id
db.session.add(item)
if item.commit_changes():
return ItemController.message(True, item)
else:
return ItemController.message(
False, 'Could not save \
the given item.')
def seed_db():
user1 = User(name='user1', email='*****@*****.**')
user2 = User(name='user2', email='*****@*****.**')
db.session.add(user1)
db.session.add(user2)
db.session.commit()
categories_data = [
{'name': 'Football'},
{'name': 'Tennis'},
]
for categories in categories_data:
new_category = Category(name=categories['name'])
db.session.add(new_category)
db.session.commit()
items_data = [
{'name': 'Ball', 'description': 'Football', 'category_id': 1},
{'name': 'Net', 'description': 'Football', 'category_id': 1},
{'name': 'Racket', 'description': 'Tennis', 'category_id': 2},
{'name': 'Tennis ball', 'description': 'Football', 'category_id': 2},
]
for index, item in enumerate(items_data):
new_item = Item(name=item['name'], description=item['description'],
category_id=item['category_id'], user_id=(index % 2 + 1))
db.session.add(new_item)
db.session.commit()
def new_item():
"""Creates new item."""
form = ItemForm(request.form)
categories = db.query(Category).order_by(Category.name).all()
form.category_id.choices = [(c.id, c.name) for c in categories]
if request.method != 'POST' or not form.validate():
return render_template('api/new_item.html', form=form)
form_file = request.files[form.image.name]
img_filename = None
if form_file:
filename = secure_filename(form_file.filename)
filename = generate_unique_filename(filename)
form_file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
img_filename = filename
new_item = Item(name=form.name.data,
description=form.description.data,
category_id=form.category_id.data,
image=img_filename,
user_id=session['user_id'])
db.add(new_item)
db.commit()
flash(message="Item successfully created", category="success")
return redirect(url_for('api.view_item', item_id=new_item.id))
def new_item():
"""
displays form to create a new item
"""
return render_template('item_form.html',
item=Item(),
categories=Category.query.all(),
target_url=url_for('new_item_save'))
def new_item_save():
"""
saves the new item to db
"""
form = request.form
item = Item()
item.category_id = int(form['category'])
item.title = form['title']
item.description = form['description']
item.created_at = datetime.now()
item.user_id = current_user.id
db.session.add(item)
db.session.commit()
return redirect(url_for('index'))
def newItem():
""" Create a new item """
# user must be authenticated
if 'user_id' not in session:
return redirect('/login')
form = ItemForm()
categories = db_session.query(Category.id, Category.name).all()
form.category_id.choices = categories
if form.validate_on_submit():
# check that name != 'new', which is used for routing
if form.name.data.lower() == 'new':
form.name.errors.append("'new' is a reserved word, and cannot"
" be used as an item name.")
return render_template('new_item.html', form=form)
filename = None
# check if user uploaded file and sanitize filename
if form.image.has_file():
# get the filename, ensuring that it is safe
filename = secure_filename(form.image.data.filename)
form.image.data.save(
os.path.join(app.config['UPLOAD_FOLDER'], filename))
# create new item and commit to database
item = Item(
name=form.name.data,
description=form.description.data,
category_id=form.category_id.data,
image=filename,
user_id=session['user_id'],
pub_date=datetime.utcnow()
)
db_session.add(item)
try:
db_session.commit()
except exc.IntegrityError:
# item name should be unique
db_session.rollback()
form.name.errors.append("Item already exists.")
return render_template('new_item.html', form=form)
flash("Created new item %s." % item.name)
return redirect(url_for('item', name=item.name))
return render_template('new_item.html', form=form)
def create_item():
"""Create new item"""
payload = g.get('payload')
name, description, category_id = (payload['name'], payload['description'],
payload['category_id'])
exist_item = db.session.query(Item) \
.filter(Item.name == name, Item.category_id == category_id)\
.first()
if exist_item is not None:
return render_json_error('Item\'s name existed in this category')
item = Item(name=name,
description=description,
category_id=category_id,
user_id=g.current_user.id)
db.session.add(item)
db.session.commit()
return render_json({'item': item_schema.dump(item).data}, 201)
def item_create(category_id):
"""
This creates a new item only if the user is logged in
"""
if not logged_in():
flash('Please log in to create items')
return redirect(url_for('category_list'))
form = ItemForm()
if form.validate_on_submit():
item = Item()
item.title = form.title.data
item.description = form.description.data
item.category_id = category_id
item.ctlg_user = get_current_user()
db.session.add(item)
db.session.commit()
return redirect(url_for('item_create', category_id=category_id))
return render_template('item_create.html',
form=form,
category_id=category_id)
def addCategoryItem(categoryName):
try:
category = Category.query.filter_by(name=categoryName).first()
if current_user.id == category.user_id or current_user.admin:
if request.method == 'GET':
return render_template('new_item.html',
category=category,
user=current_user)
elif request.method == 'POST':
if (request.form['name'] and request.form['picture']
and request.form['description']):
newItem = Item(name=request.form['name'],
picture=request.form['picture'],
description=request.form['description'],
category_id=category.id,
category_name=category.name,
user_id=current_user.id)
db.session.add(newItem)
db.session.commit()
flash({
"message": "New item successfully created.",
"role": "success"
})
return redirect(url_for('main.showHome'))
else:
flash({
"message": "Please fill in all the fields!",
"role": "failure"
})
return render_template('new_item.html',
category=category,
user=current_user)
else:
return handleUnauthorized()
except exc.SQLAlchemyError as e:
flash({
"message": "No category found. Please add a category before" +
" adding items.",
"role": "failure"
})
return redirect(url_for('main.showHome'))
def create_item(self, item_params):
try:
target_tree_item = TreeItem.objects.get(name=u'Импорт')
except TreeItem.DoesNotExist:
target_tree_item = TreeItem(parent_id=None, name=u'Импорт')
target_tree_item.save()
target_section = Section(is_meta_item=False)
target_section.save()
target_tree_item.section = target_section
target_tree_item.save()
new_tree_item = TreeItem(name=item_params['name'][:200],
parent=target_tree_item)
new_item = Item(
price=item_params['price'],
identifier=item_params['identifier'],
quantity=item_params['quantity'],
)
new_tree_item.save()
new_item.save()
new_tree_item.item = new_item
new_tree_item.save()
def _update_or_create_item(self, **kwds):
item_options_list = [
'price',
'wholesale_price',
'quantity',
'barcode',
'identifier',
'short_description',
'name',
'slug',
]
item_options = {}
for k, v in kwds.iteritems():
if k in item_options_list:
item_options[k] = v
item_options['slug'] = urlify(kwds['name'])
if kwds['identifier'] in self.data['item_by_identifier']:
item = self.data['item_by_identifier'][kwds['identifier']]
for k, v in item_options.iteritems():
setattr(item, k, v)
item.save()
self.data['item_by_identifier'].update({item.identifier: item})
logging.debug('[U] %s' % kwds['name'])
# True if created
return False
else:
item = Item(**item_options)
item.save()
tree_item = TreeItem(parent=kwds['parent'], content_object=item)
tree_item.save()
self.data['item_by_identifier'].update({item.identifier: item})
logging.debug('[S] %s' % item.name)
# True if created
return True
def items():
form = ItemForm()
if form.validate_on_submit():
if form.new_category.data:
new_category = Category(form.new_category.data)
db.session.add(new_category)
db.session.flush()
category = new_category
elif form.category.data:
category_id = form.category.get_pk(form.category.data)
category = Category.query.filter_by(id=category_id).first()
else:
category = None
catalog = Catalog.query.first()
author = Author.query.filter_by(username=session['username']).first()
title = form.title.data
description = form.description.data
slug = slugify(title)
item = Item(catalog, author, title, description, category, slug)
db.session.add(item)
db.session.commit()
return redirect(url_for('article', slug=slug))
return render_template('catalog/items.html', form=form, action="new")
def main():
#drop the database tables
#create the database and the tables
db.drop_all()
db.create_all()
# Create stock, out of the box user
UserArtV = User(name="Art Vandalay",
email="*****@*****.**",
picture="/static/costanza.jpg")
db.session.add(UserArtV)
db.session.commit()
category1 = Category(name="Soccer")
db.session.add(category1)
db.session.commit()
category2 = Category(name="Basketball")
db.session.add(category2)
db.session.commit()
category3 = Category(name="Baseball")
db.session.add(category3)
db.session.commit()
category4 = Category(name="Frisbee")
db.session.add(category4)
db.session.commit()
category5 = Category(name="Snowboarding")
db.session.add(category5)
db.session.commit()
category6 = Category(name="Rock Climbing")
db.session.add(category6)
db.session.commit()
category7 = Category(name="Foosball")
db.session.add(category7)
db.session.commit()
category8 = Category(name="Skating")
db.session.add(category8)
db.session.commit()
category9 = Category(name="Hockey")
db.session.add(category9)
db.session.commit()
item1 = Item(user_id=1,
name="Stick",
description="Interdum odio dignissim in nisi metus\
, a elit sit dis cubilia, fringilla praesent pulvinar porta.\
Sodales hac bibendum",
category=category9)
db.session.add(item1)
db.session.commit()
item2 = Item(
user_id=1,
name="Goggles",
description="Primis dignissim mattis erat bibendum eu arcu quis\
cursus",
category=category5)
db.session.add(item2)
db.session.commit()
item3 = Item(user_id=1,
name="Snowboard",
description="Curae feugiat netus auctor lacus",
category=category5)
db.session.add(item3)
db.session.commit()
item4 = Item(user_id=1,
name="Soccer Item 1",
description="Nec odio consectetur cum \
consequat quam massa habitant placerat, nam tincidunt mi egestas \
eu taciti velit dictum aenean, vestibulum inceptos semper \
penatibus proin fringilla quisque. Cursus ridiculus facilisis \
class erat varius cum consequat, ac at justo mattis magna dui \
suscipit interdum, faucibus auctor rhoncus diam parturient a.",
category=category1)
db.session.add(item4)
db.session.commit()
item5 = Item(user_id=1,
name="Soccer Item 2",
description="Fermentum scelerisque \
facilisis tortor rhoncus magna maecenas, blandit ligula metus \
amet congue fames pulvinar, eget aliquam augue eros per. Vel \
etiam dolor ornare aliquet posuere inceptos maecenas nam, varius \
eget ad imperdiet mi phasellus turpis nisl libero, urna \
tristique aptent ultricies taciti montes parturient.",
category=category1)
db.session.add(item5)
db.session.commit()
item6 = Item(user_id=1,
name="Soccer Item 3",
description="Placerat primis taciti etiam \
ut convallis accumsan lorem tortor sapien faucibus cursus, quam \
nulla tempor morbi rhoncus suscipit sociis in litora amet enim, \
praesent aptent bibendum integer ornare dapibus justo rutrum \
aliquet vivamus. Taciti dignissim neque euismod elit maecenas \
aptent interdum mollis vel sociosqu donec, nunc gravida eget ad \
quisque viverra vitae amet hendrerit.",
category=category1)
db.session.add(item6)
db.session.commit()
item7 = Item(user_id=1,
name="Soccer Item 4",
description="Litora turpis et dignissim \
nascetur faucibus taciti vivamus interdum, tempor dapibus lorem \
venenatis enim conubia lacus netus hac, dis magnis vel nulla \
phasellus bibendum fringilla. Sed torquent taciti accumsan elit \
sagittis nulla magnis, sit praesent volutpat nam consectetur \
velit, magna sociis id ultrices diam non.",
category=category1)
db.session.add(item7)
db.session.commit()
item8 = Item(user_id=1,
name="Frisbee",
description="Interdum odio dignissim in nisi \
metus, a elit sit dis cubilia, fringilla praesent pulvinar \
porta. Sodales hac bibendum tincidunt risus mus himenaeos erat \
ac, mollis semper integer tempor lacus turpis libero, ridiculus \
primis curae aliquet nec rhoncus ante.",
category=category4)
db.session.add(item8)
db.session.commit()
item9 = Item(user_id=1,
name="Bat",
description="Primis dignissim mattis erat bibendum eu arcu \
quis cursus",
category=category3)
db.session.add(item9)
db.session.commit()
#commit changes
db.session.commit()
print "Added Categories, Items, and a User."
category3 = Category(name="Fruits & Vegetables")
db.add(category3)
category4 = Category(name="More Fruits & Vegetables")
db.add(category4)
db.commit()
# Sample items
add_item(
category1,
Item(
user=user,
name="Parlsey",
description=
"A biennial plant that will return to the garden year after year once it is established."
))
add_item(
category1,
Item(user=user,
name="Sage",
description=
"A perennial, evergreen subshrub, with woody stems, grayish leaves."))
add_item(
category1,
Item(
user=user,
name="Rosemary",
description=
"A woody, perennial herb with fragrant, evergreen, needle-like leaves."
def add_items(category, item_names): """Add a list of items to a category.""" for name in item_names: item = Item(name = name, category_id = category.id) db.add(item) db.commit()
category2 = Category(name = "Electronics") db.add(category2) category3 = Category(name = "Food") db.add(category3) category4 = Category(name = "Miscellaneous") db.add(category4) db.commit() # Sample items add_item(category1, Item(user = user, name = "Data Structures and Network Algorithms", description = "This is a great book!")) add_item(category1, Item(user = user, name = "Ender's Game", description = "Did you see the movie? I only read the book.")) add_item(category1, Item(user = user, name = "Romeo and Juliet", description = "Classic love story.")) add_item(category2, Item(user = user, name = "Smart phone", description = "Pretty cool phone.")) add_item(category2, Item(user = user, name = "Tablet", description = "Who needs a computer?")) add_item(category2, Item(user = user, name = "DVD player", description = "Sorry, no blu-ray here, but still cool :)")) add_item(category3, Item(user = user, name = "Banana", description = "This is a yellow banana.")) add_item(category3, Item(user = user, name = "Apple", description = "This is a red apple.")) add_item(category3, Item(user = user, name = "Orange", description = "This is an orange orange.")) add_item(category4, Item(user = user, name = "Pen", description = "A pen. Pretty useful for writing notes on paper.")) add_item(category4, Item(user = user, name = "Pencil", description = "This can be pretty handy if you need to erase things you write.")) add_item(category4, Item(user = user, name = "Notepad", description = "Combined with a pen or pencil, can be used to write anything you want.")) add_item(category4, Item(user = user, name = "Playing cards", description = "Standard 52 card deck. What games do you like to play?"))
db.add(category2)
category3 = Category(name="Music Arts")
db.add(category3)
category4 = Category(name="Calligraphy")
db.add(category4)
category5 = Category(name="Strategy Arts(board games)")
db.commit()
add_item(
category1,
Item(user=user,
name="Kung Fu",
description="Learnt by skill and practice."))
add_item(
category1,
Item(user=user, name="Martial Art", description="The Military Kung Fu."))
add_item(
category1,
Item(user=user,
name="Law of the fist",
description="Basically Curled Finger skills."))
add_item(
category2,
Item(
user=user,
name="Gongbi(meticulous)",
db.session.add(user) db.session.commit() print "User - Sophie Reddimalla created ID=" + str(user.id) print "Creating Sample Category Football ..." category = Category() category.title = "Football" category.user_id = user.id category.created = datetime.utcnow() category.modified = datetime.utcnow() db.session.add(category) db.session.commit() print "Category - Football created ID=" + str(category.id) print "Creating Sample Items in Football ..." item = Item() item.category_id = category.id item.title = "Soccer Ball" item.description = "High Quality ,Tournament grade" item.created = datetime.utcnow() item.modified = datetime.utcnow() item.user_id = user.id db.session.add(item) db.session.commit() print "Item - %s created ID=%d" % (item.title, item.id) print "Creating Sample Items in Football ..." item = Item() item.category_id = category.id item.title = "Studs - Reebok" item.description = "Imported Studs from Taiwan"
category2 = Category(name="Electronics")
db.add(category2)
category3 = Category(name="Food")
db.add(category3)
category4 = Category(name="Miscellaneous")
db.add(category4)
db.commit()
add_item(
category1,
Item(user=user,
name="Data Structures Algorithms Design",
description="Great book!"))
add_item(
category1,
Item(user=user, name="Harry Potter", description="Did you see the movie?"))
add_item(
category1,
Item(user=user, name="Romeo and Juliet",
description="Classic love story."))
add_item(category2,
Item(user=user, name="Android phone", description="Awsome phone."))
add_item(category2,
Item(user=user, name="Laptop", description="Who needs a computer?"))
add_item(
category2,
def add_items(category, item_names):
for name in item_names:
item = Item(name=name, category_id=category.id)
db.add(item)
db.commit()
vehicles = Tag(name='Vehicles', user_id=1) db_session.add(vehicles) boats = Tag(name='Boats', user_id=1) db_session.add(boats) db_session.commit() # Create items print "Creating items." i1 = Item(name='Dictionary', description='The latest Oxford dictionary', tags=[books, nonfiction], user_id=1, picture_url = "http://ecx.images-amazon.com/images/I/51RmpdfuGRL._SX379_BO1,204,203,200_.jpg") db_session.add(i1) i2 = Item(name='Chair', description='An old antique chair', tags=[furniture], user_id=1, picture_url="https://upload.wikimedia.org/wikipedia/commons/5/52/Karin_larsson_schommelstoel.jpg") db_session.add(i2) i3 = Item(name='Coffee table', description='A perfectly ordinary coffee table', tags=[furniture], user_id=1,
