hjtvddlmZddlZddlZddlmZddlmZddlm Z dZ hdZ dd hZ dd ddZ ddddZdS) ) annotationsN)date) Connection)utc_nowinvestment_performance_scope_v1>crypto_portfoliopostfinance_etrading_cashpostfinance_etrading_depot canonical_truewealth_total_value#not_in_investment_performance_scopepostfinance_efinance_control) classified_atconnr account_idstrincludedboolclassification_rolesourcenoter str | Nonereturnc|r|tvrtd|s|tvrtd|d|fstd|d|f}t ||t f}|rt||krdS|p t} t |d|fd} |rt|n| d d f} |d t d t |d |d | d | } d tj | d  d d z} |d| | |dd|tjd| iddtjt ||ddd|d| f |d|t ||t | | f|dt ||fdS)zKApply one explicit, audited scope classification; equal repeats are no-ops.z:Performance inclusion requires an approved investment rolez>Performance exclusion requires an approved non-investment rolez)SELECT 1 FROM accounts WHERE account_id=?zUnknown accountzySELECT included,classification_role,decision_version FROM performance_scope_classifications WHERE account_id=?Fz