Python Telegram Channel Message Monitor

This project is to monitor Telegram channels using the Telephon API. It is quite easy to connect to and monitor Telegram channels for new messages and I can demonstrate code to do this if needed. What I want to do is record all messages to a SQLite or MySQL database (programmer can decide but be mindful of SQLite has limited data types compared to MySQL and over time there will be 10,000s of records). Steps: When a new message is received: 1) Check if a table exists in the database with the name as the Channel ID number for that Telegram channel. If not then create a new table for it. 2) Record in a separate 'Channels' table the ID (Auto), Channel ID, Channel Name, Last Message ID, Last Message Received DateTime Stamp 3) Record message to the database in real-time along with the following: ID (Auto), DateTime Stamp, Message ID, Reply-To Message ID, Message Text, Attachments/Images, Deleted, DeletedDays In the case of a file attachment or Image attachment they are downloaded to a sub-folder (named \files\ and then the same as the Channel ID) and in the database we store the filename(s) (not the folder path). In case of multiple files in a post then separate the filenames with a comma in the database. In case of the script is stopped for a while then it needs to catch up by looking at the last message ID for each channel in the database (use the Channels table) and then pull any new messages after that ID (following same steps as above). At the first time it should download all messages available from all channels to populate the database. Once every 24 hours, the program scans each channel to identify any deleted messages. If a message is found to be deleted then it flags the record in the database table as Deleted=True and DeletedDays is set as the difference between the Date of the original message and the Date it was deleted. If it's in the same day then = 0. If it's one day later then = 1 etc. Program output whilst running. Shows when creating a new table. Shows when a new message comes in (single line of text). Time (not date) - Channel Name (not ID) - Message (cut to first 40 characters and add ... if over 40 characters). Report to run once per day at 11:50pm (also dump to a file with the name '[login to view URL]') to show any channels with deleted messages. Channel ID, Channel name, Total Messages, Total Deleted Messages, Del. Messages as a % of total messages, Avg. No Days of Deleted messages (2 decimal places).