jm dZddlZddlmZejeZd dZdedede dzfdZ d e dzd edzd edzde e dze dzffd Z y)a2Converts prices into a tenant's reference currency so they can be compared. Every price rule in the matching specification divides one price by another. Across currencies that is meaningless and silent: an INR price against a USD one yields a ratio dozens of times out, and the output looks like a ranking opinion rather than a data fault. Conversion happens once, at ingestion, from an operator-seeded rate table -- never guessed, since a guessed rate is indistinguishable from a real one in the output while a missing one is visible as an incomplete product. N)get_master_db_connectionreturnc\t} |j5}|jdddd|j |jy#1swY+xYw#t$r)|j t jddwxYw#|jwxYw)Nar CREATE TABLE IF NOT EXISTS fx_rates ( base_currency TEXT NOT NULL, quote_currency TEXT NOT NULL, rate REAL NOT NULL, fetched_at TIMESTAMPTZ NOT NULL DEFAULT now(), PRIMARY KEY (base_currency, quote_currency) ) zCould not ensure fx_rates tableT)exc_info) rcursorexecutecommit Exceptionrollbackloggererrorclose)conncurs 6/var/www/html/strategist-ai/app/services/catalog/fx.pyensure_fx_tablers # %D [[] c KK   !     6 F  s-A$AA$A!A$$2BBB+basequotech|r|sy||k(rytt} |j5}|jd||f|j }|rt |dndcddd|j S#1swYnxYw |j y#|j wxYw)N?zJSELECT rate FROM fx_rates WHERE base_currency = %s AND quote_currency = %sr)rrrrfetchonefloatr)rrrrrows rget_rater's u u} # %D [[] 2c KK*,0%= :,,.C$'5Q=T  2 2  2 2 2  s"B6B' BB BB1 price_centssource_currencyreference_currencyc||r|sy||k(r t|dfSt||}|tjd||ytt ||z|fS)alReturns (converted_cents, rate_used), or (None, None) when no rate exists. Deliberately does not fall back to a default rate: a guessed conversion is indistinguishable from a real one in the output, whereas a null makes the product incomplete and therefore visible, matching the store-flag-exclude pattern used for every other required field. )NNrz3No fx rate for %s -> %s; product will be incomplete)intrr warninground)rrrrates rto_reference_centsr#:so/9K,,;$$ O%7 8D |L&(: < u[4'( )4 //)rN)__doc__loggingapp.services.infra.databaser getLogger__name__r rstrrrrtupler#r$rr-s@   8 $,3sut|&0t0.1Dj0d 0 3:ut| #$0r$