koans

const (
	PragmaEncoding     = "PRAGMA encoding;"
	PragmaEncodingStmt = "PRAGMA encoding = '%s';"
	UTF8               = "UTF-8"
)

const (
	PragmaForeignKeys     = "PRAGMA foreign_keys;"
	PragmaForeignKeysStmt = "PRAGMA foreign_keys = ON;"
)

const (
	PragmaJournalMode = "PRAGMA journal_mode;"
	JournalModeDelete = "DELETE"
	JournalModeWAL    = "WAL"
)

const (
	DbPrefix      = "file:"
	DbName        = "koans.db"
	BackupDbName  = "koans-backup.db"
	DbFile        = DbPrefix + DbName
	DbBackupFile  = DbPrefix + BackupDbName
	DbFileShm     = DbFile + "-shm"
	DbFileWal     = DbFile + "-wal"
	SqliteCmd     = "sqlite3"
	SqliteSchema  = "main"
	SqliteConnErr = "failed to open db connection to %s"
)

const (
	PragmaTableList  = "PRAGMA main.table_list;"
	UpsertRecordStmt = `
	INSERT INTO %s(id, name) VALUES(?, ?)
	ON CONFLICT DO
		UPDATE SET updated=datetime('unixepoch');`
)

const (
	// STRICT must be appended to every CREATE TABLE
	// https://www.sqlite.org/stricttables.html
	// WITHOUT ROWID avoids null primary keys (CHECK needed for empty strings)
	// https://www.sqlite.org/withoutrowid.html
	TableTestWithoutRowIdStrict       = "test_without_rowid_strict"
	CreateStrictWithoutRowIdTableStmt = `` /* 237-byte string literal not displayed */

)

const (
	// STRICT must be appended to every CREATE TABLE
	// https://www.sqlite.org/stricttables.html
	TableTestStrict       = "test_strict"
	CreateStrictTableStmt = `` /* 196-byte string literal not displayed */

)

const (
	PragmaSynchronous       = "PRAGMA synchronous;"
	PragmaSynchronousFull   = "FULL"
	PragmaSynchronousNormal = "NORMAL"
)

const (
	PragmaTimeoutMs   = 5000
	PragmaTimeoutStmt = "PRAGMA busy_timeout = %d;"
	PragmaTimeout     = "PRAGMA busy_timeout;"
)