kind: Composition
apiVersion: apiextensions.crossplane.io/v1
metadata:
  name: xpostgresqlinstances.aws.database.starter.org
  creationTimestamp: null
spec:
  compositeTypeRef:
    apiVersion: database.starter.org/v1alpha1
    kind: XPostgreSQLInstance
  resources:
    - name: rdsinstance
      base:
        apiVersion: rds.aws.upbound.io/v1beta1
        kind: Instance
        spec:
          forProvider:
            engine: postgres
            engineVersion: "12"
            instanceClass: db.t2.small
            passwordSecretRef:
              key: password
              name: upbound-provider-aws-password
              namespace: upbound-system
            publiclyAccessible: false
            region: us-east-1
            skipFinalSnapshot: true
            username: adminuser
          writeConnectionSecretToRef:
            namespace: upbound-system
      patches:
        - fromFieldPath: metadata.uid
          toFieldPath: spec.writeConnectionSecretToRef.name
          transforms:
            - type: string
              string:
                fmt: "%s-postgresql"
        - fromFieldPath: spec.parameters.region
          toFieldPath: spec.forProvider.region
          transforms:
            - type: map
              map:
                east: us-east-1
                west: us-west-1
        - fromFieldPath: spec.parameters.size
          toFieldPath: spec.forProvider.instanceClass
          transforms:
            - type: map
              map:
                large: db.t2.large
                medium: db.t2.medium
                small: db.t2.small
        - fromFieldPath: spec.parameters.storage
          toFieldPath: spec.forProvider.allocatedStorage
      connectionDetails:
        - name: endpoint
          fromFieldPath: status.atProvider.endpoint
        - name: host
          fromFieldPath: status.atProvider.address
        - name: username
          fromFieldPath: spec.forProvider.username
        - name: password
          fromConnectionSecretKey: attribute.password
  writeConnectionSecretsToNamespace: upbound-system