v1alpha1

type Database struct {
	// username for connecting to database
	// +kubebuilder:validation:Required
	Username string `json:"username"`

	// reference to a secret containing the password for connecting to database
	// +kubebuilder:validation:Required
	Credentials v1.SecretKeySelector `json:"credentials"`

	// the jdbcUrl to connect to database
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:Pattern=`^jdbc:.*`
	JdbcUrl string `json:"jdbcUrl"`
}

type FlywayConfiguration struct {
	// Reference to the flyway image to use.
	// +kubebuilder:validation:Optional
	FlywayImage string `json:"flywayImage"`

	// The flyway actions to apply, like "info", "migrate"
	// See https://documentation.red-gate.com/fd/commands-184127446.html
	// +kubebuilder:default={"info", "migrate", "info"}
	Commands []string `json:"commands"`

	// The default flyway schema to use.
	// See https://documentation.red-gate.com/fd/default-schema-184127496.html
	// +kubebuilder:validation:Optional
	DefaultSchema *string `json:"defaultSchema"`

	// Base-line on migrate.
	// See https://documentation.red-gate.com/fd/baseline-on-migrate-224919695.html
	// +kubebuilder:validation:Optional
	BaselineOnMigrate *bool `json:"baselineOnMigrate"`

	// Arbitrary entries to set as env-vars to Flyway migration job.
	// +kubebuilder:validation:Optional
	EnvVars []v1.EnvVar `json:"envVars"`

	// jdbcProperties to pass to the execution.
	// See https://documentation.red-gate.com/fd/environment-jdbc-properties-namespace-277578928.html
	// +kubebuilder:validation:Optional
	JdbcProperties map[string]string `json:"jdbcProperties,omitempty"`

	// Volumes to make available to the migration job.
	// +kubebuilder:validation:Optional
	Volumes []v1.Volume `json:"volumes,omitempty"`

	// Volume mounts to mount into the migration job.
	// +kubebuilder:validation:Optional
	VolumeMounts []v1.VolumeMount `json:"volumeMounts,omitempty"`
}

type Migration struct {
	metav1.TypeMeta   `json:",inline"`
	metav1.ObjectMeta `json:"metadata,omitempty"`

	// +kubebuilder:validation:Required
	Spec   MigrationSpec   `json:"spec,omitempty"`
	Status MigrationStatus `json:"status,omitempty"`
}

type MigrationList struct {
	metav1.TypeMeta `json:",inline"`
	metav1.ListMeta `json:"metadata,omitempty"`
	Items           []Migration `json:"items"`
}

type MigrationSource struct {

	// Reference to the image holding the SQLs to migrate
	// +kubebuilder:validation:Required
	ImageRef string `json:"imageRef"`

	// Optional. Image-pull secret to pull the migration source
	// +kubebuilder:validation:Optional
	ImagePullSecrets []v1.LocalObjectReference `json:"ImagePullSecret"`

	// Path within the image to the SQLs for flyway
	// +kubebuilder:default="/sql"
	SqlPath string `json:"path"`

	// The encoding of the SQL-files.
	// +kubebuilder:default="UTF-8"
	Encoding string `json:"encoding"`

	// Flyway placeholders, see: https://documentation.red-gate.com/fd/placeholders-configuration-184127475.html
	// These will be injected as env-vars with the required prefix.
	// +kubebuilder:validation:Optional
	Placeholders map[string]string `json:"placeholders"`
}

type MigrationSpec struct {
	// settings for database connection
	// +kubebuilder:validation:Required
	Database Database `json:"database"`

	// settings for flyway
	FlywayConfiguration FlywayConfiguration `json:"flywayConfiguration"`

	// settings defining the SQL migrations
	// +kubebuilder:validation:Required
	MigrationSource MigrationSource `json:"migrationSource"`
}

type MigrationStatus struct {
	// +patchMergeKey=type
	// +patchStrategy=merge
	// +listType=map
	// +listMapKey=type
	Conditions []metav1.Condition `json:"conditions,omitempty" patchStrategy:"merge" patchMergeKey:"type"`
}