Advertisement
Guest User

Untitled

a guest
Apr 24th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.48 KB | None | 0 0
  1. import telebot
  2. import os
  3. import psycopg2
  4.  
  5. DATABASE_URL = os.environ['DATABASE_URL']
  6.  
  7. bot = telebot.TeleBot("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%")
  8.  
  9. @bot.message_handler(func=lambda message: True, content_types=['text'])
  10. def insert_table(message):
  11.     conn = psycopg2.connect(DATABASE_URL, sslmode='require')
  12.     cursor = conn.cursor()
  13.     sql = """INSERT INTO PNSB(vstrech)
  14.             VALUES(%s);"""
  15.     cursor.execute(sql, (message.text,))
  16.     conn.commit()
  17.     cursor.close()
  18.          
  19. bot.polling()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement