query

const (
	CreateGroupsTable = `` /* 152-byte string literal not displayed */

	InsertOrReplaceGroup = `
	INSERT OR REPLACE INTO whats4linux_groups
	(jid, name, topic, owner_jid, participant_count)
	VALUES (?, ?, ?, ?, ?);
	`

	SelectAllGroups = `
	SELECT jid, name, topic, owner_jid, participant_count
	FROM whats4linux_groups;
	`

	SelectGroupByJID = `
	SELECT jid, name, topic, owner_jid, participant_count
	FROM whats4linux_groups
	WHERE jid = ?;
	`

	CreateSchema = `` /* 243-byte string literal not displayed */

	InsertMessage = `
	INSERT INTO messages
	(chat, message_id, timestamp, msg_info, raw_message)
	VALUES (?, ?, ?, ?, ?)
	`

	UpdateMessage = `
	UPDATE messages
	SET msg_info = ?, raw_message = ?
	WHERE message_id = ?;
	`

	SelectChatList = `` /* 265-byte string literal not displayed */

	SelectMessagesByChatBeforeTimestamp = `` /* 207-byte string literal not displayed */

	SelectLatestMessagesByChat = `` /* 189-byte string literal not displayed */

	SelectMessageByChatAndID = `
	SELECT msg_info, raw_message
	FROM messages
	WHERE chat = ? AND message_id = ?
	LIMIT 1
	`

	SelectMessageByID = `
	SELECT chat, message_id, timestamp, msg_info, raw_message
	FROM messages
	WHERE message_id = ?
	LIMIT 1
	`

	// Image cache queries
	CreateImageIndexTable = `` /* 252-byte string literal not displayed */

	SaveImageIndex = `
	INSERT OR REPLACE INTO image_index
	(message_id, sha256, mime, width, height, created_at)
	VALUES (?, ?, ?, ?, ?, ?)
	`

	GetImageByID = `
	SELECT message_id, sha256, mime, width, height, created_at
	FROM image_index
	WHERE message_id = ?
	`

	// GetImagesByIDsPrefix is the prefix used to query multiple image IDs.
	// Use it with a dynamically built placeholder list, e.g.
	// q := query.GetImagesByIDsPrefix + strings.Join(placeholders, ",") + ")"
	GetImagesByIDsPrefix = `
	SELECT message_id, sha256, mime, width, height, created_at
	FROM image_index
	WHERE message_id IN (
	`

	GetImagesByIDs = `
	SELECT message_id, sha256, mime, width, height, created_at
	FROM image_index
	WHERE message_id IN (?)
	`
)