[FEATURE] publish `tpchgen-cli` to pypi

[kevinjqliu]

Is your feature request related to a problem? Please describe.
Publish the python binding (tpchgen-cli) to pypi

Describe the solution you'd like
Now that #121 is merged, lets do the following as pre-req so we can safely publish to pypi:

• Test publishing to testpypi from main repo; the github action is currently pointing to testpypi
• Change python library version to a new version and push to testpypi (PR: [feat] pyproject use cargo version #136)
• Remove maturin repo url pointing to testpypi (PR: [feat] publish to pypi #134)
• (nice to have) Fix tpchgen-cli's README [BUG] tpchgen-cli's README no longer points to the workspace README #130 (PR: Fix up tpchgen-cli's README #133)
• Add "pending publisher" on pypi

After everything is done above, trigger github action again to publish to pypi.

[kevinjqliu]

Adding as "pending publisher" on pypi using my pypi account (kevinjqliu)

[kevinjqliu]

Triggered github action from this repo, https://github.com/clflushopt/tpchgen-rs/actions/runs/14552294288

should build everything but skip pushing artifacts to testpypi since version 0.1.0 already exists on there

[kevinjqliu]

Great the github action was successfully ran but skipped uploading since the version already exists.

Lets change the library version to 1.0.0 (#136) and push again. 1.0.0 does not exist in testpypi yet so this time the packages will be uploaded

[kevinjqliu]

Merged #136. Now lets run the github action again, https://github.com/clflushopt/tpchgen-rs/actions/runs/14552396861
This should upload the 1.0.0 version to testpypi

[kevinjqliu]

Got a 503 from testpypi... https://github.com/clflushopt/tpchgen-rs/actions/runs/14552396861/job/40825268947
but 1 file was uploaded! https://test.pypi.org/project/tpchgen-cli/1.0.0/#files

lets try again, https://github.com/clflushopt/tpchgen-rs/actions/runs/14552476566

[kevinjqliu]

Nice! That worked, https://github.com/clflushopt/tpchgen-rs/actions/runs/14552476566
Now theres version 1.0.0 on testpypi, https://test.pypi.org/project/tpchgen-cli/1.0.0/
And im able to install from testpypi,

(.venv) ➜  tpchgen-cli git:(main) pip install -i https://test.pypi.org/simple/ tpchgen-cli==1.0.0
Looking in indexes: https://test.pypi.org/simple/
Collecting tpchgen-cli==1.0.0
  Downloading https://test-files.pythonhosted.org/packages/5d/62/41be3c6939465ada272773d52878f636e2feab996a28cb21c5906c30656f/tpchgen_cli-1.0.0-py3-none-macosx_11_0_arm64.whl.metadata (2.4 kB)
Downloading https://test-files.pythonhosted.org/packages/5d/62/41be3c6939465ada272773d52878f636e2feab996a28cb21c5906c30656f/tpchgen_cli-1.0.0-py3-none-macosx_11_0_arm64.whl (4.6 MB)
   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 4.6/4.6 MB 6.6 MB/s eta 0:00:00
Installing collected packages: tpchgen-cli
Successfully installed tpchgen-cli-1.0.0

(.venv) ➜  tpchgen-cli git:(main) tpchgen-cli -V
tpchgen 1.0.0

(.venv) ➜  tpchgen-cli git:(main) tpchgen-cli -h
TPC-H Data Generator

Usage: tpchgen-cli [OPTIONS]

Options:
  -s, --scale-factor <SCALE_FACTOR>
          Scale factor to address (default: 1) [default: 1]
  -o, --output-dir <OUTPUT_DIR>
          Output directory for generated files (default: current directory) [default: .]
  -T, --tables <TABLES>
          Which tables to generate (default: all) [possible values: region, nation, supplier, customer, part, partsupp, orders, lineitem]
  -p, --parts <PARTS>
          Number of parts to generate (manual parallel generation) [default: 1]
      --part <PART>
          Which part to generate (1-based, only relevant if parts > 1) [default: 1]
  -f, --format <FORMAT>
          Output format: tbl, csv, parquet (default: tbl) [default: tbl] [possible values: tbl, csv, parquet]
  -n, --num-threads <NUM_THREADS>
          The number of threads for parallel generation, defaults to the number of CPUs [default: 8]
  -c, --parquet-compression <PARQUET_COMPRESSION>
          Parquet block compression format. Default is SNAPPY [default: SNAPPY]
  -v, --verbose
          Verbose output (default: false)
      --stdout
          Write the output to stdout instead of a file
  -h, --help
          Print help (see more with '--help')
  -V, --version
          Print version

[kevinjqliu]

Project description on testpypi also looks good, thanks to #133

[kevinjqliu]

Merged #134. Now lets publish to pypi!

Github action https://github.com/clflushopt/tpchgen-rs/actions/runs/14552574729

[kevinjqliu]

Cool, the github action ran successfully.

I see the project is now published on pypi

https://pypi.org/project/tpchgen-cli/

And i can install and run it

(.venv) ➜  tpchgen-cli git:(kevinjqliu/publish-to-pypi) pip install tpchgen-cli
Collecting tpchgen-cli
  Downloading tpchgen_cli-1.0.0-py3-none-macosx_11_0_arm64.whl.metadata (2.4 kB)
Downloading tpchgen_cli-1.0.0-py3-none-macosx_11_0_arm64.whl (4.6 MB)
   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 4.6/4.6 MB 36.7 MB/s eta 0:00:00
Installing collected packages: tpchgen-cli
Successfully installed tpchgen-cli-1.0.0

(.venv) ➜  tpchgen-cli git:(kevinjqliu/publish-to-pypi) tpchgen-cli -V     
tpchgen 1.0.0

(.venv) ➜  tpchgen-cli git:(kevinjqliu/publish-to-pypi) tpchgen-cli   

(.venv) ➜  tpchgen-cli git:(kevinjqliu/publish-to-pypi) ✗ ls
__pycache__    customer.tbl   nation.tbl     part.tbl       pyproject.toml README.md      src            tmp
Cargo.toml     lineitem.tbl   orders.tbl     partsupp.tbl   python         region.tbl     supplier.tbl