Scrape Instagram, Update Events DB, Update Static Data #195
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: Scrape Instagram, Update Events DB, Update Static Data | |
| on: | |
| schedule: | |
| - cron: '0 13 * * *' # 8am EST (UTC-5) | |
| workflow_dispatch: | |
| inputs: | |
| username: | |
| description: 'Instagram username to scrape' | |
| required: true | |
| type: string | |
| jobs: | |
| instagram_feed: | |
| runs-on: ubuntu-latest | |
| permissions: | |
| contents: write | |
| env: | |
| # --- Django & App Config --- | |
| PRODUCTION: '1' | |
| DJANGO_SETTINGS_MODULE: 'config.settings.development' | |
| SECRET_KEY: ${{ secrets.SECRET_KEY }} | |
| CLERK_SECRET_KEY: ${{ secrets.CLERK_SECRET_KEY }} | |
| # --- Database Config --- | |
| DATABASE_URL: ${{ secrets.SUPABASE_DB_URL }} | |
| SUPABASE_DB_URL: ${{ secrets.SUPABASE_DB_URL }} | |
| POSTGRES_DB: ${{ secrets.POSTGRES_DB }} | |
| POSTGRES_USER: ${{ secrets.POSTGRES_USER }} | |
| POSTGRES_PASSWORD: ${{ secrets.POSTGRES_PASSWORD }} | |
| POSTGRES_HOST: ${{ secrets.POSTGRES_HOST }} | |
| POSTGRES_PORT: ${{ secrets.POSTGRES_PORT }} | |
| # --- Service Keys --- | |
| OPENAI_API_KEY: ${{ secrets.OPENAI_API_KEY }} | |
| AWS_ACCESS_KEY_ID: ${{ secrets.AWS_ACCESS_KEY_ID }} | |
| AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_SECRET_ACCESS_KEY }} | |
| AWS_S3_BUCKET_NAME: ${{ secrets.AWS_S3_BUCKET_NAME }} | |
| AWS_DEFAULT_REGION: ${{ secrets.AWS_DEFAULT_REGION }} | |
| RESEND_API_KEY: ${{ secrets.RESEND_API_KEY }} | |
| RESEND_FROM_EMAIL: ${{ secrets.RESEND_FROM_EMAIL }} | |
| EMAIL_ENCRYPTION_KEY: ${{ secrets.EMAIL_ENCRYPTION_KEY }} | |
| EMAIL_HASH_KEY: ${{ secrets.EMAIL_HASH_KEY }} | |
| # --- Apify Token --- | |
| APIFY_API_TOKEN: ${{ secrets.APIFY_API_TOKEN }} | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Set up Python | |
| uses: actions/setup-python@v5 | |
| with: | |
| python-version: '3.11' | |
| - name: Create logs directory | |
| working-directory: backend/scraping | |
| run: mkdir -p logs | |
| - name: Cache pip | |
| uses: actions/cache@v4 | |
| with: | |
| path: ~/.cache/pip | |
| key: ${{ runner.os }}-pip-${{ hashFiles('backend/requirements.txt') }} | |
| restore-keys: | | |
| ${{ runner.os }}-pip- | |
| - name: Install dependencies | |
| working-directory: backend | |
| run: | | |
| pip install --prefer-binary -r requirements.txt | |
| - name: Run scraper | |
| working-directory: backend/scraping | |
| env: | |
| SCRAPE_USERNAME: ${{ github.event.inputs.username }} | |
| run: | | |
| python -u instagram_feed.py 2>&1 | tee logs/scraping.log | |
| continue-on-error: false | |
| - name: Upload logs as artifacts | |
| if: always() | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: logs-${{ github.run_number }} | |
| path: | | |
| backend/scraping/logs/events_scraped.csv | |
| backend/scraping/logs/scraping.log | |
| backend/scraping/apify_raw_results.json | |
| if-no-files-found: 'ignore' | |
| - name: Generate static data file | |
| id: generate_static | |
| working-directory: backend/scraping | |
| run: python generate_static_data.py | |
| - name: Commit and push changes | |
| if: steps.generate_static.outcome == 'success' | |
| run: | | |
| git config --global user.name 'github-actions[bot]' | |
| git config --global user.email 'github-actions[bot]@users.noreply.github.com' | |
| git add frontend/src/data/staticData.ts frontend/public/rss.xml | |
| git commit -m "chore: update static data from DB" || echo "No changes to commit" | |
| git pull --rebase && git push --force |