def count_rows():
"""
Данный метод считает общее количество строк в базе данных и сохраняет в хранилище.
Потом из этого количества будем выбирать музыку.
"""
print(os.getcwd()+database_name)
db = SQLighter(os.getcwd()+database_name)
rowsnum1 = db.count_rows('1')
rowsnum2 = db.count_rows('2')
rowsnum3 = db.count_rows('3')
rowsnum4 = db.count_rows('4')
rowsnum5 = db.count_rows('5')
rowsnum6 = db.count_rows('6')
rowsnum7 = db.count_rows('7')
rowsnum8 = db.count_rows('8')
rowsnum9 = db.count_rows('9')
rowsnum10 = db.count_rows('10')
rowsnum11 = db.count_rows('11')
rowsnum12 = db.count_rows('12')
rowsnum13=0
rowsnum14 = db.count_rows('14')
rowsnum15 = db.count_rows('15')
rowsnum16 = db.count_rows('16')
rowsnum17 = db.count_rows('17')
rowsnum18 = db.count_rows('18')
with shelve.open(os.getcwd()+shelve_name) as storage:
storage['rows_count'] =[rowsnum1,rowsnum2,rowsnum3,rowsnum4,rowsnum5,rowsnum6,rowsnum7,rowsnum8,rowsnum9,rowsnum10,rowsnum11,rowsnum12,rowsnum13,rowsnum14,rowsnum15,rowsnum16,rowsnum17,rowsnum18]
if debug==1: print (storage['rows_count'])
def count_rows():
"""Count amount of rows in database and save in storage.
Then chose music among them"""
db = SQLighter(database_name)
rowsnum = db.count_rows()
with shelve.open(shelve_name) as storage:
storage["rows_count"] = rowsnum
def activity(self): db_worker = SQLighter(config.database_name) rows = db_worker.count_rows() rand_val = rand.randint(1, rows) msg = db_worker.select_single(rand_val) self.bot.send_message(msg[2], msg[1]) db_worker.close()
def count_rows():
"""
Данный метод считает общее количество строк в базе данных и сохраняет в хранилище.
Потом из этого количества будем выбирать музыку.
"""
db = SQLighter(database_name)
rowsnum = db.count_rows()
with shelve.open(shelve_name) as storage:
storage['rows_count'] = rowsnum
async def с_btn1(call: CallbackQuery):
db_work = SQLighter(database_name)
table_name = "Физкультура1"
for i in range(1, db_work.count_rows(table_name) + 1):
right_answer = db_work.select_right_answer(table_name, i)[0]
answers = str(db_work.select_wrong_answers(table_name, i)[0]).split(';')
answers.append(right_answer)
keyboard = ListOfButtons(text=answers, callback=answers).inline_keyboard
await call.message.answer(text=str(db_work.select_question(table_name, i)[0]), reply_markup=keyboard)
def count_rows():
"""
Данный метод считает общее количество строк в базе данных и сохраняет в хранилище.
Потом из этого количества будем выбирать музыку.
"""
db = SQLighter(database_name)
rowsnum = db.count_rows()
with shelve.open(shelve_name) as storage:
storage['rows_count'] = rowsnum
def count_rows():
"""
Данный метод достает из базы общее колличество
строк с вопросами и сохраняет их в хранилище
"""
db = SQLighter(database_name)
rowsnum = db.count_rows()
with shelve.open(shelve_name) as storage:
storage['row_count'] = rowsnum
def count_rows():
"""
It counts rows in database
:return: rows number
"""
db = SQLighter(database_name)
rowsnum = db.count_rows()
with shelve.open(shelve_name) as storage:
storage['rows_count'] = rowsnum
def count_rows():
db = SQLighter(database_name)
rowsnum = db.count_rows()
with shelve.open(shelve_name) as storage:
storage['rows_count'] = rowsnum
import shelve
def count_rows_photo():
db = SQLighter(database_name2)
rowsnum = db.count_rows()
slovar['rows_count2'] = rowsnum
def count_rows_musiv():
db = SQLighter(database_name)
rowsnum = db.count_rows()
slovar['rows_count1'] = rowsnum
def count_rows(tname):
db = SQLighter(database_name)
rowsnum = db.count_rows(tname)
with shelve.open(shelve_name) as storage:
storage['rows_count'] = rowsnum
return rowsnum
