Details
-
Type:
Task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Labels:
-
Story Points:2
-
Epic Link:
-
Sprint:Spring 2019 Sprint 2, Spring 2019 Sprint 3, Spring 2019 Sprint 4
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.