nyk0r

Django ORM -> SQL

Mar 15th, 2011
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.15 KB | None | 0 0
  1. -- запрос
  2. Rate.objects.select_related(depth=1).
  3.     FILTER(begin_date__lte = datetime.now(), end_date__gte = datetime.now()).
  4.         FILTER(Q(source__short_name__in = ['USD']) | Q(dest__short_name__in = ['UZS']))
  5.  
  6. -- результат
  7. SELECT
  8.     "rates_widget_rates"."id",
  9.     "rates_widget_rates"."source_id",
  10.     "rates_widget_rates"."dest_id",
  11.     "rates_widget_rates"."rate",
  12.     "rates_widget_rates"."begin_date",
  13.     "rates_widget_rates"."end_date",
  14.     "rates_widget_currencies"."id",
  15.     "rates_widget_currencies"."name",
  16.     "rates_widget_currencies"."short_name",
  17.    
  18.     T3."id",
  19.     T3."name",
  20.     T3."short_name"
  21. FROM
  22.     "rates_widget_rates"
  23.     INNER JOIN "rates_widget_currencies"
  24.         ON ("rates_widget_rates"."source_id" = "rates_widget_currencies"."id")
  25.     INNER JOIN "rates_widget_currencies" T3
  26.         ON ("rates_widget_rates"."dest_id" = T3."id")
  27. WHERE
  28.     ("rates_widget_rates"."begin_date" <= 2011-03-16 00:54:41.697667  
  29.      AND "rates_widget_rates"."end_date" >= 2011-03-16 00:54:41.697685  
  30.      AND ("rates_widget_currencies"."short_name" IN (USD) OR T3."short_name" IN (UZS)))
  31. LIMIT 21
Advertisement
Add Comment
Please, Sign In to add comment