log.js

BEGIN;
INSERT INTO warehouse.rental_transport_routes
   (ride_no, sequence_no, driver_emp_id, ride_date, from_latitude, from_longitude, to_latitude, to_longitude, ride_type, distance, route_time)
   VALUES
(2,1,TEST_V0002,date '2016-01-22',50.7401640000,3.3271730000,50.8614460000,3.4276280000,'actual',25928,1447 ) ,
(2,2,TEST_V0002,date '2016-01-22',50.8614460000,3.4276280000,50.6102640000,5.5416590000,'actual',179618,6378 ) ,
(2,3,TEST_V0002,date '2016-01-22',50.6102640000,5.5416590000,50.7401640000,3.3271730000,'actual',196438,6996 ) ,
(2,1,TEST_V0002,date '2016-01-22',50.7401640000,3.3271730000,50.8599400000,3.4272200000,'Simul 1',26214,1484 ) ,
(2,2,TEST_V0002,date '2016-01-22',50.8599400000,3.4272200000,50.7401640000,3.3271730000,'Simul 1',26882,1471 ) ,
(2,3,TEST_V0002,date '2016-01-22',50.8614460000,3.4276280000,50.8614460000,3.4276280000,'Simul 1',0,0 ) ,
(2,4,TEST_V0002,date '2016-01-22',50.8614460000,3.4276280000,50.8614460000,3.4276280000,'Simul 1',0,0 ) ,
(2,5,TEST_V0002,date '2016-01-22',50.6102640000,5.5416590000,51.0166000000,5.8660800000,'Simul 1',63844,3123 ) ,
(2,6,TEST_V0002,date '2016-01-22',51.0166000000,5.8660800000,50.6102640000,5.5416590000,'Simul 1',63914,3191 ) ,
(2,7,TEST_V0002,date '2016-01-22',50.7401640000,3.3271730000,50.8599400000,3.4272200000,'Simul 1',26214,1484 ) ,
(2,8,TEST_V0002,date '2016-01-22',50.8599400000,3.4272200000,50.7401640000,3.3271730000,'Simul 1',26882,1471 ) ,
(2,1,TEST_V0002,date '2016-01-22',50.7401640000,3.3271730000,50.8614460000,3.4276280000,'Simul 2',25928,1447 ) ,
(2,2,TEST_V0002,date '2016-01-22',50.8614460000,3.4276280000,50.7401640000,3.3271730000,'Simul 2',26596,1434 ) ,
(2,3,TEST_V0002,date '2016-01-22',50.8614460000,3.4276280000,50.8614460000,3.4276280000,'Simul 2',0,0 ) ,
(2,4,TEST_V0002,date '2016-01-22',50.8614460000,3.4276280000,50.8614460000,3.4276280000,'Simul 2',0,0 ) ,
(2,5,TEST_V0002,date '2016-01-22',50.6102640000,5.5416590000,50.8614460000,3.4276280000,'Simul 2',179198,6432 ) ,
(2,6,TEST_V0002,date '2016-01-22',50.8614460000,3.4276280000,50.6102640000,5.5416590000,'Simul 2',179618,6378 ) ,
(2,7,TEST_V0002,date '2016-01-22',50.7401640000,3.3271730000,50.8614460000,3.4276280000,'Simul 2',25928,1447 ) ,
(2,8,TEST_V0002,date '2016-01-22',50.8614460000,3.4276280000,50.7401640000,3.3271730000,'Simul 2',26596,1434 ) ,
(2,1,TEST_V0002,date '2016-01-22',50.7401640000,3.3271730000,50.8614460000,3.4276280000,'Simul 3',25928,1447 ) ,
(2,2,TEST_V0002,date '2016-01-22',50.8614460000,3.4276280000,50.7401640000,3.3271730000,'Simul 3',26596,1434 ) ,
(2,3,TEST_V0002,date '2016-01-22',50.7401640000,3.3271730000,50.6102640000,5.5416590000,'Simul 3',189238,6952 ) ,
(2,4,TEST_V0002,date '2016-01-22',50.6102640000,5.5416590000,50.7401640000,3.3271730000,'Simul 3',196438,6996 ) ,
(2,5,TEST_V0002,date '2016-01-22',50.7401640000,3.3271730000,50.7401640000,3.3271730000,'Simul 3',0,0 ) ,
(2,6,TEST_V0002,date '2016-01-22',50.7401640000,3.3271730000,50.7401640000,3.3271730000,'Simul 3',0,0 )
;
UPDATE warehouse.rental_transport_points
   SET processed_date = now()
   WHERE
       driver_emp_id = 'TEST_V0002'
   AND ride_no = 2
   AND ride_date = date '2016-01-22'
;
COMMIT;