models

const (
	SQL_POST_BY_ID = `` /* 197-byte string literal not displayed */

	SQL_POST_BY_SLUG = `` /* 195-byte string literal not displayed */

	SQL_POSTS_BY_USER = `
		SELECT idPost, title, slug, date, draft
		FROM posts
		WHERE idUser=?
		ORDER BY draft DESC, date DESC`

	SQL_POSTS_BY_TAG = `` /* 200-byte string literal not displayed */

	SQL_ALL_POSTS = `` /* 152-byte string literal not displayed */

	SQL_ALL_TAGS = `SELECT DISTINCT tag FROM post_tags INNER JOIN posts USING(idPost) WHERE posts.draft=false`

	SQL_INSERT_POST = `
		INSERT INTO posts (slug, title, abstract, body, idUser, draft)
		VALUES (?, ?, ?, ?, ?, ?)`

	SQL_INSERT_TAGS = `
		INSERT IGNORE INTO post_tags (idPost, tag)
		VALUES (?, ?)`

	SQL_REMOVE_TAGS = `DELETE from post_tags WHERE idPost=?`

	SQL_DELETE_POST = `DELETE from posts WHERE idPost=?`

	SQL_UPDATE_POST = `
		UPDATE posts SET slug=?, title=?, abstract=?, body=?, idUser=?, draft=?
		WHERE idPost=?`

	SQL_USER_BY_ID = `
		SELECT name, email 
		FROM users 
		WHERE idUser=?`

	SQL_USER_AUTH = `
		SELECT name, idUser
		FROM users 
		WHERE email=? AND password=?`
)