Branch : https://bitbucket.org/svallapu/appstore-charan/branch/IGBF-1568

parseRepositoryXML.py file does the following things:

1. takes input from the user (host address, username, password, and database name)
2. Reads the XML file.
3. Copy content from XML file to string to replace "&" with "&". It is because XML parser gave an exception when parsing ampersand(&).
4. Gets the required content from the XML file using the elementTree parser and stores them in variables.
5. Modify the variables to remove exception in the app store. It creates a row when there is no data. It updates the row when there is data.
6. Connects to Mysql RDS database and stores the data.

Database details:
database : testdjango
table name : apps_app

base64 Parser should be used to decode the details field in the database
Example:
import base64
details = base64.b64decode(details)

Functional testing:

• Clone repo, checkout branch, run script with test "repository.xml" files
• Check that database was modified according to specification

Code review:

• Check that a user can't accidentally corrupt database

1. Need to add the fields which are mentioned as 'Not Null' in the document in Google Drive.
Not sure how it worked on RDS, but on local database, it throws error like- Error while connecting to MySQL 1364 (HY000): Field 'stars' doesn't have a default value
This can be avoided by having default values to the fields.
2. Please include the dependencies you used (mysql-connector-python) in the installDependencies.sh

Because of the way database and Appstore is is designed, It will be beneficial to write django-code for reading and populating the database

The suggested way is to use Django code instead of python code. Closed the ticket.

Please move repository.xml & parseRepositoryXML.py to appstore/submit_app and submit pull request.
(Make a new branch or squash commits first.)

Moved repository.xml & parseRepositoryXML.py to appstore/submit_app folder.

Branch: https://bitbucket.org/svallapu/appstore-charan/branch/IGBF-1568