Add docs for Python Table Engine #8
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Build Linux X86 | |
| on: | |
| workflow_dispatch: | |
| inputs: | |
| TAG_NAME: | |
| description: 'Release Version Tag' | |
| required: true | |
| release: | |
| types: [created] | |
| push: | |
| branches: | |
| - main | |
| paths-ignore: | |
| - '**/*.md' | |
| pull_request: | |
| branches: | |
| - main | |
| paths-ignore: | |
| - '**/*.md' | |
| jobs: | |
| build_wheels_linux: | |
| name: ${{ matrix.os }} py${{ matrix.python-version }} | |
| runs-on: gh-64c | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| os: [ ubuntu-22.04 ] | |
| python-version: [ "3.8", "3.9", "3.10", "3.11", "3.12" ] | |
| # python-version: [ "3.7" ] | |
| env: | |
| RUNNER_OS: ${{ matrix.os }} | |
| PYTHON_VERSION: ${{ matrix.python-version }} | |
| steps: | |
| - name: Install python | |
| uses: actions/setup-python@v4 | |
| with: | |
| python-version: "${{ matrix.python-version }}" | |
| - name: Install clang++ for Ubuntu | |
| if: matrix.os == 'ubuntu-22.04' | |
| run: | | |
| pwd | |
| uname -a | |
| wget https://apt.llvm.org/llvm.sh | |
| chmod +x llvm.sh | |
| sudo ./llvm.sh 18 | |
| which clang++-18 | |
| clang++-18 --version | |
| sudo apt-get install -y make cmake ccache ninja-build yasm gawk wget | |
| ccache -s | |
| - name: Update git | |
| run: | | |
| sudo add-apt-repository ppa:git-core/ppa -y | |
| sudo apt-get update | |
| sudo apt-get install -y git | |
| git --version | |
| - uses: actions/checkout@v3 | |
| with: | |
| fetch-depth: 0 | |
| - name: Restore submodules cache | |
| uses: actions/cache/restore@v3 | |
| id: cache | |
| with: | |
| path: | | |
| contrib/** | |
| key: | | |
| submodule-${{ hashFiles('.gitmodules') }} | |
| - name: Update submodules if cache miss | |
| if: steps.cache.outputs.cache-hit != 'true' | |
| run: | | |
| git submodule update --init --recursive --jobs 4 | |
| - name: Save submodules cache | |
| if: steps.cache.outputs.cache-hit != 'true' | |
| uses: actions/cache/save@v3 | |
| with: | |
| path: | | |
| contrib/** | |
| key: | | |
| submodule-${{ hashFiles('.gitmodules') }} | |
| - name: ccache | |
| uses: hendrikmuhs/[email protected] | |
| with: | |
| key: ${{ matrix.os }} | |
| max-size: 5G | |
| append-timestamp: true | |
| - name: remove old clang and link clang-18 to clang | |
| if: matrix.os == 'ubuntu-22.04' | |
| run: | | |
| sudo rm -f /usr/bin/clang || true | |
| sudo ln -s /usr/bin/clang-18 /usr/bin/clang | |
| sudo rm -f /usr/bin/clang++ || true | |
| sudo ln -s /usr/bin/clang++-18 /usr/bin/clang++ | |
| which clang++ | |
| clang++ --version | |
| - name: Run chdb/build.sh | |
| run: | | |
| python3 -m pip install pybind11 setuptools | |
| export CC=/usr/bin/clang | |
| export CXX=/usr/bin/clang++ | |
| bash ./chdb/build.sh | |
| python3 -m pip install pandas pyarrow | |
| bash -x ./chdb/test_smoke.sh | |
| continue-on-error: false | |
| - name: Run libchdb stub in examples dir | |
| run: | | |
| bash -x ./examples/runStub.sh | |
| - name: Check ccache statistics | |
| run: | | |
| ccache -s | |
| ls -lh chdb | |
| df -h | |
| - name: Install dependencies for building wheels | |
| run: python3 -m pip install -U pip tox pybind11 twine setuptools wheel | |
| - name: Build wheels | |
| run: | | |
| export CC=/usr/bin/clang | |
| export CXX=/usr/bin/clang++ | |
| make wheel | |
| - name: Install patchelf from github | |
| run: | | |
| wget https://github.com/NixOS/patchelf/releases/download/0.18.0/patchelf-0.18.0-x86_64.tar.gz -O patchelf.tar.gz | |
| tar -xvf patchelf.tar.gz | |
| sudo cp bin/patchelf /usr/bin/ | |
| sudo chmod +x /usr/bin/patchelf | |
| patchelf --version | |
| - name: Audit wheels | |
| run: | | |
| python3 -m pip install auditwheel | |
| auditwheel -v repair -w dist/ --plat manylinux2014_x86_64 dist/*.whl | |
| continue-on-error: false | |
| - name: Show files | |
| run: | | |
| sudo rm -f dist/*-linux_x86_64.whl | |
| ls -lh dist | |
| shell: bash | |
| - name: Run tests | |
| run: | | |
| python3 -m pip install dist/*.whl | |
| python3 -m pip install pandas pyarrow psutil | |
| python3 -c "import chdb; res = chdb.query('select 1112222222,555', 'CSV'); print(res)" | |
| make test | |
| continue-on-error: false | |
| - name: Upload wheels to release | |
| if: startsWith(github.ref, 'refs/tags/v') | |
| run: | | |
| gh release upload ${{ github.ref_name }} dist/*.whl --clobber | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GH_TOKEN }} | |
| - name: Packege libchdb.so | |
| if: matrix.python-version == '3.12' | |
| run: | | |
| cp programs/local/chdb.h chdb.h | |
| tar -czvf linux-x86_64-libchdb.tar.gz libchdb.so chdb.h | |
| - name: Upload libchdb.so to release | |
| if: startsWith(github.ref, 'refs/tags/v') && matrix.python-version == '3.12' | |
| run: | | |
| gh release upload ${{ github.ref_name }} linux-x86_64-libchdb.tar.gz --clobber | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GH_TOKEN }} | |
| - uses: actions/upload-artifact@v3 | |
| with: | |
| path: | | |
| ./dist/*.whl | |
| ./linux-x86_64-libchdb.tar.gz | |
| - name: Upload pypi | |
| if: startsWith(github.ref, 'refs/tags/v') | |
| run: | | |
| python3 -m pip install twine | |
| python3 -m twine upload dist/*.whl | |
| env: | |
| TWINE_USERNAME: __token__ | |
| TWINE_PASSWORD: ${{ secrets.PYPI_PASSWORD }} | |