Module sysbot.utils.robot.listener.sqlite

SQLite Listener for Robot Framework BDD Database Integration

This module provides a Robot Framework listener that stores test results in SQLite.

Usage

robot –listener sysbot.utils.robot.listener.sqlite.Sqlite:results.db:MyCampaign your_tests/

Example

robot –listener sysbot.utils.robot.listener.sqlite.Sqlite:results.db:TestRun1 your_tests/

Classes

class Sqlite (connection_string: str, campaign_name: str = 'Default Campaign')

Robot Framework listener that stores test results in SQLite database.

SQLite is a lightweight, file-based database that requires no separate server. Perfect for local testing and small to medium-sized test suites.

The listener creates a hierarchical structure: - Test Campaign (top level) - Test Suite - Test Case - Keyword

Initialize the SQLite listener.

Args

connection_string
Path to SQLite database file
campaign_name
Name of the test campaign (default: "Default Campaign")

Class variables

var ROBOT_LISTENER_API_VERSION

Methods

def close(self)

Close database connection and update campaign end time.

Updates the campaign end timestamp, commits pending transactions, and closes the database connection.

def end_keyword(self, data, result)

Called when a keyword ends.

Args

data
Robot Framework keyword data object.
result
Robot Framework keyword result object.
def end_suite(self, data, result)

Called when a test suite ends.

Args

data
Robot Framework suite data object.
result
Robot Framework suite result object.
def end_test(self, data, result)

Called when a test case ends.

Args

data
Robot Framework test data object.
result
Robot Framework test result object.
def start_keyword(self, data, result)

Called when a keyword starts.

Args

data
Robot Framework keyword data object.
result
Robot Framework keyword result object.
def start_suite(self, data, result)

Called when a test suite starts.

Args

data
Robot Framework suite data object.
result
Robot Framework suite result object.
def start_test(self, data, result)

Called when a test case starts.

Args

data
Robot Framework test data object.
result
Robot Framework test result object.