database

const (
	GetPostByIDDML            = `SELECT id, user_id, text, visit_count FROM "microblog"  WHERE id = $1`
	CountLikesDislikesByIDDML = `SELECT count(status) AS count FROM microblog_tracking WHERE microblog_id = $1 AND status = $2`
	IncrementViewDML          = `UPDATE microblog  SET visit_count = visit_count + 1 WHERE id = $1`
)

const (
	GetAllPostByUserIDDML = `SELECT id, user_id, text  FROM "microblog" WHERE user_id = $1 order by creation_date DESC`
)

const (
	GetAllPostDML = `SELECT id, user_id, text FROM "microblog" order by creation_date DESC`
)

const (
	LikeOrDislikeDML = `UPDATE microblog_tracking  SET status = $1 WHERE microblog_id = $2 AND user_id = $3`
)