Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import telebot
- import os
- import psycopg2
- DATABASE_URL = os.environ['DATABASE_URL']
- bot = telebot.TeleBot("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%")
- @bot.message_handler(func=lambda message: True, content_types=['text'])
- def insert_table(message):
- conn = psycopg2.connect(DATABASE_URL, sslmode='require')
- cursor = conn.cursor()
- sql = """INSERT INTO PNSB(vstrech)
- VALUES(%s);"""
- cursor.execute(sql, (message.text,))
- conn.commit()
- cursor.close()
- bot.polling()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement