python-ci.yml

name: Python CI

on:
  push:
    branches:
      - main
  workflow_dispatch:  

jobs:
  build:
    runs-on: ubuntu-latest

    steps:
    - name: Use Node.js 16
      uses: actions/setup-node@v4
      with:
        node-version: '16'

    - name: Checkout repository
      uses: actions/checkout@v2.5.0

    - name: Set up Python
      uses: actions/setup-python@v2
      with:
        python-version: 3.x

    - name: Install dependencies
      run: |
        python -m pip install --upgrade pip
        pip install -U xlrd pandas requests beautifulsoup4 Babel

    - name: Install openpyxl
      run: |
        python -m pip install openpyxl

    - name: Run Python script
      run: |
        python conab.py
        
    - name: List files after running Python script
      run: ls -R
      
    - name: Upload CSVs as artifacts
      uses: actions/upload-artifact@v2
      with:
        name: csv-files
        path: milhototal.csv soja.csv

    - name: Commit and Push CSV files
      run: |
        git config user.name 'github-actions[bot]'
        git config user.email 'github-actions[bot]@users.noreply.github.com'
        git add milhototal.csv soja.csv
        git commit -m "Add generated CSV files"
        git push