mirror of
https://github.com/Ichinga-Samuel/aiomql.git
synced 2026-07-27 20:27:43 +00:00
38 lines
1.2 KiB
Markdown
38 lines
1.2 KiB
Markdown
|
# 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`](../core/db.md)
|
||
|
|
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 |
|