Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pymssql
- from telegram.ext import Updater, CommandHandler, MessageHandler, Filters
- import logging
- logging.basicConfig(format='%(asctime)s - %(name)s - %(levelname)s - %(message)s', level=logging.INFO)
- logger = logging.getLogger(__name__)
- server = '10.248.205.209'
- user = 'esolis'
- password = 'secret'
- database = 'pythonstorage'
- conecction = pymssql.connetion(server, user, password, database)
- cur = connection.cursor()
- sql = ' SELECT id,servicio FROM logdaga'
- cur.execute(sql)
- def start(bot, update):
- update.message.reply_text('Hi!')
- def tables(bot, update):
- for row in cur.fetchall():
- resultado = row[0], row[1]
- update.message.reply_text(resultado)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement