Александр

# -*- coding: utf-8 -*-
import telebot
from time import sleep
from threading import Thread

bot = telebot.TeleBot(token_test)


@bot.message_handler(commands=['start'])
def thread_main(message):
    Thread(target=timer, args=(message,)).start()
    Thread(target=counter, args=(message,)).start()


def timer(message):
    msg = bot.send_message(chat_id=message.chat.id, text='Timer start')
    sleep(1)
    msg_id = msg.message_id
    time_s = 15
    for t in range(time_s, 0, -1):
        bot.edit_message_text(chat_id=message.chat.id,  message_id=msg_id, text=f'Timer - {t}')
        sleep(1)
    bot.edit_message_text(chat_id=message.chat.id, message_id=msg_id, text='Timer End')


def counter(message):
    msg = bot.send_message(chat_id=message.chat.id, text='Count start')
    sleep(1)
    msg_id = msg.message_id
    count = 15
    for c in range(count):
        bot.edit_message_text(chat_id=message.chat.id,  message_id=msg_id, text=f'Count - {c}')
        sleep(1)
    bot.edit_message_text(chat_id=message.chat.id, message_id=msg_id, text='Count End')


if __name__ == "__main__":
    try:
        bot.polling(none_stop=True)
    except Exception as e:
        print(e)

# -*- coding: utf-8 -*-
import telebot
from time import sleep

bot = telebot.TeleBot(token)


@bot.message_handler(commands=['start'])
def send_notification(message):
    msg = bot.send_message(chat_id=message.chat.id, text='START')
    sleep(1)
    msg_id = msg.message_id
    time_s = 15
    for t in range(time_s, 0, -1):
        bot.edit_message_text(chat_id=message.chat.id,  message_id=msg_id, text=f'Wait...{t}  секунд')
        sleep(1)
    bot.edit_message_text(chat_id=message.chat.id, message_id=msg_id, text='END')


if __name__ == "__main__":
    try:
        bot.polling(none_stop=True)
    except Exception as e:
        print(e)

settings_massive=['text_hello','text_goodbye','text_kick']
massnum = 1
number_text = 5
text_chat = 777
print(f"Изменяется... {settings_massive[massnum]} {number_text} {text_chat}")
#Изменяется... text_goodbye 5 777

with requests.Session() as session:
        cookies = dict(uid=uid, usess=usess)
        auth = dict(username=login, password=password)  # Данные в виде словаря, которые отправлятся в POST
        r = session.get(url, timeout=5)  # Получаем страницу с формой логина
        r.encoding = 'utf-8'
        session.post(url, auth)  # Отправляем данные в POST, в session записываются наши куки
        r = session.get(link, cookies=cookies, timeout=5)
        open('some_file_name', 'wb').write(r.content)

with open('mylist.json',"w", encoding="utf-8") as file:
    json.dump(out, file, ensure_ascii=False)

CREATE TABLE IF NOT EXISTS games
(game TEXT NOT NULL, play_date TEXT NOT NULL, play_time TEXT NOT NULL, 
team_a TEXT NOT NULL, team_b TEXT NOT NULL, cup TEXT, 
PRIMARY KEY (game , play_date , play_time ));

SELECT CONCAT(COALESCE(brand_product, "")," ", COALESCE(type_product,"")) AS name
FROM products;

-o --output=STRING         Change journal output mode (short, short-precise,
                               short-iso, short-iso-precise, short-full,
                               short-monotonic, short-unix, verbose, export,
                               json, json-pretty, json-sse, cat)

2018-01-28T18:58:20+0300 ubuntu kernel: BIOS-e820: [mem 0x00000000bfd15000-0x00000000bfd5ffff] ACPI NVS
2018-01-28T18:58:20+0300 ubuntu kernel: BIOS-e820: [mem 0x00000000bfd60000-0x00000000bfd68fff] ACPI data
2018-01-28T18:58:20+0300 ubuntu kernel: BIOS-e820: [mem 0x00000000bfd69000-0x00000000bfd6bfff] ACPI NVS

SELECT * FROM new_table 
WHERE 
link_id NOT IN (SELECT DISTINCT(link_id) FROM new_table WHERE flag=0);

user_id = 123
get_id_from_db = 6

user_data = {user_id: {'city':'', 'fio':'', 'phone':'', 'inn':'', 'address':'', 'napravlenie':'', 'id': get_id_from_db}}

print(user_data)

user_data[user_id]['city'] = 'Павлодар'
print(user_data)

user_data[user_id]['fio'] = 'Иванов а м'
print(user_data)

user_data[user_id]['phone'] = '77777777'
print(user_data)

user_data[user_id]['inn'] = '4679085467'
print(user_data)

user_data[user_id]['address'] = 'Петрова 65 кв 98'
print(user_data)

user_data[user_id]['napravlenie'] = 'сайт-визитка'
print(user_data)