aiomql/docs/lib/result_db.md

result_db

aiomql.lib.result_db — SQLite-backed trade result storage.

Overview

The ResultDB dataclass stores trade results in a SQLite database via the DB ORM base class. Each instance represents a single trade record with fields for order details, strategy parameters, and profit/loss.

Classes

ResultDB

Dataclass for persisting trade results to SQLite.

Inherits from DB. Decorated with @dataclass.

Field	Type	Description
id	int	Primary key (auto-incremented)
symbol	str	Trading instrument
order_type	str	Order type string
strategy	str	Strategy name
volume	float	Trade volume
points	float	Profit in points
profit	float	Profit in account currency
actual_profit	float	Actual profit after close
*	…	Additional strategy-specific fields

Methods

Method	Description
save(commit, update, data, conn)	Inserts or updates the record
get(**kwargs)	Retrieves a single matching record
filter(**kwargs)	Retrieves all matching records