v1alpha1

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

	Spec   PostgresDatabaseSpec   `json:"spec,omitempty"`
	Status PostgresDatabaseStatus `json:"status,omitempty"`
}

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

type PostgresDatabasePrivilegesSpec struct {
	Create    bool `json:"create,omitempty"`
	Connect   bool `json:"connect,omitempty"`
	Temporary bool `json:"temporary,omitempty"`
}

type PostgresDatabaseSpec struct {

	// Name is the PostgreSQL database's name.
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:XValidation:message="name is immutable",rule="self == oldSelf"
	Name string `json:"name"`

	// Owner is the PostgreSQL database's owner. It must be a valid existing role.
	Owner string `json:"owner,omitempty"`

	// Extensions is the list of database extensions to install on the database.
	Extensions []string `json:"extensions,omitempty"`

	// KeepOnDelete will determine if the deletion of the resource should drop the remote PostgreSQL database. Default is false.
	KeepOnDelete bool `json:"keepOnDelete,omitempty"`

	// PreserveConnectionsOnDelete will determine if the deletion of the object should drop the existing connections to the remote PostgreSQL database. Default is false.
	PreserveConnectionsOnDelete bool `json:"preserveConnectionsOnDelete,omitempty"`

	// PrivilegesByRole will grant privileges to roles
	PrivilegesByRole map[string]PostgresDatabasePrivilegesSpec `json:"privilegesByRole,omitempty"`
}

type PostgresDatabaseStatus struct {
	Succeeded bool `json:"succeeded"`
}

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

	Spec   PostgresRoleSpec   `json:"spec,omitempty"`
	Status PostgresRoleStatus `json:"status,omitempty"`
}

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

type PostgresRolePasswordFromSecret struct {
	// +kubebuilder:validation:Required
	Name string `json:"name"`
	// +kubebuilder:validation:Required
	Key string `json:"key"`
}

type PostgresRoleSpec struct {
	// PostgreSQL role name
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:XValidation:message="name is immutable",rule="self == oldSelf"
	Name string `json:"name,omitempty"`

	SuperUser   bool `json:"superUser,omitempty"`
	CreateDB    bool `json:"createDB,omitempty"`
	CreateRole  bool `json:"createRole,omitempty"`
	Inherit     bool `json:"inherit,omitempty"`
	Login       bool `json:"login,omitempty"`
	Replication bool `json:"replication,omitempty"`
	BypassRLS   bool `json:"bypassRLS,omitempty"`

	// KeepOnDelete will determine if the deletion of the resource should drop the remote PostgreSQL role. Default is false.
	KeepOnDelete bool `json:"keepOnDelete,omitempty"`

	PasswordFromSecret *PostgresRolePasswordFromSecret `json:"passwordFromSecret,omitempty"`
	SecretName         string                          `json:"secretName,omitempty"`
	SecretTemplate     map[string]string               `json:"secretTemplate,omitempty"`

	MemberOfRoles []string `json:"memberOfRoles,omitempty"`
}

type PostgresRoleStatus struct {
	Succeeded bool `json:"succeeded"`
}

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

	Spec   PostgresSchemaSpec   `json:"spec,omitempty"`
	Status PostgresSchemaStatus `json:"status,omitempty"`
}

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

type PostgresSchemaPrivilegesSpec struct {
	Create bool `json:"create,omitempty"`
	Usage  bool `json:"usage,omitempty"`
}

type PostgresSchemaSpec struct {
	// Database is the PostgreSQL database's name in which the schema exists
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:XValidation:message="database is immutable",rule="self == oldSelf"
	Database string `json:"database"`

	// Name is the PostgreSQL schema's name
	// +kubebuilder:validation:Required
	// +kubebuilder:validation:XValidation:message="name is immutable",rule="self == oldSelf"
	Name string `json:"name"`

	// Owner is the PostgreSQL schema's owner. It must be a valid existing role.
	Owner string `json:"owner,omitempty"`

	// KeepOnDelete will determine if the deletion of the resource should drop the remote PostgreSQL schema. Default is false.
	KeepOnDelete bool `json:"keepOnDelete,omitempty"`

	// PrivilegesByRole will grant privileges to roles on this schema
	PrivilegesByRole map[string]PostgresSchemaPrivilegesSpec `json:"privilegesByRole,omitempty"`
}

type PostgresSchemaStatus struct {
	Succeeded bool `json:"succeeded"`
}