ores.refdata.currency_pair

std::string(faker::finance::currencyCode()) + "/" + std::string(faker::finance::currencyCode())

std::string("EUR")

std::string("USD")

std::string("major")

drop function if exists ores_refdata_validate_currency_pair_fn;

#include <chrono>
#include <optional>
#include <string>

#include <optional>
#include <string>
#include "sqlgen/Timestamp.hpp"

void updatePairCodeFromCurrencies();

connect(ui_->baseCurrencyCombo, &QComboBox::currentTextChanged, this,
        &CurrencyPairDetailDialog::updatePairCodeFromCurrencies);
connect(ui_->quoteCurrencyCombo, &QComboBox::currentTextChanged, this,
        &CurrencyPairDetailDialog::updatePairCodeFromCurrencies);

WidgetUtils::set_combo_locked(ui_->baseCurrencyCombo, !createMode);
WidgetUtils::set_combo_locked(ui_->quoteCurrencyCombo, !createMode);
// pair_code is always derived (see updatePairCodeFromCurrencies()),
// never independently typed -- the generated locked_fields loop above
// left it as setReadOnly(!createMode) (is_key's normal, editable-at-
// create behaviour), which is wrong for a field that's never directly
// entered even at create time.
ui_->pairCodeEdit->setReadOnly(true);

WidgetUtils::set_combo_locked(ui_->baseCurrencyCombo, true);
WidgetUtils::set_combo_locked(ui_->quoteCurrencyCombo, true);

&& ui_->baseCurrencyCombo->currentText() != ui_->quoteCurrencyCombo->currentText()

void CurrencyPairDetailDialog::updatePairCodeFromCurrencies() {
    if (!createMode_)
        return;
    ui_->pairCodeEdit->setText(
        ui_->baseCurrencyCombo->currentText() + "/" + ui_->quoteCurrencyCombo->currentText());
}

if (createMode_) {
    // pair_.pair_code isn't synced from the UI until updatePairFromUi()
    // runs, later in this function -- read the live combo-derived value
    // directly rather than the (still-stale/empty) domain object.
    const QString baseCode = ui_->baseCurrencyCombo->currentText();
    const QString quoteCode = ui_->quoteCurrencyCombo->currentText();
    const std::string derivedPairCode = ui_->pairCodeEdit->text().trimmed().toStdString();
    const std::string invertedPairCode = (quoteCode + "/" + baseCode).toStdString();

    refdata::messaging::get_currency_pairs_request checkRequest;
    checkRequest.limit = lookup_fetch_limit;
    auto checkResult = clientManager_->process_authenticated_request(std::move(checkRequest));
    if (!checkResult) {
        // Fail closed: the whole point of this check is to prevent a
        // silent overwrite, so if we can't even ask the server whether
        // the pair already exists, don't let the save through blind.
        MessageBoxHelper::warning(this, "Cannot Verify",
            "Could not check for an existing pair before saving. Please try again.");
        return;
    }

    const bool exists = std::ranges::any_of(checkResult->pairs, [&](const auto& p) {
        return p.pair_code == derivedPairCode;
    });
    if (exists) {
        MessageBoxHelper::warning(this, "Duplicate Pair",
            QString("A currency pair '%1' already exists.")
                .arg(QString::fromStdString(derivedPairCode)));
        return;
    }

    // FX market convention quotes each pair in one canonical
    // direction only -- EUR/USD and USD/EUR are not independent
    // pairs, they're the same market inverted. Reject the inverse
    // rather than silently allowing both to coexist.
    const bool inverseExists = std::ranges::any_of(checkResult->pairs, [&](const auto& p) {
        return p.pair_code == invertedPairCode;
    });
    if (inverseExists) {
        MessageBoxHelper::warning(this, "Inverted Pair",
            QString("'%1' is the inverse of the existing pair '%2'. FX market "
                   "convention allows only one direction per currency pair.\n\n"
                   "To use '%1' instead, delete '%2' first, then create '%1'.")
                .arg(QString::fromStdString(derivedPairCode))
                .arg(QString::fromStdString(invertedPairCode)));
        return;
    }
}

void showConventionsRequested();

{
    toolbar_->addSeparator();
    auto* conventionsAction = toolbar_->addAction(
        IconUtils::createRecoloredIcon(Icon::Tag, IconUtils::DefaultIconColor), tr("Conventions"));
    conventionsAction->setToolTip(tr("Open Currency Pair Conventions"));
    connect(conventionsAction, &QAction::triggered, this,
            &CurrencyPairMdiWindow::showConventionsRequested);
}

void showConventionsRequested();

connect(listWindow_, &CurrencyPairMdiWindow::showConventionsRequested,
        this, &CurrencyPairController::showConventionsRequested);