@@ -75,11 +75,9 @@ async def fetch_language(id: int):
7575 },
7676 status_code = 201 ,
7777 response_class = utils .JSONResponse ,
78+ dependencies = [has_permissions ([ManageWeeklyChallengeLanguages ()])],
7879)
79- async def create_language (
80- body : NewChallengeLanguageBody ,
81- _ = has_permissions ([ManageWeeklyChallengeLanguages ()]),
82- ):
80+ async def create_language (body : NewChallengeLanguageBody ):
8381 """Create a weekly challenge language."""
8482
8583 await check_piston_language_version (body .piston_lang , body .piston_lang_ver )
@@ -116,12 +114,9 @@ async def create_language(
116114 409 : {"description" : "Language with that name already exists" },
117115 },
118116 status_code = 204 ,
117+ dependencies = [has_permissions ([ManageWeeklyChallengeLanguages ()])],
119118)
120- async def update_language (
121- id : int ,
122- body : UpdateChallengeLanguageBody ,
123- _ = has_permissions ([ManageWeeklyChallengeLanguages ()]),
124- ):
119+ async def update_language (id : int , body : UpdateChallengeLanguageBody ):
125120 """Update a weekly challenge language."""
126121
127122 query = "SELECT * FROM challengelanguages WHERE id = $1"
@@ -167,10 +162,9 @@ async def update_language(
167162 404 : {"description" : "Language not found" },
168163 },
169164 status_code = 204 ,
165+ dependencies = [has_permissions ([ManageWeeklyChallengeLanguages ()])],
170166)
171- async def delete_language (
172- id : int , _ = has_permissions ([ManageWeeklyChallengeLanguages ()])
173- ):
167+ async def delete_language (id : int ):
174168 """Delete a weekly challenge language, if it hasn't been used in any challenges."""
175169 query = "SELECT * FROM challengelanguages WHERE id = $1"
176170 record = await ChallengeLanguage .pool .fetchrow (query , id )
@@ -181,7 +175,7 @@ async def delete_language(
181175 # language = ChallengeLanguage(**record)
182176
183177 query = """
184- SELECT * FROM challenges WHERE $1 = ANY( language_ids)
178+ SELECT * FROM challenges WHERE $1 IN language_ids
185179 """
186180 records = await ChallengeLanguage .pool .fetch (query , id )
187181 if records :
0 commit comments