This bot for Telegram allows users to create, view, and delete notes using an SQLite database through the aiosqlite library and aiogram 3. Each note is associated with a unique user identifier (chat_id) and has its own unique note_id.
- Python 3.9+
aiogram 3.xaiosqlite
-
Clone the repository:
git clone https://github.com/Ananas1kexe/bot-on-aiogram
-
Install the dependencies:
pip install -r requirements.txt
-
Create a
.envfile with your bot's token and save it at the root of the project:BOT_TOKEN=yourbottoken
The main.db database contains a notes table where user notes are stored.
chat_id: User's chat ID.note_id: Unique note identifier (auto-incremented).note: Content of the note.
-
/create : Creates a new note. If a note already exists for the chat, it will not be overwritten.
Example usage:
/create Example note -
/notes: Shows all notes for the current user.
Example usage:
/notes -
/delete <note_id>: Deletes the note with the specified
note_id.Example usage:
/delete 1
- The user sends the command
/create Note 1. - The bot saves the note in the database and assigns a unique
note_id. - The user sends the command
/notes, and the bot responds with a list of all the user's notes. - If the user sends the command
/delete 1, the bot deletes the note withnote_id = 1.
To start the bot, run the following command:
python main.pyThe bot will begin running and will listen for Telegram updates.
All bot actions are logged to the console. In case of errors, information will be displayed with logging levels (INFO, ERROR).
- Fork the repository.
- Create a new branch (
git checkout -b feature-name). - Make your changes and commit them using
git commit -am 'Add feature'. - Submit a pull request.
MIT License. See the LICENSE file for more details.
https://github.com/Ananas1kexe/bot-on-aiogram/blob/main/LICENSE