Design seed data levels

Description

Document and prepare the different levels of data out of the box that will be needed for the 3.0 Beta.

Current state: Seed data is included automatically at the system startup via SQL queries, located in the codebase. (@Sebastian Brudziński indicated this is the current process)

The seed/bootstrap data currently present in the system:

https://github.com/OpenLMIS/openlmis-requisition/blob/master/src/main/resources/schema.sql (creates database schema)
https://github.com/OpenLMIS/openlmis-requisition/blob/master/src/main/resources/initial_data.sql (contains order file templates and columns, order number configuration and available requisition columns)
https://github.com/OpenLMIS/openlmis-referencedata/blob/master/src/main/resources/schema.sql (creates database schema)
https://github.com/OpenLMIS/openlmis-referencedata/blob/master/src/main/resources/initial_data.sql (creates initial admin user)
https://github.com/OpenLMIS/openlmis-auth/blob/master/src/main/resources/schema.sql (creates database schema and tables required by Spring OAuth to work properly)
https://github.com/OpenLMIS/openlmis-auth/blob/master/src/main/resources/initial_data.sql (populates Spring OAuth tables with necessary data and admin user)

We have removed the definitions and separation of bootstrap/seed/demo data into its own ticket, OLMIS-1136, to come after beta. This ticket is just about making sure we have enough seed data to demo the system for 3.0 Beta, which Sebastian has now provided and documented.

Acceptance Criteria

Confirmation of where the seed data is currently coming from so we know what this contains for demo'ing the 3.0 Beta.

Attachments

Seed Data.xlsx

10 Oct, 2016

Linked work items

relates to

OLMIS-1093

Revise the demo data for publishing the 3.0 Beta

OLMIS-1136

Divide up bootstrap, seed & demo data build tasks

QAlity Plus - Test Management

Checklists

Activity

Mary Jo Kochendorfer

October 12, 2016 at 3:15 PM

Yes, thank you. Looks good to me.

Brandon Bowersox-Johnson

October 12, 2016 at 11:54 AM

@Mary Jo Kochendorfer Moving to In Review for you. I believe we can now close this ticket, per our meeting with Sebastian yesterday. I've created a new ticket for after beta, OLMIS-1136, and I've moved significant parts of the description from this ticket into that new one. I believe we can mark this ticket Done as long as you agree that you have what you need for Beta regarding seed data (and knowing that you have a separate ticket for beta demo data, https://openlmis.atlassian.net/browse/OLMIS-1093#icft=OLMIS-1093 as well).

Chongsun Ahn

October 11, 2016 at 8:35 AM

Assigning back to @Mary Jo Kochendorfer as I've filled in clarity about data levels in the story description.

Chongsun Ahn

October 11, 2016 at 5:06 AM

After some thought and discussion, we probably shouldn't use my made-up-on-the-fly term of "schema data;" it's more confusing than informational. Probably should call it something like "bootstrap data" or "system data." Bootstrap data because it is data needed to bootstrap the system, or system data since it is data owned by the system.

Mary Jo Kochendorfer

October 10, 2016 at 5:44 PM

@Sebastian Brudziński, @Ibtesam Sharif took a look at the database and found quite a few fields/data which could be schema/seed. Seems like much is copied over from 2.0 so it isn't clear which data is needed for 3.0. I know your team is already putting in the schema and seed data but it would be useful if we kept track of what the schema and seed data is. Would you be able to update the excel or point us to a location where we could review what schema/seed data is needed for beta? I have asked @Chongsun Ahn to provide definitions for the different levels of data so we are all clear and on the same page.

@Brandon Bowersox-Johnson fyi

Resize work item view side panel

Done

Pinned fields

Click on the next to a field label to start pinning.

Details

Assignee

Mary Jo Kochendorfer(Deactivated)

Reporter

Mary Jo Kochendorfer(Deactivated)

Time tracking

2h logged

Sprint

Add sprint

Fix versions

3.0 Beta

Priority

Major

Parent

OLMIS-584 OpenLMIS Dev and Build infrastructure

Time Assistant

Created August 10, 2016 at 6:23 PM

Updated November 12, 2016 at 11:36 AM

Resolved October 12, 2016 at 3:15 PM