db

var PostgresFunctions = []PostgresFunction{
	{
		Name:       "job_results",
		Definition: jobResultFunction,
	},
	{
		Name:       "test_results",
		Definition: testResultFunction,
	},
}

var PostgresMatViews = []PostgresView{
	{
		Name:         "prow_test_report_7d_matview",
		Definition:   testReportMatView,
		IndexColumns: []string{"id", "name", "release", "variants", "suite_name"},
		ReplaceStrings: map[string]string{
			"|||START|||":    "|||TIMENOW||| - INTERVAL '14 DAY'",
			"|||BOUNDARY|||": "|||TIMENOW||| - INTERVAL '7 DAY'",
			"|||END|||":      "|||TIMENOW|||",
		},
	},
	{
		Name:         "prow_test_report_2d_matview",
		Definition:   testReportMatView,
		IndexColumns: []string{"id", "name", "release", "variants", "suite_name"},
		ReplaceStrings: map[string]string{
			"|||START|||":    "|||TIMENOW||| - INTERVAL '9 DAY'",
			"|||BOUNDARY|||": "|||TIMENOW||| - INTERVAL '2 DAY'",
			"|||END|||":      "|||TIMENOW|||",
		},
	},
	{
		Name:         "prow_job_runs_report_matview",
		Definition:   jobRunsReportMatView,
		IndexColumns: []string{"id"},
	},
	{
		Name:         "prow_job_failed_tests_by_day_matview",
		Definition:   prowJobFailedTestsMatView,
		IndexColumns: []string{"period", "prow_job_id", "test_name"},
		ReplaceStrings: map[string]string{
			"|||BY|||": "day",
		},
	},
	{
		Name:         "prow_job_failed_tests_by_hour_matview",
		Definition:   prowJobFailedTestsMatView,
		IndexColumns: []string{"period", "prow_job_id", "test_name"},
		ReplaceStrings: map[string]string{
			"|||BY|||": "hour",
		},
	},
	{

		Name:           "payload_test_failures_14d_matview",
		Definition:     payloadTestFailuresMatView,
		IndexColumns:   []string{"release", "architecture", "stream", "prow_job_run_id", "test_id", "suite_id"},
		ReplaceStrings: map[string]string{},
	},
}

var PostgresPartitionedTables = []PostgresView{
	{
		Name:       "test_analysis_by_job_by_dates",
		Definition: testAnalysisByJobByDatesTable,
	},
}

var PostgresViews = []PostgresView{
	{
		Name:       "prow_test_analysis_by_variant_14d_view",
		Definition: testAnalysisByVariantView,
	},
}