mig_0005_create_read_errors_table.go

Copyright 2023 Red Hat, Inc

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

 http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

 
package
 
main

Definition of up and down steps for migration #0005

Generated documentation is available at: https://pkg.go.dev/github.com/RedHatInsights/ccx-notification-writer/

Documentation in literate-programming-style is available at: https://redhatinsights.github.io/ccx-notification-writer/packages/mig0005createreaderrors_table.html

 


import
 
(

	
"database/sql"


	
mig
 
"github.com/RedHatInsights/insights-operator-utils/migrations"

	
types
 
"github.com/RedHatInsights/insights-results-types"

	
"github.com/rs/zerolog/log"


)

mig0001CreateEventTargetsTbl migration creates table named event_targets. This table contains all event receivers, for example Notification Backend and ServiceLog

 
var
 
mig0005CreateReadErrorsTable
 
=
 
mig
.
Migration
{

up step: migrate database to version #0005

 
	
StepUp
:
 
func
(
tx
 
*
sql
.
Tx
,
 
_
 
types
.
DBDriver
)
 
error
 
{

		
log
.
Debug
(
)
.
Msg
(
"Executing mig0005CreateReadErrorsTable stepUp function"
)

		
query
 
:=
 
`
			CREATE TABLE IF NOT EXISTS read_errors (
			    error_id    serial primary key,
			    org_id      integer not null,
			    cluster     character(36) not null,
			    updated_at  timestamp not null,
			    error_text  varchar(1000) not null,
			    created_at  timestamp not null,
			    FOREIGN KEY(org_id, cluster, updated_at)
			    REFERENCES new_reports(org_id, cluster, updated_at),
			    UNIQUE(error_id, org_id, cluster, updated_at)
			)`

		
_
,
 
err
 
:=
 
executeQuery
(
tx
,
 
query
)

		
if
 
err
 
==
 
nil
 
{

			
log
.
Debug
(
)
.
Msg
(
"Table read_errors created successfully"
)

		
}

		
return
 
err

	
}
,

up down: migrate database to version #0004

 
	
StepDown
:
 
func
(
tx
 
*
sql
.
Tx
,
 
_
 
types
.
DBDriver
)
 
error
 
{

		
log
.
Debug
(
)
.
Msg
(
"Executing mig0005CreateReadErrorsTable stepDown function"
)

		
query
 
:=
 
"DROP TABLE read_errors"

		
_
,
 
err
 
:=
 
executeQuery
(
tx
,
 
query
)

		
if
 
err
 
==
 
nil
 
{

			
log
.
Debug
(
)
.
Msg
(
"Table read_errors dropped successfully"
)

		
}

		
return
 
err

	
}
,


}