sqlite

Documentation

Index

• Constants

Constants

const (
	CommandTableQuery = `` /* 161-byte string literal not displayed */

	ParametersTableQuery = `` /* 273-byte string literal not displayed */

	SearchTableQuery = `
	CREATE VIRTUAL TABLE IF NOT EXISTS commands_fts
	USING fts5(id UNINDEXED, name, command, description);
	`

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

)

table creation

const (
	InsertCommandFtsTrigger = `` /* 215-byte string literal not displayed */

	UpdateCommandFtsTrigger = `` /* 224-byte string literal not displayed */

	DeleteCommandFtsTrigger = `` /* 140-byte string literal not displayed */

)

triggers

const (
	UpsertCommandQuery = `` /* 244-byte string literal not displayed */

	UpsertParameterPartialQuery = `` /* 240-byte string literal not displayed */

	GetAllCommandsQuery = `
	SELECT id, name, description, command 
	FROM commands`

	GetCommandbyIDQuery = `
	SELECT 
		id, name, description, command 
	FROM commands
	WHERE id = ?`

	GetParametersByCommandID = `
	SELECT 
		id, name, description, value 
	FROM parameters
	WHERE command = ?`

	SearchCommandQuery = `` /* 186-byte string literal not displayed */

	DeleteCommandQuery = `DELETE FROM commands WHERE id = ?`

	DeleteParametersQuery = `DELETE FROM parameters WHERE id IN (?)`

	UpsertExplanationQuery = `` /* 187-byte string literal not displayed */

	GetExplanationByCommandID = `
	SELECT 
		command, explanation
	FROM notebook
	WHERE command = ?`

	DeleteExplanationQuery = `DELETE FROM notebook WHERE command = ?`
)

queries