Python like system?

Question

Python

I would like to implement a system of likes under posts in Telegram, for example:



But I got confused, how can I make a separate system of likes for each post, so that the numbers are not the same!

Answer 1

Database is our future!

Answer 2

It is possible so for example. Table for storing likes by post and user:

CREATE TABLE IF NOT EXISTS post_likes (
id integer primary key,
post_id integer, -- id поста
user_id integer, -- id пользователя
likes integer
);

Likes can be recorded in one "likes" field. 1 - like, 0 - nothing, -1 - dislike.
Accordingly, to collect the totals, you can use the following query:

select sum(likes) total_score, -- общий счет
sum(case likes when 1 then 1 end) sum_likes, -- кол-во лайков
sum(case likes when -1 then 1 end) sum_dislikes -- кол-во дизлайков
from post_likes where post_id = нужный_id_поста