759:ERD generation

Test Case #:759

Test Case Name: ERD generation

System: OpenLmis

Subsystem: auth

Test case designed by: Paulina Borowa

Design Date:03.08.2016

Short description: Acceptance:

* Generate ERD for all schema.  Work with dev team on whether these are per service, or can be combined into a consolidated view.  Or both.* ERD is automatically generated, either with each service or as a separate build job * Default tech choice is SchemaSpy - open to alternatives. * Publish link to ERD(s) for all to enjoy

                                                                                                                                                   

Pre – conditions:

                                                                                                                                                                                                                                                       


Step 

Action

Expected system response

Comment

1

Go to:

http://ci.openlmis.org/erd-auth/

                                                                          

Appears SchemaSpy Analysis of Database open_lmis view:  

                                                 

2

Choose from Schema →public

 

Appears SchemaSpy Analysis of open_lmis.public view:

 Appears SchemaSpy Analysis of open_lmis.public - All Relationships view:

 

3

Check Realtionships bookmark:

 

 

 

4

At: http://ci.openlmis.org/erd-requisition/

 

 

Appears SchemaSpy Analysis of Database open_lmis view:

 

 

5

Go to: Schema →referencedata

 

Appears SchemaSpy Analysis of open_lmis.referencedata view:

 
 

6

Check Realtionships bookmark

 

 

Appears SchemaSpy Analysis of open_lmis.referencedata - All Relationships view:

 

 

7

Back to Schemas bookmark and chose requisition

 

appears SchemaSpy Analysis of open_lmis.requisition view:

 

 

8

                    

Check Realtionships bookmark

                            

 

Appears SchemaSpy Analysis of open_lmis.requisition - All Relationships view

 

 

OpenLMIS: the global initiative for powerful LMIS software