Integrate Scribe-Data SQLite DBs

[andrewtavis]

Terms

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

Description

As discussed in #1, we need to include the SQLite databases that are present in Scribe-Data/scribe_data_sqlite_export. The goal of this issue would be to import these DBs into the project, but them in an appropriate location where they would be accessible by the rest of the app, and code a simple call to the databases. The call could be as simple as typing a word in the nouns table would then cause its gender or plural to then be inserted into the GUI's text :)

Contribution

Happy to check this and assist as needed! Questions for how this should work are welcome 😊

[henrikth93]

I am interested

[andrewtavis]

@RyanPaulGannon, @henrikth93: One thing that we need to discuss here is where the data will live within the application. Specifically we will have a data directory like Scribe-Android. We also need to check the suggested structure of Rust projects in general and make sure that we're following best practices :)

[andrewtavis]

We also need to remember to add the current version of the data contracts at that time :)

[henrikth93]

Terms

• I have searched open and closed feature requests[x] I agree to follow Scribe-Desktop's Code of Conduct

Description

As discussed in #1, we need to include the SQLite databases that are present in Scribe-Data/scribe_data_sqlite_export. The goal of this issue would be to import these DBs into the project, but them in an appropriate location where they would be accessible by the rest of the app, and code a simple call to the databases. The call could be as simple as typing a word in the nouns table would then cause its gender or plural to then be inserted into the GUI's text :)

Contribution

Happy to check this and assist as needed! Questions for how this should work are welcome 😊
https://github.com/scribe-org/Scribe-Data/tree/main/scribe_data_sqlite_export
That link does not seem to work.

[andrewtavis]

Those have been deleted from Scribe-Data as the point is that it makes them, it doesn't have them. I'd copy over the DBs from Scribe-Android/tree/main/app/src/main/assets/data once we decide where they go :)

[andrewtavis]

I think it's fine that we have the data in a scribe/src/data directory for now as we can just move it whenever, and this is what I saw as a suggestion in a few places :) Added them in in e1de03c, and by the looks of it testing/implementation of using these should leverage rusqlite/rusqlite 😊