@ictu/testx-keywords-postgres

A library that extends testx with keywords for testing Postgres databases. @ictu/testx-keywords-postgres is a fork of @testx/keywords-postgres, maintained and used by ICTU (www.ictu.nl). This library is packaged as a npm package.

How does it work

From the directory of the art code install the package as follows:

npm install @ictu/testx-keywords-postgres --save

After installing the package you add these keywords to testx by adding the following line to your protractor config file:

testx.keywords.add(require('@ictu/testx-keywords-postgres'))

Example testx script:

- execute sql:
    sql: SELECT 1;
    expected result:
      - ?column?: 1
    save result to: saved
- execute sql:
    sql: SELECT 1;
    expected result: '{{saved}}'
- execute sql:
    sql: |-
      DROP TABLE IF EXISTS test;
      CREATE TABLE test (first varchar(20), second integer);
      INSERT INTO test(first, second) VALUES ('test1', 12), ('test2', 34);
      SELECT * FROM test;
    expected result:
      - first: test1
        second: 12
      - first: test2
        second: 34

Keywords

| Keyword | Argument name | Argument value | Description | | ---------------------- | ------------- | --------------- |------------ | | execute sql | | | Connect to the database, execute the SQL query/statement and optionally check the expected result and/or save it in the test context. | | | connection string | Connection string in the format of postgres://user:password@host:port/database.| Optional. If not set, the postgresConnectionString command line (or config file) parameter will be used.| | | sql | SQL query/statement to execute. | Required. | | | expected result | Expected result of the query. | Optional. It will be compared to the result of the query. The keyword will fail if they are different. The expected result should be a list of rows. Every row is an object (see the example). | | | save result to | varname | Optional. The name of a context variable, that will be used to save the result of the query. |