Test spreadsheet standard and ticket creation code
See Below Attachment for Sample spreadsheet
Background
What fields do we need?
Do we want to loop based on some of the input
How can we make the spreadsheet code-readable?
What important data did i leave out?
Fields available:
- Issue number (will be created)
- Ticket Summary
- Ticket Type (story/sub-task)
- Story Points
- Label
- Sprint
- Component
- Affects Version
- Fix Version
- Epic
- Ticket Description
Proposed Fields in the spreadsheet
- Component
- Ticket summary (test desc < 100 chars)
- Test description
- Story Points
- Comments
- EL6 (Y if required)
- EL7 (Y if required)
Process csv → Jira → csv → new confluence page!
Conversion Code would:
- The version can be passed in via command line (e.g. "6.4.0-Beta") as the whole set of tests is relevant - this would be the "Fix Version
- Copy ticket summary into the summary field
- If component is present, copy that in to the component field
- If EL6 == "Y" then concatenate "EL6" and Test description to description field
- If EL7 == "Y" then concatenate "EL7" and Test description
- If neither EL6 or EL7 is set, just use the test description
- Story points need to go into the command
- Create the ticket!
- Maybe write all the data into a new spreadsheet with the ticket number?
- Then copy/paste the spreadsheet into confluence
Start with this table and edit, then upload to testing confluence page. The code can be run and we'll update confluence.
Sample csv or confluence table:
Component | Summary | EL6 | EL7 | Description | Comment | Story Points | Ticket numbers (added later) |
---|---|---|---|---|---|---|---|
pupmod-simp-simp | rake beaker:suites works for all suites using current Puppetfile | Y | Run the pupmod-simp-simp acceptance tests for the tagged version of pupmod-simp-simp included in simp-6.2.0RC1, using the appropriate tagged versions of all dependencies in its .fixtures.yml.
| 1 | SIMP-11235 | ||
simp-core | rake beaker:suites works for all suites using current Puppetfile | Y | Y | Run the following test suites with/without FIPS for CentOS6 and CentOS7 (as appropriate): Suite Category Description Notes Result FIPS Result not FIPS Gliffy Diagrams | 2 | SIMP-11236, SIMP-11237 | |
Validate that the compliance maps do not have errors on enforcement | Loop over all enforcement modes, and verify the catalog compiles. If it does not compile, there is a type error that will need to be fixed. | A test was added to the default test suite in simp-core for this | 1 | SIMP-11238 |
Creates these tickets:
SIMP-11236 Summary: EL6 - rake beaker:suites works for all suites using current Puppetfile Component: pupmod-simp-simp Description: Run the pupmod-simp-simp acceptance tests for the tagged version of pupmod-simp-simp included in simp-6.2.0RC1, using the appropriate tagged versions of all dependencies in its .fixtures.yml. Procedures to generate .fixtures.yml with tagged versions from the simp-core Puppetfile This will error-out for the simp module, because of entries in the .fixtures file the rake task can't figure out yet (simp-environment and simp-rsync). However, it will tell you the location of a generated fixtures file that contains entries for nearly all the dependencies, with appropriate URLS and tags from the Puppetfile.tracking. Edit the generated fixtures file to include the missing, special fixtures. Fix Version: 6.4.0 Story Points: 1 Comment: |
SIMP-11237 Summary: EL6 - rake beaker:suites works for all suites using current Puppetfile Component: simp-core Description: Run the following test suites with/without FIPS for CentOS6 and CentOS7 (as appropriate): Suite Category Description Notes Result FIPS Result not FIPS Gliffy Diagrams Fix Version: 6.4.0 Story Points: 1 Comment: |
SIMP-11238 Summary: EL7 - rake beaker:suites works for all suites using current Puppetfile Component: simp-core Description: Run the following test suites with/without FIPS for CentOS6 and CentOS7 (as appropriate): Suite Category Description Notes Result FIPS Result not FIPS Gliffy Diagrams Fix Version: 6.4.0 Story Points: 2 Comment: |
SIMP-11239 Summary: Validate that the compliance maps do not have errors on enforcement Component: Description: Loop over all enforcement modes, and verify the catalog compiles. If it does not compile, there is a type error that will need to be fixed. Fix Version: 6.4.0 Story Points: 1 Comment: A test was added to the default test suite in simp-core for this |
Action items
- ensure we have the necessary fields
- decide whether to use yaml or csv
- decide what repo to use (suggestion: a folder in https://github.com/simp/releng-misc wit the csvs as well as the ruby)
- make it happen!