com.mysql.jdbc.Driver
jdbc:mysql://localhost:3306/[DATABASE]?allowMultiQueries=true
[USER]
[PASSWORD]
SELECT imeiNumber AS id, imeiNumber AS imei FROM Device WHERE imeiNumber <> '';
START TRANSACTION;
UPDATE Device SET lastValidLatitude = :latitude, lastValidLongitude = :longitude, lastGPSTimestamp = UNIX_TIMESTAMP(:time), lastUpdateTime = UNIX_TIMESTAMP(NOW()) WHERE imeiNumber = :device_id;
SELECT @accountID := accountID, @deviceID := deviceID FROM Device WHERE imeiNumber = :device_id;
INSERT INTO EventData (accountID, deviceID, timestamp, statusCode, latitude, longitude, speedKPH, heading, altitude, rawData, creationTime, address)
VALUES (@accountID, @deviceID, UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, :speed * 1.852, :course, :altitude, '', UNIX_TIMESTAMP(NOW()), :address);
COMMIT;
DO 0;
false
true
google
false
true
5000
true
5001
true
5002
true
5003
true
5004
true
5005
true
5006
true
5007
true
5008
true
5009
true
5010
true
5011
true
5012
true
5013
true
5014
true
5015
true
5016
true
5017
true
5018
true
5019
true
5020
true
5021
true
5022
true
5023
7200
true
5024
true
5025
true
5026
true
5027
true
5028
true
5029
true
5030
true
5031
true
5032
true
5033
true
5034
true
5035
true
5036
true
5037
true
5038
true
5039
true
5040
true
5041
true
5042
true
5043
true
5044
true
5045
true
5046
true
5047
true
5048
true
5049
true
5050
true
5051
true
5052
true
5053
true
5054
true
5055
true
5056
true
5057
true
5058
true
5059
true
5060
true
5061
true
5062
true
5063
true
5064
true
5065
true
5066
true
5067
true
5068
true
5069
true
5070
true
5071