From d0d146cc099bfe2d58a8c8ec6e57096661d1fdcb Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Mon, 13 Nov 2023 18:55:30 +0100 Subject: ⚡️ improve parcel post-treatments - add timestamp to prevent multiple geo and cached_label edition MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- archaeological_context_records/models.py | 20 -------------------- 1 file changed, 20 deletions(-) (limited to 'archaeological_context_records/models.py') diff --git a/archaeological_context_records/models.py b/archaeological_context_records/models.py index 985390861..2f9737c14 100644 --- a/archaeological_context_records/models.py +++ b/archaeological_context_records/models.py @@ -378,26 +378,6 @@ post_save.connect(post_save_cache, sender=DocumentationType) post_delete.connect(post_save_cache, sender=DocumentationType) -class CRBulkView(object): - CREATE_SQL = """ - CREATE VIEW context_records_cached_label_bulk_update - AS ( - SELECT cr.id AS id, ope.code_patriarche AS main_code, - ope.year AS year, - ope.operation_code AS ope_code, - parcel.section AS section, - parcel.parcel_number AS number, cr.label AS label - FROM archaeological_context_records_contextrecord AS cr - INNER JOIN archaeological_operations_operation ope - ON ope.id = cr.operation_id - INNER JOIN archaeological_operations_parcel parcel - ON cr.parcel_id = parcel.id - );""" - DELETE_SQL = """ - DROP VIEW IF EXISTS context_records_cached_label_bulk_update; - """ - - class GeographicSubTownItem(GeoItem): UPPER_GEO = [] -- cgit v1.2.3