Skip to content

Instantly share code, notes, and snippets.

View mford22392's full-sized avatar

Madeline Ford Ryerson mford22392

View GitHub Profile
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');
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": [
// 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"
},
{
"anonymousId": "a890490b-15bd-4bef-a426-3a4725529b27",
"context": {
"ip": "76.120.111.18",
"library": {
"name": "analytics.js",
"version": "3.11.4"
},
"locale": "en-US",
"page": {
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"]
# 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
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
}
[
{
"key": "next_step",
"weight": 100,
"children": [
{
"key": "quiz",
"weight": 0,
"children": null
},
{
"data": {
"portal_data": {
"error": "Service unavailable."
},
"eligibility_data": {
"error": "Service unavailable",
"eligible": null,
"eligibilityCriteria": []
},
{
"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",