🔌 Google Cloud SQL Instance - object.extracts.yaml

• Contextual name: 🔌 object.extracts.yaml
• ID: /types/CA10__CaGoogleSqlInstance__c/object.extracts.yaml
• Located in: 📕 Google Cloud SQL Instance

Used In

Logic	Policy	Flags
🧠 prod.logic.yaml 🟢	📝 Google Cloud MySQL Instance Local_infile Database Flag is not set to off 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud MySQL Instance Skip_show_database Database Flag is not set to on 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud PostgreSQL Instance Log_error_verbosity Database Flag is not set to DEFAULT or stricter 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud PostgreSQL Instance cloudsql.enable_pgaudit Database Flag is not set to on 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud PostgreSQL Instance Log_connections Database Flag is not set to On 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud PostgreSQL Instance Log_disconnections Database Flag is not set to On 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud PostgreSQL Instance Log_min_duration_statement Database Flag is not set to -1 (Disabled) 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud PostgreSQL Instance Log_min_error_statement Database Flag is not set to Error or stricter 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud PostgreSQL Instance Log_min_messages Database Flag is not set at minimum to Warning 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud PostgreSQL Instance Log_statement Database Flag is not set appropriately 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Instance Automated Backups are not configured 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Instance External Authorized Networks do not whitelist all public IP addresses 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Instance has public IP addresses 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Instance SSL Connections are not enforced 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Server Instance 3625 (trace flag) Database Flag is not set to on 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Server Instance contained database authentication Database Flag is set to on 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Server Instance cross db ownership chaining Database Flag is not set to off 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Server Instance external scripts enabled Database Flag is not set to off 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Server Instance remote access Database Flag is not set to off 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Server Instance user connections Database Flag is set to a limiting (other than 0) value 🟢	🟢 x3
🧠 prod.logic.yaml 🟢	📝 Google Cloud SQL Server Instance user options Database Flag is configured 🟢	🟢 x3

Content

Open File

---
extracts:
  - name: "CA10__databaseVersion__c"
    value: 
      FIELD:
        path: "CA10__databaseVersion__c"
        undeterminedIf:
          isEmpty:  "Database version should not be empty"
  - name: "CA10__ipv4Enabled__c"
    value: 
      FIELD:
        path: "CA10__ipv4Enabled__c"
        undeterminedIf:
          isEmpty:  "Ipv4Enabled should not be empty"
  - name: "caExtract__databaseFlagsJson__c"
    value: 
      JSON_FROM:
        arg:
          FIELD:
            path: CA10__databaseFlagsJson__c
            returnType: BYTES
        undeterminedIf:
          isInvalid: "Database Flags JSON is invalid."
          isEmpty: "Database Flags JSON is empty."

  - name: "caExtract_databaseFlags_skip_show_database_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'skip_show_database'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_local_infile_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'local_infile'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_log_error_verbosity_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression:  "to_string([?name == 'log_error_verbosity'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_log_connections_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'log_connections'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_log_disconnections_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression:  "to_string([?name == 'log_disconnections'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_log_statement_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'log_statement'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_log_min_messages_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'log_min_messages'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_log_min_error_statement_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'log_min_error_statement'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_log_min_duration_statement_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'log_min_duration_statement'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."


  - name: "caExtract_databaseFlags_cloudsql_enable_pgaudit_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'cloudsql.enable_pgaudit'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_external_scripts_enabled_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'external scripts enabled'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_cross_db_ownership_chaining_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'cross db ownership chaining'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_user_connections_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'user connections'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_user_options_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'user options'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_remote_access_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'remote access'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_3625_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == '3625'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "caExtract_databaseFlags_contained_database_authentication_flagValue__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caExtract__databaseFlagsJson__c"
        expression: "to_string([?name == 'contained database authentication'].value[] | [0])"
        undeterminedIf:
          evaluationError: "The JSON query has failed."
          resultTypeMismatch: "The JSON query did not return text type."

  - name: "CA10__authorizedNetworksJson__c"
    value: 
      FIELD:
        path: "CA10__authorizedNetworksJson__c"
        returnType: BYTES
  - name: "caJsonFrom_authorizedNetworksJson__c"
    value: 
      JSON_FROM:
        arg: 
          EXTRACT: "CA10__authorizedNetworksJson__c"
        undeterminedIf:
          isInvalid: "Authorized Networks JSON is invalid."  
  - name: "caJsonFrom_authorizedNetworksJson_value__c"
    value: 
      JSON_QUERY_TEXT:
        arg:
          EXTRACT: "caJsonFrom_authorizedNetworksJson__c"
        expression: "to_string([].value)"
        undeterminedIf:
          evaluationError: "The JSON query was failed."
          resultTypeMismatch: "The JSON query did not return a text."

  - name: "CA10__instanceType__c"
    value: 
      FIELD:
        path: "CA10__instanceType__c"
        undeterminedIf:
          isEmpty: "Instance type should not be empty"
  - name: "CA10__backendType__c"
    value: 
      FIELD:
        path: "CA10__backendType__c"
        undeterminedIf:
          isEmpty: "Backend type should not be empty"
  - name: "CA10__backupEnabled__c"
    value: 
      FIELD:
        path: "CA10__backupEnabled__c"
        undeterminedIf:
          isEmpty: "Backup enabled should not be empty"
  - name: "CA10__backupStartTime__c"
    value: 
      FIELD:
        path: "CA10__backupStartTime__c"
  - name: "CA10__sslMode__c"
    value: 
      FIELD:
        path: "CA10__sslMode__c"