with sqlite3.connect('my.db') as connection:
cursor = connection.cursor()
cursor.execute(cmd)def is_user_warned(user_id: int) -> bool:if not is_user_warned(event.obj.reply_message['from_id']):def post_sql_query(sql_query):
with sqlite3.connect('my.db') as connection:
cursor = connection.cursor()
try:
cursor.execute(sql_query)
except Error:
pass
result = cursor.fetchall()
return result
def is_user_warned(user_id: int):
cmd = "select count(user_id) from warnlist where user_id = %d" % (user_id)
result = post_sql_query(cmd)
return result
if not is_user_warned(event.obj.reply_message['from_id']):
print('добавить')
else:
print('+ 1/3 варн')# -*- coding: utf-8 -*-
import time
import sys
def update_msg(text):
message = f'\r{text}'
sys.stdout.write(message)
sys.stdout.flush()
words = ['world', 'XTerris', 'Maksim']
for word in words:
update_msg(f'Hello, {word}')
time.sleep(1)def post_sql_query(sql_query):
with sqlite3.connect(database) as connection:
cursor = connection.cursor()
try:
cursor.execute(sql_query)
except Error:
print(Error)
result = cursor.fetchall()
return result
def delete_user(user_id):
del_user_query = f'DELETE FROM users WHERE user_id = {user_id};'
post_sql_query(del_user_query)
try:
bot.send_message(user_id, text)
except telebot.apihelper.ApiException:
delete_user(user_id)if message.text.find('?') != -1:
print('ok')import sqlite3
from sqlite3 import Error
from time import sleep, ctimedef post_sql_query(sql_query):
with sqlite3.connect('my.db') as connection:
cursor = connection.cursor()
try:
cursor.execute(sql_query)
except Error:
pass
result = cursor.fetchall()
return resultdef create_tables():
users_query = '''CREATE TABLE IF NOT EXISTS USERS
(user_id INTEGER PRIMARY KEY NOT NULL,
username TEXT,
first_name TEXT,
last_name TEXT,
reg_date TEXT);'''
post_sql_query(users_query)def register_user(user, username, first_name, last_name):
user_check_query = f'SELECT * FROM USERS WHERE user_id = {user};'
user_check_data = post_sql_query(user_check_query)
if not user_check_data:
insert_to_db_query = f'INSERT INTO USERS (user_id, username, first_name, last_name, reg_date) VALUES ({user}, "{username}", "{first_name}", "{last_name}", "{ctime()}");'
post_sql_query(insert_to_db_query )create_tables() # вызываем функцию создания таблицы users
@bot.message_handler(commands=['start'])
def start(message):
register_user(message.from_user.id, message.from_user.username,
message.from_user.first_name, message.from_user.last_name)
bot.send_message(message.from_user.id, f'Welcome {message.from_user.first_name}' )for elem in list_b:
bot.send_message(userid, elem)city = message.text
with db.connect('your.db') as connection:
cursor = connection.cursor()
cursor.execute("SELECT * FROM table WHERE row = ?", (city,))
result = cursor.fetchall()def check_city(city ):
with db.connect('your.db') as connection:
cursor = connection.cursor()
cursor.execute("SELECT * FROM table WHERE row = ? ", (city,))
data = cursor.fetchone()
if data is None:
return False
else:
return data
test = check_city(message.text)
if test:
bot.send_message(user_id, test[0]) # например первое поле из таблицыdef IsCorrect(number):
if number.isdigit() and (len(number) >= 9 and len(number) <= 12):
if number[:2] != '00' and number[0] == '0':
rNumber = '421' + number[1:]
elif number[0] == '9':
rNumber = '0' + number
else:
rNumber = number[2:]
return rNumber
else:
return Falsemassage_string = True
while massage_string is Truedef send_file(user, file):
doc = open(file, 'rb')
bot.send_document(user, doc)
bot.send_document(user, "FILEID")users = [1, 2, 3, 4, 5]
mesg = 'Welcome Bot v.1.2'
for user in users:
bot.send_message(user, mesg)
answer_yes = 'yes'
answer_no = 'no'
if input('Вы прочитали книгу Лутца? ').lower() == answer_yes:
print('Ложь! Этого вопроса бы тут не было!')
else:
answer = input('Вам нужно сначала прочитать книгу Лутца, хотите? ').lower()
if answer == answer_yes:
print('https://www.litres.ru/mark-lutc/izuchaem-python-4-e-izdanie-24500334/')
elif answer == answer_no:
print('без труда не вытащишь и рыбку из пруда')
else:
print('Вот Вам и простой пример ветвления')# создаете словарь
persons = {}
# пополняете словарь
for num in enumerate(name, date_time, first_ip):
persons[num] = {"user": {"name": name, "IP from the last entry point": first_ip, "Last login date": date_time}}
# в конце кода записываете в json, записывать каждый раз в цикле for нет необходимости
with open(r'C:\users.json', 'w', encoding='utf-8') as fh:
fh.write(json.dumps(message, ensure_ascii=False))