Sprout version 21 is currently intended to be the first version from which a PPO database can be generated. Among the changes were
- Ripping out the whole PCH family of tables in favor of the PCH server
- Adding a CDD table and putting CELLO data in the Feature table
- Converting all of the keyed array fields (feature alias, compound name, role EC number) into separate entities
This last was because PPO does not support keyed array fields. Because of this change, we should be able to generate a working PPO database from the NMPDR database definition, and this will give us a template to shoot for in accomplishing the integration.
In the meantime, I am working on bug fixes to the live NMPDR using the mirror version of NMPDR. One big problem was that the Sprout attribute call did not support the full capabilities of the new attribute system. This caused a problem with incorrect literature counts on the subsystem display page. In addition, it was causing CDD codes to appear in the evidence column for the commentary of a pin page.
The final problem has to do with an incompatibility of the diagrams. I hope to resolve this tomorrow and will then copy the mirror to the live site over the weekend.
It would be tricky, but possible, to reload the version 20 database to get the latest information. This would fix the problem with outdated abbreviations and stuff in the subsystems. It would also give us an opportunity to add serotypes to the names of the core genomes and possibly get any core genome updates out of the pipeline. At the current time, however, I am assuming this would not be done. Please correct me if I'm wrong.
Leave a comment