CitasBot

This Telegram Bot will let group admins create, modify, delete, etc... any kind of meeting. Other users will be able to show group meetings, filter them by date, meeting number, etc... In adition, all members will receive a notification one day and one hour before the meeting date as a reminder.

Currently avalaible commands

• /citastodas: Muestra un resumen de todas las citas.
• /citasmostrar: Muestra una cita en detalle dado el "Número de cita" de la misma.
• /citashoy: Muestra las citas programadas para hoy en detalle.
• /citascrear: Crea una cita paso a paso.
• /citaseliminar: Elimina una cita dado el "Número de cita" de la misma.
• /citasmodificar: Modifica una cita dado el "Número de cita" de la misma.
• /citasfechas: Muestra las citas programadas para la/s fecha/s indicada/s en detalle.
• /citassemana: Muestra las citas programadas para la semana actual en detalle.

Commands currently in development

• /citasasistir: Apuntarse como acompañante a una cita, dado el "Número de cita" de la misma.

Currently avalaible features

• 1 day before notification: Users will receive a notification reminding they have a meeting the next day.
• 1 hour before notification: Users will receive a notification reminding they have a meeting in one hour.

How to deal with Emojis and strange characters in MySQL

You need to make some modifications in your MySQL database in order to deal especially with Emojis (but also with some special characters).

Basically, you have to change your tables and columns charset to "utf-8", as we configured on our python Bot, in the columns that have free text entry:

ALTER TABLE cita charset=utf8mb4,
MODIFY COLUMN motivo VARCHAR(45) CHARACTER SET utf8mb4 NOT NULL,
MODIFY COLUMN lugar VARCHAR(50) CHARACTER SET utf8mb4 NOT NULL,
MODIFY COLUMN direccion VARCHAR(100) CHARACTER SET utf8mb4,
MODIFY COLUMN interesado VARCHAR(45) CHARACTER SET utf8mb4 NOT NULL,
MODIFY COLUMN acompanantes VARCHAR(100) CHARACTER SET utf8mb4;

But this is not all, make sure in your python Bot you decode your "message text" before inserting it into the database, just in case your message isn't completely a string:

if not isinstance(cita.motivo, str):
	cita.motivo = cita.motivo.decode('utf-8')

You don't have to take any special care when retrieving your data from the database.

Example

I have my own Bot running 24/7 exactly with this code, please check it out!

Contact

Please, feel free to contact me by my GitHub profile methods or by chatting me on Telegram for any doubt or question about my Bot functionality or code.