von Swen » Mi 18. Nov 2015, 16:35
Code: Alles auswählen
curl --verbose -H "X-Requested-With: XMLHttpRequest" -d 'SELECT inttohex(F.ICAO), F.LAT, F.LON, F.ALT, F.CALLSIGN, CAST(ROUND(F.SPEED) AS INTEGER), F.VSPEED, CAST(ROUND(F.HEADING) AS INTEGER), CASE WHEN F.SQUAWK IS NULL THEN "" ELSE inttooct(F.SQUAWK) END, CAST(ROUND((julianday("now") - 2440587.5)*86400 - F.SEEN_TIME, 0) AS INTEGER), S.TXT, F.DF17_POS, F.CAT, F.GND, F.HEADING_INDIRECT, F.VSPEED_INDIRECT, F.SPEED_INDIRECT FROM FLIGHTS F LEFT JOIN (SELECT ID, TXT FROM V_SOURCES) S ON S.ID = F.ID_SOURCE ORDER BY F.APP_TIME DESC' -X POST http://localhost:8080/execute
Für die Nerds, denn sie wissen nicht was sie tuen.
Ist quasi ein Tipp.
[code]curl --verbose -H "X-Requested-With: XMLHttpRequest" -d 'SELECT inttohex(F.ICAO), F.LAT, F.LON, F.ALT, F.CALLSIGN, CAST(ROUND(F.SPEED) AS INTEGER), F.VSPEED, CAST(ROUND(F.HEADING) AS INTEGER), CASE WHEN F.SQUAWK IS NULL THEN "" ELSE inttooct(F.SQUAWK) END, CAST(ROUND((julianday("now") - 2440587.5)*86400 - F.SEEN_TIME, 0) AS INTEGER), S.TXT, F.DF17_POS, F.CAT, F.GND, F.HEADING_INDIRECT, F.VSPEED_INDIRECT, F.SPEED_INDIRECT FROM FLIGHTS F LEFT JOIN (SELECT ID, TXT FROM V_SOURCES) S ON S.ID = F.ID_SOURCE ORDER BY F.APP_TIME DESC' -X POST http://localhost:8080/execute[/code]
Für die Nerds, denn sie wissen nicht was sie tuen. :) Ist quasi ein Tipp.