Last active
February 8, 2018 15:12
-
-
Save sebjamesfd/acd9cb2f0c3943eafcebb479425a3224 to your computer and use it in GitHub Desktop.
gist to update null event category
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
update event set category="THREE_POINT" where category is NULL; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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
To match enum at:
https://github.com/fanduel/bingo/blob/master/bingo_service_api/src/main/java/com/fanduel/bingo/constants/BingoEventCategory.java#L12