The aim of this project was to handle some queries using a local sqlite database after connecting to the server by a token provided and using an API. The sort of queries are related to comparison among game dataset, so to compare them, we utilize a csv file to import into our sqlite database. The background language is Django.
In above picture, we are gonna respond to the queries by sqlite statements, retrieving from the database and send the respond in a Json format using API to the user.
in the project, we dont kill time on implementing a UI for the user, however, to check the result and validating them, we use Postman software which is an API platform for developers.
the next step is signing up...so we send a post request using postman to our django project, and here what we got:
using MVC modelhere is gettoken function to associate a token for each user in the admin folder of our project.
AS we have games in our csv dataset, we need to request by sqlite statement and retrieve related records
to answer a query like:
Five BestGame For One Platform In Particular Year???
using token put into header, we request using postman
and here is the background what I did using MVC or sometimes Sqlite commands!
hope of finishing this project soon...!
Thank you sincerely for being with me