jbdZddlZddlmZddlmZej eZdZ de fdZ dZ y) zBands a tenant's own prices into budget, mid and premium. "Premium" has no global meaning -- it means expensive for this catalog. The live catalog spans 79 to 3,699,999 minor units, so a fixed threshold would put nearly everything in one bucket. N)sql)get_db_connection tenant_idct} |j5}|jtjdj tj ||j\}}}ddd|jr |tkstjd|yt|t|fS#1swYUxYw#|jwxYw)zThe 33rd and 67th percentile of a tenant's prices, or None. Prefers price_reference_cents so a tenant with two currencies is not banded on unconverted numbers. a SELECT count(*), percentile_disc(0.33) WITHIN GROUP (ORDER BY p), percentile_disc(0.67) WITHIN GROUP (ORDER BY p) FROM ( SELECT COALESCE(price_reference_cents, price_cents) AS p FROM {}.strategist_products WHERE COALESCE(price_reference_cents, price_cents) IS NOT NULL ) prices Nz,Too few priced products in %s to band prices) rcursorexecuterSQLformat IdentifierfetchonecloseMIN_PRICED_PRODUCTSloggerinfoint)rconncurcountlowhighs B/var/www/html/strategist-ai/app/services/enrichment/price_tiers.py compute_bandsrs  D [[] .c KK ! y12 4 #||~ E3 . E//3;$, BIN s8SY % . . s#CAC 7C CCC)c0||y|\}}||kry||kryy)Nbudgetmidpremium) price_centsbandsrrs rclassifyr!/s1emICST ) __doc__loggingpsycopg2rapp.services.infra.databaser getLogger__name__rrstrrr!rr"rr*s> 9   8 $S:r"