s-pratyush / atlan-task

atlan-task

Problem Statement

Subtask 1

Design a sample schematic for how you would store forms (with questions) and responses (with answers) in the Collect data store. Forms, Questions, Responses and Answers each will have relevant metadata.

Approach

Schema -

The above image shows the schematic approach of implementation.So as we can see that the tables itself stores the metadata of the form,For ex. field table have columns like

• type - type of data to be accepted in this field
• mandate - if the feild is mandatory or not
• upper_ limit and lower_limit - to add constraint to the input

and many more which can be used to validate response.

APIs-

These are the REST APIs implemented using flask-restful, and are protected with JWT token based authentication.

Subtask 2

Design and implement a solution for the Google Sheets use case and choose any one of the others to keep in mind how we want to solve this problem in a plug-n-play fashion. Make fair assumptions wherever necessary.

Approach

For googlesheet plugin, the service is designed seperately using GoogleSheet API.

https://github.com/Pratyush-Saxena/atlan-task/blob/3d5759cf47c0225efded267c9dfe667570554258/plugins/googlesheet/__init__.py#L4-L38

So the Service can easily be called by initializing whenever needed

https://github.com/Pratyush-Saxena/atlan-task/blob/3d5759cf47c0225efded267c9dfe667570554258/collect/routes.py#L139-L180

Getting Started

1. Clone the repository

git clone https://github.com/Pratyush-Saxena/atlan-task.git

2. Run docker-compose

docker-compose up --build

3. Open Url http://127.0.0.1:5000/swagger-ui/#/default