gfrenoy / TabT-API

Programming interface for TabT, the free table tennis manager software
http://tabt.frenoy.net
GNU Affero General Public License v3.0
9 stars 5 forks source link

GetTournaments : MatchEntry missing #2

Closed Fllorent0D closed 6 years ago

Fllorent0D commented 6 years ago

GetTournaments only send back tournament entries and the series of each tournament. We should get an option to get the match entries of a tournament.

capture d ecran 2018-04-25 a 21 49 45
gfrenoy commented 6 years ago

Yes, that certainly makes sense. I would restrict that to only one tournament to start with. So we would also need a parameter to select the tournament.

Fllorent0D commented 6 years ago

Look perfect to me if you do that! So, I can query once the GetTournament and then query again with the new parameter when the user wants to see the details.

Fllorent0D commented 6 years ago

@gfrenoy Any updates? 😅

gfrenoy commented 6 years ago

@Fllorent0D Any suggestion on how should look the new GetTournamentsRequest and GetTournamentsResponse ?

Fonsvanh commented 6 years ago

Dear all,

I’ve followed this discussion in the background. I use the TABT-API in an Excel vba macro to produce a weekly overview of the match result.

This overview is published in our provincial monthly magazine.

Recently I’ve started developing a vb.net program using the TABT-API to check whether the interclub regulations have been violated and to sanction the clubs for this. Today this is done manually but this can be done programmatically.

This program is not finished yet but it’s my intention to finish it by the start of next season.

I also like to use the API to publish the tournament results in my monthly because I’m not happy with the layout of the results I receive today (word documents)

What data is stored in the database regarding the tournaments?

Krgds,

Alfons Vanhoudt Secretaris PCLK

gfrenoy commented 6 years ago

Thanks for your feedback Alfons :) Happy to read the API is used in ways that were certainly not foreseen in the beginning !

In the TabT database, you have only a "flat" list of results for each series, like this: https://competitie.vttl.be/?menu=7&viewresults=1&t_id=2641

There is no clue about the structure of the tournament. So you don't have the necessary information to rebuild the final round table and/or round robin tables.

That being said, this information is for sure kept in the database of the tournament application so we should check with Luc how to transfer this in text files that are exported from that application (and then imported in TabT).

Fllorent0D commented 6 years ago

Sorry for the late response. I don't know how the tournaments works in real world. If it's always the same flows: pools, quarter-final, semi-final, final, ... If it's always the same we can create a object in each SerieEntries with in it

{
  pools:[MatchEntryDetails],
  quarter-final:[MatchEntryDetails],
  semi-final: [MatchEntryDetails],
  final: atchEntryDetails,
}

What do you think?

gfrenoy commented 6 years ago

As said in the previous comment, there is no information about the structure of the tournament in the database. It's just a flat list of results.

Anyway, at this stage, the first step to complete this request is to change the WSDL file. And especially the GetTournaments_Request and GetTournaments_Response structures.