Madeline Ford Ryerson mford22392

mford22392 / pepsi_investigation.sql

Last active July 12, 2023 23:28

	SELECT DISTINCT(employee_id) FROM BI_BASE.ETL.STG_EMPLOYER_SERVICE__EMPLOYEE_LIVE WHERE
	EMPLOYER_ID = '9297466f-7d4c-4553-9eb6-1464b2a2e51a'
	AND eligibility:employer_specified_status = 'N'
	AND employment:status IN('T', 'Terminated');


	SELECT DISTINCT(employee_id) FROM BI_BASE.ETL.STG_EMPLOYER_SERVICE__EMPLOYEE_LIVE WHERE
	EMPLOYER_ID = '9297466f-7d4c-4553-9eb6-1464b2a2e51a'
	AND employment:status IN('T', 'Terminated');

mford22392 / programs_and_apps.py

Created May 28, 2020 21:21

	class ProgramsAndApplicationsAccordion:
	def __init__(self, data_store):
	self.data_store = data_store
	self.default = self.programs_and_applications_tabs_default()

	def calculate_weights(self):
	weights = {
	"key": "programs_and_applications",
	"weight": 90,
	"children": [

mford22392 / keybindings.json

Created April 25, 2020 19:19

	// Place your key bindings in this file to override the defaultsauto[]
	[
	{
	"key": "cmd+k left",
	"command": "-workbench.action.moveActiveEditorGroupLeft"
	},
	{
	"key": "cmd+k left",
	"command": "workbench.action.splitEditorRight"
	},

mford22392 / exampleHomeLayout.json

Last active April 22, 2020 00:49

mford22392 / sample.py

Created April 16, 2020 16:11

	from services.weighting_service import WeightingService
	from tests.unit.test_utility import sort_keys, set_data

	def test_default():
	influencer_answer = "I want to go back to school, and I know what type of program, degree, or certificate I want to complete"
	apps_to_finish = True
	completed_apps = True
	coach_recs = ["foo"]
	bookmarks = ["foo"]
	quiz_results = ["foo"]

mford22392 / Ex_2.py

Last active April 2, 2020 14:51

	# Note how you could easily make 50 the default, and have the elif statement return default
	# while the else statement returns hard coded 40... it sort of makes "default" lose its meaning...
	class ContactComponent(WeightedComponent):
	def calculate_weight(self):
	if seeking_reimbursement:
	return 70
	elif unsure:
	return 50
	else:
	return self.default_weight # 40

mford22392 / Ex_1.py

Last active April 2, 2020 14:51

	def reimbursement_weights(self):
	return {
	"reimbursement": 80,
	"contact": 70,
	"coach_recommendations": 60 if self.coach_recommendations else 0,
	"bookmarks": 50 if self.bookmarks else 0,
	"quiz_recommendations": 40 if self.quiz_results else 0,
	"quiz": 0
	}

mford22392 / Weights - as of March 30

Last active March 30, 2020 20:03

mford22392 / Available Home Data - Error States - March 25

Last active March 25, 2020 19:37

mford22392 / Available Home Data - March 24

Last active March 24, 2020 22:56

	{
	"data": {
	"portal_data": {
	"first_name": "Madeline",
	"last_name": "Ryerson",
	"phone": "917-699-5885",
	"email": "madeline+graphql@guildeducation.com",
	"state": "Connecticut",
	"prior_education_experience": "Earned a high school diploma",
	"how_can_we_help_you": "I'd like to submit reimbursement costs for existing programs",