duxbuse / ninthage-data-analytics

A better way for the project to ingest tournament results
GNU General Public License v3.0
1 stars 0 forks source link

NewRecruit entries with army is null #164

Open SanderND opened 1 year ago

SanderND commented 1 year ago

Many games from New Recruit have army is null. Try this query to see the current cases:

SELECT army_uuid, tournament, player_name FROM ninthage-data-analytics.t9a_data_views.All-data where army is null and data_source = "NEW_RECRUIT"

All games should have an army.

SanderND commented 1 year ago

Example: This army is null on our database as you see with this query:

SELECT army_uuid, tournament, player_name, list_placing FROM ninthage-data-analytics.t9a_data_views.All-data where army is null and data_source = "NEW_RECRUIT" and tournament = "ETC T9A 2022" and player_name ="Furion"

On NewRecruit it is shown as HbE: https://www.newrecruit.eu/app/tournydetails?id=626a8baee7f13c9414e073bd&id_participant=62c341c0703ab55f64a5a669

duxbuse commented 1 year ago

So after investigation there seems to be a bug in the NR api for this example with furion we are getting

{
    'alias': 'Furion',
    'id_member': '609674e3e77d8c5c867f8c41',
    'id_list': '62c491151f40fd299bb6bed3',
    'id_book': 7,
    'id_participant': '62c341c0703ab55f64a5a669',
    'report_list': None,
    'name': 'FollowFurion',
    'elo': {'friendly': 15, 'tourny': 15, '62fac2eb0c3de1ff3946ca94': 14}
}
As seen report_list = None, and yet the list is shown on the page so I have reached out to flammy to investigate.
duxbuse commented 1 year ago

@SanderND Are we still seeing this?