robotframework-sqless 0.0.4

robotframework-sqless is a SQL abstraction library for Robot Framework

Robot Framework - SQLess

robotframework-sqless is a SQL abstraction library for Robot Framework

Usage

pip install robotframework-sqless

Example testcase

*** Settings ***
Library	SQLess	schema.yml	db_config.yml
*** Test Cases ***
Get Users By Filter
	${users}	Get By Filter	Users	username=TestUser
	Length Should Be	${users}	1

The example presumes there is a database with a user table and at least a column username.

Schema definition

The database schema must be defined in an .yml file. For the above example, the following file should apply:

database_config:
  dbms: sqlite
  db: sqless.db

schema:
  users:
    tablename: user
    fields:
      id: integer
      username: char