def item_seed():
"""Seed the database."""
stream = io.open('items.yaml', 'r')
items_to_seed = yaml.safe_load(stream)
for item_name in items_to_seed['items']:
existing_item = models.Item().query.filter_by(name=item_name).first()
if not existing_item:
item = models.Item(name=item_name)
db.session.add(item)
db.session.commit()
for role_name in ('raider', 'council', 'initiate'):
role = models.Role.query.filter_by(name=role_name).first()
if not role:
db.session.add(models.Role(name=role_name))
db.session.commit()
if not models.User.query.filter(models.User.username == 'admin').first():
user1 = models.User(username='******',
email='*****@*****.**',
active=True,
password=user_manager.hash_password('asdf'))
council_role = models.Role.query.filter_by(name='council').first()
user1.roles.append(council_role)
db.session.add(user1)
db.session.commit()
db.session.commit()
def add_items_list(list_id):
"""
This endpoint will add items to a given list
:param list_id:
:return: json response
"""
the_list = models.List.query.filter_by(list_id=list_id).first()
# check to ensure the list exists
if the_list is not None:
data = request.json
if 'name' in data:
try:
description = data['description']
except Exception as ex:
shoplist_api.logger.warning(ex.message)
description = ""
# add an item to the list
item = models.Item(item_name=data['name'],
list_id=list_id,
description=description)
item.add()
shoplist_api.logger.debug("added {0} to list <{1}>".format(item, list_id))
return jsonify({'item_id': item.item_id, 'name': item.item_name,
'description': item.description,
'status': 'pass', 'message': 'item added to list'}), 201
shoplist_api.logger.error("bad or missing parameters in json body")
return jsonify({'status': 'fail', 'message': 'bad or missing parameters in request'}), 400
shoplist_api.logger.error("list <%s> does not exist" % list_id)
return jsonify({'status': 'fail', 'message': 'list does not exist'}), 404
def create_user_item(db: Session, item: interface.ItemCreate, user_id: int):
# **item.dict() instead of reading one by one
db_item = models.Item(**item.dict(), owner_id=user_id)
db.add(db_item)
db.commit()
db.refresh(db_item)
return db_item
def create_fake_items(
self,
session,
name=None,
price=None,
measure=None,
commit=True,
_quantity=1,
):
payload_item = self.payload_item()
if not name:
name = payload_item['name']
if not measure:
measure = payload_item['measure']
items = []
for _ in range(_quantity):
if _quantity > 1: # force random fields
name = f'Leite-{uuid.uuid4()}'
price = round(random.uniform(20, 100), 2)
measure = str(uuid.uuid4())
item = models.Item(name=name, price=price, measure=measure)
items.append(item)
session.add(item)
if commit:
session.flush()
session.commit()
return items
def new():
form=ItemForm()
if form.validate_on_submit():
item = models.Item(title=form.title.data, course=form.course.data, price=form.price.data, description = form.description.data)
db.session.add(item)
db.session.commit()
flash('New Item has been created')
return redirect(url_for('index'))
return render_template('new.html', form=form)
def _create_fake_item(self, payload_item, session_maker):
session = session_maker()
item = models.Item(
name=payload_item["name"],
price=payload_item["price"],
measure=payload_item["measure"],
)
session.add(item)
session.flush()
session.commit()
return (item, session)
def test_create(self, payload_item, session_maker):
session = session_maker()
item = models.Item(
name=payload_item["name"],
price=payload_item["price"],
measure=payload_item["measure"],
)
assert 0 == session.query(models.Item).count()
session.add(item)
session.flush()
session.commit()
assert 1 == session.query(models.Item).count()
assert item == session.query(models.Item).first()
def _create_fake_user_and_item(payload_user, session_maker):
session = session_maker()
user = models.User(
username=payload_user['username'],
email=payload_user['email'],
hashed_password=payload_user['password'],
)
items = [
models.Item(
name=f'Leite-{uuid.uuid4()}',
measure=str(uuid.uuid4()),
) for _ in range(random.randint(1, 10))
]
session.add(user)
session.bulk_save_objects(items, return_defaults=True)
session.commit()
info = collections.namedtuple('info', 'user items')
return info(user=user, items=items)
def index():
form = SearchForm()
if form.validate_on_submit():
flash("Parse requested for %s" % form.url_to_search)
url_search = form.url_to_search._value()
get_match = parser.spider(url_search)
match = models.Match(url=get_match.match_url, date_play = datetime.datetime.now())
db.session.add(match)
for get_build in get_match.match_data:
build = models.Build(champ_name = get_build.champName, match = match)
db.session.add(build)
for get_step in get_build.stepList:
step = models.Step(time = get_step.time, build = build)
db.session.add(step)
for get_item in get_step.items:
item = models.Item(item = get_item.item_number, is_sold=get_item.is_sold, step=step)
db.session.add(item)
db.session.commit()
return redirect('/index')
matches = models.Match.query.all()
return render_template("index.html",
title='Home',
matches=matches,
form = form)
def add_item():
"""
route for adding item to database
"""
if request.cookies.get('masterkey') == utils.password_hashing(
app.config['MASTER_PASSWORD']):
# authorized
add_form = ItemForm()
if request.method == 'POST':
#adding item?
if add_form.currency.data == '2':
fiat_crypto_main_flag = "crypto"
else:
fiat_crypto_main_flag = "fiat"
new_item = models.Item(
name=add_form.name.data,
description=add_form.description.data,
pic_name=add_form.pic_name.data,
price_crypto=add_form.price_crypto.data,
price_fiat=add_form.price_fiat.data,
price_crypto_id=1,
price_fiat_id=1,
fiat_crypto_main_flag=fiat_crypto_main_flag
) #fixme ..=1 is lame way to reference crypto and fiat id
db.session.add(new_item)
db.session.commit()
return redirect('/admin_modify')
else:
return render_template(app.config['TEMPLATE_NAME'] +
'/admin-add.html',
config=app.config,
active="add-good",
form=add_form,
items=['']) #fixme enchance default perhaps
else:
return redirect('/admin')
def create_user_item(db: Session, item: schemas.ItemCreate, user_id: int):
db_item = models.Item(**item.dict(), owner_id=user_id)
db.add(db_item)
db.commit()
db.refresh(db_item)
return db_item
def add_item(self):
"""This is a test list item to use during the running of tests"""
item = models.Item(item_name=self.test_item,
list_id=1,
description=self.test_item_desc)
item.add()
from app import routes, models c = models.Client(phone='89745612321', passport='4568789456', name='IlyaGreen') c2 = models.Client(phone='89741234567', passport='4589621234', name='KarolGreen') d = models.Delivery(client=c, user_code=123456) d2 = models.Delivery(client=c2, user_code=123457) d3 = models.Delivery(client=c2, user_code=123458) cell = models.Cell(capacity=3) cell1 = models.Cell(capacity=3) cell2 = models.Cell(capacity=3) cell3 = models.Cell(capacity=3) cell4 = models.Cell(capacity=3) cell5 = models.Cell(capacity=3) cell6 = models.Cell(capacity=3) it_cel = models.Items_cell(cell=cell) i = models.Item(barcode=12, delivery=d, cell=it_cel) it = models.Item(barcode=14, delivery=d) it1 = models.Item(barcode=15, delivery=d2) it2 = models.Item(barcode=16, delivery=d3) it3 = models.Item(barcode=17, delivery=d3) db.session.add(c) db.session.add(c2) db.session.add(d) db.session.add(d2) db.session.add(d3) db.session.add(cell) db.session.add(cell1) db.session.add(cell2) db.session.add(cell3) db.session.add(cell4) db.session.add(cell5)
def add_item(self):
"""This is a test list item to use during the running of tests"""
item = models.Item(name=self.test_name, price=self.test_price)
db.session.add(item)
db.session.commit()
user_store = stores.UserStore()
user_store.add(user)
cat1 = models.Category(name='Sports', user_id=user.id)
cat2 = models.Category(name='Music', user_id=user.id)
cat3 = models.Category(name='Art', user_id=user.id)
cat_store = stores.CategoryStore()
cat_store.add(cat1)
cat_store.add(cat2)
cat_store.add(cat3)
dummy_items = {
models.Item(name='Football',
description="It's the most popular sport in the world!",
category_id=cat1.id,
user_id=user.id),
models.Item(name='Basketball',
description="It's the most amusing for many Americans!",
category_id=cat1.id,
user_id=user.id),
models.Item(name='Karate',
description="It's a good sport to defend yourself!",
category_id=cat1.id,
user_id=user.id),
models.Item(name='Piano',
description="I really love playing piano!",
category_id=cat2.id,
user_id=user.id),
models.Item(
name='Violin',
'price': 10,
'category': 'Food'
},
{
'img': 'app/static/images/spidermancostume.jpeg',
'name': 'Spiderman Costume',
'ins': True,
'price': 50,
'category': 'Clothes'
},
]
for product in my_products:
item = models.Item(
item_name=product['name'],
price=product['price'],
instock=product['ins'],
category=product['category'],
)
db.session.add(item)
db.session.commit()
users = [
{
'customer_name': 'shaul-test-1',
'customer_password': '******',
'status': 'active'
},
{
'customer_name': 'rick-test-1',
'customer_password': '******',
