diff options
| -rw-r--r-- | archaeological_finds/models_finds.py | 98 |
1 files changed, 52 insertions, 46 deletions
diff --git a/archaeological_finds/models_finds.py b/archaeological_finds/models_finds.py index e99b43bc7..bf5ba6380 100644 --- a/archaeological_finds/models_finds.py +++ b/archaeological_finds/models_finds.py @@ -344,44 +344,48 @@ class BaseFind(BaseHistorizedItem, OwnPerms): sql = """ UPDATE "archaeological_finds_basefind" AS bf SET cache_short_id = - CASE basefind_cached_bulk_update.main_ope_code - WHEN NULL THEN - CASE basefind_cached_bulk_update.year - IS NOT NULL + CASE + WHEN basefind_cached_bulk_update.main_ope_code is NULL + THEN + CASE + WHEN basefind_cached_bulk_update.year + IS NOT NULL AND basefind_cached_bulk_update.ope_code - IS NOT NULL - WHEN TRUE THEN - '{ope_prefix}' || - basefind_cached_bulk_update.year || - '-' || - basefind_cached_bulk_update.ope_code - ELSE '' - END - ELSE - '{main_ope_prefix}' || - basefind_cached_bulk_update.main_ope_code + IS NOT NULL + THEN + '{ope_prefix}' || + basefind_cached_bulk_update.year || + '-' || + basefind_cached_bulk_update.ope_code + ELSE '' END + ELSE + '{main_ope_prefix}' || + basefind_cached_bulk_update.main_ope_code + END || '{join}' || to_char(basefind_cached_bulk_update.index, 'fm{zeros}'), - cache_complete_id = - CASE basefind_cached_bulk_update.main_ope_code - WHEN NULL THEN - CASE basefind_cached_bulk_update.year - IS NOT NULL + cache_complete_id = + CASE + WHEN basefind_cached_bulk_update.main_ope_code IS NULL + THEN + CASE + WHEN basefind_cached_bulk_update.year + IS NOT NULL AND basefind_cached_bulk_update.ope_code - IS NOT NULL - WHEN TRUE THEN - '{ope_prefix}' || - basefind_cached_bulk_update.year || - '-' || - basefind_cached_bulk_update.ope_code - ELSE '' - END - ELSE - '{main_ope_prefix}' || - basefind_cached_bulk_update.main_ope_code + IS NOT NULL + THEN + '{ope_prefix}' || + basefind_cached_bulk_update.year || + '-' || + basefind_cached_bulk_update.ope_code + ELSE '' END + ELSE + '{main_ope_prefix}' || + basefind_cached_bulk_update.main_ope_code + END || '{join}' || COALESCE( @@ -901,23 +905,25 @@ class Find(BaseHistorizedItem, ImageModel, OwnPerms, ShortMenuItem): sql = """ UPDATE "archaeological_finds_find" AS f SET cached_label = - CASE find_cached_bulk_update.main_ope_code - WHEN NULL THEN - CASE find_cached_bulk_update.year - IS NOT NULL + CASE + WHEN find_cached_bulk_update.main_ope_code is NULL + THEN + CASE + WHEN find_cached_bulk_update.year + IS NOT NULL AND find_cached_bulk_update.ope_code - IS NOT NULL - WHEN TRUE THEN - '{ope_prefix}' || - find_cached_bulk_update.year || - '-' || - find_cached_bulk_update.ope_code - ELSE '' - END - ELSE - '{main_ope_prefix}' || - find_cached_bulk_update.main_ope_code + IS NOT NULL + THEN + '{ope_prefix}' || + find_cached_bulk_update.year || + '-' || + find_cached_bulk_update.ope_code + ELSE '' END + ELSE + '{main_ope_prefix}' || + find_cached_bulk_update.main_ope_code + END || '-' || to_char(find_cached_bulk_update.index, 'fm{zeros}') || '{join}' || |