]jNdZddlmZddlZddlmZddlmZddlm Z ddl m Z m Z ee jjd z d z Zdd Zdd Zdd ZdddZy)zKCenter configuration versions (append-only; exactly one active per center).) annotationsN)Path) HTTPException) Connection)Jsonbfetchonedatazdefault-config.jsoncPtjtjSN)jsonloadsDEFAULT_CONFIG_PATH read_text(/var/www/avy-guidance/api/app/configs.pydefault_configrs ::)335 66rc>t|d|f}|s tdd|S)NzySELECT id, version, status, config, rationale, approved_at FROM center_configs WHERE center_id = %s AND status = 'active'iz,This center has no active configuration yet.r r)conn center_idrows r active_configrs2   D   C C!OPP Jrc>t|d|f}|s tdd|S)Nz*SELECT * FROM center_configs WHERE id = %sizConfig not foundr)r config_idrs r config_by_idrs) 4E | TC C!344 Jrc |t|d|f}|r|dSt|d|ttd||f}|dS)zJCreate config version 1 (active) from the shipped default, if none exists.zKSELECT id FROM center_configs WHERE center_id = %s ORDER BY version LIMIT 1idzINSERT INTO center_configs (center_id, version, status, config, rationale, created_by, approved_by, approved_at) VALUES (%s, 1, 'active', %s, %s, %s, %s, now()) RETURNING idz_Default configuration seeded from the USDA FS Forecast Guidance and CMAH (Statham et al. 2018).)r rr)rruser_idexistingrs r seed_defaultr"&s_knwmyzH~   K  ." # m    C t9r)returndict)rrrintr#r$)rrrr%r#r$r )rrrr%r z int | Noner#r%)__doc__ __future__rr pathlibrfastapirpsycopgrdbrr __file__resolveparentrrrrr"rrrr/sRQ" !8n,,.55>AVV7r