Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Game of Day property to Backend #168

Closed
Tracked by #96
sonerkuyar opened this issue Apr 30, 2024 · 3 comments
Closed
Tracked by #96

Add Game of Day property to Backend #168

sonerkuyar opened this issue Apr 30, 2024 · 3 comments
Assignees
Labels
Component: Backend Issues related to server-side logic or infrastructure Priority: High This issue needs to be resolved ASAP
Milestone

Comments

@sonerkuyar
Copy link
Member

Description

For the game Page wrote a query and backend endpoint to extract genres, publishers, platform, country infos(attributes can get broaden).


Reviewer:

This issue will be reviewed by: @ahmetfirat23

@sonerkuyar sonerkuyar added Priority: High This issue needs to be resolved ASAP Component: Backend Issues related to server-side logic or infrastructure labels Apr 30, 2024
@sonerkuyar sonerkuyar self-assigned this Apr 30, 2024
@ahmetfirat23
Copy link
Contributor

SELECT DISTINCT ?gameLabel
WHERE {
?game wdt:P31 wd:Q7889; # Video game instance
rdfs:label ?gameLabel.
FILTER(LANG(?gameLabel) = "en").
}
ORDER BY RAND()
LIMIT 1

this query selects a random game name, it is a bit slow but it should be run once per day so i dont think it should be huge a problem. please review before using it might be buggy.

@ahmetfirat23 ahmetfirat23 added this to the Milestone 4 milestone Apr 30, 2024
@sonerkuyar
Copy link
Member Author

Let's keep it for the final milestone. I dont want to break the code.

@isilsukarakuzuu isilsukarakuzuu mentioned this issue May 3, 2024
40 tasks
@ahmetfirat23
Copy link
Contributor

This issue is complete sorry I forgot to close it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Component: Backend Issues related to server-side logic or infrastructure Priority: High This issue needs to be resolved ASAP
Projects
None yet
Development

No branches or pull requests

2 participants