Skip to content

Instantly share code, notes, and snippets.

View nwgambee's full-sized avatar

Noah Gambee nwgambee

6 followers · 2 following
View GitHub Profile
@nwgambee
nwgambee / la_waiver_queries.md
Created November 20, 2024 18:01
finalized LA auto show waiver query

adult waiver

UPDATE `autoshowtracker`.`shows` SET `waiver` = '{\n  \"en\": \"**PARTICIPANT AGREEMENT, RELEASE AND ASSUMPTION OF RISK**\\n\\nIn consideration of being permitted to participate in the Activities (as defined below) and the services of **Releasees,** Ford Motor Company, LA Auto Show, ANSA Productions, AEG Management LACC LLC, the City of Los Angeles, ASM Global Parent Inc., their agents, owners, officers, volunteers, participants, employees, Exhibit Works, Inc. d/b/a EWI Worldwide and all other persons or entities acting in any capacity on their behalf **(hereinafter collectively referred to as \\\"Releasees\\\"),** I hereby agree to release, indemnify, and discharge the above named, on behalf of myself, my spouse, domestic partner, my children, my parents, my heirs, assignees, personal representatives and estate as follows:\\n\\nI acknowledge that participation in the following activities (\\\"Activities\\\") entail both known and unanticipated risks that could result in physical or emotio
@nwgambee
nwgambee / pfg_1217.txt
Last active August 1, 2023 17:06
PFG-1217
UPDATE `pfg`.`events` SET `waiver` = '{\n \"english\": {\n \"body\": \"Date: ____________\\nEvent City: Palo Alto, CA\\nADULT RELEASE OF CLAIMS, HOLD HARMLESS AND INDEMNITY AGREEMENT; AND WAIVERS\\nIn Consideration of, and as a condition to being permitted to participate in the \'Palo Alto Festival of the Arts- Test Drive Experience\' (\'Event\'), the undersigned (\'Driver or Passenger\') for himself/herself, his/her personal representatives, heirs and next of kin, acknowledges, represents and agrees as follows:\\n1. Driver/Passenger Representations: Driver/Passenger represents and warrants that he/she:\\n a) Possesses a currently valid driver\'s license, is 18 years of age or older, and is a citizen or legal resident of the United States;\\n b) can see and hear well enough to operate and Ride along in a motor vehicle properly and safely on public roadways and in off-roadway driving and is wearing any eye wear or hearing apparatus required to operate a motor vehicle properly and safely;\\n c)
@nwgambee
nwgambee / 2023 Bronco tour custom q's
Created April 17, 2023 16:22
UPDATE `pfg`.`events` SET `custom_questions` = '[\n {\n \"key\": \"bronco_order_holder\",\n \"type\": \"radio\",\n \"format\": \"extra_large\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Yes\"\n },\n \"value\": \"Yes\"\n },\n {\n \"label\": {\n \"en\": \"No\"\n },\n \"value\": \"No\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"Are you a Bronco owner or order holder?\"\n },\n \"required\": true,\n \"orientation\": \"column\"\n },\n {\n \"key\": \"engaged_with_ps\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Yes\"\n },\n \"value\": \"Yes\"\n },\n {\n \"label\": {\n
@nwgambee
nwgambee / pure_cup_23_details.md
Last active January 17, 2023 22:02
Pure Cup 2023 Logistics Update

Logistics Update

Dates (July 1st-5th)

  • Check-in begins 5pm on July 1st
  • Check-out before our round on the morning of July 5th
  • First round of the Pure Cup is 9am @ The Highlands on the 2nd

Package

@nwgambee
nwgambee / ford_raiders_custom_q.txt
Last active September 9, 2022 15:01
UPDATE `pfg`.`events` SET `custom_questions` = '[{\n \"key\": \"sweeps_optin\", \n \"type\": \"checkbox\", \n \"appOrWeb\": \"both\", \n \"question\": \"Please enter me in the Ford Bronco Off Roadeo-Nevada Giveaway\", \n \"required\": false, \n \"rulesData\": {\n \"rulesURL\": \"https://d2n145t5d2n6zs.cloudfront.net/2022/nfl/Ford_Raiders_Roadeo_rules.pdf", \n \"rulesText\": \"I agree that I am 18 years of age or older. I agree that I have read and that I accept the \", \n \"rulesTextHyperlink\": \"Official Giveaway Rules.\"\n }, \n \"disclaimer\": \"No purchase necessary. Must be a legal resident of Clark County, Nevada and have an active/valid driver’s license at the time of entry. The Sweepstakes begins at 12:00:01 a.m. Pacific Time (“PT”) on September 18, 2022 and ends at 11:59:59 p.m. PT on December 18, 2022. Void where prohibited. Official Rules, available at site.\"\n}]' WHERE (`event_id` IN (701199, 701194, 701193, 701197, 701200, 701196, 701198, 701195));
@nwgambee
nwgambee / bronco_reg_custom_q.txt
Last active August 29, 2022 19:20
Updated Bronco Registration Custom Question query
UPDATE `pfg`.`events` SET `custom_questions` = '[{\"key\": \"how_likely_acquire\", \"type\": \"radio\", \"answers\": [{\"label\": {\"en\": \"Own\", \"es\": \"\"}, \"value\": \"Purchase\"}, {\"label\": {\"en\": \"Lease\", \"es\": \"\"}, \"value\": \"Lease\"}], \"appOrWeb\": \"both\", \"question\": {\"en\": \"Do you own or lease your current vehicle?\", \"es\": \"\"}, \"required\": true, \"app_survey_key\": \"purchaseType\", \"web_survey_key\": \"how_likely_acquire\"}, {\"key\": \"in_market_timing\", \"type\": \"radio\", \"answers\": [{\"label\": {\"en\": \"0-30 Days\", \"es\": \"\"}, \"value\": \"0-30 Days\"}, {\"label\": {\"en\": \"1-3 Months\", \"es\": \"\"}, \"value\": \"1-3 Months\"}, {\"label\": {\"en\": \"4-6 Months\", \"es\": \"\"}, \"value\": \"4-6 Months\"}, {\"label\": {\"en\": \"7+ Months\", \"es\": \"\"}, \"value\": \"7+ Months\"}, {\"label\": {\"en\": \"No Definite Plans\", \"es\": \"\"}, \"value\": \"No Definite Plans\"}], \"appOrWeb\": \"both\", \"question\": {\"en\": \"When do you plan to purch
@nwgambee
nwgambee / maverick_zip_codes.csv
Created July 20, 2022 15:36
PFG-1063
90017 90071 90015 90014 90070 90189 90099 90030 90050 90051 90052 90053 90054 90055 90060 90072 90074 90075 90076 90078 90080 90081 90082 90083 90086 90087 90088 90093 90009 90013 90057 90079 90006 90012 90021 90007 90026 90089 90011 90005 90033 90010 90020 90029 90004 90031 90037 90018 90096 90062 90023 90058 90063 90019 90038 90065 90039 90028 90001 90036 90032 90008 90016 90255 90027 90003 91204 90270 90043 90042 91205 90022 91209 91221 91222 91224 91225 91226 91754 90048 91210 90044 90041 90211 90002 90035 90068 90047 91803 90091 90305 91203 90046 90302 90040 90056 90201 90069 91030 90232 90231 90306 90307 90308 90309 90310 90312 90311 91804 90034 91801 91393 90209 90213 90212 91031 91608 91522 91756 91521 90301 91523 91202 91802 91896 91899 91714 91715 90202 91206 91716 91105 90230 90280 90067 91755 91201 90303 90061 90059 91123 90262 91506 91602 91502 90640 90222 90064 91503 91507 91508 91510 91526 90210 91778 90304 91207 91604 91102 91109 91110 91114 91115 91116 91117 91118 91121 91124 91125 91126 9112
@nwgambee
nwgambee / voice hive_scanning.md
Created June 16, 2022 18:27
Sheriff event badge scanning query 
UPDATE `pfg`.`events` SET `custom_data` = '{\"voicehive\": {\"apiKey\": \"8de066494cf9f468a4f5984ecb108afd\"}}' WHERE (`event_id` = '701082');
@nwgambee
nwgambee / IACLEA_scanning.md
Last active June 16, 2022 16:34
IACLEA scanning json 
UPDATE `pfg`.`events` SET `custom_data` = '{\n    \"cvent\": {\n        \"apiKey\": \"51289ae4-6bd1-4555-b141-c93ba3eea3a1\",\n        \"secret\": \"BJoZWgYbQtunV8KqTuct/A==\",\n        \"eventID\": \"04be7def-c553-4f2e-8656-b3e62b58b193\",\n        \"accountID\": \"128952\",\n        \"exhibitorID\": \"87637dc3-5216-4fc9-9ef1-07e7e2a411ef\"\n    }\n}' WHERE (`event_id` = '701081');
@nwgambee
nwgambee / makes_models_queries.md
Last active May 23, 2022 16:27
queries for May 2022 makes/models update

NEW MAKES

  • active for currently drive and purchase intention
INSERT INTO `vehicles`.`makes` (`make`, `active`, `currently_drive`, `purchase_intention`, `ffs_code`, `ffs_1349`, `sort_top`) VALUES ('Fisker', 1, 1, 1, 'OTH', 'R', 0), ('Kandi', 1, 1, 1, 'OTH', 'R', 0), ('Karma', 1, 1, 1, 'OTH', 'R', 0);

PURCHASE INTENTION UPDATES/REMOVALS

  • no removals for currently drive
  • 1 one-off addition of an existing model for purchase intention (3477)