The database provides stats for modeling and web application, thus the performance is crucial. We replaced the MySQL with MongoDB due to the performance limitation. The players’ statistical data can then be retrieved through SQL and analyzed for your own purpose. Some statistics like the number of battles are stored in wows_stats, and you can customize your own database as well. The players’ id list is stored in an individual table wows_idlist, which is essential for efficient API request since the complete id list is not officially provided, and the account number is sparsely distributed in a large range ( WOWS account number range). The script connects relational database (MySQL, AWS RDS, etc.) for storing extracted data. To be consistent with the data, we store the newest stats and historical stats differently. The newest and historical stats of a player differ a little. Since the API request returns JSON format data, it is natural to use MongoDB (BSON) for data storing. There are several limitations, as well as specific JSON format regarding different types of the API request (refer to API reference), please check based on your need. Also the ip address of the terminal running this script (provided by package ipgetter) should be added in your application launched on developer room of. The World of Warships API needs an application_id for credential connection with the API server, the application_id should be registered on and stored in a local configuration file named as “ config.json”. This python based script handles World of Warships API request for statistical data and store them in local MySQL database. World-of-Warships-Stats-Analysis World of Warships Stats Analysis and Web Application
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |