HousewareHQ / data-engineering-octernship

6 stars 4 forks source link

doubts regarding end Result #5

Open Lazeeez opened 1 year ago

Lazeeez commented 1 year ago

Hey guys, I had a question regarding end result of this assignment.

Are we supposed to just code the whole assignment in python and create a API endpoint (I'm using Flask) locally or do we have to host it on a server and then submit the link?

@shubh24 @ashwinexe @nipunj15

Lazeeez commented 1 year ago

Currently, I wrote the python script to load the data from .csv to .db and then perform the operations on that .db file and create another .csv file (different files for different criteria) and save the result of those criteria in those files.

The script takes input from a .json file in the same directory and I also made the script very generalized so that it can take various different operations and not just the given criteria.

gaurav-2-0-0-2 commented 1 year ago

I have a question did you run the converted query on your database ?

Also, how are you posting the data, is it via query parameters, I am using postman to post the JSON data for criteria and console logging it in my terminal to show the converted query.

Lazeeez commented 1 year ago

@gaurav-2-0-0-2 yes, it prints out the result and also stores it into an output file provided in the .json

gaurav-2-0-0-2 commented 1 year ago

where are you printing those results in the console or at the page itself.

Lazeeez commented 1 year ago

@gaurav-2-0-0-2 it basically returns the result in the message, the return statement of the API

gaurav-2-0-0-2 commented 1 year ago

Oh, I'm actually using node.js express for writing the API and posting the request (the JSON data) via postman.

gaurav-2-0-0-2 commented 1 year ago

Are you using any tool like knex.js to convert JSON data into query or just the python code.

Lazeeez commented 1 year ago

core python and some other libraries

Lazeeez commented 1 year ago

Oh, I'm actually using node.js express for writing the API and posting the request (the JSON data) via postman.

did you host it somewhere orr are you running it locally?

gaurav-2-0-0-2 commented 1 year ago

I'm actually running it locally. I think they should also provide the info about it. I'm confused too.