v1alpha1

type ConnectionTypesSpecEnum string

type DatabaseModulesList struct {
	// Modules list
	// +optional
	// +listType=set
	List []string `json:"list,omitempty"`
	// Should drop on delete ?
	// +optional
	DropOnOnDelete bool `json:"dropOnDelete,omitempty"`
	// Should drop with cascade ?
	// +optional
	DeleteWithCascade bool `json:"deleteWithCascade,omitempty"`
}

type DatabaseStatusPhase string

type EngineStatusPhase string

type GenericUserConnection struct {
	// Hostname
	// +required
	// +kubebuilder:validation:Required
	Host string `json:"host"`
	// URI args like sslmode, ...
	URIArgs string `json:"uriArgs"`
	// Port
	Port int `json:"port,omitempty"`
}

type ModeEnum string

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

	Spec   PostgresqlDatabaseSpec   `json:"spec,omitempty"`
	Status PostgresqlDatabaseStatus `json:"status,omitempty"`
}

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

type PostgresqlDatabaseSpec struct {

	// Database name
	// +required
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:MinLength=1
	Database string `json:"database"`
	// Master role name will be used to create top group role.
	// Database owner and users will be in this group role.
	// +optional
	MasterRole string `json:"masterRole,omitempty"`
	// Should drop database on Custom Resource deletion ?
	// +optional
	DropOnDelete bool `json:"dropOnDelete,omitempty"`
	// Wait for linked resource to be deleted
	// +optional
	WaitLinkedResourcesDeletion bool `json:"waitLinkedResourcesDeletion,omitempty"`
	// Schema to create in database
	// +optional
	Schemas DatabaseModulesList `json:"schemas,omitempty"`
	// Extensions to enable
	// +optional
	Extensions DatabaseModulesList `json:"extensions,omitempty"`
	// Postgresql Engine Configuration link
	// +required
	// +kubebuilder:validation:Required
	EngineConfiguration *common.CRLink `json:"engineConfiguration"`
}

type PostgresqlDatabaseStatus struct {

	// Current phase of the operator
	Phase DatabaseStatusPhase `json:"phase"`
	// Human-readable message indicating details about current operator phase or error.
	// +optional
	Message string `json:"message"`
	// True if all resources are in a ready state and all work is done.
	// +optional
	Ready bool `json:"ready"`
	// Created database
	// +optional
	Database string `json:"database"`
	// Already created roles for database
	// +optional
	Roles StatusPostgresRoles `json:"roles"`
	// Already created schemas
	// +optional
	// +listType=set
	Schemas []string `json:"schemas,omitempty"`
	// Already extensions added
	// +optional
	// +listType=set
	Extensions []string `json:"extensions,omitempty"`
}

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

	Spec   PostgresqlEngineConfigurationSpec   `json:"spec,omitempty"`
	Status PostgresqlEngineConfigurationStatus `json:"status,omitempty"`
}

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

type PostgresqlEngineConfigurationSpec struct {

	// Provider
	// +kubebuilder:validation:Enum="";AWS;AZURE
	Provider ProviderType `json:"provider,omitempty"`
	// Hostname
	// +required
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:MinLength=1
	Host string `json:"host"`
	// Port
	Port int `json:"port,omitempty"`
	// URI args like sslmode, ...
	URIArgs string `json:"uriArgs,omitempty"`
	// Default database
	DefaultDatabase string `json:"defaultDatabase,omitempty"`
	// Duration between two checks for valid engine
	CheckInterval string `json:"checkInterval,omitempty"`
	// Allow grant admin on every created roles (group or user) for provided PGEC user in order to
	// have power to administrate those roles even with a less powered "admin" user.
	// Operator will create role and after grant PGEC provided user on those roles with admin option if enabled.
	AllowGrantAdminOption bool `json:"allowGrantAdminOption,omitempty"`
	// Wait for linked resource to be deleted
	WaitLinkedResourcesDeletion bool `json:"waitLinkedResourcesDeletion,omitempty"`
	// User and password secret
	// +required
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:MinLength=1
	SecretName string `json:"secretName"`
	// User connections used for secret generation
	// That will be used to generate secret with primary server as url or
	// to use the pg bouncer one.
	// Note: Operator won't check those values.
	// +optional
	UserConnections *UserConnections `json:"userConnections"`
}

type PostgresqlEngineConfigurationStatus struct {

	// Current phase of the operator
	Phase EngineStatusPhase `json:"phase"`
	// Human-readable message indicating details about current operator phase or error.
	// +optional
	Message string `json:"message"`
	// True if all resources are in a ready state and all work is done.
	// +optional
	Ready bool `json:"ready"`
	// Last validated time
	// +optional
	LastValidatedTime string `json:"lastValidatedTime"`
	// Resource Spec hash
	// +optional
	Hash string `json:"hash"`
}

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

	Spec   PostgresqlPublicationSpec   `json:"spec,omitempty"`
	Status PostgresqlPublicationStatus `json:"status,omitempty"`
}

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

type PostgresqlPublicationSpec struct {

	// Postgresql Database
	// +required
	// +kubebuilder:validation:Required
	Database *common.CRLink `json:"database"`
	// Postgresql Publication name
	// +required
	// +kubebuilder:validation:Required
	Name string `json:"name"`
	// Postgresql replication slot name
	// Default value will the publication name
	// +optional
	ReplicationSlotName string `json:"replicationSlotName,omitempty"`
	// Postgresql replication slot plugin
	// Default value will be "pgoutput"
	// +optional
	ReplicationSlotPlugin string `json:"replicationSlotPlugin,omitempty"`
	// Should drop database on Custom Resource deletion ?
	// +optional
	DropOnDelete bool `json:"dropOnDelete,omitempty"`
	// Publication for all tables
	// Note: This is mutually exclusive with "tablesInSchema" & "tables"
	// +optional
	AllTables bool `json:"allTables,omitempty"`
	// Publication for tables in schema
	// Note: This is a list of schema
	// +optional
	TablesInSchema []string `json:"tablesInSchema,omitempty"`
	// Publication for selected tables
	// +optional
	Tables []*PostgresqlPublicationTable `json:"tables,omitempty"`
	// Publication with parameters
	// +optional
	WithParameters *PostgresqlPublicationWith `json:"withParameters,omitempty"`
}

type PostgresqlPublicationStatus struct {

	// Current phase of the operator
	Phase PublicationStatusPhase `json:"phase"`
	// Human-readable message indicating details about current operator phase or error.
	// +optional
	Message string `json:"message"`
	// True if all resources are in a ready state and all work is done.
	// +optional
	Ready bool `json:"ready"`
	// Created publication name
	// +optional
	Name string `json:"name,omitempty"`
	// Created replication slot name
	// +optional
	ReplicationSlotName string `json:"replicationSlotName,omitempty"`
	// Created replication slot plugin
	// +optional
	ReplicationSlotPlugin string `json:"replicationSlotPlugin,omitempty"`
	// Marker for save
	// +optional
	AllTables *bool `json:"allTables,omitempty"`
	// Resource Spec hash
	// +optional
	Hash string `json:"hash,omitempty"`
}

type PostgresqlPublicationTable struct {
	// Table name to use for publication
	TableName string `json:"tableName"`
	// Columns to export
	Columns *[]string `json:"columns,omitempty"`
	// Additional WHERE for table
	AdditionalWhere *string `json:"additionalWhere,omitempty"`
}

type PostgresqlPublicationWith struct {
	// Publish param
	// See here: https://www.postgresql.org/docs/current/sql-createpublication.html#SQL-CREATEPUBLICATION-PARAMS-WITH-PUBLISH
	Publish string `json:"publish"`
	// Publish via partition root param
	// See here: https://www.postgresql.org/docs/current/sql-createpublication.html#SQL-CREATEPUBLICATION-PARAMS-WITH-PUBLISH
	PublishViaPartitionRoot *bool `json:"publishViaPartitionRoot,omitempty"`
}

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

	Spec   PostgresqlUserRoleSpec   `json:"spec,omitempty"`
	Status PostgresqlUserRoleStatus `json:"status,omitempty"`
}

type PostgresqlUserRoleAttributes struct {
	// REPLICATION attribute
	// Note: This can be either true, false or null (to ignore this parameter)
	Replication *bool `json:"replication,omitempty"`
	// BYPASSRLS attribute
	// Note: This can be either true, false or null (to ignore this parameter)
	BypassRLS *bool `json:"bypassRLS,omitempty"` //nolint:tagliatelle
	// CONNECTION LIMIT connlimit attribute
	// Note: This can be either -1, a number or null (to ignore this parameter)
	// Note: Increase your number by one because operator is using the created user to perform some operations.
	ConnectionLimit *int `json:"connectionLimit,omitempty"`
}

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

type PostgresqlUserRolePrivilege struct {
	// User Connection type.
	// This is referring to the user connection type needed for this user.
	// +optional
	// +kubebuilder:default=PRIMARY
	// +kubebuilder:validation:Enum=PRIMARY;BOUNCER
	ConnectionType ConnectionTypesSpecEnum `json:"connectionType,omitempty"`
	// User privileges
	// +required
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:Enum=OWNER;WRITER;READER
	Privilege PrivilegesSpecEnum `json:"privilege"`
	// Postgresql Database
	// +required
	// +kubebuilder:validation:Required
	Database *common.CRLink `json:"database"`
	// Generated secret name prefix
	// +required
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:MinLength=1
	GeneratedSecretName string `json:"generatedSecretName"`
	// Extra connection URL Parameters
	ExtraConnectionURLParameters map[string]string `json:"extraConnectionUrlParameters,omitempty"`
}

type PostgresqlUserRoleSpec struct {

	// User mode
	// +required
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:Enum=PROVIDED;MANAGED
	Mode ModeEnum `json:"mode,omitempty"`
	// Privileges
	// +required
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:Min=1
	Privileges []*PostgresqlUserRolePrivilege `json:"privileges"`
	// User role prefix
	// +optional
	RolePrefix string `json:"rolePrefix,omitempty"`
	// User password rotation duration
	// +optional
	UserPasswordRotationDuration string `json:"userPasswordRotationDuration,omitempty"`
	// Simple user password tuple generated secret name
	// +optional
	WorkGeneratedSecretName string `json:"workGeneratedSecretName"`
	// Import secret name
	// +optional
	ImportSecretName string `json:"importSecretName,omitempty"`
	// Role attributes
	// Note: Only attributes that aren't conflicting with operator are supported.
	// +optional
	RoleAttributes *PostgresqlUserRoleAttributes `json:"roleAttributes,omitempty"`
}

type PostgresqlUserRoleStatus struct {

	// Current phase of the operator
	Phase UserRoleStatusPhase `json:"phase"`
	// Human-readable message indicating details about current operator phase or error.
	// +optional
	Message string `json:"message"`
	// True if all resources are in a ready state and all work is done.
	// +optional
	Ready bool `json:"ready"`
	// User role
	// +optional
	RolePrefix string `json:"roleName"`
	// Postgres role for user
	// +optional
	PostgresRole string `json:"postgresRole"`
	// Postgres old roles to cleanup
	// +optional
	OldPostgresRoles []string `json:"oldPostgresRoles"`
	// Last password changed time
	// +optional
	LastPasswordChangedTime string `json:"lastPasswordChangedTime"`
}

type PrivilegesSpecEnum string

type ProviderType string

type PublicationStatusPhase string

type StatusPostgresRoles struct {
	Owner  string `json:"owner"`
	Reader string `json:"reader"`
	Writer string `json:"writer"`
}

type UserConnections struct {
	// Primary connection is referring to the primary node connection.
	// +optional
	PrimaryConnection *GenericUserConnection `json:"primaryConnection,omitempty"`
	// Bouncer connection is referring to a pg bouncer node.
	// +optional
	BouncerConnection *GenericUserConnection `json:"bouncerConnection,omitempty"`
	// Replica connections are referring to the replica nodes.
	// +optional
	ReplicaConnections []*GenericUserConnection `json:"replicaConnections,omitempty"`
	// Replica Bouncer connections are referring to pg bouncer nodes.
	// +optional
	ReplicaBouncerConnections []*GenericUserConnection `json:"replicaBouncerConnections,omitempty"`
}

type UserRoleStatusPhase string