Using Databases
Concordia can use databases to retrieve test data or to set the testing environment up before or after running test scripts.
Installation
Installing
To reduce the number of downloaded packages, Concordia Compiler 2 does not install database drivers by default anymore - as version 1 did.
Use --db-install
plus the driver name. Example:
Available driver names:
Database drivers are installed as development dependencies of your application.
You can also install or uninstall them with NPM, prefixing the driver name with database-js-
. Example: npm i -D database-js-mysql
.
Uninstalling
Use --db-uninstall
plus the driver name. Example:
Upgrading
Just uninstall and then install it again.
Usage
A Database
is global declaration. You must declare it once and then import its file in other features. Example:
A database can be referenced inside UI properties and Test Events by its name between [
and ]
. Example: [My DB]
. To reference a database table, separate the table name from the database name with with a dot (.
) - e.g. [My DB.profession]
. Let's see an example:
Instead of reinventing the wheel, Concordia uses SQL to query and modify databases and files. Even JSON and INI files can be queried with SQL.
In the example above, the property value
from the UI Element "Profession" indicates that its (valid) values are retrieved from the table "profession" that belongs to the database declared as "My DB". The test event Before Each Scenario
was declared to connect to the database, clean the table "profession", and then insert new records that the UI Element "Profession" will use.
See also
Last updated