def fill_currencies(engine: Engine): """ Fill currencies table with CurrencyEnum values """ conn = engine.connect() trans = conn.begin() for c in CurrencyEnum: query = sa.select((1, )).where(Currency.c.name == c.value) already_exists = conn.execute(query).scalar() if not already_exists: query = Currency.insert().values(name=c.value) conn.execute(query) trans.commit()