Coverage for migrations / 0018_remove_formcomponents_order_on_insert_option_and_more.py: 0%

1# Generated by Django 4.2.5 on 2023-10-01 05:35 

2 

3import pgtrigger.compiler 

4import pgtrigger.migrations 

5from django.db import migrations, models 

6 

7 

8class Migration(migrations.Migration): 

9 dependencies = [ 

10 ("formkit_ninja", "0017_nodechildren_change_id"), 

11 ] 

12 

13 operations = [ 

14 pgtrigger.migrations.RemoveTrigger( 

15 model_name="formcomponents", 

16 name="order_on_insert_option", 

17 ), 

18 pgtrigger.migrations.RemoveTrigger( 

19 model_name="formcomponents", 

20 name="order_on_update_option", 

21 ), 

22 pgtrigger.migrations.RemoveTrigger( 

23 model_name="nodechildren", 

24 name="order_on_update_option", 

25 ), 

26 pgtrigger.migrations.RemoveTrigger( 

27 model_name="option", 

28 name="order_on_update_option", 

29 ), 

30 migrations.AddField( 

31 model_name="nodechildren", 

32 name="track_change", 

33 field=models.BigIntegerField(blank=True, null=True), 

34 ), 

35 pgtrigger.migrations.AddTrigger( 

36 model_name="formcomponents", 

37 trigger=pgtrigger.compiler.Trigger( 

38 name="order_on_insert_option", 

39 sql=pgtrigger.compiler.UpsertTriggerSql( 

40 func='NEW."order" = (SELECT coalesce(max("order"), 0) + 1 FROM formkit_ninja_formcomponents WHERE formkit_ninja_formcomponents."schema_id" = NEW."schema_id"); RETURN NEW;', 

41 hash="77d4e855615a2d36545c807726d62f4bcd4c88c2", 

42 operation="INSERT", 

43 pgid="pgtrigger_order_on_insert_option_1fbd2", 

44 table="formkit_ninja_formcomponents", 

45 when="BEFORE", 

46 ), 

47 ), 

48 ), 

49 pgtrigger.migrations.AddTrigger( 

50 model_name="formcomponents", 

51 trigger=pgtrigger.compiler.Trigger( 

52 name="order_on_update_option", 

53 sql=pgtrigger.compiler.UpsertTriggerSql( 

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

55 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" = OLD."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" = OLD."schema_id"\n and "id" <> NEW."id";\n end if;\n RETURN NEW;\n ', 

56 hash="73f3c187b4413f399667c968c68f1964681f4b70", 

57 operation="UPDATE", 

58 pgid="pgtrigger_order_on_update_option_a5326", 

59 table="formkit_ninja_formcomponents", 

60 when="AFTER", 

61 ), 

62 ), 

63 ), 

64 pgtrigger.migrations.AddTrigger( 

65 model_name="nodechildren", 

66 trigger=pgtrigger.compiler.Trigger( 

67 name="order_on_update_option", 

68 sql=pgtrigger.compiler.UpsertTriggerSql( 

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

70 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" = OLD."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" = OLD."parent_id"\n and "id" <> NEW."id";\n end if;\n RETURN NEW;\n ', 

71 hash="1e4478cd11d7361fe36817fdc7d0bc79a06f43ee", 

72 operation="UPDATE", 

73 pgid="pgtrigger_order_on_update_option_44228", 

74 table="formkit_ninja_nodechildren", 

75 when="AFTER", 

76 ), 

77 ), 

78 ), 

79 pgtrigger.migrations.AddTrigger( 

80 model_name="nodechildren", 

81 trigger=pgtrigger.compiler.Trigger( 

82 name="version_on_update", 

83 sql=pgtrigger.compiler.UpsertTriggerSql( 

84 func="NEW.\"track_change\" = nextval('nodechildren_change_id'); RETURN NEW;", 

85 hash="555bcf98d37b335497f307dd7bbb258fae562109", 

86 operation="UPDATE OR INSERT", 

87 pgid="pgtrigger_version_on_update_9c530", 

88 table="formkit_ninja_nodechildren", 

89 when="BEFORE", 

90 ), 

91 ), 

92 ), 

93 pgtrigger.migrations.AddTrigger( 

94 model_name="option", 

95 trigger=pgtrigger.compiler.Trigger( 

96 name="order_on_update_option", 

97 sql=pgtrigger.compiler.UpsertTriggerSql( 

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

99 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" = OLD."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" = OLD."group_id"\n and "id" <> NEW."id";\n end if;\n RETURN NEW;\n ', 

100 hash="9c254236d010611cd7d5a2bb01b971e1015781ca", 

101 operation="UPDATE", 

102 pgid="pgtrigger_order_on_update_option_417cb", 

103 table="formkit_ninja_option", 

104 when="AFTER", 

105 ), 

106 ), 

107 ), 

108 ]