Telegram Bot

Vocabulary reminder

Requirements:

Create the Virtual Environment

virtualenv -p python3 --no-site-packages telegrambot-env

Activate the virtual environment (i have all virtual environments stored in ~/.virtualenvironments).

source ~/.virtualenvironments/telegrambot-env/bin/activate

Install packages

The required packages are:

• pyTelegramBotAPI
• websocket-client

And we can install from requirements.txt file typing:

pip install -r requirements.txt

Database (2 ways)

- Option 1: data.yml.

Since only words and their translation are stored, the way of using yml files for loading and storing data is explored. With the following simple fragment of code, we can store and load the data from yml file.

import yaml

# Store
yaml_file = open('my_dict.yml', 'w')

dict = {'foo': 'a', 'bar': 'b', 'bam': [1, 2, 3]}

yaml.dump(diccionario, yaml_file, default_flow_style=False)
yaml_file.close()

# Load
yaml_file = open('test.yml', 'r')
yaml.load(yaml_file, Loader=yaml.FullLoader)

- Option 2: SQLite using ORM.

The bot will connect to a simple database (sqlite) to exchange requests.

Documentation about how to connect Python application with simple database using ORM, can be found here.

The simple program to connect, create, delete, has the following usage:

from sqlite_orm.database import Database
from sqlite_orm.field import IntegerField, BooleanField, TextField
from sqlite_orm.table import BaseTable

import logging


class User(BaseTable):
    __table_name__ = 'users'

    id = IntegerField(primary_key=True, auto_increment=True) #автоинкремент на int поле
    name = TextField(not_null=True)
    active = BooleanField(not_null=True, default_value=1)


class Post(BaseTable):
    __table_name__ = 'posts'

    id = IntegerField(primary_key=True)
    name = TextField(not_null=True)
    id_user = IntegerField(foreign_key=User.id)


if __name__ == '__main__':

    #logger configure:
    logging.basicConfig(filename="sample.log", level=logging.DEBUG, format=('%(asctime)s: '
                                                                            '%(filename)s: '
                                                                            '%(levelname)s: '
                                                                            '%(funcName)s(): '
                                                                            '%(lineno)d: '
                                                                            '%(message)s'), datefmt="%Y-%m-%d %H:%M:%S")
    with Database("test.db") as db:
        # create table
        db.query(Post, User).create().execute()

        user1 = User(id=1, name='User1')
        user2 = User(id=2, name='User2')
        user3 = User(id=3, name='User3')

        post1 = Post(id=1, name='Post1', id_user=user1.id)
        post2 = Post(id=2, name='Post2', id_user=user2.id)
        post3 = Post(id=3, name='Post3', id_user=user3.id)

        #insert data
        db.query().insert(user1, user2, user3, post1, post2, post3).execute()

        # select with columns + autojoin with fk;
        print('\n=======SELECT + Auto Join=======')
        for row in db.query(User, Post.name).select().join(Post).execute():
            print(row)

        # update
        db.query(User).update(name='User3_UPDATED').filter(User.name == 'User3').execute()

        print('\n=======SELECT after update=======')
        for row in db.query(User, Post.name).select().join(Post).execute():
            print(row)

        db.query(User).delete().filter(User.name == 'User3_UPDATED').execute()

        print('\n=======SELECT after delete=======')
        for row in db.query(User, Post.name).select().join(Post).execute():
            print(row)

        # delete
        db.query(User, Post).drop().execute()

TelegramBot API

@bot.message_handler(commands=['piensa3D'])
def command_piensa3D(m):
    cid = m.chat.id
    Piensa3D = open('favicon_jderobot.png', 'rb')
    xxx=open('xxx.mp3', 'rb')
    yyy=open('yyy.mp4', 'rb')
    zzz=open('zzz.jpg', 'rb')
    bot.send_sticker(cid, Piensa3D)
    bot.send_audio(cid, xxx)
    bot.send_video(cid, yyy)
    bot.send_photo(cid, zzz)
    bot.send_message(cid, "hola")
    piensa3D.close()
    xxx.close()
    yyy.close()
    zzz.close()