<commit_before>trigger: none

pool:
  vmImage: ubuntu-latest

variables:
  CACHE_DIR: $(Pipeline.Workspace)/.cache
  SQLCL_DIR: $(Build.BinariesDirectory)/sqlcl
  UTPLSQL_DIR: $(Build.BinariesDirectory)/utPLSQL
  UTPLSQL_CLI_DIR: $(Build.BinariesDirectory)/utPLSQL-cli
  UTPLSQL_CLI_VERSION: 'v3.1.8'
  UTPLSQL_VERSION: 'v3.1.11' 
  DOCKHER_HUB_REPO: 'utplsqlv3/oracledb'

steps:
  - template: templates/t-extend-download-binaries.yml
    parameters:
      packages:
        - name: sqlcl
          download_location: "$(Build.BinariesDirectory)/sqlcl-latest.zip"
          unpack_location: "$(Build.BinariesDirectory)"
          url: "https://download.oracle.com/otn_software/java/sqldeveloper/sqlcl-latest.zip"
          archive: "zip"
          addtoPath: "$(SQLCL_DIR)/bin"

        - name: utlplsqlcli
          download_location: "$(Build.BinariesDirectory)/utPLSQL-cli.zip"
          unpack_location: "$(Build.BinariesDirectory)"
          url: "https://github.com/utPLSQL/utPLSQL-cli/releases/download/$(UTPLSQL_CLI_VERSION)/utPLSQL-cli.zip"
          archive: "zip"
          addToPath: "$(UTPLSQL_CLI_DIR)/bin"
    
  - template: templates/t-extend-database-build.yml
    parameters:
      utplsqlVersion: ${UTPLSQL_VERSION}
      utplsqlDir: ${UTPLSQL_DIR}
      targetDatabases:
        - oracleVersion: "19c-se2-small"
          connectionString: "127.0.0.1:1521/ORCLCDB"
          dockerPortMap: "1521"
          dockerOptions: "--shm-size=1g"
          scripts:
            - displayName: "Install utPLSQL"
              user: "sys"
              password: "<PASSWORD>"           
              script: "install_headless.sql UT3 UT3 users"
              work_dir: "${UTPLSQL_DIR}/source"

<commit_msg>Rearrange to allow binaries been kept<commit_after>trigger: none

pool:
  vmImage: ubuntu-latest

variables:
  CACHE_DIR: $(Pipeline.Workspace)/.cache
  SQLCL_DIR: $(Build.BinariesDirectory)/sqlcl
  UTPLSQL_DIR: $(Build.BinariesDirectory)/utPLSQL
  UTPLSQL_CLI_DIR: $(Build.BinariesDirectory)/utPLSQL-cli
  UTPLSQL_CLI_VERSION: 'v3.1.8'
  UTPLSQL_VERSION: 'v3.1.11' 
  DOCKHER_HUB_REPO: 'utplsqlv3/oracledb'

steps:
- template: templates/t-extend-download-binaries.yml
  parameters:
    packages:
      - name: sqlcl
        download_location: "$(Build.BinariesDirectory)/sqlcl-latest.zip"
        unpack_location: "$(Build.BinariesDirectory)"
        url: "https://download.oracle.com/otn_software/java/sqldeveloper/sqlcl-latest.zip"
        archive: "zip"
        addtoPath: "$(SQLCL_DIR)/bin"

      - name: utlplsqlcli
        download_location: "$(Build.BinariesDirectory)/utPLSQL-cli.zip"
        unpack_location: "$(Build.BinariesDirectory)"
        url: "https://github.com/utPLSQL/utPLSQL-cli/releases/download/$(UTPLSQL_CLI_VERSION)/utPLSQL-cli.zip"
        archive: "zip"
        addToPath: "$(UTPLSQL_CLI_DIR)/bin"
    
- template: templates/t-extend-database-build.yml
  parameters:
    utplsqlVersion: ${UTPLSQL_VERSION}
    utplsqlDir: ${UTPLSQL_DIR}
    targetDatabases:
      - oracleVersion: "19c-se2-small"
        connectionString: "127.0.0.1:1521/ORCLCDB"
        dockerPortMap: "1521"
        dockerOptions: "--shm-size=1g"
        scripts:
          - displayName: "Install utPLSQL"
            user: "sys"
            password: "<PASSWORD>"           
            script: "install_headless.sql UT3 UT3 users"
            work_dir: "${UTPLSQL_DIR}/source"


{'fraction_non_alphanumeric': 0.12256586483390607, 'fraction_numerical': 0.016036655211912942, 'mean_word_length': 2.5642857142857145, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 4, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 2, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 10, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1329027', 'n_tokens_mistral': 1263, 'n_tokens_neox': 1160, 'n_words': 165}