Implement CLI query sqlite --output-type functionality via convert

[andrewtavis]

Terms

• I have searched open and closed feature requests
• I agree to follow Scribe-Data's Code of Conduct

Description

As discussed in the 24/5/2024 GSoC sync, we'd like Scribe-Data to be able to also export other file types besides JSONs. This issue would look into the exporting of .sqlite database files. The user would call --ouput-type sqlite (or .sqlite just to be sure), and then the resulting JSON files would be converted over to .sqlite data files. To be more explicit, Scribe-Data would first export JSON files as that's the baseline output file type, and then the convert process would run such that these filetypes are converted over to SQLite databases. The files in OUTPUT_DIR/German/ like nouns.json and verbs.json would be within a german.sqlite file with nouns and verbs tables.

• Note that this issue is blocked by Implement --output-dir and --overwrite functionality for a JSON file output #144
• Note further that the file scribe_data/load/data_to_sqlite.py is set up to do the conversions already, but may need to be reworked just a bit :)

Contribution

@mhmohona will be working on this as a part of GSoC 2024! ☀️ Please write in here so I can assign, and let us know if there's anything we can do to support!

[mhmohona]

gonna work on it!

[andrewtavis]

@mhmohona, quick check on things :) I think it make sense to have covert just be from JSON to SQLite, CSV or TSV. The user will always get a JSON at first and then this process can be one directional to what they want? Or can you think of cases where an SQLite Scribe-Data output should be changed to a CSV, etc?

[andrewtavis]

Closed by #163! The features are really coming along, @mhmohona! ☀️