Coverage for migrations / 0016_alter_nodechildren_options_and_more.py: 0%

1# Generated by Django 4.2.5 on 2023-09-10 16:44 

2 

3import pgtrigger.compiler 

4import pgtrigger.migrations 

5from django.db import migrations, models 

6 

7 

8class Migration(migrations.Migration): 

9 dependencies = [ 

10 ("formkit_ninja", "0015_alter_formkitschema_label"), 

11 ] 

12 

13 operations = [ 

14 migrations.AlterModelOptions( 

15 name="nodechildren", 

16 options={"ordering": ("parent_id", "order")}, 

17 ), 

18 migrations.AlterField( 

19 model_name="formcomponents", 

20 name="order", 

21 field=models.IntegerField(blank=True, null=True), 

22 ), 

23 migrations.AlterField( 

24 model_name="nodechildren", 

25 name="order", 

26 field=models.IntegerField(blank=True, null=True), 

27 ), 

28 migrations.AlterField( 

29 model_name="option", 

30 name="order", 

31 field=models.IntegerField(blank=True, null=True), 

32 ), 

33 pgtrigger.migrations.AddTrigger( 

34 model_name="formcomponents", 

35 trigger=pgtrigger.compiler.Trigger( 

36 name="order_on_insert_option", 

37 sql=pgtrigger.compiler.UpsertTriggerSql( 

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

39 hash="32de6ecbd50ae312fcc482cdba82ce45e9b76908", 

40 operation="INSERT", 

41 pgid="pgtrigger_order_on_insert_option_1fbd2", 

42 table="formkit_ninja_formcomponents", 

43 when="BEFORE", 

44 ), 

45 ), 

46 ), 

47 pgtrigger.migrations.AddTrigger( 

48 model_name="formcomponents", 

49 trigger=pgtrigger.compiler.Trigger( 

50 name="order_on_update_option", 

51 sql=pgtrigger.compiler.UpsertTriggerSql( 

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

53 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 ', 

54 hash="e87c38bfcb4fa1b13b8f6f2aa5cb186fe831c8a3", 

55 operation="UPDATE", 

56 pgid="pgtrigger_order_on_update_option_a5326", 

57 table="formkit_ninja_formcomponents", 

58 when="AFTER", 

59 ), 

60 ), 

61 ), 

62 pgtrigger.migrations.AddTrigger( 

63 model_name="nodechildren", 

64 trigger=pgtrigger.compiler.Trigger( 

65 name="order_on_insert_option", 

66 sql=pgtrigger.compiler.UpsertTriggerSql( 

67 func='NEW."order" = (SELECT coalesce(max("order"), 0) + 1 FROM formkit_ninja_nodechildren WHERE formkit_ninja_nodechildren."parent_id" = NEW."parent_id"); RETURN NEW;', 

68 hash="c66dfe1401c425e23a30d21ed7cd257cfc02b5b5", 

69 operation="INSERT", 

70 pgid="pgtrigger_order_on_insert_option_1816c", 

71 table="formkit_ninja_nodechildren", 

72 when="BEFORE", 

73 ), 

74 ), 

75 ), 

76 pgtrigger.migrations.AddTrigger( 

77 model_name="nodechildren", 

78 trigger=pgtrigger.compiler.Trigger( 

79 name="order_on_update_option", 

80 sql=pgtrigger.compiler.UpsertTriggerSql( 

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

82 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 ', 

83 hash="a421dc6da53fa50d3226e4bb4802866879344941", 

84 operation="UPDATE", 

85 pgid="pgtrigger_order_on_update_option_44228", 

86 table="formkit_ninja_nodechildren", 

87 when="AFTER", 

88 ), 

89 ), 

90 ), 

91 pgtrigger.migrations.AddTrigger( 

92 model_name="option", 

93 trigger=pgtrigger.compiler.Trigger( 

94 name="order_on_insert_option", 

95 sql=pgtrigger.compiler.UpsertTriggerSql( 

96 func='NEW."order" = (SELECT coalesce(max("order"), 0) + 1 FROM formkit_ninja_option WHERE formkit_ninja_option."group_id" = NEW."group_id"); RETURN NEW;', 

97 hash="eff471a7791c174bd5c48d6ebb6baad36aa108d9", 

98 operation="INSERT", 

99 pgid="pgtrigger_order_on_insert_option_e1443", 

100 table="formkit_ninja_option", 

101 when="BEFORE", 

102 ), 

103 ), 

104 ), 

105 pgtrigger.migrations.AddTrigger( 

106 model_name="option", 

107 trigger=pgtrigger.compiler.Trigger( 

108 name="order_on_update_option", 

109 sql=pgtrigger.compiler.UpsertTriggerSql( 

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

111 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 ', 

112 hash="ea7dde4b2c32fe380c79eaf105621171c396fa71", 

113 operation="UPDATE", 

114 pgid="pgtrigger_order_on_update_option_417cb", 

115 table="formkit_ninja_option", 

116 when="AFTER", 

117 ), 

118 ), 

119 ), 

120 ]