jkkummerfeld / text2sql-data

A collection of datasets that pair questions with SQL queries.
http://jkk.name/text2sql-data/
Other
534 stars 105 forks source link

Tool to create spider sqlite databases. #55

Closed prasad83 closed 7 months ago

prasad83 commented 1 year ago

Create sqlite database files required for evaluating spider.

python tools/spider_schema_to_sqlite.py
Output: databases/*.sqlite files
mv databases /path/to/taoyds/spider
cd /path/to/taoyds/spider
python evaluation.py --gold evaluation_examples/gold_example.txt 
--pred evaluation_examples/pred_example.txt 
--etype all --table evaluation_examples/examples/tables.json --db databases
jkkummerfeld commented 1 year ago

Thank you for this contribution! I will test it and merge once confirming it also works for me. Note - that may take a few weeks as I am in the middle of semester, teaching a large NLP class.

jkkummerfeld commented 7 months ago

Thanks for your contribution! And sorry it took me so long to test it out and merge it.