def get_goods():
con = sqlite3.connect(files.main_db)
cursor = con.cursor()
cursor.execute("SELECT name, description FROM goods;")
goods = []
for name, price in cursor.fetchall(): goods.append(name)
con.close()
return goods
def get_stored(name_good):
con = sqlite3.connect(files.main_db)
cursor = con.cursor()
cursor.execute("SELECT name, stored FROM goods WHERE name = '" + name_good + "';")
for name, stored in cursor.fetchall(): pass
con.close()
return stored
def amount_of_goods(name_good):
stored = get_stored(name_good)
try:
with open(stored, encoding='utf-8') as f: return len(f.readlines())
except: return 0
вот код он берет кол-во из строк делает