End-user search queries on datasets (JSON)

The application aims to allow user to filter any dataset based on primary, secondary and tertiary filters generated by the application. A JSON file containing data and metadata is given as an input generating a set of filters based on the values contained in different columns.

Instructions

Frontend

• Move to the /frontend directory which contains the files required to run the frontend of the application.
• The following snippet can be used to run the frontend.

  yarn install
  yarn start
  

• The application can now be seen running on a local host.

Backend

• Move to the /backend directory which contains the files required to run the backend of the application.
• Install all the libraries with appropriate versions as mentioned in requirements.txt.

  pip3 install -r requirements.txt
  

• After all the libraries have been install, run wsgi.py to start the backend.

  python3 wsgi.py
  

Usage

While using the application, the uploaded .json file should meet the following requirements.

├── Json File
│   ├── "metadata" :[
│   │   ├── {"fieldName": <column name>, "dataType": <date/time/datetime/number/string>},
│   │   ├── {"fieldName": <column name>, "dataType": <date/time/datetime/number/string>},
│   │   ├── {"fieldName": <column name>, "dataType": <date/time/datetime/number/string>},
|   |   |
.   .   .
.   .   .
.   .   .
│   │   ├── {"fieldName": <column name>, "dataType": <date/time/datetime/number/string>}]
|   |   
│   ├── "data" : [
│   │   ├── {<column name> : <value>, <column name> : <value>, <column name> : <value>, ... , <column name> : <value>},
│   │   ├── {<column name> : <value>, <column name> : <value>, <column name> : <value>, ... , <column name> : <value>},
│   │   ├── {<column name> : <value>, <column name> : <value>, <column name> : <value>, ... , <column name> : <value>},
.   .   .
.   .   .
.   .   .
│   │   ├── {<column name> : <value>, <column name> : <value>, <column name> : <value>, ... , <column name> : <value>}]