-
Notifications
You must be signed in to change notification settings - Fork 0
Open
Description
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.
Metadata
Metadata
Assignees
Labels
No labels