samedi 25 juillet 2015

Android SQLite Query

So I have a query which pulls all the right data but I am having problems going through the data and pulling out the right data.

I have this Query:

SELECT meets.meet_id, meets_athletes.total_score, events.event, meets_athletes_splits.split_number, meets_athletes_splits.split_score 
FROM meets INNER JOIN meets_athletes ON meets.meet_id = meets_athletes.meet_id 
LEFT JOIN meets_athletes_splits ON meets_athletes.meet_id = meets_athletes_splits.meet_id AND meets_athletes.athlete_id = meets_athletes_splits.athlete_id AND meets_athletes.event_id = meets_athletes_splits.event_id 
INNER JOIN events ON meets_athletes.event_id = events.event_id 
WHERE meets_athletes.athlete_id = 1

Image: http://ift.tt/1JmSbMS

I would like the data returned like so:

Meet 1 String:

Event: 5000 Meter Long Distance
Total Score 1:35.4
Split 1: 0:00.0
Split 2: 0:12.4
Split 3: 0:16.5
Split 4: 0:49.4

Event: 800 Meter Middle Distance
Total Score: 0:48.3
Split 1: 

Meet 2 String:

Event: 5000 Meter Long Distance
Total Score:
Split 1:
Event: 800 Meter Middle Distance
Total Score:
Split 1:

I am trying to return a string per meet with the events and splits included per event. I don't know how to really do this in Android. Any help would be much appreciated

Aucun commentaire:

Enregistrer un commentaire