Blame view

query/translator.py 29.4 KB
be52af70   tangwang   first commit
1
2
3
4
  """
  Translation service for multi-language query support.
  
  Supports DeepL API for high-quality translations.
0064e946   tangwang   feat: 增量索引服务、租户配置...
5
6
7
8
9
10
11
  
  
  #### 官方文档:
  https://developers.deepl.com/api-reference/translate/request-translation
  #####
  
  
be52af70   tangwang   first commit
12
13
14
  """
  
  import requests
a5a6bab8   tangwang   多语言查询优化
15
  import re
453992a8   tangwang   需求:
16
  import redis
3ec5bfe6   tangwang   1. get_translatio...
17
  from concurrent.futures import ThreadPoolExecutor, Future
453992a8   tangwang   需求:
18
  from datetime import timedelta
3ec5bfe6   tangwang   1. get_translatio...
19
  from typing import Dict, List, Optional, Union
6e0e310c   tangwang   1. Translator 类增强
20
21
22
  import logging
  
  logger = logging.getLogger(__name__)
be52af70   tangwang   first commit
23
  
453992a8   tangwang   需求:
24
  # Try to import DEEPL_AUTH_KEY and REDIS_CONFIG, but allow import to fail
325eec03   tangwang   1. 日志、配置基础设施,使用优化
25
  try:
453992a8   tangwang   需求:
26
      from config.env_config import DEEPL_AUTH_KEY, REDIS_CONFIG
325eec03   tangwang   1. 日志、配置基础设施,使用优化
27
28
  except ImportError:
      DEEPL_AUTH_KEY = None
453992a8   tangwang   需求:
29
      REDIS_CONFIG = {}
325eec03   tangwang   1. 日志、配置基础设施,使用优化
30
  
be52af70   tangwang   first commit
31
32
33
34
  
  class Translator:
      """Multi-language translator using DeepL API."""
  
16c42787   tangwang   feat: implement r...
35
      DEEPL_API_URL = "https://api.deepl.com/v2/translate"  # Pro tier
be52af70   tangwang   first commit
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
  
      # Language code mapping
      LANG_CODE_MAP = {
          'zh': 'ZH',
          'en': 'EN',
          'ru': 'RU',
          'ar': 'AR',
          'ja': 'JA',
          'es': 'ES',
          'de': 'DE',
          'fr': 'FR',
          'it': 'IT',
          'pt': 'PT',
      }
  
      def __init__(
          self,
          api_key: Optional[str] = None,
          use_cache: bool = True,
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
55
56
57
          timeout: int = 10,
          glossary_id: Optional[str] = None,
          translation_context: Optional[str] = None
be52af70   tangwang   first commit
58
59
60
61
62
      ):
          """
          Initialize translator.
  
          Args:
d79810d5   tangwang   first commit
63
              api_key: DeepL API key (or None to use from config/env)
be52af70   tangwang   first commit
64
65
              use_cache: Whether to cache translations
              timeout: Request timeout in seconds
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
66
67
              glossary_id: DeepL glossary ID for custom terminology (optional)
              translation_context: Context hint for translation (e.g., "e-commerce", "product search")
be52af70   tangwang   first commit
68
          """
d79810d5   tangwang   first commit
69
          # Get API key from config if not provided
325eec03   tangwang   1. 日志、配置基础设施,使用优化
70
71
          if api_key is None and DEEPL_AUTH_KEY:
              api_key = DEEPL_AUTH_KEY
d79810d5   tangwang   first commit
72
  
be52af70   tangwang   first commit
73
74
75
          self.api_key = api_key
          self.timeout = timeout
          self.use_cache = use_cache
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
76
77
          self.glossary_id = glossary_id
          self.translation_context = translation_context or "e-commerce product search"
be52af70   tangwang   first commit
78
  
453992a8   tangwang   需求:
79
          # Initialize Redis cache if enabled
be52af70   tangwang   first commit
80
          if use_cache:
453992a8   tangwang   需求:
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
              try:
                  self.redis_client = redis.Redis(
                      host=REDIS_CONFIG.get('host', 'localhost'),
                      port=REDIS_CONFIG.get('port', 6479),
                      password=REDIS_CONFIG.get('password'),
                      decode_responses=True,  # Return str instead of bytes
                      socket_timeout=REDIS_CONFIG.get('socket_timeout', 1),
                      socket_connect_timeout=REDIS_CONFIG.get('socket_connect_timeout', 1),
                      retry_on_timeout=REDIS_CONFIG.get('retry_on_timeout', False),
                      health_check_interval=10,  # 避免复用坏连接
                  )
                  # Test connection
                  self.redis_client.ping()
                  self.expire_time = timedelta(days=REDIS_CONFIG.get('translation_cache_expire_days', 360))
                  self.cache_prefix = REDIS_CONFIG.get('translation_cache_prefix', 'trans')
                  logger.info("Redis cache initialized for translations")
              except Exception as e:
                  logger.warning(f"Failed to initialize Redis cache: {e}, falling back to no cache")
                  self.redis_client = None
                  self.cache = None
be52af70   tangwang   first commit
101
          else:
453992a8   tangwang   需求:
102
              self.redis_client = None
be52af70   tangwang   first commit
103
              self.cache = None
6e0e310c   tangwang   1. Translator 类增强
104
105
106
          
          # Thread pool for async translation
          self.executor = ThreadPoolExecutor(max_workers=2, thread_name_prefix="translator")
be52af70   tangwang   first commit
107
108
109
110
111
  
      def translate(
          self,
          text: str,
          target_lang: str,
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
112
          source_lang: Optional[str] = None,
0064e946   tangwang   feat: 增量索引服务、租户配置...
113
114
          context: Optional[str] = None,
          prompt: Optional[str] = None
be52af70   tangwang   first commit
115
116
      ) -> Optional[str]:
          """
0064e946   tangwang   feat: 增量索引服务、租户配置...
117
          Translate text to target language (synchronous mode).
be52af70   tangwang   first commit
118
119
120
121
122
  
          Args:
              text: Text to translate
              target_lang: Target language code ('zh', 'en', 'ru', etc.)
              source_lang: Source language code (optional, auto-detect if None)
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
123
              context: Additional context for translation (overrides default context)
0064e946   tangwang   feat: 增量索引服务、租户配置...
124
              prompt: Translation prompt/instruction (optional, for better translation quality)
be52af70   tangwang   first commit
125
126
127
128
129
130
131
132
133
134
135
136
  
          Returns:
              Translated text or None if translation fails
          """
          if not text or not text.strip():
              return text
  
          # Normalize language codes
          target_lang = target_lang.lower()
          if source_lang:
              source_lang = source_lang.lower()
  
a5a6bab8   tangwang   多语言查询优化
137
138
139
140
141
142
143
144
145
          # Optimization: Skip translation if not needed
          if target_lang == 'en' and self._is_english_text(text):
              logger.debug(f"[Translator] Text is already English, skipping translation: '{text[:50]}...'")
              return text
          
          if target_lang == 'zh' and (self._contains_chinese(text) or self._is_pure_number(text)):
              logger.debug(f"[Translator] Text contains Chinese or is pure number, skipping translation: '{text[:50]}...'")
              return text
  
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
146
147
          # Use provided context or default context
          translation_context = context or self.translation_context
0064e946   tangwang   feat: 增量索引服务、租户配置...
148
149
150
151
152
153
154
155
156
          
          # Build cache key (include prompt in cache key if provided)
          cache_key_parts = [source_lang or 'auto', target_lang, translation_context]
          if prompt:
              cache_key_parts.append(prompt)
          cache_key_parts.append(text)
          cache_key = ':'.join(cache_key_parts)
  
          # Check cache (include context and prompt in cache key for accuracy)
453992a8   tangwang   需求:
157
158
          if self.use_cache and self.redis_client:
              cached = self._get_cached_translation_redis(text, target_lang, source_lang, translation_context, prompt)
be52af70   tangwang   first commit
159
160
161
162
163
              if cached:
                  return cached
  
          # If no API key, return mock translation (for testing)
          if not self.api_key:
0064e946   tangwang   feat: 增量索引服务、租户配置...
164
              logger.debug(f"[Translator] No API key, returning original text (mock mode)")
be52af70   tangwang   first commit
165
166
              return text
  
16c42787   tangwang   feat: implement r...
167
          # Translate using DeepL with fallback
0064e946   tangwang   feat: 增量索引服务、租户配置...
168
          result = self._translate_deepl(text, target_lang, source_lang, translation_context, prompt)
be52af70   tangwang   first commit
169
  
16c42787   tangwang   feat: implement r...
170
171
          # If translation failed, try fallback to free API
          if result is None and "api.deepl.com" in self.DEEPL_API_URL:
0064e946   tangwang   feat: 增量索引服务、租户配置...
172
173
              logger.debug(f"[Translator] Pro API failed, trying free API...")
              result = self._translate_deepl_free(text, target_lang, source_lang, translation_context, prompt)
16c42787   tangwang   feat: implement r...
174
175
176
  
          # If still failed, return original text with warning
          if result is None:
0064e946   tangwang   feat: 增量索引服务、租户配置...
177
              logger.warning(f"[Translator] Translation failed for '{text[:50]}...', returning original text")
16c42787   tangwang   feat: implement r...
178
179
              result = text
  
be52af70   tangwang   first commit
180
          # Cache result
453992a8   tangwang   需求:
181
182
          if result and self.use_cache and self.redis_client:
              self._set_cached_translation_redis(text, target_lang, result, source_lang, translation_context, prompt)
be52af70   tangwang   first commit
183
184
185
186
187
188
189
  
          return result
  
      def _translate_deepl(
          self,
          text: str,
          target_lang: str,
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
190
          source_lang: Optional[str],
0064e946   tangwang   feat: 增量索引服务、租户配置...
191
192
          context: Optional[str] = None,
          prompt: Optional[str] = None
be52af70   tangwang   first commit
193
      ) -> Optional[str]:
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
194
195
196
197
198
199
200
201
202
          """
          Translate using DeepL API with context and glossary support.
          
          Args:
              text: Text to translate
              target_lang: Target language code
              source_lang: Source language code (optional)
              context: Context hint for translation (e.g., "e-commerce product search")
          """
be52af70   tangwang   first commit
203
204
205
206
207
208
209
210
          # Map to DeepL language codes
          target_code = self.LANG_CODE_MAP.get(target_lang, target_lang.upper())
  
          headers = {
              "Authorization": f"DeepL-Auth-Key {self.api_key}",
              "Content-Type": "application/json",
          }
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
211
212
213
214
215
          # Use prompt as context parameter for DeepL API (not as text prefix)
          # According to DeepL API: context is "Additional context that can influence a translation but is not translated itself"
          # If prompt is provided, use it as context; otherwise use the default context
          api_context = prompt if prompt else context
          
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
216
217
          # For e-commerce, add context words to help DeepL understand the domain
          # This is especially important for single-word ambiguous terms like "车" (car vs rook)
0064e946   tangwang   feat: 增量索引服务、租户配置...
218
          text_to_translate, needs_extraction = self._add_ecommerce_context(text, source_lang, api_context)
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
219
  
be52af70   tangwang   first commit
220
          payload = {
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
221
              "text": [text_to_translate],
be52af70   tangwang   first commit
222
223
224
225
226
227
228
              "target_lang": target_code,
          }
  
          if source_lang:
              source_code = self.LANG_CODE_MAP.get(source_lang, source_lang.upper())
              payload["source_lang"] = source_code
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
229
230
231
232
233
          # Add context parameter (prompt or default context)
          # Context influences translation but is not translated itself
          if api_context:
              payload["context"] = api_context
  
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
234
235
236
237
          # Add glossary if configured
          if self.glossary_id:
              payload["glossary_id"] = self.glossary_id
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
238
239
240
          # Note: DeepL API v2 supports "context" parameter for additional context
          # that influences translation but is not translated itself.
          # We use prompt as context parameter when provided.
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
241
  
be52af70   tangwang   first commit
242
243
244
245
246
247
248
249
250
251
252
          try:
              response = requests.post(
                  self.DEEPL_API_URL,
                  headers=headers,
                  json=payload,
                  timeout=self.timeout
              )
  
              if response.status_code == 200:
                  data = response.json()
                  if "translations" in data and len(data["translations"]) > 0:
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
253
254
255
256
257
258
259
                      translated_text = data["translations"][0]["text"]
                      # If we added context, extract just the term from the result
                      if needs_extraction:
                          translated_text = self._extract_term_from_translation(
                              translated_text, text, target_code
                          )
                      return translated_text
be52af70   tangwang   first commit
260
              else:
0064e946   tangwang   feat: 增量索引服务、租户配置...
261
                  logger.error(f"[Translator] DeepL API error: {response.status_code} - {response.text}")
be52af70   tangwang   first commit
262
263
264
                  return None
  
          except requests.Timeout:
0064e946   tangwang   feat: 增量索引服务、租户配置...
265
              logger.warning(f"[Translator] Translation request timed out")
be52af70   tangwang   first commit
266
267
              return None
          except Exception as e:
0064e946   tangwang   feat: 增量索引服务、租户配置...
268
              logger.error(f"[Translator] Translation failed: {e}", exc_info=True)
be52af70   tangwang   first commit
269
270
              return None
  
16c42787   tangwang   feat: implement r...
271
272
273
274
      def _translate_deepl_free(
          self,
          text: str,
          target_lang: str,
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
275
          source_lang: Optional[str],
0064e946   tangwang   feat: 增量索引服务、租户配置...
276
277
          context: Optional[str] = None,
          prompt: Optional[str] = None
16c42787   tangwang   feat: implement r...
278
      ) -> Optional[str]:
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
279
280
281
282
283
          """
          Translate using DeepL Free API.
          
          Note: Free API may not support glossary_id parameter.
          """
16c42787   tangwang   feat: implement r...
284
285
286
287
288
289
290
291
          # Map to DeepL language codes
          target_code = self.LANG_CODE_MAP.get(target_lang, target_lang.upper())
  
          headers = {
              "Authorization": f"DeepL-Auth-Key {self.api_key}",
              "Content-Type": "application/json",
          }
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
292
293
294
          # Use prompt as context parameter for DeepL API
          api_context = prompt if prompt else context
          
16c42787   tangwang   feat: implement r...
295
296
297
298
299
300
301
302
303
          payload = {
              "text": [text],
              "target_lang": target_code,
          }
  
          if source_lang:
              source_code = self.LANG_CODE_MAP.get(source_lang, source_lang.upper())
              payload["source_lang"] = source_code
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
304
305
306
307
          # Add context parameter
          if api_context:
              payload["context"] = api_context
  
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
308
309
310
          # Note: Free API typically doesn't support glossary_id
          # But we can still use context hints in the text
  
16c42787   tangwang   feat: implement r...
311
312
313
314
315
316
317
318
319
320
321
322
323
          try:
              response = requests.post(
                  "https://api-free.deepl.com/v2/translate",
                  headers=headers,
                  json=payload,
                  timeout=self.timeout
              )
  
              if response.status_code == 200:
                  data = response.json()
                  if "translations" in data and len(data["translations"]) > 0:
                      return data["translations"][0]["text"]
              else:
0064e946   tangwang   feat: 增量索引服务、租户配置...
324
                  logger.error(f"[Translator] DeepL Free API error: {response.status_code} - {response.text}")
16c42787   tangwang   feat: implement r...
325
326
327
                  return None
  
          except requests.Timeout:
0064e946   tangwang   feat: 增量索引服务、租户配置...
328
              logger.warning(f"[Translator] Free API request timed out")
16c42787   tangwang   feat: implement r...
329
330
              return None
          except Exception as e:
0064e946   tangwang   feat: 增量索引服务、租户配置...
331
              logger.error(f"[Translator] Free API translation failed: {e}", exc_info=True)
16c42787   tangwang   feat: implement r...
332
333
              return None
  
be52af70   tangwang   first commit
334
335
336
337
      def translate_multi(
          self,
          text: str,
          target_langs: List[str],
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
338
          source_lang: Optional[str] = None,
6e0e310c   tangwang   1. Translator 类增强
339
          context: Optional[str] = None,
0064e946   tangwang   feat: 增量索引服务、租户配置...
340
341
          async_mode: bool = True,
          prompt: Optional[str] = None
be52af70   tangwang   first commit
342
343
344
      ) -> Dict[str, Optional[str]]:
          """
          Translate text to multiple target languages.
6e0e310c   tangwang   1. Translator 类增强
345
346
347
          
          In async_mode=True (default):
          - Returns cached translations immediately if available
a5a6bab8   tangwang   多语言查询优化
348
349
350
351
          - For translations that can be optimized (e.g., pure numbers, already in target language),
            returns result immediately via synchronous call
          - Launches async tasks for other missing translations (non-blocking)
          - Returns None for missing translations that require async processing
6e0e310c   tangwang   1. Translator 类增强
352
353
354
          
          In async_mode=False:
          - Waits for all translations to complete (blocking)
be52af70   tangwang   first commit
355
356
357
358
359
  
          Args:
              text: Text to translate
              target_langs: List of target language codes
              source_lang: Source language code (optional)
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
360
              context: Context hint for translation (optional)
6e0e310c   tangwang   1. Translator 类增强
361
              async_mode: If True, return cached results immediately and translate missing ones async
0064e946   tangwang   feat: 增量索引服务、租户配置...
362
              prompt: Translation prompt/instruction (optional)
be52af70   tangwang   first commit
363
364
  
          Returns:
6e0e310c   tangwang   1. Translator 类增强
365
              Dictionary mapping language code to translated text (only cached results in async mode)
be52af70   tangwang   first commit
366
367
          """
          results = {}
6e0e310c   tangwang   1. Translator 类增强
368
          missing_langs = []
a5a6bab8   tangwang   多语言查询优化
369
          async_langs = []
6e0e310c   tangwang   1. Translator 类增强
370
371
          
          # First, get cached translations
be52af70   tangwang   first commit
372
          for lang in target_langs:
0064e946   tangwang   feat: 增量索引服务、租户配置...
373
              cached = self._get_cached_translation(text, lang, source_lang, context, prompt)
6e0e310c   tangwang   1. Translator 类增强
374
375
376
377
378
              if cached is not None:
                  results[lang] = cached
              else:
                  missing_langs.append(lang)
          
a5a6bab8   tangwang   多语言查询优化
379
          # If async mode and there are missing translations
6e0e310c   tangwang   1. Translator 类增强
380
          if async_mode and missing_langs:
a5a6bab8   tangwang   多语言查询优化
381
              # Check if translation can be optimized (immediate return)
6e0e310c   tangwang   1. Translator 类增强
382
              for lang in missing_langs:
a5a6bab8   tangwang   多语言查询优化
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
                  target_lang = lang.lower()
                  # Check optimization conditions (same as in translate method)
                  can_optimize = False
                  if target_lang == 'en' and self._is_english_text(text):
                      can_optimize = True
                  elif target_lang == 'zh' and (self._contains_chinese(text) or self._is_pure_number(text)):
                      can_optimize = True
                  
                  if can_optimize:
                      # Can be optimized, call translate synchronously for immediate result
                      results[lang] = self.translate(text, lang, source_lang, context, prompt)
                  else:
                      # Requires actual translation, add to async list
                      async_langs.append(lang)
              
              # Launch async tasks for translations that require actual API calls
              if async_langs:
                  for lang in async_langs:
                      self._translate_async(text, lang, source_lang, context, prompt)
                  # Return None for async translations
                  for lang in async_langs:
                      results[lang] = None
6e0e310c   tangwang   1. Translator 类增强
405
406
407
          else:
              # Synchronous mode: wait for all translations
              for lang in missing_langs:
0064e946   tangwang   feat: 增量索引服务、租户配置...
408
                  results[lang] = self.translate(text, lang, source_lang, context, prompt)
6e0e310c   tangwang   1. Translator 类增强
409
          
be52af70   tangwang   first commit
410
          return results
6e0e310c   tangwang   1. Translator 类增强
411
      
3ec5bfe6   tangwang   1. get_translatio...
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
      def translate_multi_async(
          self,
          text: str,
          target_langs: List[str],
          source_lang: Optional[str] = None,
          context: Optional[str] = None,
          prompt: Optional[str] = None
      ) -> Dict[str, Union[str, Future]]:
          """
          Translate text to multiple target languages asynchronously, returning Futures that can be awaited.
          
          This method returns a dictionary where:
          - If translation is cached, the value is the translation string (immediate)
          - If translation needs to be done, the value is a Future object that can be awaited
          
          Args:
              text: Text to translate
              target_langs: List of target language codes
              source_lang: Source language code (optional)
              context: Context hint for translation (optional)
              prompt: Translation prompt/instruction (optional)
  
          Returns:
              Dictionary mapping language code to either translation string (cached) or Future object
          """
          results = {}
          missing_langs = []
          
          # First, get cached translations
          for lang in target_langs:
              cached = self._get_cached_translation(text, lang, source_lang, context, prompt)
              if cached is not None:
                  results[lang] = cached
              else:
                  missing_langs.append(lang)
          
          # For missing translations, submit async tasks and return Futures
          for lang in missing_langs:
              future = self.executor.submit(
                  self.translate,
                  text,
                  lang,
                  source_lang,
                  context,
                  prompt
              )
              results[lang] = future
          
          return results
      
6e0e310c   tangwang   1. Translator 类增强
462
463
464
465
466
      def _get_cached_translation(
          self,
          text: str,
          target_lang: str,
          source_lang: Optional[str] = None,
0064e946   tangwang   feat: 增量索引服务、租户配置...
467
468
          context: Optional[str] = None,
          prompt: Optional[str] = None
6e0e310c   tangwang   1. Translator 类增强
469
470
      ) -> Optional[str]:
          """Get translation from cache if available."""
453992a8   tangwang   需求:
471
472
473
474
475
476
477
478
479
480
481
482
483
484
          if not self.redis_client:
              return None
          return self._get_cached_translation_redis(text, target_lang, source_lang, context, prompt)
      
      def _get_cached_translation_redis(
          self,
          text: str,
          target_lang: str,
          source_lang: Optional[str] = None,
          context: Optional[str] = None,
          prompt: Optional[str] = None
      ) -> Optional[str]:
          """Get translation from Redis cache with sliding expiration."""
          if not self.redis_client:
6e0e310c   tangwang   1. Translator 类增强
485
486
              return None
          
453992a8   tangwang   需求:
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
          try:
              # Build cache key: prefix:target_lang:text
              # For simplicity, we use target_lang and text as key
              # Context and prompt are not included in key to maximize cache hits
              cache_key = f"{self.cache_prefix}:{target_lang.upper()}:{text}"
              value = self.redis_client.get(cache_key)
              if value:
                  # Sliding expiration: reset expiration time on access
                  self.redis_client.expire(cache_key, self.expire_time)
                  logger.debug(f"[Translator] Cache hit for translation: {text} -> {target_lang}")
                  return value
              return None
          except Exception as e:
              logger.error(f"[Translator] Redis error during get translation cache: '{text}' {target_lang}: {e}")
              return None
      
      def _set_cached_translation_redis(
          self,
          text: str,
          target_lang: str,
          translation: str,
          source_lang: Optional[str] = None,
          context: Optional[str] = None,
          prompt: Optional[str] = None
      ) -> None:
          """Store translation in Redis cache."""
          if not self.redis_client:
              return
          
          try:
              cache_key = f"{self.cache_prefix}:{target_lang.upper()}:{text}"
              self.redis_client.setex(cache_key, self.expire_time, translation)
              logger.debug(f"[Translator] Cached translation: {text} -> {target_lang}: {translation}")
          except Exception as e:
              logger.error(f"[Translator] Redis error during set translation cache: '{text}' {target_lang}: {e}")
6e0e310c   tangwang   1. Translator 类增强
522
523
524
525
526
527
      
      def _translate_async(
          self,
          text: str,
          target_lang: str,
          source_lang: Optional[str] = None,
0064e946   tangwang   feat: 增量索引服务、租户配置...
528
529
          context: Optional[str] = None,
          prompt: Optional[str] = None
6e0e310c   tangwang   1. Translator 类增强
530
531
532
533
      ):
          """Launch async translation task."""
          def _do_translate():
              try:
0064e946   tangwang   feat: 增量索引服务、租户配置...
534
                  result = self.translate(text, target_lang, source_lang, context, prompt)
6e0e310c   tangwang   1. Translator 类增强
535
536
537
538
539
540
                  if result:
                      logger.debug(f"Async translation completed: {text} -> {target_lang}: {result}")
              except Exception as e:
                  logger.warning(f"Async translation failed: {text} -> {target_lang}: {e}")
          
          self.executor.submit(_do_translate)
be52af70   tangwang   first commit
541
  
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
      def _add_ecommerce_context(
          self,
          text: str,
          source_lang: Optional[str],
          context: Optional[str]
      ) -> tuple:
          """
          Add e-commerce context to text for better disambiguation.
          
          For single-word ambiguous Chinese terms, we add context words that help
          DeepL understand this is an e-commerce/product search context.
          
          Args:
              text: Original text to translate
              source_lang: Source language code
              context: Context hint
              
          Returns:
              Tuple of (text_with_context, needs_extraction)
              - text_with_context: Text to send to DeepL
              - needs_extraction: Whether we need to extract the term from the result
          """
          # Only apply for e-commerce context and Chinese source
          if not context or "e-commerce" not in context.lower():
              return text, False
              
          if not source_lang or source_lang.lower() != 'zh':
              return text, False
              
          # For single-word queries, add context to help disambiguation
          text_stripped = text.strip()
          if len(text_stripped.split()) == 1 and len(text_stripped) <= 2:
              # Common ambiguous Chinese e-commerce terms like "车" (car vs rook)
              # We add a context phrase: "购买 [term]" (buy [term]) or "商品 [term]" (product [term])
              # This helps DeepL understand the e-commerce context
              # We'll need to extract just the term from the translation result
              context_phrase = f"购买 {text_stripped}"
              return context_phrase, True
          
          # For multi-word queries, DeepL usually has enough context
          return text, False
  
      def _extract_term_from_translation(
          self,
          translated_text: str,
          original_text: str,
          target_lang_code: str
      ) -> str:
          """
          Extract the actual term from a translation that included context.
          
          For example, if we translated "购买 车" (buy car) and got "buy car",
          we want to extract just "car".
          
          Args:
              translated_text: Full translation result
              original_text: Original single-word query
              target_lang_code: Target language code (EN, ZH, etc.)
              
          Returns:
              Extracted term or original translation if extraction fails
          """
          # For English target, try to extract the last word (the actual term)
          if target_lang_code == "EN":
              words = translated_text.strip().split()
              if len(words) > 1:
                  # Usually the last word is the term we want
                  # But we need to be smart - if it's "buy car", we want "car"
                  # Common context words to skip: buy, purchase, product, item, etc.
                  context_words = {"buy", "purchase", "product", "item", "commodity", "goods"}
                  # Try to find the term (not a context word)
                  for word in reversed(words):
                      word_lower = word.lower().rstrip('.,!?;:')
                      if word_lower not in context_words:
                          return word_lower
                  # If all words are context words, return the last one
                  return words[-1].lower().rstrip('.,!?;:')
          
          # For other languages or if extraction fails, return as-is
          # The user can configure a glossary for better results
          return translated_text
  
453992a8   tangwang   需求:
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
      def translate_for_indexing(
          self,
          text: str,
          shop_language: str,
          source_lang: Optional[str] = None,
          context: Optional[str] = None,
          prompt: Optional[str] = None
      ) -> Dict[str, Optional[str]]:
          """
          Translate text for indexing based on shop language configuration.
          
          This method automatically handles multi-language translation:
          - If shop language is not 'zh', translate to Chinese (zh)
          - If shop language is not 'en', translate to English (en)
          
          All translation logic is internal - callers don't need to worry about
          which languages to translate to.
          
          Args:
              text: Text to translate
              shop_language: Shop's configured language (e.g., 'zh', 'en', 'ru')
              source_lang: Source language code (optional, auto-detect if None)
              context: Additional context for translation (optional)
              prompt: Translation prompt/instruction (optional)
              
          Returns:
              Dictionary with 'zh' and 'en' keys containing translated text (or None if not needed)
              Example: {'zh': '中文翻译', 'en': 'English translation'}
          """
          if not text or not text.strip():
              return {'zh': None, 'en': None}
          
          # Skip translation for symbol-only queries
          if re.match(r'^[\d\s_-]+$', text):
              logger.info(f"[Translator] Skip translation for symbol-only query: '{text}'")
              return {'zh': None, 'en': None}
          
          results = {'zh': None, 'en': None}
          shop_lang_lower = shop_language.lower() if shop_language else ""
          
          # Determine which languages need translation
          targets = []
          if "zh" not in shop_lang_lower:
              targets.append("zh")
          if "en" not in shop_lang_lower:
              targets.append("en")
          
          # If shop language is already zh and en, no translation needed
          if not targets:
              # Use original text for both languages
              if "zh" in shop_lang_lower:
                  results['zh'] = text
              if "en" in shop_lang_lower:
                  results['en'] = text
              return results
          
          # Translate to each target language
          for target_lang in targets:
              # Check cache first
              cached = self._get_cached_translation_redis(text, target_lang, source_lang, context, prompt)
              if cached:
                  results[target_lang] = cached
                  logger.debug(f"[Translator] Cache hit for indexing: '{text}' -> {target_lang}: {cached}")
                  continue
              
              # Translate synchronously for indexing (we need the result immediately)
              translated = self.translate(
                  text,
                  target_lang=target_lang,
                  source_lang=source_lang or shop_language,
                  context=context,
                  prompt=prompt
              )
              results[target_lang] = translated
          
          return results
  
be52af70   tangwang   first commit
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
      def get_translation_needs(
          self,
          detected_lang: str,
          supported_langs: List[str]
      ) -> List[str]:
          """
          Determine which languages need translation.
  
          Args:
              detected_lang: Detected query language
              supported_langs: List of supported languages
  
          Returns:
              List of language codes to translate to
          """
          # If detected language is in supported list, translate to others
          if detected_lang in supported_langs:
453992a8   tangwang   需求:
718
              return [lang for lang in supported_langs if detected_lang != lang]
be52af70   tangwang   first commit
719
720
721
  
          # Otherwise, translate to all supported languages
          return supported_langs
a5a6bab8   tangwang   多语言查询优化
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
      
      def _is_english_text(self, text: str) -> bool:
          """
          Check if text is primarily English (ASCII letters, numbers, common punctuation).
          
          Args:
              text: Text to check
              
          Returns:
              True if text appears to be English
          """
          if not text or not text.strip():
              return True
          
          # Remove whitespace and common punctuation
          text_clean = re.sub(r'[\s\.,!?;:\-\'\"\(\)\[\]{}]', '', text)
          if not text_clean:
              return True
          
          # Check if all remaining characters are ASCII (letters, numbers)
          # This is a simple heuristic: if most characters are ASCII, it's likely English
          ascii_count = sum(1 for c in text_clean if ord(c) < 128)
          ratio = ascii_count / len(text_clean) if text_clean else 0
          
          # If more than 80% are ASCII characters, consider it English
          return ratio > 0.8
      
      def _contains_chinese(self, text: str) -> bool:
          """
          Check if text contains Chinese characters (Han characters).
          
          Args:
              text: Text to check
              
          Returns:
              True if text contains Chinese characters
          """
          if not text:
              return False
          
          # Check for Chinese characters (Unicode range: \u4e00-\u9fff)
          chinese_pattern = re.compile(r'[\u4e00-\u9fff]')
          return bool(chinese_pattern.search(text))
      
      def _is_pure_number(self, text: str) -> bool:
          """
          Check if text is purely numeric (digits, possibly with spaces, dots, commas).
          
          Args:
              text: Text to check
              
          Returns:
              True if text is purely numeric
          """
          if not text or not text.strip():
              return False
          
          # Remove whitespace, dots, commas (common number separators)
          text_clean = re.sub(r'[\s\.,]', '', text.strip())
          if not text_clean:
              return False
          
          # Check if all remaining characters are digits
          return text_clean.isdigit()