def send_message(message):
global admin_mesage
db_worker = SQLStudents(database_name)
students = db_worker.select_all()
for student in students:
bot.send_message(student[0], admin_mesage)
markup = data.buttons.button_admin()
bot.send_message(message.chat.id, 'Пост отправлен', reply_markup=markup)
admin_mesage = '' ''
def start_message(message):
db_worker = SQLStudents(database_name)
if db_worker.chek_database(message.chat.id) == False:
add_student(message.chat.id)
else:
if message.chat.id in admin:
bot.send_message(message.chat.id, myString.help_for_admin)
else:
bot.send_message(message.chat.id, myString.help_for_users)
db_worker.close()
def button(message):
db_worker = SQLStudents(database_name)
if db_worker.chek_database(message.chat.id) == False:
add_student(message.chat.id)
else:
if message.chat.id in admin:
markup = data.buttons.button_admin()
else:
markup = data.buttons.button_days()
bot.send_message(message.chat.id, "Кнопки добавлены", reply_markup=markup)
db_worker.close()
def counter_users(message):
db_worker = SQLStudents(database_name)
bot.send_message(message.chat.id, db_worker.counts_row())
students = db_worker.select_all()
for student in students:
bot.send_message(message.chat.id, str(student[0]) + " " + str(student[1]) + " " + str(student[2]) + " " + str(student[3]))
db_worker.close()
def student(message):
if message.chat.id in admin:
markup = data.buttons.button_admin()
else:
markup = data.buttons.button_days()
msg = bot.send_message(message.chat.id, "Спасибо, " + message.chat.first_name, reply_markup=markup)
user = User()
user.message(msg)
user.getNumberGroup(message.text)
db_worker = SQLStudents(database_name)
db_worker.insert_students(user)
db_worker.close()
def send_timetable_wednesday(message):
db_worker = SQLStudents(database_name)
if db_worker.chek_database(message.chat.id) == False:
add_student(message.chat.id)
else:
student = db_worker.select_id(message.chat.id)
bot.send_message(message.chat.id, 'Среда\n')
if student.number == 'KН36Г':
bot.send_message(message.chat.id, myString.wednesday_kn36g)
if student.number == 'KН36Д':
bot.send_message(message.chat.id, myString.wednesday_kn36d)
if student.number == 'KН36Е':
bot.send_message(message.chat.id, myString.wednesday_kn36e)
db_worker.close()
def start_message(message):
bot.send_message(message.chat.id, myString.start)
db_worker = SQLStudents(database_name)
if db_worker.chek_database(message.chat.id) == False:
add_student(message.chat.id)
db_worker.close()