Skip to content

Instantly share code, notes, and snippets.

@sebjamesfd
Last active February 8, 2018 15:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sebjamesfd/acd9cb2f0c3943eafcebb479425a3224 to your computer and use it in GitHub Desktop.
Save sebjamesfd/acd9cb2f0c3943eafcebb479425a3224 to your computer and use it in GitHub Desktop.
gist to update null event category
update event set category="THREE_POINT" where category is NULL;
select * from event where category is NULL;
+-----+------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------+-------------+-------+----------+--------+----------------+
| id | name | description | short_description | probability | type | category | gen_id | is_second_half |
+-----+------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------+-------------+-------+----------+--------+----------------+
| 141 | Five Three-Pointers In A Row | Five three-pointers made in a row during three-point contest | 3PT: 5 In A Row | 1 | EVENT | NULL | 80 | 0 |
| 142 | Three Money Balls In A Row | Three money balls made in a row during three-point contest | 3 Money Balls In A Row | 1 | EVENT | NULL | 81 | 0 |
| 143 | Player Makes 5+ Money Balls | Player makes five or more money balls in a round during three-point contest | 5+ Money Balls | 1 | EVENT | NULL | 82 | 0 |
| 144 | Three-Point Score Under 10 | Total three-point contest score under 10 points | 3PT: Score Under 10 | 1 | EVENT | NULL | 83 | 0 |
| 145 | Three-Point Score Over 20 | Total three-point contest score over 20 points | 3PT: Score Over 20 | 1 | EVENT | NULL | 84 | 0 |
| 146 | Three-Point Shooter Runs Out Of Time | Clock expires while player is shooting during three-point contest | 3PT: Shooter Out of Time | 1 | EVENT | NULL | 85 | 0 |
| 147 | Repeat Three-Point Champion | Previous three-point champion wins the three-point contest (Eric Gordon or Klay Thompson) | 3PT: Repeat Champion | 1 | EVENT | NULL | 86 | 0 |
| 148 | Two Consecutive Shooters Score Over 15 Points In One Round of Three-Point Contest | Two consecutive shooters score over 15 points in one round of three-point contest | 3PT: B2B Scores Over 15 | 1 | EVENT | NULL | 87 | 0 |
| 149 | Three-Point Winner Over 30 Years Old | Three-Point Winner is 30 Years or Older (Wayne Ellington or Kyle Lowry) | 3PT: 30+ Year Old Champ | 1 | EVENT | NULL | 88 | 0 |
| 150 | Perfect Three-Pointer Rack | Player makes all balls in one rack during three-point contest | 3PT: Perfect Rack | 1 | EVENT | NULL | 89 | 0 |
| 151 | Money Ball Rack at Top of Key | Money ball rack is placed at the top of the key for three-point contest participant | Money Balls Top Of Key | 1 | EVENT | NULL | 90 | 0 |
| 152 | Three-Pointer Made Off of Backboard During Three-Point Contest | Player makes a three-pointer off of the backboard during the three-point contest | 3PT: Bank Shot | 1 | EVENT | NULL | 91 | 0 |
| 153 | Three-Point Goggles During Three-Point Contest | Broadcast shows current of former NBA player displaying "three-point goggles" with their fingers during the three-point contest | 3PT: Three Goggles | 1 | EVENT | NULL | 92 | 0 |
| 154 | Player Makes Opening Shot In Three-Point Contest | Player makes opening shot during three-point contest | 3PT: First Shot Made | 1 | EVENT | NULL | 93 | 0 |
| 155 | Tiebreaker Shoot Off In Three-Point Contest | Tiebreaker shoot off in any round of the three-point contest | 3PT: Tiebreaker Shoot Off | 1 | EVENT | NULL | 94 | 0 |
+-----+------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------+-------------+-------+----------+--------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment