def save_changes(self): if not sqlite_requests.get_products_not_in_table('personal_products', USER.name, [self.parent_product.name]): sqlite_requests.sqlite_update_record('personal_products', {'name': self.ids.name.text, 'units': self.ids.units.text, 'rating': self.ids.rating.text, 'quality': self.ids.quality.text, 'note': self.ids.note.text }, {'name': self.parent_product.name, 'user': USER.name }) else: sqlite_requests.sqlite_fill_table('personal_products', self.parent_product.name, 'шт', USER.name, self.parent_product.rating, 0, 0, self.parent_product.quality, 0, self.parent_product.note) self.parent_product.parent_allproducts.on_pre_open() self.dismiss()
def update_record_bd(self): self.selected = self.ids.selected.active if self.selected: self.last_use = round(time.time()) self.frequency_of_use += 1 if (not sqlite_requests.get_products_not_in_table('current_products', USER.name, [self.name], self.parent_listrepresentation)) is self.selected: return # If called by creating of Product in on_pre_open of AllProductsList # Че это ваще за хуйня выше? Можно как-то перестроить работу проги, чтобы не было этот ебанины? # Она ваще всё еще есть? Разве я не переделал это? ._. if not sqlite_requests.get_products_not_in_table('personal_products', USER.name, [self.name]): sqlite_requests.sqlite_update_record('personal_products', { 'frequency_of_use': self.frequency_of_use, 'last_use': self.last_use }, {'user': USER.name, 'name': self.name}) else: sqlite_requests.sqlite_fill_table('personal_products', self.name, self.units, user=USER.name, frequency_of_use=1, last_use=round(time.time()), is_category=True) if self.selected: sqlite_requests.sqlite_fill_table('current_products', self.name, self.units, user=USER.name, products_list=self.parent_listrepresentation, price=self.current_price, quantity=self.quantity, bought='False') else: sqlite_requests.sqlite_delete_record('current_products', name=self.name, user=USER.name, products_list=self.parent_listrepresentation)
def add_product(self, instance): sqlite_requests.sqlite_fill_table('personal_products', self.current_product, user=USER.name, category=instance.text) self.new_products.remove(self.current_product) self.on_pre_open( ) # Не нравится на пре опен ссылаться, мб вынести в еще одну функцию? Хотя тогда
def add_list(self, text='No name' ): # Adds List (Product list) in List of Products list self.LR.ids.name.text = str(text) self.LR.parent_box = self.parentlist self.parentlist.ids.list_of_products_lists.add_widget(self.LR) sqlite_requests.sqlite_fill_table('lists', str(text), user=USER.name) self.dismiss()
def add_category(self): sqlite_requests.sqlite_fill_table('personal_products', self.ids.search.text[0].upper() + self.ids.search.text[1:], 'шт', USER.name, 0, 0, 0, 0, round(time.time()), '', is_category=True) self.search()
def add_product(self): sqlite_requests.sqlite_fill_table('personal_products', self.ids.search.text[0].upper() + self.ids.search.text[1:], 'шт', USER.name, 0, 0, 0, 0, round(time.time()), '', is_category=True) self.ids.search.text = '' # test пизда говно решение но я хочу спать переделай нормальн self.ids.last_sorting.state = 'down' self.ids.popular_sorting.state = 'normal' self.ids.abc_sorting.state = 'normal' self.update_sort('last')
from global_variables import USER with open('13.json', 'r', encoding='utf-8') as read_json: data = json.load(read_json) print(data) date = data['date'] shop_name = data['shopName'] shop_address = data['shopAddress'] sum = data['totalSum'] products = data['products'] products_names = [prod['name'] for prod in products] new_products = sqlite_requests.get_products_not_in_table( 'personal_products', USER.name, products_names) for prod in new_products: sqlite_requests.sqlite_fill_table('personal_products', prod, user=USER.name, category=1) a = sqlite_requests.get_all_products(USER.name, search='', only_categories=True) print(new_products) # for prod in products: # sqlite_requests.