test_crm_name_pinyin_search.py 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. """产品/客户列表 keyword:名称/编号/拼音首字母 OR 匹配。"""
  2. from __future__ import annotations
  3. from unittest.mock import MagicMock
  4. from app.crud.crm.customer import list_customer_options, list_customers
  5. from app.crud.crm.product import list_products
  6. def test_list_products_keyword_includes_name_and_pinyin():
  7. db = MagicMock()
  8. q = MagicMock()
  9. db.query.return_value = q
  10. q.filter.return_value = q
  11. q.order_by.return_value = q
  12. q.with_entities.return_value = q
  13. q.scalar.return_value = 0
  14. q.offset.return_value = q
  15. q.limit.return_value = q
  16. q.all.return_value = []
  17. list_products(db, "shanxia2.0", keyword="gyls")
  18. assert q.filter.call_count >= 2
  19. keyword_expr = " ".join(str(a) for a in q.filter.call_args_list[1][0])
  20. assert "product_name" in keyword_expr
  21. assert "name_pinyin_abbr" in keyword_expr
  22. def test_list_customers_keyword_includes_name_and_pinyin():
  23. db = MagicMock()
  24. q = MagicMock()
  25. db.query.return_value = q
  26. q.filter.return_value = q
  27. q.order_by.return_value = q
  28. q.with_entities.return_value = q
  29. q.scalar.return_value = 0
  30. q.offset.return_value = q
  31. q.limit.return_value = q
  32. q.all.return_value = []
  33. list_customers(db, "shanxia2.0", keyword="sxhg")
  34. assert q.filter.call_count >= 2
  35. keyword_expr = " ".join(str(a) for a in q.filter.call_args_list[1][0])
  36. assert "customer_name" in keyword_expr
  37. assert "name_pinyin_abbr" in keyword_expr
  38. def test_list_customer_options_keyword_includes_name_and_pinyin():
  39. db = MagicMock()
  40. q = MagicMock()
  41. db.query.return_value = q
  42. q.filter.return_value = q
  43. q.order_by.return_value = q
  44. q.limit.return_value = q
  45. q.all.return_value = []
  46. list_customer_options(db, "shanxia2.0", keyword="sxhg")
  47. assert q.filter.call_count >= 2
  48. keyword_expr = " ".join(str(a) for a in q.filter.call_args_list[1][0])
  49. assert "customer_name" in keyword_expr
  50. assert "name_pinyin_abbr" in keyword_expr