# Copyright 2016 Google Inc. All Rights Reserved.
#
# 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.
"""Resource info registry."""

from googlecloudsdk.core.resource import resource_exceptions
from googlecloudsdk.core.resource import resource_info

RESOURCE_REGISTRY = {

    # appengine
    'appengine.instances':
        resource_info.ResourceInfo(
            list_format="""
          table(
            service:sort=1,
            version:sort=2,
            id:sort=3,
            instance.vmStatus.yesno(no="N/A"),
            instance.vmDebugEnabled.yesno(yes="YES", no=""):label=DEBUG_MODE
          )
        """,),
    'appengine.module_versions':
        resource_info.ResourceInfo(
            list_format="""
          table(
            module,
            version,
            traffic_split.format("{0:.2f}", .)
          )
        """,),
    'appengine.regions':
        resource_info.ResourceInfo(
            list_format="""
          table(
           region:sort=1,
           standard.yesno(yes="YES", no="NO"):label='SUPPORTS STANDARD',
           flexible.yesno(yes="YES", no="NO"):label='SUPPORTS FLEXIBLE'
          )
        """,),
    'appengine.services':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id:label=SERVICE:sort=1,
            versions.len():label=NUM_VERSIONS
          )
        """,),
    'appengine.versions':
        resource_info.ResourceInfo(
            list_format="""
          table(
            service,
            id:label=VERSION,
            traffic_split.format("{0:.2f}", .),
            last_deployed_time.date("%Y-%m-%dT%H:%M:%S%Oz", undefined="-")
              :label=LAST_DEPLOYED,
            version.servingStatus:label=SERVING_STATUS
          )
        """,),

    # bigtable
    'bigtable.clusters.list.alpha':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            displayName:label=NAME,
            clusterId:label=ID,
            zoneId:label=ZONE,
            serveNodes:label=NODES
          )
        """,),
    'bigtable.clusters.list':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.segment(3):sort=1:label=INSTANCE,
            name.basename():sort=2:label=NAME,
            location.basename():label=ZONE,
            serveNodes:label=NODES,
            defaultStorageType:label=STORAGE,
            state
          )
        """,),
    'bigtable.instances.list':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.basename():sort=1,
            displayName,
            state
          )
        """,),

    # bio
    'bio.projects.operations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.basename(),
            metadata.request.'@type'.split('.').slice(-1:):label=TYPE,
            metadata.request.workflowName,
            metadata.createTime.date(),
            done,
            error.code:label=ERROR_CODE,
            format('{0:40}', error.message):label=ERROR_MESSAGE
          )
        """,),

    # cloud billing
    'cloudbilling.billingAccounts':
        resource_info.ResourceInfo(
            cache_command='billing accounts list',
            # TODO(b/22402915) Delete this when OP resource completion is
            # supported.
            bypass_cache=True,
            list_format="""
          table(
            name.basename():label=ID,
            displayName:label=NAME,
            open
          )
        """,),
    'cloudbilling.projectBillingInfo':
        resource_info.ResourceInfo(
            list_format="""
          table(
            projectId,
            billingAccountName.basename():label=BILLING_ACCOUNT_ID,
            billingEnabled
          )
        """,),

    # cloud build
    'cloudbuild.projects.builds':
        resource_info.ResourceInfo(
            cache_command='cloud build list',
            bypass_cache=True,
            async_collection='cloudbuild.projects.builds',
            list_format="""
          table(
            id,
            createTime.date('%Y-%m-%dT%H:%M:%S%Oz', undefined='-'),
            duration(start=startTime,end=finishTime,precision=0,calendar=false,undefined="  -").slice(2:).join(""):label=DURATION,
            build_source(undefined="-"):label=SOURCE,
            build_images(undefined="-"):label=IMAGES,
            status
          )
        """,),

    # cloud key management system
    'cloudkms.projects.locations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            locationId
          )
        """,),
    'cloudkms.projects.locations.keyRings':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name
          )
        """,),
    'cloudkms.projects.locations.keyRings.cryptoKeys':
        resource_info.ResourceInfo(
            list_format="""
              table(
                name,
                purpose,
                primary.state:label=PRIMARY_STATE
              )
            """,),
    'cloudkms.projects.locations.keyRings.cryptoKeys.cryptoKeyVersions':
        resource_info.ResourceInfo(
            list_format="""
              table(
                name,
                state
              )
            """,),

    # cloud resource manager
    'cloudresourcemanager.folders':
        resource_info.ResourceInfo(
            async_collection='cloudresourcemanager.operations',
            list_format="""
          table(
            displayName,
            name:sort=101,
            parent
          )
        """,),
    'cloudresourcemanager.projects':
        resource_info.ResourceInfo(
            cache_command='projects list',
            list_format="""
          table(
            projectId:sort=1,
            name,
            projectNumber
          )
        """,),
    'cloudresourcemanager.operations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name:sort=101,
            done,
            response,
            metadata,
            error
          )
        """,),
    'cloudresourcemanager.organizations':
        resource_info.ResourceInfo(
            cache_command='organizations list',
            list_format="""
          table(
            displayName,
            organizationId:sort=1,
            owner.directoryCustomerId
          )
        """,),
    'cloudresourcemanager.liens':
        resource_info.ResourceInfo(list_format="""
          table(
            name.segment(),
            origin,
            reason
          )
        """),

    # Cloud SDK client side resources

    # 'coudsdk.*': ...

    # compute
    'compute.addresses':
        resource_info.ResourceInfo(
            cache_command='compute addresses list',
            list_format="""
          table(
            name,
            region.basename(),
            address,
            status
          )
        """,),
    'compute.autoscalers':
        resource_info.ResourceInfo(
            async_collection='compute.operations',
            cache_command='compute autoscaler list',
            list_format="""
          table(
            name,
            target.basename(),
            autoscalingPolicy.policy():label=POLICY
          )
        """,),
    'compute.backendBuckets':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            bucketName:label=GCS_BUCKET_NAME,
            enableCdn
          )
        """,),
    'compute.backendServiceGroupHealth':
        resource_info.ResourceInfo(
            list_format="""
          default
        """,),
    'compute.backendServices':
        resource_info.ResourceInfo(
            cache_command='compute backend-services list',
            list_format="""
          table(
            name,
            backends[].group.list():label=BACKENDS,
            protocol
          )
        """,),
    'compute.backendServices.alpha':
        resource_info.ResourceInfo(
            cache_command='compute backend-services list',
            list_format="""
          table(
            name,
            backends[].group.list():label=BACKENDS,
            protocol,
            loadBalancingScheme,
            healthChecks.map().basename().list()
          )
        """,),
    'compute.regionBackendServices':
        resource_info.ResourceInfo(
            cache_command='compute backend-services list',
            list_format="""
          table(
            name,
            backends[].group.list():label=BACKENDS,
            protocol,
            loadBalancingScheme,
            healthChecks.map().basename().list()
          )
        """,),
    'compute.disks':
        resource_info.ResourceInfo(
            cache_command='compute disks list',
            list_format="""
          table(
            name,
            zone.basename(),
            sizeGb,
            type.basename(),
            status
          )
        """,),
    'compute.diskTypes':
        resource_info.ResourceInfo(
            cache_command='compute disk-types list',
            list_format="""
          table(
            name,
            zone.basename(),
            validDiskSize:label=VALID_DISK_SIZES
          )
        """,),
    'compute.diskTypes.alpha':
        resource_info.ResourceInfo(
            cache_command='compute disk-types list',
            list_format="""
          table(
            name,
            location():label=LOCATION,
            location_scope():label=SCOPE,
            validDiskSize:label=VALID_DISK_SIZES
          )
        """,),
    'compute.firewalls':
        resource_info.ResourceInfo(
            cache_command='compute firewall-rules list',
            list_format="""
          table(
            name,
            network.basename(),
            sourceRanges.list():label=SRC_RANGES,
            allowed[].map().firewall_rule().list():label=RULES,
            sourceTags.list():label=SRC_TAGS,
            targetTags.list():label=TARGET_TAGS
          )
        """,),
    'compute.firewalls.alpha':
        resource_info.ResourceInfo(
            cache_command='compute firewall-rules list',
            list_format="""
          table(
            name,
            network.basename(),
            direction,
            priority,
            sourceRanges.list():label=SRC_RANGES,
            destinationRanges.list():label=DEST_RANGES,
            allowed[].map().firewall_rule().list():label=ALLOW,
            denied[].map().firewall_rule().list():label=DENY,
            sourceTags.list():label=SRC_TAGS,
            targetTags.list():label=TARGET_TAGS
          )
        """,),
    'compute.forwardingRules':
        resource_info.ResourceInfo(
            cache_command='compute forwarding-rules list',
            list_format="""
          table(
            name,
            region.basename(),
            IPAddress,
            IPProtocol,
            firstof(
                target,
                backendService).scope():label=TARGET
          )
        """,),
    'compute.groups':
        resource_info.ResourceInfo(
            cache_command='compute groups list',
            list_format="""
          table(
            name,
            members.len():label=NUM_MEMBERS,
            description
          )
        """,),
    'compute.healthChecks':
        resource_info.ResourceInfo(
            cache_command='compute health-checks list',
            list_format="""
          table(
            name,
            type:label=PROTOCOL
          )
        """,),
    'compute.hosts':
        resource_info.ResourceInfo(
            cache_command='compute sole-tenancy hosts list',
            list_format="""
          table(
            name,
            zone.basename(),
            instances.len():label=INSTANCES,
            status
          )
        """,),
    'compute.hostTypes':
        resource_info.ResourceInfo(
            cache_command='compute sole-tenancy host-types list',
            list_format="""
          table(
            name,
            zone.basename(),
            guestCpus:label=CPUs,
            memoryMb,
            localSsdGb,
            deprecated.state:label=DEPRECATED
          )
        """,),
    'compute.httpHealthChecks':
        resource_info.ResourceInfo(
            cache_command='compute http-health-checks list',
            list_format="""
          table(
            name,
            host,
            port,
            requestPath
          )
        """,),
    'compute.httpsHealthChecks':
        resource_info.ResourceInfo(
            cache_command='compute https-health-checks list',
            list_format="""
          table(
            name,
            host,
            port,
            requestPath
          )
        """,),
    'compute.images':
        resource_info.ResourceInfo(
            cache_command='compute images list',
            list_format="""
          table(
            name,
            selfLink.map().scope(projects).segment(0):label=PROJECT,
            family,
            deprecated.state:label=DEPRECATED,
            status
          )
        """,),
    'compute.instanceGroups':
        resource_info.ResourceInfo(
            cache_command='compute instance-groups list',
            list_format="""
          table(
            name,
            location():label=LOCATION,
            location_scope():label=SCOPE,
            network.basename(),
            isManaged:label=MANAGED,
            size:label=INSTANCES
          )
        """,),
    'compute.instanceGroupManagers':
        resource_info.ResourceInfo(
            cache_command='compute instance-groups managed list',
            list_format="""
          table(
            name,
            location():label=LOCATION,
            location_scope():label=SCOPE,
            baseInstanceName,
            size,
            targetSize,
            instanceTemplate.basename(),
            autoscaled
          )
        """,),
    'compute.instances':
        resource_info.ResourceInfo(
            cache_command='compute instances list',
            list_format="""
          table(
            name,
            zone.basename(),
            machineType.machine_type(),
            scheduling.preemptible.yesno(yes=true, no=''),
            networkInterfaces[].networkIP.notnull().list():label=INTERNAL_IP,
            networkInterfaces[].accessConfigs[0].natIP.notnull().list()\
            :label=EXTERNAL_IP,
            status
          )
        """,),
    'compute.instanceTemplates':
        resource_info.ResourceInfo(
            cache_command='compute instance-templates list',
            list_format="""
          table(
            name,
            properties.machineType.machine_type(),
            properties.scheduling.preemptible.yesno(yes=true, no=''),
            creationTimestamp
          )
        """,),
    'compute.invalidations':
        resource_info.ResourceInfo(
            cache_command='beta compute url-maps list-cdn-cache-invalidations',
            list_format="""
          table(
            description,
            operation_http_status():label=HTTP_STATUS,
            status,
            insertTime:label=TIMESTAMP
          )
        """,),
    'compute.machineTypes':
        resource_info.ResourceInfo(
            cache_command='compute machine-types list',
            list_format="""
          table(
            name,
            zone.basename(),
            guestCpus:label=CPUS,
            memoryMb.size(units_in=MiB, units_out=GiB, precision=2):label=MEMORY_GB,
            deprecated.state:label=DEPRECATED
          )
        """,),
    'compute.networks':
        resource_info.ResourceInfo(
            cache_command='compute networks list',
            list_format="""
          table(
            name,
            x_gcloud_mode:label=MODE,
            IPv4Range:label=IPV4_RANGE,
            gatewayIPv4
          )
        """,),
    'compute.operations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            operationType:label=TYPE,
            targetLink.scope():label=TARGET,
            operation_http_status():label=HTTP_STATUS,
            status,
            insertTime:label=TIMESTAMP
          )
        """,),
    'compute.peerings':
        resource_info.ResourceInfo(
            cache_command='alpha compute networks peerings list',
            list_format="""
          table(
            name,
            source_network.basename():label=NETWORK,
            network.map().scope(projects).segment(0):label=PEER_PROJECT,
            network.basename():label=PEER_NETWORK,
            autoCreateRoutes,
            state,
            stateDetails
          )
        """,),
    'compute.projects':
        resource_info.ResourceInfo(
            list_format="""
          value(
            format("There is no API support yet.")
          )
        """,),
    'compute.xpnProjects':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            creationTimestamp,
            xpnProjectStatus
          )
        """,),
    'compute.xpnResourceId':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id:label=RESOURCE_ID,
            type:label=RESOURCE_TYPE)
        """,),
    'compute.regions':
        resource_info.ResourceInfo(
            cache_command='compute regions list',
            list_format="""
          table(
            name,
            quotas.metric.CPUS.quota():label=CPUS,
            quotas.metric.DISKS_TOTAL_GB.quota():label=DISKS_GB,
            quotas.metric.IN_USE_ADDRESSES.quota():label=ADDRESSES,
            quotas.metric.STATIC_ADDRESSES.quota():label=RESERVED_ADDRESSES,
            status():label=STATUS,
            deprecated.deleted:label=TURNDOWN_DATE
          )
        """,),
    'compute.routers':
        resource_info.ResourceInfo(
            cache_command='compute routers list',
            list_format="""
          table(
            name,
            region.basename(),
            network.basename()
          )
        """,),
    'compute.routes':
        resource_info.ResourceInfo(
            cache_command='compute routes list',
            list_format="""
          table(
            name,
            network.basename(),
            destRange,
            firstof(
                nextHopInstance,
                nextHopGateway,
                nextHopIp,
                nextHopVpnTunnel,
                nextHopPeering).scope()
              :label=NEXT_HOP,
            priority
          )
        """,),
    'compute.snapshots':
        resource_info.ResourceInfo(
            cache_command='compute snapshots list',
            list_format="""
          table(
            name,
            diskSizeGb,
            sourceDisk.scope():label=SRC_DISK,
            status
          )
        """,),
    'compute.sslCertificates':
        resource_info.ResourceInfo(
            cache_command='compute ssl-certificates list',
            list_format="""
          table(
            name,
            creationTimestamp
          )
        """,),
    'compute.subnetworks':
        resource_info.ResourceInfo(
            cache_command='compute networks subnets list',
            list_format="""
          table(
            name,
            region.basename(),
            network.basename(),
            ipCidrRange:label=RANGE
          )
        """,),
    'compute.targetHttpProxies':
        resource_info.ResourceInfo(
            cache_command='compute target-http-proxies list',
            list_format="""
          table(
            name,
            urlMap.basename()
          )
        """,),
    'compute.targetHttpsProxies':
        resource_info.ResourceInfo(
            cache_command='compute target-https-proxies list',
            list_format="""
          table(
            name,
            sslCertificates.map().basename().list():label=SSL_CERTIFICATES,
            urlMap.basename()
          )
        """,),
    'compute.targetInstances':
        resource_info.ResourceInfo(
            cache_command='compute target-instances list',
            list_format="""
          table(
            name,
            zone.basename(),
            instance.basename(),
            natPolicy
          )
        """,),
    'compute.targetPoolInstanceHealth':
        resource_info.ResourceInfo(
            list_format="""
          default
        """,),
    'compute.targetPools':
        resource_info.ResourceInfo(
            cache_command='compute target-pools list',
            list_format="""
          table(
            name,
            region.basename(),
            sessionAffinity,
            backupPool.basename():label=BACKUP,
            healthChecks[].map().basename().list():label=HEALTH_CHECKS
          )
        """,),
    'compute.targetSslProxies':
        resource_info.ResourceInfo(
            cache_command='compute target-ssl-proxies list',),
    'compute.targetTcpProxies':
        resource_info.ResourceInfo(
            cache_command='compute target-tcp-proxies list',),
    'compute.targetVpnGateways':
        resource_info.ResourceInfo(
            cache_command='compute target-vpn-gateways list',
            list_format="""
          table(
            name,
            network.basename(),
            region.basename()
          )
        """,),
    'compute.urlMaps':
        resource_info.ResourceInfo(
            cache_command='compute url-maps list',
            list_format="""
          table(
            name,
            defaultService
          )
        """,),
    'compute.users':
        resource_info.ResourceInfo(
            cache_command='compute users list',
            list_format="""
          table(
            name,
            owner,
            description
          )
        """,),
    'compute.vpnTunnels':
        resource_info.ResourceInfo(
            cache_command='compute vpn-tunnels list',
            list_format="""
          table(
            name,
            region.basename(),
            targetVpnGateway.basename():label=GATEWAY,
            peerIp:label=PEER_ADDRESS
          )
        """,),
    'compute.zones':
        resource_info.ResourceInfo(
            cache_command='compute zones list',
            list_format="""
          table(
            name,
            region.basename(),
            status():label=STATUS,
            maintenanceWindows.next_maintenance():label=NEXT_MAINTENANCE,
            deprecated.deleted:label=TURNDOWN_DATE
          )
        """,),

    # container
    'container.images':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name
          )
        """,),
    'container.tags':
        resource_info.ResourceInfo(
            list_format="""
          table(
            digest.slice(7:19).join(''),
            tags.list(),
            timestamp.date(),
            BUILD_DETAILS.buildDetails.provenance.sourceProvenance.sourceContext.context.cloudRepo.revisionId.notnull().list().slice(:8).join(''):label=GIT_SHA,
            PACKAGE_VULNERABILITY.vulnerabilityDetails.severity.notnull().count().list():label=VULNERABILITIES,
            IMAGE_BASIS.derivedImage.sort(distance).map().extract(baseResourceUrl).slice(:1).map().list().list().split('//').slice(1:).list().split('@').slice(:1).list():label=FROM,
            BUILD_DETAILS.buildDetails.provenance.id.notnull().list():label=BUILD
          )
        """,),
    'container.projects.zones.clusters':
        resource_info.ResourceInfo(
            async_collection='container.projects.zones.clusters',
            list_format="""
          table(
            name,
            zone,
            master_version():label=MASTER_VERSION,
            endpoint:label=MASTER_IP,
            nodePools[0].config.machineType,
            currentNodeVersion:label=NODE_VERSION,
            currentNodeCount:label=NUM_NODES,
            status
          )
        """,),
    'container.projects.zones.clusters.nodePools':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            config.machineType,
            config.diskSizeGb,
            version:label=NODE_VERSION
          )
        """,),
    'container.projects.zones.operations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            operationType:label=TYPE,
            zone,
            targetLink.basename():label=TARGET,
            statusMessage,
            status
          )
        """,),

    # dataflow
    'dataflow.jobs':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id:label=ID,
            name:label=NAME,
            type:label=TYPE,
            creationTime.yesno(no="-"),
            state
          )
        """,),
    'dataflow.logs':
        resource_info.ResourceInfo(
            list_format="""
          table[no-heading,pad=1](
            messageImportance.enum(dataflow.JobMessage),
            time.date(tz=LOCAL):label=TIME,
            id,
            messageText:label=TEXT
          )
        """,),

    # dataproc
    'dataproc.clusters':
        resource_info.ResourceInfo(
            list_format="""
          table(
            clusterName:label=NAME,
            config.workerConfig.numInstances:label=WORKER_COUNT,
            status.state:label=STATUS,
            config.gceClusterConfig.zoneUri.scope(zone):label=ZONE
          )
        """,),
    'dataproc.jobs':
        resource_info.ResourceInfo(
            async_collection='dataproc.operations',
            list_format="""
          table(
            reference.jobId,
            type.yesno(no="-"),
            status.state:label=STATUS
          )
        """,),
    'dataproc.operations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name:label=OPERATION_NAME,
            done
          )
        """,),

    # debug
    'debug.logpoints':
        resource_info.ResourceInfo(
            list_format="""
          table(
            userEmail.if(all_users),
            location,
            condition,
            logLevel,
            logMessageFormat,
            id,
            full_status():label=STATUS)
            :(isFinalState:sort=1, createTime:sort=2)
        """,),
    'debug.logpoints.create':
        resource_info.ResourceInfo(
            list_format="""
          list(
            format("id: {0}", id),
            format("location: {0}", location),
            format("logLevel: {0}", logLevel),
            format("logMessageFormat: {0}", logMessageFormat),
            format("condition: {0}", condition),
            format("logViewUrl: {0}", logViewUrl),
            format("status: {0}", full_status())
          )
        """,),
    'debug.snapshots':
        resource_info.ResourceInfo(list_format="""
          table(
            short_status():label=STATUS,
            userEmail.if(all_users),
            location,
            condition,
            finalTime.if(include_inactive != 0):label=COMPLETED_TIME,
            id,
            consoleViewUrl:label=VIEW
          )
        """),
    'debug.snapshots.create':
        resource_info.ResourceInfo(list_format="""
          list(
            format("id: {0}", id),
            format("location: {0}", location),
            format("status: {0}", full_status()),
            format("consoleViewUrl: {0}", consoleViewUrl)
          )
        """),
    'debug.targets':
        resource_info.ResourceInfo(list_format="""
          table(
            name,
            target_id:label=ID,
            description
          )
        """),

    # deployment manager v2
    'deploymentmanager.deployments':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            operation.operationType:label=LAST_OPERATION_TYPE,
            operation.status,
            description,
            manifest.basename(),
            operation.error.errors.group(code)
          )
        """,),
    'deploymentmanager.operations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            operationType:label=TYPE,
            status,
            targetLink.basename():label=TARGET,
            error.errors.group(code)
          )
        """,),
    'deploymentmanager.resources':
        resource_info.ResourceInfo(
            async_collection='deploymentmanager.operations',
            list_format="""
          table(
            name,
            type,
            update.state.yesno(no="COMPLETED"),
            update.error.errors.group(code),
            update.intent
          )
        """,),
    'deploymentmanager.resources_and_outputs':
        resource_info.ResourceInfo(
            async_collection='deploymentmanager.operations',
            list_format="""
          table(
            resources:format='table(
              name,
              type,
              update.state.yesno(no="COMPLETED"),
              update.error.errors.group(code),
              update.intent)',
            outputs:format='table(
              name:label=OUTPUTS,
              finalValue:label=VALUE)'
          )
        """,),
    'deploymentmanager.deployments_and_resources_and_outputs':
        resource_info.ResourceInfo(
            list_format="""
              table(
                deployment:format='default(name, id, description, fingerprint,
                insertTime, manifest.basename(), labels, operation.operationType,
                operation.name, operation.progress, operation.status,
                operation.user, operation.endTime, operation.startTime,
                operation.error, update)',
                resources:format='table(
                  name:label=NAME,
                  type:label=TYPE,
                  update.state.yesno(no="COMPLETED"),
                  update.intent)',
              outputs:format='table(
                name:label=OUTPUTS,
                finalValue:label=VALUE)'
             )
             """,),
    'deploymentmanager.types':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name
          )
        """,),
    'deploymentmanager.type_providers':
        resource_info.ResourceInfo(
            async_collection='deploymentmanager.operations',
            list_format="""
          table(
            name,
            insertTime.date(format="%Y-%m-%d"):label=INSERT_DATE
          )
        """,),

    # dns
    'dns.changes':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id,
            startTime,
            status
          )
        """,),
    'dns.managedZones':
        resource_info.ResourceInfo(
            cache_command='dns managed-zones list',
            list_format="""
          table(
            name,
            dnsName,
            description
          )
        """,),
    'dns.resourceRecordSets':
        resource_info.ResourceInfo(
            list_format="""
          table(
                name,
                type,
                ttl,
                rrdatas.list():label=DATA
              )
        """,),

    # functions
    'functions.projects.locations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name
          )
        """,),
    'functions.projects.locations.functions':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.basename(),
            status,
            trigger():label=TRIGGER
          )
        """,),

    # genomics
    'genomics.alignments':
        resource_info.ResourceInfo(
            list_format="""
          table(
            alignment.position.referenceName,
            alignment.position.position,
            alignment.position.reverseStrand,
            fragmentName,
            alignedSequence:label=SEQUENCE
          )
        """,),
    'genomics.callSets':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id,
            name,
            variantSetIds.list()
          )
        """,),
    'genomics.datasets':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id,
            name
          )
        """,),
    'genomics.readGroupSets':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id,
            name,
            referenceSetId
          )
        """,),
    'genomics.references':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id,
            name,
            length,
            sourceUri,
            sourceAccessions.list():label=ACCESSIONS
          )
        """,),
    'genomics.referenceSets':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id,
            assemblyId,
            sourceAccessions.list()
          )
        """,),
    'genomics.variants':
        resource_info.ResourceInfo(
            list_format="""
          table(
            variantSetId,
            referenceName,
            start,
            end,
            referenceBases,
            alternateBases
          )
        """,),
    'genomics.variantsets':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id,
            name,
            description
          )
        """,),

    # iam
    'iam.service_accounts':
        resource_info.ResourceInfo(
            list_format="""
          table(
            displayName:label=NAME,
            email
          )
        """,),
    'iam.service_accounts.keys':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.scope(keys):label=KEY_ID,
            validAfterTime:label=CREATED_AT,
            validBeforeTime:label=EXPIRES_AT
          )
        """,),

    # logging
    'logging.logs':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.scope(logs):label=ID
          )
        """,),
    'logging.metrics':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            description,
            filter,
            version
          )
        """,),
    'logging.resourceDescriptors':
        resource_info.ResourceInfo(
            list_format="""
          table(
            type,
            description,
            labels[].key.list()
          )
        """,),
    'logging.sinks':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            destination,
            type,
            format,
            filter
          )
        """,),

    # ml
    'ml.operations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name
          )
        """,),
    'ml.beta.jobs':
        resource_info.ResourceInfo(
            list_format="""
          table(
            jobId.basename(),
            state:label=STATUS,
            createTime.date(tz=LOCAL):label=CREATED
          )
        """,),
    'ml.models.versions':
        resource_info.ResourceInfo(
            async_collection='ml.operations',
            list_format="""
          table(
            name.basename(),
            deploymentUri
          )
        """,),
    'ml.models':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.basename(),
            defaultVersion.name.basename()
          )
        """,),

    # projects
    'developerprojects.projects':
        resource_info.ResourceInfo(
            list_format="""
          table(
            projectId,
            title,
            projectNumber
          )
        """,),

    # pubsub
    'pubsub.projects.topics':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            topicId:label=TOPIC,
            success:label=SUCCESS,
            reason:label=REASON
          )
        """,),
    'pubsub.topics.publish':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            messageIds:label=MESSAGE_ID,
          )
        """,),
    'pubsub.projects.subscriptions':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            subscriptionId:label=SUBSCRIPTION,
            topic:label=TOPIC,
            type,
            pushEndpoint:label=PUSH_ENDPOINT,
            ackDeadlineSeconds:label=ACK_DEADLINE,
            retainAckedMessages:label=RETAIN_ACKED_MESSAGES,
            messageRetentionDuration:label=MESSAGE_RETENTION_DURATION,
            success:label=SUCCESS,
            reason:label=REASON
          )
        """,),
    'pubsub.subscriptions.ack':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            subscriptionId:label=SUBSCRIPTION,
            ackIds:label=ACK_IDS
          )
        """,),
    'pubsub.subscriptions.mod_ack':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            subscriptionId:label=SUBSCRIPTION,
            ackId:label=ACK_ID,
            ackDeadlineSeconds:label=ACK_DEADLINE
          )
        """,),
    'pubsub.subscriptions.mod_config':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            subscriptionId:label=SUBSCRIPTION,
            pushEndpoint:label=PUSH_ENDPOINT
          )
        """,),
    'pubsub.subscriptions.pull':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            message.data.decode(base64),
            message.messageId,
            message.attributes.list(separator=' '),
            ackId.if(NOT auto_ack)
          )
        """,),
    'pubsub.subscriptions.list':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            projectId:label=PROJECT,
            subscriptionId:label=SUBSCRIPTION,
            topicId:label=TOPIC,
            type,
            ackDeadlineSeconds:label=ACK_DEADLINE
          )
        """,),
    'pubsub.projects.snapshots':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            snapshotId:label=SNAPSHOT,
            topicId:label=TOPIC,
            exipirationTime:label=EXPIRATION_TIME,
            success:label=SUCCESS,
            reason:label=REASON
            )
        """,),
    'pubsub.snapshots.list':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            projectId:label=PROJECT,
            snapshotId:label=SNAPSHOT,
            topicId:label=TOPIC,
            expirationTime:label=EXPIRATION_TIME
            )
        """,),
    'pubsub.subscriptions.seek':
        resource_info.ResourceInfo(
            list_format="""
          table[box](
            time:label=TIME,
            snapshotId:label=SNAPSHOT
            subscriptionId:label=SUBSCRIPTION,
          )
        """,),
    'replicapoolupdater.rollingUpdates':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id,
            instanceGroupManager.basename():label=GROUP_NAME,
            instanceTemplate.basename():label=TEMPLATE_NAME,
            status,
            statusMessage
          )
        """,),
    'replicapoolupdater.rollingUpdates.instanceUpdates':
        resource_info.ResourceInfo(
            list_format="""
              table(
                instance.basename():label=INSTANCE_NAME,
                status
              )
            """,),

    # runtime config
    'runtimeconfig.configurations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            description
          )
        """,),
    'runtimeconfig.variables':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            updateTime.date()
          )
        """,),
    'runtimeconfig.waiters':
        resource_info.ResourceInfo(
            async_collection='runtimeconfig.waiters',
            list_format="""
          table(
            name,
            createTime.date(),
            waiter_status(),
            error.message
          )
        """,),

    # service management (inception)
    'servicemanagement-v1.services':
        resource_info.ResourceInfo(
            bypass_cache=True,
            list_format="""
          table(
            serviceName:label=NAME,
            serviceConfig.title
          )
        """,),
    'servicemanagement-v1.serviceConfigs':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id:label=CONFIG_ID,
            name:label=SERVICE_NAME
          )
        """,),

    # service registry
    'service_registry.endpoints':
        resource_info.ResourceInfo(
            async_collection='service_registry.operations',
            list_format="""
          table[box](
            name,
            state,
            addresses[].map().endpoint_address().list(separator=' | '):label=ADDRESSES
          )
        """,),
    'service_registry.operations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            operationType:label=TYPE,
            status,
            targetLink.basename():label=TARGET,
            insertTime.date(format="%Y-%m-%d"):label=DATE,
            error.errors.group(code, message)
          )
        """,),

    # source
    'source.captures':
        resource_info.ResourceInfo(
            list_format="""
          table(
            project_id,
            id:label=CAPTURE_ID
          )
        """,),
    'source.captures.upload':
        resource_info.ResourceInfo(
            list_format="""
          flattened(capture.id, context_file, extended_context_file)
        """,),
    'source.jobs':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.yesno(no="default"):label=REPO_NAME,
            projectId,
            vcs,
            state,
            createTime
          )
        """,),

    # spanner
    'spanner.databases':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.basename(),
            state
          )
        """,),
    'spanner.instanceConfigs':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.basename(),
            displayName
          )
        """,),
    'spanner.instances':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.basename(),
            displayName,
            config.basename(),
            nodeCount,
            state
          )
        """,),
    'spanner.operations':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name.basename():label=OPERATION_ID,
            metadata.statements.join(sep="\n"),
            done,
            metadata.'@type'.split('.').slice(-1:).join()
          )
        """,),

    # sql
    'sql.databases':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            charset,
            collation
          )
        """,),
    'sql.backupRuns':
        resource_info.ResourceInfo(
            list_format="""
          table(
            dueTime.iso(),
            error.code.yesno(no="-"):label=ERROR,
            status
          )
        """,),
    'sql.backupRuns.v1beta4':
        resource_info.ResourceInfo(
            list_format="""
          table(
            id,
            windowStartTime.iso(),
            error.code.yesno(no="-"):label=ERROR,
            status
          )
        """,),
    'sql.flags':
        resource_info.ResourceInfo(
            list_format="""
          table(
            name,
            type,
            appliesTo.list():label=DATABASE_VERSION,
            allowedStringValues.list():label=ALLOWED_VALUES
          )
        """,),
    'sql.instances':
        resource_info.ResourceInfo(
            async_collection='sql.operations',
            cache_command='sql instances list',
            list_format="""
          table(
            instance:label=NAME,
            region,
            settings.tier,
            ipAddresses[0].ipAddress.yesno(no="-"):label=ADDRESS,
            state:label=STATUS
          )
        """,),
    'sql.instances.v1beta4':
        resource_info.ResourceInfo(
            async_collection='sql.operations.v1beta4',
            cache_command='sql instances list',
            list_format="""
          table(
            name,
            region,
            settings.tier,
            ipAddresses[0].ipAddress.yesno(no="-"):label=ADDRESS,
            state:label=STATUS
          )
        """,),
    'sql.operations':
        resource_info.ResourceInfo(
            async_collection='default',
            list_format="""
          table(
            operation,
            operationType:label=TYPE,
            startTime.iso():label=START,
            endTime.iso():label=END,
            error[0].code.yesno(no="-"):label=ERROR,
            state:label=STATUS
          )
        """,),
    'sql.operations.v1beta4':
        resource_info.ResourceInfo(
            async_collection='default',
            list_format="""
          table(
            name,
            operationType:label=TYPE,
            startTime.iso():label=START,
            endTime.iso():label=END,
            error[0].code.yesno(no="-"):label=ERROR,
            status:label=STATUS
          )
        """,),
    'sql.sslCerts':
        resource_info.ResourceInfo(
            async_collection='sql.operations',
            list_format="""
          table(