Skip to content

CHORE: Publish Symbols Pipeline #105

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Draft
wants to merge 11 commits into
base: main
Choose a base branch
from

Conversation

bewithgaurav
Copy link
Collaborator

@bewithgaurav bewithgaurav commented Jun 25, 2025

ADO Work Item Reference

AB#37472


Summary

This pull request includes a small addition to the build pipeline configuration in eng/pipelines/build-whl-pipeline.yml. The change adds a new task to publish .pdb files as build artifacts under the name mssql-python-symbols.

@Copilot Copilot AI review requested due to automatic review settings June 25, 2025 11:05
Copy link
Contributor

@Copilot Copilot AI left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Pull Request Overview

Adds a new pipeline task to publish .pdb symbol files as build artifacts under the name mssql-python-symbols.

  • Introduces a PublishBuildArtifacts@1 step conditioned on success or failure
  • Points PathtoPublish at $(Build.ArtifactStagingDirectory)\all-pdbs
  • Uses mssql-python-symbols as the artifact name
Comments suppressed due to low confidence (2)

eng/pipelines/build-whl-pipeline.yml:165

  • Use forward slashes for PathtoPublish to ensure cross-platform compatibility (e.g., $(Build.ArtifactStagingDirectory)/all-pdbs).
        PathtoPublish: '$(Build.ArtifactStagingDirectory)\all-pdbs'

eng/pipelines/build-whl-pipeline.yml:161

  • [nitpick] Consider adding a preceding step to create or clean the all-pdbs directory so that you don’t publish stale or missing artifacts.
    # Publish the collected .pdb file(s) as build artifacts

@bewithgaurav bewithgaurav marked this pull request as draft June 25, 2025 12:29
SymbolsProduct: mssql-python
# Have kept the default version as the build ID, which is unique for each build
# This will be used to identify the symbols in the symbol server
SymbolsVersion: $(Build.BuildId)
Copy link
Collaborator Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Need to change ID for SymbolsVersion - perhaps the driver release version?

env:
SymbolServer: '$(SymbolServer)'
SymbolTokenUri: '$(SymbolTokenUri)'
requestName: '$(Build.DefinitionName)-$(Build.BuildId)'
Copy link
Collaborator Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

kept this since requestName needs to be unique for each API call. Might need to change this?

Comment on lines +25 to +26
- powershell: 'Write-Host "##vso[task.setvariable variable=ArtifactServices.Symbol.AccountName;]mssql-python"'
displayName: 'Update Symbol.AccountName with mssql-python'

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Suggested change
- powershell: 'Write-Host "##vso[task.setvariable variable=ArtifactServices.Symbol.AccountName;]mssql-python"'
displayName: 'Update Symbol.AccountName with mssql-python'
- powershell: 'Write-Host "##vso[task.setvariable variable=ArtifactServices.Symbol.AccountName;]SqlClientDrivers"'
displayName: 'Update Symbol.AccountName with SqlClientDrivers'

displayName: 'Update Symbol.AccountName with mssql-python'

- task: PublishSymbols@2
displayName: 'Upload symbols to mssql-python org'

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Suggested change
displayName: 'Upload symbols to mssql-python org'
displayName: 'Upload symbols to SqlClientDrivers org'

ServiceEndpointUrl: 'https://api.esrp.microsoft.com'
MainPublisher: 'ESRPRELPACMAN'
DomainTenantId: '$(DomainTenantId)'
azureSubscription: 'mssql-python-service'

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Suggested change
azureSubscription: 'mssql-python-service'
azureSubscription: 'SymbolsPublishing-msodbcsql-mssql-python'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants