for n in res:
c.execute('INSERT INTO Zayavka(id) VALUES(?) ON CONFLICT(id) DO NOTHING', (n, ) )
res = [[40065], [40064]]
c.executemany('INSERT INTO Zayavka(id) VALUES(?) ON CONFLICT(id) DO NOTHING', res )
@bot.message_handler(commands=['start'])
def start(message):
# соответственно берем первый аргумент
per = message.text.split()[1]
args = message.text.split()[1:]
per = args[0] if args else None
data = pd.read_csv(sys.argv[1], sep=';')
self.cursor.execute("UPDATE users SET balance = ? WHERE chat_id = ?", (balance, chat_id,))
trophy_road INT
self.player.trophy_road = user_data[10]
self.player.trophy_road = json.loads(user_data[36])
self.player.trophy_road = user_data[36]
self.player.league_reward = user_data[10]
def log_into_steam(self):
pass
item.open_items = ['item 1', 'item 2']
item.open_items.append('item 1')
from urllib.parse import unquote
url = "%25EC%259B%2590%25EC%2597%2591%25EC%258A%25A4%25EB%25B2%25B3-%25EB%25A8%25B9%25ED%258A%2580"
print(unquote(unquote(url)))
select * from users, orders, items, commands, cats
select * from users u join orders o on u.user_id = o.user_id
sorted(self.students, key=lambda x: sum(x.grades))
while True:
try:
n = int(input('N = '))
break
except ValueError:
pass
print(n)
from PIL import Image, ImageDraw
img = Image.new("RGB", (800, 800))
idraw = ImageDraw.Draw(img)
idraw.pieslice([10,10,200,200], start=0, end=270, fill=None, outline="yellow")
img.show()
import re
categories = {
r"(время|времени|час)": "время",
r"(зовут|имя)": "имя",
}
# тестовые вопросы
questions = ["Сколько времени?", "Какой час?", "Время", "Как тебя зовут?", "Как твоё имя?"]
for question in questions:
for pattern, category in categories.items():
if re.search(pattern, question, re.I):
print(f"{question} = {category}")
root=Tk()
root.geometry('1000x1000')
img=Label(image=phot)
img.image=phot
gl.add_widget(Button(text='=',on_press = self.calc_result))
def calc_result(self, instance):
"UPDATE users SET user_name = COALESCE(?, user_name), user_surname = COALESCE(?, user_surname), username = COALESCE(?, username), phone_number = COALESCE(?, phone_number) WHERE id = ?"
SET user_name = COALESCE(NULLIF(?, ''), user_name),