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

Convert food and food group IDs from strings to ints #171

Open
bglusman opened this issue Nov 1, 2017 · 0 comments
Open

Convert food and food group IDs from strings to ints #171

bglusman opened this issue Nov 1, 2017 · 0 comments

Comments

@bglusman
Copy link
Collaborator

bglusman commented Nov 1, 2017

Possibly a bit tedious, but we only used strings for stricter compatibility with USDA DB, and if we make this work as a mix task or something we should be able to run on future imports of their DB pretty easily too, since they are logically integers, just sometimes zero-prefixed etc, and with internal references using the string based primary keys... ideally we'd preserve those relationships, but frankly dropping the other tables besides those two is also an acceptable option as we're not using any other tables from DB at present. Dealing with future goals like showing aggregate nutritional info for orders would leverage them, but we can deal with that when the time comes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant