Uploaded image for project: 'IGB'
  1. IGB
  2. IGBF-1568

Write script that updates database using info from OBR XML - repository.xml

        Details

        • Type: Task
        • Status: Closed (View Workflow)
        • Priority: Major
        • Resolution: Done
        • Affects Version/s: None
        • Fix Version/s: None
        • Labels:

          Description

          Write script (python) that reads relevant App information from OBR XML file "repository.xml" and imports data about Apps into App Store database.

          Specification:

          • Read XML, compare contents to database
          • Identify Apps via defining "coordinates" - bundle (App) version and symbolic name
          • If an App in XML also exists in database, check that the information contained in the XML matches what is in the database. If there is a difference, update it. Only compare relevant fields.

          Note: The database will contain info about Apps that is not in the XML, such as number of downloads, details about the authors, etc. Leave that stuff intact.

          • If an App in XML does not exist in the database, create new records for it in the database.

          Note that this script can update information about Apps and can also add entirely new Apps to the database.

          Implementation: Write this in python. Run/test on EC2. Can assume database is MySQL.

            Attachments

              Issue Links

              blocks

              New Feature - A new feature of the product, which has yet to be developed. IGBF-1521 Show existing apps on IGB AppStore

              • Major - Major loss of function.
              • Closed
              is blocked by

              Task - A task that needs to be done. IGBF-1567 Determine mappings between databases schema and repository.xml attributes and elements

              • Major - Major loss of function.
              • Closed
              relates to

              Bug - A problem which impairs or prevents the functions of the product. IGBF-1470 Create RDS database for development purpose

              • Major - Major loss of function.
              • Closed

                Activity

                Descending order - Click to sort in ascending order
                ann.loraine Ann Loraine made changes -
                Workflow Fall 2019 Workflow Update [ 20036 ] Revised Fall 2019 Workflow Update [ 22166 ]
                ann.loraine Ann Loraine made changes -
                Workflow Loraine Lab Workflow [ 18289 ] Fall 2019 Workflow Update [ 20036 ]
                ann.loraine Ann Loraine made changes -
                Assignee Sai Charan Reddy Vallapureddy [ svallapu ]
                ann.loraine Ann Loraine made changes -
                Resolution Done [ 10000 ]
                Status Pull Request Submitted [ 10101 ] Closed [ 6 ]
                svallapu Sai Charan Reddy Vallapureddy (Inactive) made changes -
                Assignee Sai Charan Reddy Vallapureddy [ svallapu ]
                svallapu Sai Charan Reddy Vallapureddy (Inactive) made changes -
                Status In Progress [ 3 ] Pull Request Submitted [ 10101 ]
                svallapu Sai Charan Reddy Vallapureddy (Inactive) made changes -
                Status Open [ 1 ] In Progress [ 3 ]
                ann.loraine Ann Loraine made changes -
                Rank Ranked higher
                ann.loraine Ann Loraine made changes -
                Sprint Spring 2019 Sprint 2, Spring 2019 Sprint 3 [ 60, 61 ] Spring 2019 Sprint 2, Spring 2019 Sprint 3, Spring 2019 Sprint 4 [ 60, 61, 62 ]
                ann.loraine Ann Loraine made changes -
                Resolution Done [ 10000 ]
                Status Closed [ 6 ] Open [ 1 ]
                svallapu Sai Charan Reddy Vallapureddy (Inactive) made changes -
                Resolution Done [ 10000 ]
                Status Open [ 1 ] Closed [ 6 ]
                svallapu Sai Charan Reddy Vallapureddy (Inactive) made changes -
                Status In Progress [ 3 ] Open [ 1 ]
                svallapu Sai Charan Reddy Vallapureddy (Inactive) made changes -
                Status Open [ 1 ] In Progress [ 3 ]
                ptambvek Pranav Sanjay Tambvekar (Inactive) made changes -
                Assignee Pranav Sanjay Tambvekar [ ptambvek ] Sai Charan Reddy Vallapureddy [ svallapu ]
                ptambvek Pranav Sanjay Tambvekar (Inactive) made changes -
                Status Reviewing [ 10301 ] Open [ 1 ]
                ptambvek Pranav Sanjay Tambvekar (Inactive) made changes -
                Status Needs 1st Level Review [ 10005 ] Reviewing [ 10301 ]
                ptambvek Pranav Sanjay Tambvekar (Inactive) made changes -
                Assignee Pranav Sanjay Tambvekar [ ptambvek ]
                ann.loraine Ann Loraine made changes -
                Link This issue relates to IGBF-1613 [ IGBF-1613 ]
                ann.loraine Ann Loraine made changes -
                Rank Ranked higher
                ann.loraine Ann Loraine made changes -
                Sprint Spring 2019 Sprint 2 [ 60 ] Spring 2019 Sprint 2, Spring 2019 Sprint 3 [ 60, 61 ]
                svallapu Sai Charan Reddy Vallapureddy (Inactive) made changes -
                Assignee Sai Charan Reddy Vallapureddy [ svallapu ]
                svallapu Sai Charan Reddy Vallapureddy (Inactive) made changes -
                Status In Progress [ 3 ] Needs 1st Level Review [ 10005 ]
                svallapu Sai Charan Reddy Vallapureddy (Inactive) made changes -
                Status Open [ 1 ] In Progress [ 3 ]
                ann.loraine Ann Loraine made changes -
                Link This issue relates to IGBF-1567 [ IGBF-1567 ]
                ann.loraine Ann Loraine made changes -
                Link This issue is blocked by IGBF-1567 [ IGBF-1567 ]
                ann.loraine Ann Loraine made changes -
                Link This issue blocks IGBF-1521 [ IGBF-1521 ]
                ann.loraine Ann Loraine made changes -
                Assignee Sai Charan Reddy Vallapureddy [ svallapu ]
                ann.loraine Ann Loraine made changes -
                Rank Ranked higher
                ann.loraine Ann Loraine made changes -
                Link This issue relates to IGBF-1470 [ IGBF-1470 ]
                ann.loraine Ann Loraine made changes -
                Link This issue relates to IGBF-1567 [ IGBF-1567 ]
                ann.loraine Ann Loraine made changes -
                Field Original Value New Value
                Epic Link IGBF-1388 [ 17463 ]
                ann.loraine Ann Loraine created issue -

                  People

                  • Assignee:
                    svallapu Sai Charan Reddy Vallapureddy (Inactive)
                    Reporter:
                    ann.loraine Ann Loraine
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: