-
Notifications
You must be signed in to change notification settings - Fork 0
/
getsendtelegram.py
41 lines (38 loc) · 1.62 KB
/
getsendtelegram.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
import telebot
import mysql.connector
import json
import datetime
from datetime import datetime
from mysql.connector import Error
bot = telebot.TeleBot("YOUR-BOT-TOKEN")
try:
connection = mysql.connector.connect(host='localhost',
database='cacti',
user='yourcactiuser',
password='yourcactidb')
if connection.is_connected():
db_Info = connection.get_server_info()
print("Connected to MySQL database... MySQL Server version on ",db_Info)
cursor = connection.cursor()
cursor.execute("SELECT description,hostname FROM host WHERE status='1'")
record = cursor.fetchall()
print ("Total Row(s)", cursor.rowcount)
#bot.reply_to(287076189,record)
#while record is not None:
#for row in record:
# print(row)
data = []
#for row in record:
# datetime = datetime.datetime(row[2])
# print(datetime)
print json.dumps(record, sort_keys=True, indent=4, separators=(',',':'))
#bot.send_message(287076189,"Automatic hosts Checked, the following offline devices : \n ============================= \n \n"+json.dumps(record,sort_keys=True, indent=4, separators=(',',':')))
bot.send_message(YOUR-CHAT-ID,"Automatic hosts Checked, the following offline devices : \n ============================= \n \n"+json.dumps(record,sort_keys=True, indent=4, separators=(',',':')))
except Error as e :
print ("Error while connecting to MySQL", e)
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")