Extract_and_Load_Data #98

	---
	name: Extract_and_Load_Data

	on:
	schedule:
	- cron: '00 16 * * *' # Rodar todos os dias às 12:00 (UTC)

	jobs:
	extract_load_data:
	runs-on: ubuntu-latest

	steps:
	- name: Checkout repository
	uses: actions/checkout@v2

	- name: Set up Python
	uses: actions/setup-python@v2
	with:
	python-version: 3.11

	- name: Install FreeTDS driver
	run: \|
	sudo apt-get update
	sudo apt-get install -y freetds-dev

	- name: Install ODBC Driver 17 for SQL Server
	run: \|
	sudo su \
	&& curl https://packages.microsoft.com/keys/microsoft.asc \| apt-key add - \
	&& curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list > /etc/apt/sources.list.d/mssql-release.list \
	&& exit \
	&& sudo apt-get update \
	&& sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17

	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install requests pyodbc python-dotenv

	- name: Run Extract and Load Data
	env:
	base_url: ${{ secrets.BASE_URL }}
	api_token: ${{ secrets.API_TOKEN }}
	Server: ${{ secrets.SERVER }}
	database: ${{ secrets.DATABASE }}
	UID: ${{ secrets.UID }}
	PWD: ${{ secrets.PWD }}
	run: python .venv/extract_deals_insert.py

Provide feedback