telegram-bot-store-info-sqlite-database

Introduction

This sample script starts a Telegram bot which saves user input into a SQLite3 database as the user interacts with the bot.

The script was adapted from the example conversationbot2 from python-telegram-bot.

This script was written for Python 3 (preferably 3.3 and above).

The script requires the following libraries (and dependencies therein).

A library for the Telegram Bot API.

You can install or upgrade the python-telegram-bot library with:

$ pip install python-telegram-bot --upgrade

For more information please refer to PyPI or Github.

SQLite3 should be included in the standard library.

For more information please refer to the SQLite3 Documentation.

Please update the token of your bot before starting the script.

The token goes between the quotation marks of the Update call in the main function.

Currently the placeholder text where the token should be is TOKEN:token.

You can start the script in Windows Powershell or command prompt with:

> py -3 telephone.py

or on Linux terminal with:

$ python3 telephone.py

You can terminate the bot by pressing Ctrl+C.

You may browse the SQLite3 file using DB Browser for SQLite.