def save_item(self): if len(self.ui.itemNameField.text().strip()) <= 0: self.ui.errorMessagesLabel.setText("Item name is required!") elif item_name_exists(self.ui.itemNameField.text().strip()): self.ui.errorMessagesLabel.setText( "Item with that name already exists in database") elif len(self.ui.itemCostPriceField.text().strip()) <= 0 or ( not is_float(self.ui.itemPriceField.text().strip())): self.ui.errorMessagesLabel.setText( "Cost Price is required! (Use valid characters)") elif len(self.ui.itemPriceField.text().strip()) <= 0 or (not is_float( self.ui.itemPriceField.text().strip())): self.ui.errorMessagesLabel.setText( "Unit Price is required! (Use valid characters)") elif len(self.ui.itemQuantityField.text().strip()) <= 0 or ( not is_integer(self.ui.itemQuantityField.text().strip())): self.ui.errorMessagesLabel.setText( "Quantity is required! (Be sure to enter an integer)") else: item_name = self.ui.itemNameField.text().strip() cost_price = self.ui.itemCostPriceField.text().strip() unit_price = self.ui.itemPriceField.text().strip() quantity = self.ui.itemQuantityField.text().strip() if len(self.ui.itemDescField.toPlainText().strip()) > 0: description = self.ui.itemDescField.toPlainText().strip() if add_item('', item_name, description, cost_price, unit_price, quantity): self.new_item_added.emit() self.close() else: if add_item('', item_name, '', cost_price, unit_price, quantity): self.new_item_added.emit() self.close()
def push_content_to_the_db(dict_of_items): for item in dict_of_items: add_item( title=item['title'], link=item['link'], # photo=item['photo'], price_usd=item['price_usd'], )
def add_item(form): print("Добавляю новый товар в наколадную") new_item = db.Item(name=form.name.data, size_x=form.size_x.data, size_y=form.size_y.data, size_z=form.size_z.data, weight=form.weight.data) # Добавление в БД новой записи о товаре db.add_item(new_item) print("Товар добавлен")
def items_page(): global item if request.method == 'POST': item = request.form.to_dict(flat=False) purchaseId = item["purchaseid"] brand = item["brand"] name = item["name"] price = item["price"] db.add_item(purchaseId[0], brand[0], name[0], price[0]) print(item) return redirect(url_for('items_page')) return render_template('items.html')
def import_inventory(): service = build('sheets', 'v4', credentials=creds) sheet = service.spreadsheets() result = sheet.values().get(spreadsheetId=settings.secrets["sheets"]["tuotteet"], range="A1:3", majorDimension = "COLUMNS").execute() values = result.get('values', []) values = list(map(lambda x: [x[0], int(x[1]), int(x[2])], values[1:])) print(values) db.delete_inventory() for i in values: db.add_item(i[0], i[1], i[2]) return len(values)
def add_item(): name = input("Name: ") types = input("Type: ") cost = int(input("Cost (cost cannot include cents): ")) store_id = int(input("Store ID: ")) store = db.get_store(store_id) if store == None: print("There is no category with that ID. Movie NOT added.\n") else: item = Item(name=name, types=types, cost=cost, store=store) db.add_item(item) print(name + " was added to database.\n")
def add_item(): content: dict = request.json current_login = content.get("current_login") name = content.get("name") location = content.get("location") barcode = content.get("barcode") user_id = db.check_login(current_login) db.log_event(user_id, current_login, f"Add Item {name} @ {location} with barcode {barcode}") if user_id is None: abort(403, messsage="Not authenticated") return db.add_item(name, location, barcode) return jsonify({"status": "good"})
def import_inventory(): service = build('sheets', 'v4', credentials=google_auth.creds) sheet = service.spreadsheets() result = sheet.values().get(spreadsheetId=config.INVENTORY_SHEET_ID, range="A1:3", majorDimension="COLUMNS").execute() values = result.get('values', []) values = list(map(lambda x: [x[0], int(x[1]), int(x[2])], values[1:])) print(values) db.delete_inventory() for i in values: db.add_item(i[0], i[1], i[2]) return len(values)
def start_scan(path, scan_for, scan_type, scan_title=None, scan_lookup_type=None, scan_lookup_id=None): section = utils.get_plex_section(conf.configs, path) if section <= 0: return False else: logger.info("Using Section ID '%d' for '%s'", section, path) if conf.configs['SERVER_USE_SQLITE']: db_exists, db_file = db.exists_file_root_path(path) if not db_exists and db.add_item(path, scan_for, section, scan_type): logger.info("Added '%s' to Plex Autoscan database.", path) logger.info("Proceeding with scan...") else: logger.info( "Already processing '%s' from same folder. Skip adding extra scan request to the queue.", db_file) resleep_paths.append(db_file) return False thread.start(plex.scan, args=[ conf.configs, scan_lock, path, scan_for, section, scan_type, resleep_paths, scan_title, scan_lookup_type, scan_lookup_id ]) return True
def add(): if 'admin' in session: if request.method == 'POST': if 'tag' in session: tag = session['tag'] session['tag'] = None else: tag = None name = request.form['item'] desc = request.form['desc'] cost = request.form['cost'] in_stock = 'in_stock' in request.form db.add_item(tag, name, desc, cost, in_stock) return redirect(url_for('items')) elif request.method == 'GET': return render_template('add.html.j2') else: return redirect(url_for('login'))
def start_scan(path, scan_for, scan_type): section = utils.get_plex_section(conf.configs, path) if section <= 0: return False else: logger.debug("Using section id: %d for '%s'", section, path) if conf.configs['SERVER_USE_SQLITE']: db_exists, db_file = db.exists_file_root_path(path) if not db_exists and db.add_item(path, scan_for, section, scan_type): logger.info("Added '%s' to database, proceeding with scan", path) else: logger.info( "Already processing '%s' from same folder, aborting adding an extra scan request to the queue", db_file) resleep_paths.append(db_file) return False thread.start(plex.scan, args=[conf.configs, scan_lock, path, scan_for, section, scan_type, resleep_paths]) return True
def init_demo_items(): db.clean_items() new_item = db.Item(name="Компьютер 1", size_x=900, size_y=900, size_z=300, weight=15) db.add_item(new_item) new_item = db.Item(name="Монитор", size_x=900, size_y=1500, size_z=50, weight=7) db.add_item(new_item) new_item = db.Item(name="Доска маркерная", size_x=1900, size_y=1100, size_z=900, weight=5) db.add_item(new_item)