On this page

db-show

Shows content of specified database table and creates DbUnit dataset in xml, json or csv formats

Overview

e:db-show

<e:db-show table="ANDROIDS_TABLE"/>

1. Configure a connection to database via DbPlugin.

2. Use e:db-show tag in specification:

src/test/resources/specs/Specs.html

<e:db-show table="ANDROIDS_TABLE"/>

attribute	desc	example
`table`	Table name	`Required`. `Default: -` `table="androids_table"`
`cols`	List of comma-separated column names to include in dataset	`Optional`. `Default: -` `cols="id, name"`
`saveToResources`	Path in `srs/test/resources/` where to store generated dataset	`Optional`. `Default: -` `saveToResources="/data/db/person.xml"`
`where`	`WHERE clause` in database-specific SQL format to filter actual dataset	`Optional`. `Default: -` `where="name='andrew'"`
`ds`	Datasource to which dataset will be applied. By default only 1 datasource with name default exists, other may be added by DbPlugin configuration.	`Optional`. `Default: default` `ds="myOtherDatasource"`
`caption`	Caption to display instead of table name in report	`Optional`. `Default: -` `caption="Androids"`

Given

Empty table:

ANDROIDS_TABLE

EMPTY

Then

The following markup:

<e:db-show table="ANDROIDS_TABLE"/>

will be rendered as:

ANDROIDS_TABLE

EMPTY

Given

ANDROIDS_TABLE
id	name	weight	height	manufactured
1	Adam	10	110	2001-01-01
2	Bob	20	120	2002-02-02

Then

The following markup:

<e:db-show table="ANDROIDS_TABLE" cols="name, weight, manufactured"/>

will be rendered as:

ANDROIDS_TABLE
NAME	WEIGHT	MANUFACTURED
Adam	1E+1	2001-01-01 00:00:00.000
Bob	2E+1	2002-02-02 00:00:00.000

Given

ANDROIDS_TABLE
id	name	weight	height	manufactured
1	Adam	10	110	2001-01-01
2	Bob	20	120	2002-02-02

Then

The following markup:

<e:db-show table="ANDROIDS_TABLE" cols="name, weight" where="name='Adam'"/>

will be rendered as:

ANDROIDS_TABLE
NAME	WEIGHT
Adam	1E+1