All relevant SQL code and command line code necessary for Rohith Banda's tryout project for Mr. Jordan Lee Boyd-Graber's internship. This goes along with the write up and a pre-requisite is that the baseline QANTA system already exists on your machine.
Associated Write Up:
https://docs.google.com/document/d/1jS-Boe32R5YPvIoGUaAKdBh_hMonQqPawsW7f9fhTak/edit?usp=sharing
Baseline QANTA system:
https://github.com/Pinafore/qanta-codalab
This SQL file performs 3 steps. It creates the table "trainableformat", creates the function called "get_token", and inserts values into "trainableformat" by consolidating data from existing table data. This file is to be executed only after the full QuizDB dataset is downloaded. (Refer to associated write-up). NOTE: you may need to change the username according to how PostgreSQL is set up on your machine.
This file contains 5 CLI commands that can be executed to convert the data from "trainableformat" to a JSON file. NOTE: Replace {absolute filepath} with the appropriate download filepath for your machine. Replace {username} with appropriate PostgreSQL username.
For a complete list of references, take a look at the associated write-up.