Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 2.97 KB | None | 0 0
  1. (Pdb)         from django.db import connection; connection.queries[-1]
  2. {'time': '0.000', 'sql': 'SELECT (get_pourcentage_rank(\n                    "carpool_tripoffer"."direction_route_proj",\n                    ST_PointFromWKB(ST_AsEWKB(\'E\'POINT (651509.410732221789658 2627229.228190750814974)\'\'::geometry)),\n                    ST_PointFromWKB(ST_AsEWKB(\'E\'POINT (601063.245795517694205 2428703.302194458432496)\'\'::geometry))\n                )\n                ) AS "pourcentage_rank", "carpool_trip"."id", "carpool_trip"."name", "carpool_trip"."user_id", "carpool_trip"."departure_city", "carpool_trip"."departure_address", "carpool_trip"."departure_point", "carpool_trip"."arrival_city", "carpool_trip"."arrival_address", "carpool_trip"."arrival_point", "carpool_trip"."offer_id", "carpool_trip"."demand_id", "carpool_trip"."regular", "carpool_trip"."date", "carpool_trip"."interval_min", "carpool_trip"."interval_max", "carpool_trip"."dows", "carpool_trip"."time", "carpool_trip"."comment", "carpool_trip"."alert", "carpool_trip"."creation_date", "carpool_trip"."modification_date", "auth_user"."id", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."password", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."is_superuser", "auth_user"."last_login", "auth_user"."date_joined", "carpool_tripoffer"."id", "carpool_tripoffer"."checkpoints", "carpool_tripoffer"."route", "carpool_tripoffer"."simple_route", "carpool_tripoffer"."direction_route", "carpool_tripoffer"."radius", "carpool_tripoffer"."driver_km_price", "carpool_tripoffer"."driver_smokers_accepted", "carpool_tripoffer"."driver_pets_accepted", "carpool_tripoffer"."driver_place_for_luggage", "carpool_tripoffer"."driver_car_type_id", "carpool_tripoffer"."driver_seats_available" FROM "carpool_trip" LEFT OUTER JOIN "carpool_tripoffer" ON ("carpool_trip"."offer_id" = "carpool_tripoffer"."id") INNER JOIN "auth_user" ON ("carpool_trip"."user_id" = "auth_user"."id") WHERE ("carpool_trip"."offer_id" IS NOT NULL AND ST_DWithin(\n                    "carpool_tripoffer"."simple_route_proj",\n                    ST_PointFromWKB(ST_AsEWKB(\'E\'POINT (651509.410732221789658 2627229.228190750814974)\'\'::geometry)),\n                    "carpool_tripoffer"."radius" + 500\n                )\n                 AND ST_DWithin(\n                    "carpool_tripoffer"."simple_route_proj",\n                    ST_PointFromWKB(ST_AsEWKB(\'E\'POINT (601063.245795517694205 2428703.302194458432496)\'\'::geometry)),\n                    "carpool_tripoffer"."radius" + 500\n                )\n                 AND get_pourcentage_rank(\n                    "carpool_tripoffer"."direction_route_proj",\n                    ST_PointFromWKB(ST_AsEWKB(\'E\'POINT (651509.410732221789658 2627229.228190750814974)\'\'::geometry)),\n                    ST_PointFromWKB(ST_AsEWKB(\'E\'POINT (601063.245795517694205 2428703.302194458432496)\'\'::geometry))\n                ) >= 10\n                ) LIMIT 21'}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement