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': '******',