Skip to content
.github/workflows/new-lgp-revision.yml

Revert "fix: right endpoint" #10

Sign in to view logs

Revert "fix: right endpoint"

Revert "fix: right endpoint" #10

Workflow file for this run

.github/workflows/new-lgp-revision.yml at 63eab96
# name: Production Deployment & Cleanup
# # Trigger on PR close/merge to main
# on:
# pull_request:
# branches: [ main ]
# types: [ closed ]
# # Set environment variables
# env:
# PYTHON_VERSION: '3.11'
# REGISTRY: docker.io
# IMAGE_NAME: perinim98/text2sql-agent
# LANGSMITH_API_KEY: ${{ secrets.LANGSMITH_API_KEY }}
# OPENAI_API_KEY: ${{ secrets.OPENAI_API_KEY }}
# # Add permissions for PR comments
# permissions:
# contents: read
# pull-requests: write
# issues: write
# packages: write
# jobs:
# # Job 1: Cleanup preview deployment
# cleanup-preview:
# runs-on: ubuntu-latest
# steps:
# - name: Checkout repository
# uses: actions/checkout@v4
# with:
# fetch-depth: 0
# - name: Set up Python
# uses: actions/setup-python@v4
# with:
# python-version: ${{ env.PYTHON_VERSION }}
# - name: Install uv
# uses: astral-sh/setup-uv@v1
# with:
# version: "latest"
# - name: Cache uv dependencies
# uses: actions/cache@v3
# with:
# path: |
# .uv/cache
# .venv
# key: ${{ runner.os }}-uv-cleanup-${{ hashFiles('**/pyproject.toml') }}
# restore-keys: |
# ${{ runner.os }}-uv-cleanup-
# - name: Install dependencies
# run: uv sync
# - name: Install requests
# run: pip install requests
# - name: Cleanup preview deployment
# run: |
# python .github/scripts/langgraph_api.py \
# --action cleanup-preview \
# --pr-number ${{ github.event.pull_request.number }} \
# --api-key ${{ secrets.LANGSMITH_API_KEY }}
# # Job 2: Build and push production Docker image (only if PR was merged)
# build-and-push:
# needs: cleanup-preview
# if: github.event.pull_request.merged == true
# runs-on: ubuntu-latest
# permissions:
# contents: read
# packages: write
# steps:
# - name: Checkout repository
# uses: actions/checkout@v4
# - name: Set up Docker Buildx
# uses: docker/setup-buildx-action@v3
# - name: Log in to Docker Hub
# uses: docker/login-action@v3
# with:
# registry: ${{ env.REGISTRY }}
# username: ${{ secrets.DOCKER_USERNAME }}
# password: ${{ secrets.DOCKER_PASSWORD }}
# - name: Extract metadata
# id: meta
# uses: docker/metadata-action@v5
# with:
# images: ${{ env.REGISTRY }}/${{ env.IMAGE_NAME }}
# tags: |
# type=raw,value=latest
# type=sha,prefix=main-
# labels: |
# org.opencontainers.image.title=Text2SQL Agent
# org.opencontainers.image.description=Text-to-SQL Agent built with LangGraph
# org.opencontainers.image.vendor=Text2SQL Agent
# - name: Build and push production Docker image
# uses: docker/build-push-action@v5
# with:
# context: .
# file: ./dockerfiles/Dockerfile
# push: true
# tags: ${{ steps.meta.outputs.tags }}
# labels: ${{ steps.meta.outputs.labels }}
# platforms: linux/amd64,linux/arm64
# cache-from: type=gha
# cache-to: type=gha,mode=max
# build-args: |
# PYTHON_VERSION=${{ env.PYTHON_VERSION }}
# BUILD_DATE=${{ fromJSON(steps.meta.outputs.json).labels['org.opencontainers.image.created'] }}
# VERSION=${{ fromJSON(steps.meta.outputs.json).labels['org.opencontainers.image.version'] }}
# - name: Output image details
# run: |
# echo "🐳 Production Docker image built and pushed successfully!"
# echo "📦 Image: ${{ env.REGISTRY }}/${{ env.IMAGE_NAME }}"
# echo "🏷️ Tags: ${{ steps.meta.outputs.tags }}"
# # Job 3: Deploy to production (only if PR was merged)
# deploy-production:
# needs: [cleanup-preview, build-and-push]
# if: github.event.pull_request.merged == true
# runs-on: ubuntu-latest
# steps:
# - name: Checkout repository
# uses: actions/checkout@v4
# - name: Set up Python
# uses: actions/setup-python@v4
# with:
# python-version: ${{ env.PYTHON_VERSION }}
# - name: Install uv
# uses: astral-sh/setup-uv@v1
# with:
# version: "latest"
# - name: Cache uv dependencies
# uses: actions/cache@v3
# with:
# path: |
# .uv/cache
# .venv
# key: ${{ runner.os }}-uv-prod-${{ hashFiles('**/pyproject.toml') }}
# restore-keys: |
# ${{ runner.os }}-uv-prod-
# - name: Install dependencies
# run: uv sync
# - name: Install requests
# run: pip install requests
# - name: Deploy to production
# run: |
# python .github/scripts/langgraph_api.py \
# --action deploy-production \
# --image-uri ${{ env.REGISTRY }}/${{ env.IMAGE_NAME }}:latest \
# --api-key ${{ secrets.LANGSMITH_API_KEY }} \
# --openai-api-key ${{ secrets.OPENAI_API_KEY }}
# # Generate deployment status report
# - name: Generate deployment status report
# run: |
# python .github/scripts/report_deployment.py \
# --deployment-name text2sql-agent-prod \
# --image-uri ${{ env.REGISTRY }}/${{ env.IMAGE_NAME }}:latest \
# --deployment-type production
# # Comment PR with deployment status
# - name: Comment PR with production deployment status
# uses: actions/github-script@v7
# with:
# script: |
# const fs = require('fs');
# try {
# const comment = fs.readFileSync('deployment_comment.md', 'utf8');
# await github.rest.issues.createComment({
# issue_number: context.issue.number,
# owner: context.repo.owner,
# repo: context.repo.repo,
# body: comment
# });
# } catch (error) {
# console.log('Failed to read deployment comment file:', error.message);
# // Fallback comment
# await github.rest.issues.createComment({
# issue_number: context.issue.number,
# owner: context.repo.owner,
# repo: context.repo.repo,
# body: `🚀 **Production Deployment Status**\n\n✅ Production deployment completed!\n🔗 Production URL: https://text2sql-agent-prod.langchain.dev\n📦 Docker image: ${{ env.REGISTRY }}/${{ env.IMAGE_NAME }}:latest`
# });
# }
# - name: Production deployment success
# run: |
# echo "✅ Production deployment completed!"
# echo "🔗 Production URL: https://text2sql-agent-prod.langchain.dev"
# echo "📦 Docker image: ${{ env.REGISTRY }}/${{ env.IMAGE_NAME }}:latest"