README
¶
Venom - Executor Database Fixtures
Step to load fixtures into MySQL and PostgreSQL databases.
It use the package testfixtures.v2 under the hood: https://github.com/go-testfixtures/testfixtures
Please read its documentation for further details about the parameters of this executor, especially folder and files, and how you should write the fixtures.
Input
In your yaml file, you declare tour step like this
- database mandatory [mysql/postgres]
- dsn mandatory
- schemas optional
- files optional
- folder optional
schemasis a list of paths to several.sqlfile that contains the schemas of the tables in your database. If specified, the content of every file will be executed before loading the fixtures.filesparameter is only used as a fallback iffolderis not used.
Example usage (mysql):
name: Title of TestSuite
testcases:
- name: Load database fixtures
steps:
- type: dbfixtures
database: mysql
dsn: user:password@(localhost:3306)/venom?multiStatements=true
schemas:
- schemas/mysql.sql
folder: fixtures
files:
- fixtures/table.yml
note: in the example above, the query param multiStatements=true is mandatory if we want to be able to load the schema.
SQL drivers
This executor uses the following SQL drivers:
- MySQL: https://github.com/go-sql-driver/mysql
- PostgreSQL: https://github.com/lib/pq
Documentation
¶
Index ¶
Constants ¶
const Name = "dbfixtures"
Name of the executor.
Variables ¶
This section is empty.
Functions ¶
Types ¶
type Executor ¶
type Executor struct {
Files []string `json:"files" yaml:"files"`
Folder string `json:"folder" yaml:"folder"`
Database string `json:"database" yaml:"database"`
DSN string `json:"dsn" yaml:"dsn"`
Schemas []string `json:"schemas" yaml:"schemas"`
}
Executor is a venom executor that can load fixtures in many databases, using YAML schemas.
func (Executor) GetDefaultAssertions ¶
func (e Executor) GetDefaultAssertions() venom.StepAssertions
GetDefaultAssertions return the default assertions of the executor.
Source Files