nyk0r

Django ORM -> SQL 2

Mar 16th, 2011
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.16 KB | None | 0 0
  1. Rate.objects.select_related(depth=1).
  2.     FILTER(begin_date__lte = datetime.now(), end_date__gte = datetime.now()).FILTER(
  3.     Q(source__short_name = 'USD', dest__short_name = 'UZS') | Q(source__short_name = 'USD', dest__short_name = 'RUB'))
  4.    
  5. SELECT
  6.     "rates_widget_rates"."id",
  7.     "rates_widget_rates"."source_id",
  8.     "rates_widget_rates"."dest_id",
  9.     "rates_widget_rates"."rate",
  10.     "rates_widget_rates"."begin_date",
  11.     "rates_widget_rates"."end_date",
  12.     T3."id",
  13.     T3."name",
  14.     T3."short_name",
  15.     "rates_widget_currencies"."id",
  16.     "rates_widget_currencies"."name",
  17.     "rates_widget_currencies"."short_name"
  18. FROM
  19.     "rates_widget_rates"
  20.     INNER JOIN "rates_widget_currencies"
  21.         ON ("rates_widget_rates"."dest_id" = "rates_widget_currencies"."id")
  22.     INNER JOIN "rates_widget_currencies" T3
  23.         ON ("rates_widget_rates"."source_id" = T3."id")
  24. WHERE
  25.     ("rates_widget_rates"."begin_date" <= 2011-03-16 12:34:43.320052  
  26.      AND "rates_widget_rates"."end_date" >= 2011-03-16 12:34:43.320071  
  27.      AND (("rates_widget_currencies"."short_name" = UZS  AND T3."short_name" = USD )
  28.            OR ("rates_widget_currencies"."short_name" = RUB  AND T3."short_name" = USD )))
  29. LIMIT 21
Advertisement
Add Comment
Please, Sign In to add comment