Language queries don't work yet

j127 commented 3 years ago

When querying on Slack for CW puzzles, languages aren't taken into account in the Django queries.

The q query will be a dictionary with a languages key that holds a Python list. The structure is like this:

{'languages': ['fortran', 'cobol', 'raku'], 'source': 'codewars', 'difficulty': 3}

The relevant data is stored as JSONB in Postgres. An example raw SQL query is:

SELECT original_raw_data ->> 'languages'
FROM puzzles_puzzle
WHERE source='Codewars'
LIMIT 1;
-- ["javascript", "haskell", "python", "rust"]

The Django query should return a puzzle that includes all of the languages that in listed in the q query.

See the notes that will be in apps/puzzles/puzzles.py.

j127 commented 3 years ago

Check out 9:20 in this video for how to do queries on JSON fields: https://www.youtube.com/watch?v=LbdUpY1I1zg

j127 commented 3 years ago

codeselfstudy / codeselfstudy_django