Advertisement
Guest User

Untitled

a guest
Jun 20th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.98 KB | None | 0 0
  1.         vector = SearchVector('name') + SearchVector('last_name')
  2.  
  3.         q = self.strip_punctuation(query_str)
  4.         str_vector = q.split(' ')
  5.         if len(str_vector) > 1:
  6.             query = SearchQuery(str_vector[0])
  7.             for string in str_vector[1:]:
  8.                 query |= SearchQuery(string)
  9.  
  10.             QQ = queryset.annotate(search=vector).filter(search=query)
  11.         else:
  12.             QQ = queryset.filter(Q(last_name__istartswith=q) |
  13.                                  Q(name__istartswith=q)
  14.                                  )
  15.                            
  16.  
  17. SELECT "id", "polymorphic_ctype_id", "level", "company_id", "profile_id",
  18. "email", "state", "category_id", "is_aml_cft_responsable", "name",
  19. "middle_names", "last_name", "preferred_name", "occupation", "role",
  20. "role_in_relation", "percentage_of_ownership", "pep", "date_created",
  21. "last_update", "parent_client_id", "shares_held", "must_be_verified",
  22. "ctype_sort_order", "reason_for_using_amlnz", "other_reason_for_using_amlnz",
  23. "nature_of_the_business", "nature_of_the_transaction", "value_start",
  24. "value_end", "value_per", "value_comment", "volume_start", "volume_end",
  25. "volume_per", "volume_comment", "review_date", "client_number",
  26. "registration_number", "nzbn", "risk_rating", "has_more_than_25_percent",
  27. "has_effective_control_relationship", "is_person_for_transactions",
  28. "is_person_acting_on_behalf", "has_call_nzbn_api", "is_archived",
  29. "nzbn_api_response", "search_api_response", "date_of_birth", "is_the_same",
  30. "address", "suburb", "city", "country", "post_code", "authorization_letter",
  31. "ird_number", "country_of_establishment", "gender", "contact_person_name",
  32. "contact_person_last_name",
  33.  (to_tsvector(COALESCE("name", )) || to_tsvector(COALESCE("last_name", )))
  34.    AS "search"
  35.  
  36. FROM "aml_validations_baseclient"
  37.  WHERE
  38. ("company_id" = 1
  39. AND
  40. (
  41.     to_tsvector(COALESCE("name", )) ||
  42.     to_tsvector(COALESCE("last_name", ))
  43.  )
  44.  @@
  45.     ((plainto_tsquery(William) || plainto_tsquery(Buick))) = true
  46.  )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement