borozcod/baller-stats-stack

aws cdk stack for baller stats

baller-stats-stack's Issues

Develop python script for exctracting game week data

Update Needed

Build upon the current python function to get the data from each game week

Lambda function: ./lib/lambda/python/app.py

Running the function

# from inside ./lib/lambda/python/
pip install -r requirements.txt
python app.py

I'm using Python 3.9.13 and pip 22.2.2, for reference. Should work with Python ≥ 3.5

Additional Notes

I was thinking we could just make another function called getGameWeek() and add it here

baller-stats-stack/lib/lambda/python/app.py

Lines 15 to 17 in e7e45f1

	def handler(event, context):
	getLeagueLeaders()

This function gets the data in csv format from google sheets

baller-stats-stack/lib/lambda/python/app.py

Lines 18 to 30 in e7e45f1

	def getCSV(sheet_name):
	google_sheet = {
	"id": os.environ.get('BS_SHEET_ID'),
	"sheet": sheet_name
	}
	# Get the sheet as csv
	google_sheet_url = "https://docs.google.com/spreadsheets/d/" + google_sheet["id"] +"/gviz/tq?tqx=out:csv&sheet=" + google_sheet['sheet']
	res = requests.get(google_sheet_url)
	csvStringIO = StringIO(res.text)
	return csvStringIO

For developing locally this should create the files in your local machine

baller-stats-stack/lib/lambda/python/app.py

Lines 71 to 80 in e7e45f1

	#local development
	if(os.environ.get('LOCAL_PATH')):
	abs_path = os.path.abspath(os.environ.get('LOCAL_PATH') + file_path)
	file = abs_path + "/" + file_name
	os.makedirs(abs_path, exist_ok=True)
	with open(file, "w") as f:
	f.write(body)
	return

Note that this directory is ignored for testing purposes

baller-stats-stack/.gitignore

Line 13 in e7e45f1

lib/lambda/python/test-data