Function prodTemplateReviewConfigForPostgreSQL

backend/tests/sql_review_test.go:544–794

()

}

func prodTemplateReviewConfigForPostgreSQL() *v1pb.ReviewConfig {
	config := &v1pb.ReviewConfig{
		Name:    common.FormatReviewConfig(generateRandomString("review")),
		Title:   "Prod",
		Enabled: true,
		Rules: []*v1pb.SQLReviewRule{
			// Naming
			{
				Type:   v1pb.SQLReviewRule_NAMING_TABLE,
				Level:  v1pb.SQLReviewRule_WARNING,
				Engine: v1pb.Engine_POSTGRES,
				Payload: &v1pb.SQLReviewRule_NamingPayload{
					NamingPayload: &v1pb.SQLReviewRule_NamingRulePayload{
						Format:    "^[a-z]+(_[a-z]+)*$",
						MaxLength: 64,
					},
				},
			},
			{
				Type:   v1pb.SQLReviewRule_NAMING_COLUMN,
				Level:  v1pb.SQLReviewRule_WARNING,
				Engine: v1pb.Engine_POSTGRES,
				Payload: &v1pb.SQLReviewRule_NamingPayload{
					NamingPayload: &v1pb.SQLReviewRule_NamingRulePayload{
						Format:    "^[a-z]+(_[a-z]+)*$",
						MaxLength: 64,
					},
				},
			},
			{
				Type:   v1pb.SQLReviewRule_NAMING_INDEX_IDX,
				Level:  v1pb.SQLReviewRule_WARNING,
				Engine: v1pb.Engine_POSTGRES,
				Payload: &v1pb.SQLReviewRule_NamingPayload{
					NamingPayload: &v1pb.SQLReviewRule_NamingRulePayload{
						Format:    "^$|^idx_{{table}}_{{column_list}}$",
						MaxLength: 64,
					},
				},
			},
			{
				Type:   v1pb.SQLReviewRule_NAMING_INDEX_PK,
				Level:  v1pb.SQLReviewRule_WARNING,
				Engine: v1pb.Engine_POSTGRES,
				Payload: &v1pb.SQLReviewRule_NamingPayload{
					NamingPayload: &v1pb.SQLReviewRule_NamingRulePayload{
						Format:    "^$|^pk_{{table}}_{{column_list}}$",
						MaxLength: 64,
					},
				},
			},
			{
				Type:   v1pb.SQLReviewRule_NAMING_INDEX_UK,
				Level:  v1pb.SQLReviewRule_WARNING,
				Engine: v1pb.Engine_POSTGRES,
				Payload: &v1pb.SQLReviewRule_NamingPayload{
					NamingPayload: &v1pb.SQLReviewRule_NamingRulePayload{
						Format:    "^$|^uk_{{table}}_{{column_list}}$",