Coverage for migrations / 0020_remove_formcomponents_order_on_update_option_and_more.py: 0%

1# Generated by Django 4.2.5 on 2023-10-03 00:08 

2 

3import pgtrigger.compiler 

4import pgtrigger.migrations 

5from django.db import migrations 

6 

7 

8class Migration(migrations.Migration): 

9 dependencies = [ 

10 ("formkit_ninja", "0019_formkitschemanode_track_change_and_more"), 

11 ] 

12 

13 operations = [ 

14 pgtrigger.migrations.RemoveTrigger( 

15 model_name="formcomponents", 

16 name="order_on_update_option", 

17 ), 

18 pgtrigger.migrations.RemoveTrigger( 

19 model_name="nodechildren", 

20 name="order_on_update_option", 

21 ), 

22 pgtrigger.migrations.RemoveTrigger( 

23 model_name="option", 

24 name="order_on_update_option", 

25 ), 

26 pgtrigger.migrations.AddTrigger( 

27 model_name="formcomponents", 

28 trigger=pgtrigger.compiler.Trigger( 

29 name="order_on_update_option", 

30 sql=pgtrigger.compiler.UpsertTriggerSql( 

31 condition="WHEN (pg_trigger_depth() = 0)", 

32 func='\n -- Do not allow a "null" value\n -- This stops Django from dumbly updating\n -- which can break the trigger\n if NEW."order" IS NULL then\n NEW."order" = OLD."order";\n end if;\n if NEW."order" > OLD."order" then\n update formkit_ninja_formcomponents\n set "order" = "order"- 1\n where "order" <= NEW."order"\n and "order" > OLD."order"\n and "schema_id" = NEW."schema_id"\n and "id" <> NEW."id";\n else\n update formkit_ninja_formcomponents\n set "order" = "order"+ 1\n where "order" >= NEW."order"\n and "order" < OLD."order"\n and "schema_id" = NEW."schema_id"\n and "id" <> NEW."id";\n end if;\n RETURN NEW;\n ', 

33 hash="432443481a60d58c40ceb3204bda0e3ad58ce9aa", 

34 operation="UPDATE", 

35 pgid="pgtrigger_order_on_update_option_a5326", 

36 table="formkit_ninja_formcomponents", 

37 when="AFTER", 

38 ), 

39 ), 

40 ), 

41 pgtrigger.migrations.AddTrigger( 

42 model_name="nodechildren", 

43 trigger=pgtrigger.compiler.Trigger( 

44 name="order_on_update_option", 

45 sql=pgtrigger.compiler.UpsertTriggerSql( 

46 condition="WHEN (pg_trigger_depth() = 0)", 

47 func='\n -- Do not allow a "null" value\n -- This stops Django from dumbly updating\n -- which can break the trigger\n if NEW."order" IS NULL then\n NEW."order" = OLD."order";\n end if;\n if NEW."order" > OLD."order" then\n update formkit_ninja_nodechildren\n set "order" = "order"- 1\n where "order" <= NEW."order"\n and "order" > OLD."order"\n and "parent_id" = NEW."parent_id"\n and "id" <> NEW."id";\n else\n update formkit_ninja_nodechildren\n set "order" = "order"+ 1\n where "order" >= NEW."order"\n and "order" < OLD."order"\n and "parent_id" = NEW."parent_id"\n and "id" <> NEW."id";\n end if;\n RETURN NEW;\n ', 

48 hash="f8eaa7c49b5c81e7b0fa3830557746f40e2498bd", 

49 operation="UPDATE", 

50 pgid="pgtrigger_order_on_update_option_44228", 

51 table="formkit_ninja_nodechildren", 

52 when="AFTER", 

53 ), 

54 ), 

55 ), 

56 pgtrigger.migrations.AddTrigger( 

57 model_name="option", 

58 trigger=pgtrigger.compiler.Trigger( 

59 name="order_on_update_option", 

60 sql=pgtrigger.compiler.UpsertTriggerSql( 

61 condition="WHEN (pg_trigger_depth() = 0)", 

62 func='\n -- Do not allow a "null" value\n -- This stops Django from dumbly updating\n -- which can break the trigger\n if NEW."order" IS NULL then\n NEW."order" = OLD."order";\n end if;\n if NEW."order" > OLD."order" then\n update formkit_ninja_option\n set "order" = "order"- 1\n where "order" <= NEW."order"\n and "order" > OLD."order"\n and "group_id" = NEW."group_id"\n and "id" <> NEW."id";\n else\n update formkit_ninja_option\n set "order" = "order"+ 1\n where "order" >= NEW."order"\n and "order" < OLD."order"\n and "group_id" = NEW."group_id"\n and "id" <> NEW."id";\n end if;\n RETURN NEW;\n ', 

63 hash="3f44c5db88a1344000e61868009e4b424d7c29ef", 

64 operation="UPDATE", 

65 pgid="pgtrigger_order_on_update_option_417cb", 

66 table="formkit_ninja_option", 

67 when="AFTER", 

68 ), 

69 ), 

70 ), 

71 ]