Projet

Général

Profil

0002-to-fixup-rename-sql-snippets.patch

Benjamin Dauvergne, 08 juin 2021 15:17

Télécharger (1,52 ko)

Voir les différences: 

Subject: [PATCH 2/9] to fixup: rename sql snippets


 chrono/agendas/migrations/0088_lease.py | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)
chrono/agendas/migrations/0088_lease.py
3 3 
import django.db.models.deletion
4 4 
from django.db import migrations, models
5 5 

  		




  6
  
  
    
sql_forwards = """

  		




  
  6
  
    
create_gist_constraints_on_leases = """

  		




  7
  7
  
    
ALTER TABLE agendas_lease

  		




  8
  8
  
    
ADD CONSTRAINT lease_desk_constraint

  		




  9
  9
  
    
EXCLUDE USING GIST(desk_id WITH =, tstzrange(start_datetime, end_datetime) WITH &&)

  		




  ......




  14
  14
  
    
    WHERE (resource_id IS NOT NULL);

  		




  15
  15
  
    
"""

  		




  16
  16
  
    

  		




  17
  
  
    
sql_backwards = """

  		




  
  17
  
    
drop_gist_constraints_on_leases = """

  		




  18
  18
  
    
ALTER TABLE agendas_lease DROP CONSTRAINT lease_desk_constraint;

  		




  19
  19
  
    
ALTER TABLE agendas_lease DROP CONSTRAINT lease_resource_constraint;

  		




  20
  20
  
    
"""

  		




  ......




  60
  60
  
    
                'index_together': {('start_datetime', 'end_datetime')},

  		




  61
  61
  
    
            },

  		




  62
  62
  
    
        ),

  		




  63
  
  
    
        migrations.RunSQL(sql=sql_forwards, reverse_sql=sql_backwards),

  		




  
  63
  
    
        migrations.RunSQL(sql=create_gist_constraints_on_leases, reverse_sql=drop_gist_constraints_on_leases),

  		




  64
  64
  
    
    ]

  		




  65
  
  
    
-