/
ocp_migrations.go
51 lines (48 loc) · 1.98 KB
/
ocp_migrations.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
package ocpmigrations
import "github.com/RedHatInsights/insights-results-aggregator/migration"
const (
ruleErrorKeyTable = "rule_error_key"
clusterRuleUserFeedbackTable = "cluster_rule_user_feedback"
clusterReportTable = "report"
clusterRuleToggleTable = "cluster_rule_toggle"
clusterUserRuleDisableFeedbackTable = "cluster_user_rule_disable_feedback"
alterTableDropColumnQuery = "ALTER TABLE %v DROP COLUMN IF EXISTS %v"
alterTableAddVarcharColumn = "ALTER TABLE %v ADD COLUMN %v VARCHAR NOT NULL DEFAULT '-1'"
alterTableDropPK = "ALTER TABLE %v DROP CONSTRAINT IF EXISTS %v_pkey"
alterTableAddPK = "ALTER TABLE %v ADD CONSTRAINT %v_pkey PRIMARY KEY %v"
userIDColumn = "user_id"
)
// UsableOCPMigrations contains all OCP recommendation related migrations
var UsableOCPMigrations = []migration.Migration{
mig0001CreateReport,
mig0002CreateRuleContent,
mig0003CreateClusterRuleUserFeedback,
mig0004ModifyClusterRuleUserFeedback,
mig0005CreateConsumerError,
mig0006AddOnDeleteCascade,
mig0007CreateClusterRuleToggle,
mig0008AddOffsetFieldToReportTable,
mig0009AddIndexOnReportKafkaOffset,
mig0010AddTagsFieldToRuleErrorKeyTable,
mig0011RemoveFKAndContentTables,
mig0012CreateClusterUserRuleDisableFeedback,
mig0013AddRuleHitTable,
mig0014ModifyClusterRuleToggle,
mig0015ModifyFeedbackTables,
mig0016AddRecommendationsTable,
mig0017AddSystemWideRuleDisableTable,
mig0018AddRatingsTable,
mig0019ModifyRecommendationTable,
mig0020ModifyAdvisorRatingsTable,
mig0021AddGatheredAtToReport,
mig0022CleanupEnableDisableTables,
mig0023AddReportInfoTable,
mig0024AddTimestampToRuleHit,
mig0025AddImpactedToRecommendation,
mig0026AddAndPopulateOrgIDColumns,
mig0027CleanupInvalidRowsMissingOrgID,
mig0028AlterRuleDisablePKAndIndex,
mig0029DropClusterRuleToggleUserIDColumn,
mig0030DropRuleDisableUserIDColumn,
mig0031AlterConstraintDropUserAdvisorRatings,
}