Fix/postgresql #7620

ole-larsen · 2025-05-23T06:35:16Z

add a try/except block to the loop in SqlConnectionManager.init where foreign key constraints are dropped using SQLAlchemy. The goal is to ensure that any unexpected issues (e.g., invalid constraints, engine dialect inconsistencies, etc.) are gracefully logged without crashing the initialization process.
add psycopg2>=2.9.10 and freeze cython version
_did_create_order and _did_fill_order methods now query the database to check if an Order record with the same order_id already exists.
_did_fill_order has been enhanced to create a new Order record if one is missing at the time of a fill event.
session.flush() is used after inserting new Order records to ensure the SQLAlchemy session registers the new object immediately
xemm_multiple_levels.py: active_buy_executors_target = [e.config.target_profitability == target_profitability for e in active_buy_executors] and active_sell_executors_target = [e.config.target_profitability == target_profitability for e in active_sell_executors] changed to
active_buy_executors_target = [
e for e in active_buy_executors if e.config.target_profitability == target_profitability
]
active_sell_executors_target = [
e for e in active_sell_executors if e.config.target_profitability == target_profitability
]

…nt))

…er if not exists

ole-larsen added 4 commits May 23, 2025 11:31

(fix) add try-except block to conn.execute(DropConstraint(fk_constrai…

04cc067

…nt))

(fix) freeze cython version and add psycopg2>=2.9.10 to environments

a47f606

(fix) fix market_recorder. Add check for existing records. create Ord…

d98a65f

…er if not exists

(fix) fix xemm_multiple_levels.py

c32a1d7

Provide feedback