Problem/Motivation
I've added 4 collections at this point. And each of those results in a new code pools table in the DB. I don't think we want that. This will result in thousands of tables.

Proposed resolution
Only use a single table per plugin type?
Remaining tasks
User interface changes
API changes
Data model changes
Release notes snippet
| Comment | File | Size | Author |
|---|---|---|---|
| Screenshot from 2020-04-02 15-51-12.png | 17.53 KB | heddn |
Issue fork codes_pool-3124589
Show commands
Start within a Git clone of the project using the version control instructions.
Or, if you do not have SSH keys set up on git.drupalcode.org:
Comments
Comment #2
sbergmann commented@heddn I believe we don't want one great table, here are some of my thoughts as to why we want the codes pools as seperate tables.
Comment #3
sbergmann commented@heddn @vijaycs85
After reviewing this some more we have decided that we will want to make bundles of codes pools. Each Bundle would be stored as a single large table and be able to reference it's own sources. The sources could have specific constraints which will allow for handling unique codes uploaded on a per bundle level table, as well as constraints on the source of the pool data. This way we'll be able to have a more reusable codes pool module.
ie. A Codes pool could be used to dispense codes, or simple to store codes, prospect emails, phone numbers, etc for use in granting access or verification method for a tool.
In having a large table per bundle we will solve the issue of creating a new table for each code collection, as we will only create a new table on the bundle level.
Comment #4
heddnThat seems really reasonable. Thanks for pondering this.
Comment #7
vijaycs85Comment #9
vijaycs85