sakila

Documentation

Overview

Package sakila holds test constants and such for the sakila test sources.

Index

• Constants
• func AllHandles() []string
• func AllTbls() []string
• func AllTblsExceptFilmText() []string
• func AllTblsViews() []string
• func MSAll() []string
• func MyAll() []string
• func PgAll() []string
• func SQLAll() []string
• func SQLAllExternal() []string
• func SQLLatest() []string
• func TblActorColKinds() []kind.Kind
• func TblActorCols() []string
• func TblFilmActorColKinds() []kind.Kind
• func TblFilmActorCols() []string
• func TblPaymentColKinds() []kind.Kind
• func TblPaymentCols() []string

Constants

const (
	XLSX             = "@sakila_xlsx"
	XLSXSubset       = "@sakila_xlsx_subset"
	XLSXNoHeader     = "@sakila_xlsx_noheader"
	CSVActor         = "@sakila_csv_actor"
	CSVActorHTTP     = "@sakila_csv_actor_http"
	CSVActorNoHeader = "@sakila_csv_actor_noheader"
	TSVActor         = "@sakila_tsv_actor"
	TSVActorNoHeader = "@sakila_tsv_actor_noheader"
	SL3              = "@sakila_sl3"
	Pg9              = "@sakila_pg9"
	Pg10             = "@sakila_pg10"
	Pg11             = "@sakila_pg11"
	Pg12             = "@sakila_pg12"
	Pg               = Pg12
	My56             = "@sakila_my56" // FIXME: rename to @sakila_my5_6
	My57             = "@sakila_my57" // FIXME: rename to @sakila_my5_7
	My8              = "@sakila_my8"
	My               = My8
	MS17             = "@sakila_ms17"
	MS               = MS17
)

Sakila source handles.

const (
	TblActor          = "actor"
	TblActorCount     = 200
	TblFilm           = "film"
	TblFilmCount      = 1000
	TblFilmActor      = "film_actor"
	TblFilmActorCount = 5462
	TblPayment        = "payment"
	TblPaymentCount   = 16049

	MillerEmail  = "MARIA.MILLER@sakilacustomer.org"
	MillerCustID = 7
	MillerAddrID = 11
	MillerCityID = 280
)

Facts regarding the sakila database.

const (
	URLActorCSV   = "https://sq.io/testdata/actor.csv"
	URLSubsetXLSX = "https://sq.io/testdata/sakila_subset.xlsx"
	URLXLSX       = "https://sq.io/testdata/sakila.xlsx"
)

URLs for sakila resources.

const (
	PathSL3              = "drivers/sqlite3/testdata/sakila.db"
	PathXLSX             = "drivers/xlsx/testdata/sakila.xlsx"
	PathXLSXSubset       = "drivers/xlsx/testdata/sakila_subset.xlsx"
	PathXLSXActorHeader  = "drivers/xlsx/testdata/sakila_actor_header.xlsx"
	PathCSVActor         = "drivers/csv/testdata/sakila-csv/actor.csv"
	PathCSVActorNoHeader = "drivers/csv/testdata/sakila-csv-noheader/actor.csv"
	PathTSVActor         = "drivers/csv/testdata/sakila-tsv/actor.tsv"
)

Paths for sakila resources.

Functions

func AllHandles

func AllHandles() []string

AllHandles returns all the typical sakila handles. It does not include monotable handles such as @sakila_csv_actor.

func AllTbls

func AllTbls() []string

AllTbls returns all table names.

func AllTblsExceptFilmText

func AllTblsExceptFilmText() []string

AllTblsExceptFilmText exists because our current postgres image is different from the others in that it doesn't have the film_text table.

func AllTblsViews

func AllTblsViews() []string

AllTblsViews returns all table AND view names.

func MSAll

func MSAll() []string

MSAll returns the handles for all SQL Server versions.

func MyAll

func MyAll() []string

MyAll returns the handles for all MySQL versions.

func PgAll

func PgAll() []string

PgAll returns the handles for all postgres versions.

func SQLAll

func SQLAll() []string

SQLAll returns all the sakila SQL handles.

func SQLAllExternal

func SQLAllExternal() []string

SQLAllExternal is the same as SQLAll, but only includes external (non-embedded) sources. That is, it excludes SL3.

func SQLLatest

func SQLLatest() []string

SQLLatest returns the handles for the latest version of each supported SQL database. This is provided in addition to SQLAll to enable quicker iterative testing during development.

func TblActorColKinds

func TblActorColKinds() []kind.Kind

TblActorColKinds returns table "actor" column kinds.

func TblActorCols

func TblActorCols() []string

TblActorCols returns table "actor" column names.

func TblFilmActorColKinds

func TblFilmActorColKinds() []kind.Kind

TblFilmActorColKinds returns table "film_actor" column kinds.

func TblFilmActorCols

func TblFilmActorCols() []string

TblFilmActorCols returns table "film" column names.

func TblPaymentColKinds

func TblPaymentColKinds() []kind.Kind

TblPaymentColKinds returns table "payment" column kinds.

func TblPaymentCols

func TblPaymentCols() []string

TblPaymentCols returns table "payment" column names.