Miroslavsckaya/tg_rss_bot

Fork 0

Persistence module (database interaction) #6

New issue

Closed

opened 2022-04-30 12:26:58 +00:00 by skobkin · 4 comments

skobkin commented

2022-04-30 12:26:58 +00:00

Collaborator

To implement a module which interacts with the database to:

Register new users
Adding new RSS feeds
- Check if feed exists
- If not, inserting new
- Linking the user to the feed if not linked before
Deleting RSS feed for user
- Remove link to the user
- Or remove link and feed if user is the last subscriber for this feed
- Use COUNT() on the linking table?
Getting feed list for update
Getting user's feeds
Getting feed content from last update (items)
Storing feed content from the update (delete last + insert new)

Recommendations:

Use SQLite for MVP

To implement a module which interacts with the database to: * Register new users * Adding new RSS feeds * Check if feed exists * If not, inserting new * Linking the user to the feed if not linked before * Deleting RSS feed for user * Remove link to the user * Or remove link and feed if user is the last subscriber for this feed * Use `COUNT()` on the linking table? * Getting feed list for update * Getting user's feeds * Getting feed content from last update (items) * Storing feed content from the update (`delete` last + `insert` new) Recommendations: * Use SQLite for MVP

skobkin added this to the MVP 0.1 milestone 2022-04-30 12:26:58 +00:00

skobkin added the

new feature

label 2022-04-30 12:26:58 +00:00

Miroslavsckaya was assigned by skobkin

2022-04-30 12:26:58 +00:00

skobkin added a new dependency 2022-04-30 12:27:29 +00:00

#5 RSS update manager

skobkin referenced this issue

2022-04-30 12:33:04 +00:00

Telegram Command Processor #7

skobkin added a new dependency 2022-04-30 12:33:18 +00:00

#7 Telegram Command Processor

skobkin added a new dependency 2022-05-01 23:47:56 +00:00

#9 Python venv

skobkin removed a dependency 2022-05-01 23:48:02 +00:00

#9 Python venv

skobkin added a new dependency 2022-05-01 23:48:10 +00:00

#10 Telegram module

skobkin commented

2022-05-15 19:57:23 +00:00

Author

Collaborator

@Miroslavsckaya, let's use SQLite in MVP to save time.
I'll create another ticket for PostgreSQL migration.

@Miroslavsckaya, let's use SQLite in MVP to save time. I'll create another ticket for PostgreSQL migration.

👍 1

skobkin added a new dependency 2022-05-15 19:59:17 +00:00

#15 Migrate persistence module to PostgreSQL

Miroslavsckaya commented

2022-05-19 14:18:21 +00:00

Owner

@Miroslavsckaya, let's use SQLite in MVP to save time.
I'll create another ticket for PostgreSQL migration.

> @Miroslavsckaya, let's use SQLite in MVP to save time. > I'll create another ticket for PostgreSQL migration. ok

skobkin added a new dependency 2022-05-19 16:48:13 +00:00

#16 Database initialization and migration

skobkin commented

2022-05-19 16:51:22 +00:00

Author

Collaborator

@Miroslavsckaya we also need to have migrations to be able to properly develop the project as a team. So I've created #16 for you. You can implement that after imlementing a draft of this task.

skobkin added a new dependency 2022-05-22 17:19:11 +00:00

#18 Refactor/Optimize transactions

skobkin commented

2022-05-22 17:43:47 +00:00

Author

Collaborator

We forgot about get_user() method. So we should implement it too 🤷‍♂️

We forgot about `get_user()` method. So we should implement it too 🤷‍♂️

Miroslavsckaya closed this issue

2022-05-29 20:25:10 +00:00

skobkin referenced this issue from a commit

2022-05-30 00:02:11 +00:00