wofdb
a database for every version of "wheel of fortune"
very much a work in progress. The design is a mess, but this is not how it is intended to look. It need more and better styling, but that comes when the backend stuff is all finished.
latest update: people
I did not like the way I made the database and site, so I am rebuilding all of it. Categories have been redone. Check it out.
database and model model changes have led to some errors in how data is displayed. Seasons, for example, are duplicated in list due to updates resulting in cartesian joins. It needs to be fixed, but I want to finalize schema and normalize database first.
still to come
- editing/adding data
- practice using the puzzles
- more in depth data for each round
- other stuff? possibly!
api preview
One of the goals for the site is an api to easily find and use information in the database. puzzle endpoint is partly functional. Only returns JSON at this time.
GET http://wofdb.com/api/beta/puzzle
the parameters for puzzle endpoint
- keyword
- type: string
- keyword to find in the puzzle.
- Uses SQL LIKE. Searches are not bounded by word beginning or ending.
keyword=the will return all of the following: "the", "there", and "other"
- Separate multiple keywords with the pipe character (|):
keyword=this|that|another.
- versionSlug
- type: string
- the slug of version desired. found through version endpoint that does not exist yet.
- separate multiple versions with pipe character (|):
versionSlug=wheel-of-fortune-syndication
- versionId
- type: integer, pipe separated integers, or range of integers separated by dash (x-y)
- version ID number. supports searching multiple versions using pipe to separate different versions.
- separate multiple versions with pipe character (|):
versionId=1|4|19
- search a range of versions using dash:
versionId=1-3
- pipe and range can be combined:
versionId=1|4-6|8|10
- season
- type: integer, pipe separated integers, or range of integers separated by dash (x-y)
- season(s) to return. Only valid for versions with seasons.
- separate multiple seasons with pipe character (|):
season=37|40|1</dd>
- search a range of seasons using dash:
versionId=36-40
- pipe and range can be combined:
season=1-5|10|20|30|36-40
- episode
- type: integer, pipe separated integers, or range of integers separated by dash (x-y)
- Episode number for that season. Only valid for versions with episodes.
- separate multiple episodes using pipe character (|):
episode=1|195
- search a range of episodes using dash:
episode=1-20
- pipe and range can be combined:
episode=1-10|51-60|186-195
- categorySlug
- type: string
- Slugs of categories to include. supports searching multiple categories using pipe as separator.
- Separate multiple categories with pipe character (|):
categorySlug=person|place|thing
- categoryId
- type: integer, pipe separated integers, or range of integers separated by dash (x-y)
- Category ID number.
- separate multiple category IDs with pipe character (|):
categoryId=1|3|9
- search a range of category IDs using dash:
categoryId=9-15
- pipe and range can be combined:
categoryId=2|4-10|20-22
- from
- type: date (yyyy-mm-dd)
- Start date of episode airdates to include:
from=2020-09-01
- until
- type: date (yyyy-mm-dd)
- End date of episode airdates to include:
until=1990-12-25
- minLetters
- type: integer
- Minimum number of letters in puzzles to return. Does not include spaces or punctuation.
- Example:
minLetters=30
- maxLetters
- type: integer
- Maximum number of letters in puzzles to return. Does not include spaces or punctuation.
- Example:
maxLetters=11
- minLength
- type: integer
- Minimum length of puzzle to return, including spaces and punctuations.
- Example:
minLength=30
- maxLength
- type: integer
- Maximum length of puzzle to return, including spaces and punctuations.
- Example:
maxLength=11
- minWords
- type: integer
- Minimum number of words in the puzzle.
- Example:
minWords=5
- maxWords
- type: integer
- Maximum number of words in the puzzle.
- Example:
maxWords=3
- rows
- type: integer
- Maximum number of rows to return per page. Default is 50. Maximum is 250.
- Example:
rows=200
- page
- type: integer
- start page to include. Default is 1. For ease of iterating, response includes meta->currentPage and meta->maxPage.
- Example:
page=4
- showDetails
- type: boolean
- Most values for true and false work: true/false, t/f, yes/no, y/n, 1/0. Default is false. When set to false, response data only includes puzzle, category->name, and clue (if applicable).
- Example:
showDetails=true
example requests:
https://wofdb.com/api/beta/puzzle?keyword=christmas|thanksgiving|easter|fourth of july
https://wofdb.com/api/beta/puzzle?versionId=1|3&categorySlug=thing&page=3&rows=10