Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create a Mastr.translate method #461

Closed
1 task done
FlorianK13 opened this issue Aug 9, 2023 · 1 comment · Fixed by #471
Closed
1 task done

Create a Mastr.translate method #461

FlorianK13 opened this issue Aug 9, 2023 · 1 comment · Fixed by #471
Assignees
Labels
👐 help wanted Extra attention is needed 🚀 feature New feature or request

Comments

@FlorianK13
Copy link
Member

Description of the issue

We could now implement a translation method for the Mastr database, where all columns are translated to english. Thanks to LLMs like chatgpt we would not need to translate it on our own.

Ideas of solution

  1. Create a list of all distinct column names of all tables.
  2. Pass this list to chatGPT asking for a translation of every item.
  3. Create a dictionary with translations. If new columns are added and not available in the dict, they shall not be translated.

Workflow checklist

@FlorianK13 FlorianK13 added 🚀 feature New feature or request 👐 help wanted Extra attention is needed labels Aug 9, 2023
@FlorianK13 FlorianK13 self-assigned this Aug 9, 2023
@FlorianK13
Copy link
Member Author

I think this could be solved as follows:

  1. Get a list of all column names from all tables, either by connecting to an existing database or by using the orm.py file and according sqlalchemy methods.
  2. Transfer this list to a set.
  3. Go to your favourite LLM and create a translation dictionary from this set of column names.
  4. Implement a Mastr.translate method that takes the downloaded database, iterates over all tables and all columns and translates them. The database should then be renamed to open_mastr_translated.db so that the open_mastr module will not try to work with it again when writing new data to this database.

@FlorianK13 FlorianK13 linked a pull request Nov 2, 2023 that will close this issue
5 tasks
FlorianK13 added a commit to Grazvy/open-MaStR that referenced this issue Nov 2, 2023
FlorianK13 added a commit that referenced this issue Nov 3, 2023
Create Mastr.translate method #461
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
👐 help wanted Extra attention is needed 🚀 feature New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant