fix: 将 SQLite 连接池从 QueuePool 切换为 NullPool，解决多用户并发访问时连接池耗尽问题 #29
Workflow file for this run
This file contains hidden or 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: release | |
| on: | |
| push: | |
| tags: | |
| # PanWatch tags are like 0.2.3 (no "v" prefix) | |
| - '*.*.*' | |
| workflow_dispatch: | |
| inputs: | |
| version: | |
| description: 'Docker tag to publish (e.g. 0.2.3)' | |
| required: true | |
| type: string | |
| push_latest: | |
| description: 'Also push :latest' | |
| required: false | |
| type: boolean | |
| default: true | |
| platforms: | |
| description: 'Target platforms' | |
| required: false | |
| type: string | |
| default: 'linux/amd64,linux/arm64' | |
| env: | |
| IMAGE_NAME: sunxiao0721/panwatch | |
| jobs: | |
| docker: | |
| runs-on: ubuntu-latest | |
| permissions: | |
| contents: write | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 0 | |
| - name: Resolve version | |
| id: vars | |
| shell: bash | |
| run: | | |
| set -euo pipefail | |
| if [[ "${{ github.event_name }}" == "workflow_dispatch" ]]; then | |
| version="${{ inputs.version }}" | |
| push_latest="${{ inputs.push_latest }}" | |
| platforms="${{ inputs.platforms }}" | |
| else | |
| version="${{ github.ref_name }}" | |
| push_latest="true" | |
| platforms="linux/amd64,linux/arm64" | |
| fi | |
| version_no_v="$version" | |
| if [[ "$version" == v* ]]; then | |
| version_no_v="${version#v}" | |
| fi | |
| echo "version=$version" >> "$GITHUB_OUTPUT" | |
| echo "version_no_v=$version_no_v" >> "$GITHUB_OUTPUT" | |
| echo "push_latest=$push_latest" >> "$GITHUB_OUTPUT" | |
| echo "platforms=$platforms" >> "$GITHUB_OUTPUT" | |
| - name: Set up QEMU | |
| uses: docker/setup-qemu-action@v3 | |
| - name: Set up Docker Buildx | |
| uses: docker/setup-buildx-action@v3 | |
| - name: Log in to Docker Hub | |
| uses: docker/login-action@v3 | |
| with: | |
| username: ${{ secrets.DOCKERHUB_USERNAME }} | |
| password: ${{ secrets.DOCKERHUB_TOKEN }} | |
| - name: Docker metadata | |
| id: meta | |
| uses: docker/metadata-action@v5 | |
| with: | |
| images: ${{ env.IMAGE_NAME }} | |
| tags: | | |
| type=raw,value=${{ steps.vars.outputs.version }} | |
| type=raw,value=${{ steps.vars.outputs.version_no_v }},enable=${{ steps.vars.outputs.version_no_v != steps.vars.outputs.version }} | |
| type=raw,value=latest,enable=${{ steps.vars.outputs.push_latest == 'true' }} | |
| labels: | | |
| org.opencontainers.image.title=PanWatch | |
| org.opencontainers.image.version=${{ steps.vars.outputs.version }} | |
| org.opencontainers.image.source=${{ github.repositoryUrl }} | |
| - name: Build and push | |
| uses: docker/build-push-action@v6 | |
| with: | |
| context: . | |
| file: ./Dockerfile | |
| platforms: ${{ steps.vars.outputs.platforms }} | |
| push: true | |
| tags: ${{ steps.meta.outputs.tags }} | |
| labels: ${{ steps.meta.outputs.labels }} | |
| build-args: | | |
| VERSION=${{ steps.vars.outputs.version }} | |
| cache-from: type=gha | |
| cache-to: type=gha,mode=max | |
| - name: Generate release notes (tag push only) | |
| if: ${{ github.event_name == 'push' }} | |
| shell: bash | |
| run: | | |
| set -euo pipefail | |
| current="${{ steps.vars.outputs.version }}" | |
| repo="${{ github.repository }}" | |
| # Find previous tag by semver sort (best effort). | |
| prev="" | |
| while IFS= read -r t; do | |
| if [[ "$t" != "$current" ]]; then | |
| prev="$t" | |
| break | |
| fi | |
| done < <(git tag --list --sort=-v:refname) | |
| echo "Current tag: $current" | |
| if [[ -n "$prev" ]]; then | |
| echo "Previous tag: $prev" | |
| range="$prev..$current" | |
| else | |
| echo "Previous tag: (none)" | |
| range="$current" | |
| fi | |
| { | |
| echo "## Docker" | |
| echo "- $IMAGE_NAME:$current" | |
| echo "- $IMAGE_NAME:latest" | |
| echo "" | |
| echo "## Commits" | |
| if [[ -n "$prev" ]]; then | |
| echo "Compare: https://github.com/$repo/compare/$prev...$current" | |
| echo "" | |
| echo "Changes since $prev:" | |
| echo "" | |
| # Non-merge commits only (exclude MR/PR merges). | |
| git log --no-merges --pretty=format:'- %s (%h)' "$range" || true | |
| else | |
| echo "First release tag." | |
| fi | |
| echo "" | |
| } > release-notes.md | |
| - name: Create GitHub Release (tag push only) | |
| if: ${{ github.event_name == 'push' }} | |
| uses: softprops/action-gh-release@v2 | |
| with: | |
| tag_name: ${{ steps.vars.outputs.version }} | |
| body_path: release-notes.md | |
| - name: Send Telegram notification | |
| if: ${{ github.event_name == 'push' }} | |
| continue-on-error: true | |
| env: | |
| TELEGRAM_BOT_TOKEN: ${{ secrets.TELEGRAM_BOT_TOKEN }} | |
| TELEGRAM_CHAT_ID: ${{ secrets.TELEGRAM_CHAT_ID }} | |
| run: | | |
| TAG="${{ steps.vars.outputs.version }}" | |
| RELEASE_URL="https://github.com/${{ github.repository }}/releases/tag/${TAG}" | |
| # 获取 commit 变更列表 | |
| PREV_TAG=$(git tag --list --sort=-version:refname | grep -v "^${TAG}$" | head -n1) | |
| if [ -n "$PREV_TAG" ]; then | |
| COMMITS=$(git log --no-merges --pretty=format:"- %s" "$PREV_TAG"..HEAD) | |
| else | |
| COMMITS=$(git log --no-merges --pretty=format:"- %s") | |
| fi | |
| # 转义 Markdown 特殊字符，然后进行 URL 编码 | |
| COMMITS_ESCAPED=$(echo "$COMMITS" | sed 's/\*/\\*/g; s/_/\\_/g; s/\[/\\[/g; s/\]/\\]/g; s/`/\\`/g') | |
| COMMITS_ENCODED=$(echo "$COMMITS_ESCAPED" | sed 's/$/%0A/g' | tr -d '\n') | |
| # 构建消息 | |
| MESSAGE="📊 *PanWatch ${TAG}* 发布%0A%0A" | |
| MESSAGE="${MESSAGE}🔗 [查看完整说明](${RELEASE_URL})%0A%0A" | |
| MESSAGE="${MESSAGE}*变更内容*:%0A${COMMITS_ENCODED}" | |
| # 发送到 Telegram | |
| if [ -n "${TELEGRAM_BOT_TOKEN:-}" ] && [ -n "${TELEGRAM_CHAT_ID:-}" ]; then | |
| curl -s -X POST "https://api.telegram.org/bot${TELEGRAM_BOT_TOKEN}/sendMessage" \ | |
| -d "chat_id=${TELEGRAM_CHAT_ID}" \ | |
| -d "text=${MESSAGE}" \ | |
| -d "parse_mode=Markdown" \ | |
| -d "disable_web_page_preview=true" | |
| echo "✅ Telegram notification sent successfully!" | |
| else | |
| echo "⚠️ Telegram credentials not configured, skipping notification" | |
| fi |