testapi6-sql

A plugin to create tag to execute sql(mysql, postgres...)

Features

• Execute sql

Read document details

How to use

Installation

// install via npm
npm install -g testapi6-sql

// install via yarn
yarn global add testapi6-sql

Configuration

Read knex

Use in yaml

- testapi6-sql.Sql:
    connection: mysql://root:root@localhost/mydb
    # connection: postgres://root:root@localhost/mydb
    queries: 
      - select * from user
      - title: Get users
        sql: select * from users where id = ?
        prms: 
          - 123
        var: rs
- Echo: ${rs}