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

Refactor ReleaseDB schema (and name) #12

Open
mjuric opened this issue Jul 10, 2015 · 1 comment
Open

Refactor ReleaseDB schema (and name) #12

mjuric opened this issue Jul 10, 2015 · 1 comment

Comments

@mjuric
Copy link
Owner

mjuric commented Jul 10, 2015

The SQL schema used by the cache of built packages is a horrible mess. It needs to be refactored and normalized. I think the right schema is something along the lines of:

Products:
    prod_id, name, version
Packages:
    pkg_id,   prod_id, channel_id,   buildnum, filename, recipe_hash
Channels:
   channel_id, urlbase

with a many-to-many relationship from Products->Packages and a one-to-many from Channels->packages

While at it, the ReleaseDB class should also be renamed to something like BuiltProductsCache.

@mjuric
Copy link
Owner Author

mjuric commented Jan 28, 2016

ReleaseDB has been renamed to RecipeDB

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

No branches or pull requests

1 participant