I have the following code:
from prettytable import PrettyTable
myTable = PrettyTable(["Student Name", "Class", "Section", "Percentage"])
# Add rows
myTable.add_row(["Leanord", "X", "B", "91.2 %"])
myTable.add_row(["Penny", "X", "C", "63.5 %"])
myTable.add_row(["Howard", "X", "A", "90.23 %"])
myTable.add_row(["Bernadette", "X", "D", "92.7 %"])
myTable.add_row(["Sheldon", "X", "A", "98.2 %"])
myTable.add_row(["Raj", "X", "B", "88.1 %"])
myTable.add_row(["Amy", "X", "B", "95.0 %"])
This produces a table which looks like this:
+--------------+-------+---------+------------+
| Student Name | Class | Section | Percentage |
+--------------+-------+---------+------------+
| Leanord | X | B | 91.2 % |
| Penny | X | C | 63.5 % |
| Howard | X | A | 90.23 % |
| Bernadette | X | D | 92.7 % |
| Sheldon | X | A | 98.2 % |
| Raj | X | B | 88.1 % |
| Amy | X | B | 95.0 % |
+--------------+-------+---------+------------+
I want to send this table exactly how it appears with no changes to the format to the telegram messages. So i write this to a text file:
table_txt = table.get_string()
with open('output.txt','w') as file:
file.write(table_txt)
Next i use this code:
import telegram
def send_msg(text):
token = "******************:***********"
chat_id = "********"
bot = telegram.Bot(token=token)
for i in text:
bot.sendMessage(chat_id=chat_id, text=i)
new_list = []
with open("output.txt", 'r', encoding="utf-8") as file:
new_list = file.read()
for i in new_list:
send_msg()
What it does is send the content of the file 1 character at a time until you get the telegram error:
RetryAfter: Flood control exceeded. Retry in 43.0 seconds
Please advise what can i do to resolve this?
I'm not a python developer, But I think this will work.
import telegram
def send_msg(text):
token = "******************:***********"
chat_id = "********"
bot = telegram.Bot(token=token)
bot.sendMessage(chat_id=chat_id, text=text)
with open("output.txt", 'r', encoding="utf-8") as file:
send_msg(file.read())