/
1631261634964_enforce_uniqueness.go
103 lines (98 loc) · 4.34 KB
/
1631261634964_enforce_uniqueness.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
package migrations
import "reflect"
type EnforceUniqueness1631261634964 struct {
r Registry
}
func (m *EnforceUniqueness1631261634964) GetName() string {
return reflect.Indirect(reflect.ValueOf(m)).Type().Name()
}
func (m *EnforceUniqueness1631261634964) Up() error {
if err := m.r.Context().Exec(`DROP INDEX "IDX_e08af711f3493df1e921c4c9ef"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_77c4073c30ea7793f484750529"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_0683952543d7d3f4fffc427034"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_410649600ce31c10c4b667ca10"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_5248fda27b9f16ef818604bb6f"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_832f86daf8103491d634a967da"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_ae3e22c67d7c7a969a363533c0"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_6f234f058bbbea810dce1d04d0" ON "product_collection" ("handle") WHERE deleted_at IS NULL`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_cf9cc6c3f2e6414b992223fff1" ON "product" ("handle") WHERE deleted_at IS NULL`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_2ca8cfbdafb998ecfd6d340389" ON "product_variant" ("sku") WHERE deleted_at IS NULL`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_045d4a149c09f4704e0bc08dd4" ON "product_variant" ("barcode") WHERE deleted_at IS NULL`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_b5b6225539ee8501082fbc0714" ON "product_variant" ("ean") WHERE deleted_at IS NULL`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_aa16f61348be02dd07ce3fc54e" ON "product_variant" ("upc") WHERE deleted_at IS NULL`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_f65bf52e2239ace276ece2b2f4" ON "discount" ("code") WHERE deleted_at IS NULL`).Error; err != nil {
return err
}
return nil
}
func (m *EnforceUniqueness1631261634964) Down() error {
if err := m.r.Context().Exec(`DROP INDEX "IDX_f65bf52e2239ace276ece2b2f4"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_aa16f61348be02dd07ce3fc54e"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_b5b6225539ee8501082fbc0714"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_045d4a149c09f4704e0bc08dd4"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_2ca8cfbdafb998ecfd6d340389"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_cf9cc6c3f2e6414b992223fff1"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`DROP INDEX "IDX_6f234f058bbbea810dce1d04d0"`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_ae3e22c67d7c7a969a363533c0" ON "discount" ("code") WHERE (deleted_at IS NOT NULL)`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_832f86daf8103491d634a967da" ON "product_variant" ("upc") WHERE (deleted_at IS NOT NULL)`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_5248fda27b9f16ef818604bb6f" ON "product_variant" ("ean") WHERE (deleted_at IS NOT NULL)`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_410649600ce31c10c4b667ca10" ON "product_variant" ("barcode") WHERE (deleted_at IS NOT NULL)`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_0683952543d7d3f4fffc427034" ON "product_variant" ("sku") WHERE (deleted_at IS NOT NULL)`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_77c4073c30ea7793f484750529" ON "product" ("handle") WHERE (deleted_at IS NOT NULL)`).Error; err != nil {
return err
}
if err := m.r.Context().Exec(`CREATE UNIQUE INDEX "IDX_e08af711f3493df1e921c4c9ef" ON "product_collection" ("handle") WHERE (deleted_at IS NOT NULL)`).Error; err != nil {
return err
}
return nil
}