如何从TeamCity直接运行Python查询及Windows机器文件下载问题

Hey there! Let's tackle your two key requirements step by step:

1. Replicate Linux curl Download Behavior on Windows #

Windows has a couple of straightforward ways to match the silent, targeted download behavior you're getting with Linux curl:

Option 1: Use Windows' Built-in curl.exe (Simplest) #

Starting with Windows 10 1803 and Windows Server 2019, Microsoft includes a native curl.exe that's nearly identical to the Linux version. You can run exactly the same command as on Linux:

curl -s -o cmake-3.4.1-Linux-x86_64.tar.gz http://ccm-XYZ/tools/cmake-3.4.1-Linux-x86_64.tar.gz

This will silently download the file to your specified output path, just like on Linux. The same command works for your Anaconda .sh file too.

Option 2: PowerShell (For Older Windows Versions) #

If you're stuck on an older Windows release without native curl.exe, use PowerShell's Invoke-WebRequest (or its alias iwr) with parameters that mirror curl's behavior:

Invoke-WebRequest -Uri "http://ccm-XYZ/tools/cmake-3.4.1-Linux-x86_64.tar.gz" `
    -OutFile "cmake-3.4.1-Linux-x86_64.tar.gz" `
    -UseBasicParsing `
    -ProgressAction SilentlyContinue

• -OutFile replaces Linux curl's -o flag
• -ProgressAction SilentlyContinue mimics the silent (-s) behavior by hiding download progress
• -UseBasicParsing avoids relying on Internet Explorer (critical for server environments)

2. Run Python Queries Directly from TeamCity #

Getting TeamCity to execute Python code is straightforward—here's how to set it up:

Prerequisite: Configure Python in TeamCity #

First, make sure the TeamCity Agent machine has Python installed. You can either:

• Ensure Python is added to the system PATH of the agent machine, or
• Configure a Python tool in TeamCity:
  1. Go to Administration → Tools → Add Tool
  2. Select "Python" from the dropdown
  3. Specify the path to your Python executable (e.g., C:\Python39\python.exe on Windows)

Run Python Code via Command Line Step #

The easiest way is to add a Command Line build step:

• In your build configuration, go to Build Steps → Add Step → Command Line
• Set the "Run" option to "Custom script"
• Enter your Python command. For one-off queries, use the -c flag to execute inline code:

  python -c "import os; print('Current directory:', os.getcwd())"
  

• If you have a dedicated Python script, point directly to it:

  python path/to/your/query_script.py
  

Use the TeamCity Python Plugin (Optional) #

If you want more control (like virtual environment support or script parameterization), install the official TeamCity Python plugin. Once installed:

• Add a Python build step
• Specify your script path or inline code
• Configure additional settings like virtual environment path or command-line arguments

内容的提问来源于stack exchange，提问作者user2781150