Blame view

query/translator.py 30.2 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
          # Optimization: Skip translation if not needed
          if target_lang == 'en' and self._is_english_text(text):
3652f85f   tangwang   trans for index
139
              logger.info(f"[Translator] Text is already English, skipping translation: '{text[:50]}...'")
a5a6bab8   tangwang   多语言查询优化
140
141
142
              return text
          
          if target_lang == 'zh' and (self._contains_chinese(text) or self._is_pure_number(text)):
70dab99f   tangwang   add logs
143
144
145
146
              logger.info(
                  f"[Translator] Translation request | Original text: '{text}' | Target language: {target_lang} | "
                  f"Source language: {source_lang or 'auto'} | Result: Skip translation (contains Chinese or pure number)"
              )
a5a6bab8   tangwang   多语言查询优化
147
148
              return text
  
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
149
150
          # Use provided context or default context
          translation_context = context or self.translation_context
0064e946   tangwang   feat: 增量索引服务、租户配置...
151
152
153
154
155
156
157
158
159
          
          # 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   需求:
160
161
          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
162
              if cached:
3652f85f   tangwang   trans for index
163
                  logger.info(
70dab99f   tangwang   add logs
164
165
                      f"[Translator] Translation request | Original text: '{text}' | Target language: {target_lang} | "
                      f"Source language: {source_lang or 'auto'} | Result: '{cached}' | Source: Cache hit"
3652f85f   tangwang   trans for index
166
                  )
be52af70   tangwang   first commit
167
168
169
170
                  return cached
  
          # If no API key, return mock translation (for testing)
          if not self.api_key:
70dab99f   tangwang   add logs
171
172
173
174
              logger.info(
                  f"[Translator] Translation request | Original text: '{text}' | Target language: {target_lang} | "
                  f"Source language: {source_lang or 'auto'} | Result: '{text}' | Source: Mock mode (no API key)"
              )
be52af70   tangwang   first commit
175
176
              return text
  
3652f85f   tangwang   trans for index
177
178
          # Translate using DeepL (Pro endpoint only, no free fallback)
          logger.info(
70dab99f   tangwang   add logs
179
180
181
              f"[Translator] Translation request | Original text: '{text}' | Target language: {target_lang} | "
              f"Source language: {source_lang or 'auto'} | Context: {translation_context} | "
              f"Prompt: {'yes' if prompt else 'no'} | Status: Starting translation"
3652f85f   tangwang   trans for index
182
          )
0064e946   tangwang   feat: 增量索引服务、租户配置...
183
          result = self._translate_deepl(text, target_lang, source_lang, translation_context, prompt)
be52af70   tangwang   first commit
184
  
16c42787   tangwang   feat: implement r...
185
186
          # If still failed, return original text with warning
          if result is None:
70dab99f   tangwang   add logs
187
188
189
190
              logger.warning(
                  f"[Translator] Translation request | Original text: '{text}' | Target language: {target_lang} | "
                  f"Source language: {source_lang or 'auto'} | Result: '{text}' | Status: Translation failed, returning original"
              )
16c42787   tangwang   feat: implement r...
191
              result = text
70dab99f   tangwang   add logs
192
193
194
195
196
          else:
              logger.info(
                  f"[Translator] Translation request | Original text: '{text}' | Target language: {target_lang} | "
                  f"Source language: {source_lang or 'auto'} | Result: '{result}' | Status: Translation successful"
              )
3652f85f   tangwang   trans for index
197
  
be52af70   tangwang   first commit
198
          # Cache result
453992a8   tangwang   需求:
199
200
          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
201
202
203
204
205
206
207
  
          return result
  
      def _translate_deepl(
          self,
          text: str,
          target_lang: str,
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
208
          source_lang: Optional[str],
0064e946   tangwang   feat: 增量索引服务、租户配置...
209
210
          context: Optional[str] = None,
          prompt: Optional[str] = None
be52af70   tangwang   first commit
211
      ) -> Optional[str]:
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
212
213
214
215
216
217
218
219
220
          """
          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
221
222
223
224
225
226
227
228
          # 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: 增量索引服务、租户配置...
229
230
231
232
233
          # 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添...
234
235
          # 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: 增量索引服务、租户配置...
236
          text_to_translate, needs_extraction = self._add_ecommerce_context(text, source_lang, api_context)
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
237
  
be52af70   tangwang   first commit
238
          payload = {
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
239
              "text": [text_to_translate],
be52af70   tangwang   first commit
240
241
242
243
244
245
246
              "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: 增量索引服务、租户配置...
247
248
249
250
251
          # 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添...
252
253
254
255
          # Add glossary if configured
          if self.glossary_id:
              payload["glossary_id"] = self.glossary_id
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
256
257
258
          # 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添...
259
  
be52af70   tangwang   first commit
260
261
262
263
264
265
266
267
268
269
270
          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添...
271
272
273
274
275
276
                      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
                          )
70dab99f   tangwang   add logs
277
278
279
280
                      logger.debug(
                          f"[Translator] DeepL API response success | Original text: '{text}' | Target language: {target_code} | "
                          f"Translation result: '{translated_text}'"
                      )
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
281
                      return translated_text
be52af70   tangwang   first commit
282
              else:
70dab99f   tangwang   add logs
283
284
285
286
                  logger.error(
                      f"[Translator] DeepL API error | Original text: '{text}' | Target language: {target_code} | "
                      f"Status code: {response.status_code} | Error message: {response.text}"
                  )
be52af70   tangwang   first commit
287
288
289
                  return None
  
          except requests.Timeout:
70dab99f   tangwang   add logs
290
291
292
293
              logger.warning(
                  f"[Translator] DeepL API request timeout | Original text: '{text}' | Target language: {target_code} | "
                  f"Timeout: {self.timeout}s"
              )
be52af70   tangwang   first commit
294
295
              return None
          except Exception as e:
70dab99f   tangwang   add logs
296
297
298
299
              logger.error(
                  f"[Translator] DeepL API request exception | Original text: '{text}' | Target language: {target_code} | "
                  f"Error: {e}", exc_info=True
              )
be52af70   tangwang   first commit
300
301
              return None
  
3652f85f   tangwang   trans for index
302
303
304
      # NOTE: _translate_deepl_free is intentionally not implemented.
      # We do not support automatic fallback to the free endpoint, to avoid
      # mixing Pro keys with https://api-free.deepl.com and related 403 errors.
16c42787   tangwang   feat: implement r...
305
  
be52af70   tangwang   first commit
306
307
308
309
      def translate_multi(
          self,
          text: str,
          target_langs: List[str],
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
310
          source_lang: Optional[str] = None,
6e0e310c   tangwang   1. Translator 类增强
311
          context: Optional[str] = None,
0064e946   tangwang   feat: 增量索引服务、租户配置...
312
313
          async_mode: bool = True,
          prompt: Optional[str] = None
be52af70   tangwang   first commit
314
315
316
      ) -> Dict[str, Optional[str]]:
          """
          Translate text to multiple target languages.
6e0e310c   tangwang   1. Translator 类增强
317
318
319
          
          In async_mode=True (default):
          - Returns cached translations immediately if available
a5a6bab8   tangwang   多语言查询优化
320
321
322
323
          - 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 类增强
324
325
326
          
          In async_mode=False:
          - Waits for all translations to complete (blocking)
be52af70   tangwang   first commit
327
328
329
330
331
  
          Args:
              text: Text to translate
              target_langs: List of target language codes
              source_lang: Source language code (optional)
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
332
              context: Context hint for translation (optional)
6e0e310c   tangwang   1. Translator 类增强
333
              async_mode: If True, return cached results immediately and translate missing ones async
0064e946   tangwang   feat: 增量索引服务、租户配置...
334
              prompt: Translation prompt/instruction (optional)
be52af70   tangwang   first commit
335
336
  
          Returns:
6e0e310c   tangwang   1. Translator 类增强
337
              Dictionary mapping language code to translated text (only cached results in async mode)
be52af70   tangwang   first commit
338
339
          """
          results = {}
6e0e310c   tangwang   1. Translator 类增强
340
          missing_langs = []
a5a6bab8   tangwang   多语言查询优化
341
          async_langs = []
6e0e310c   tangwang   1. Translator 类增强
342
343
          
          # First, get cached translations
be52af70   tangwang   first commit
344
          for lang in target_langs:
0064e946   tangwang   feat: 增量索引服务、租户配置...
345
              cached = self._get_cached_translation(text, lang, source_lang, context, prompt)
6e0e310c   tangwang   1. Translator 类增强
346
347
348
349
350
              if cached is not None:
                  results[lang] = cached
              else:
                  missing_langs.append(lang)
          
a5a6bab8   tangwang   多语言查询优化
351
          # If async mode and there are missing translations
6e0e310c   tangwang   1. Translator 类增强
352
          if async_mode and missing_langs:
a5a6bab8   tangwang   多语言查询优化
353
              # Check if translation can be optimized (immediate return)
6e0e310c   tangwang   1. Translator 类增强
354
              for lang in missing_langs:
a5a6bab8   tangwang   多语言查询优化
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
                  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 类增强
377
378
379
          else:
              # Synchronous mode: wait for all translations
              for lang in missing_langs:
0064e946   tangwang   feat: 增量索引服务、租户配置...
380
                  results[lang] = self.translate(text, lang, source_lang, context, prompt)
6e0e310c   tangwang   1. Translator 类增强
381
          
be52af70   tangwang   first commit
382
          return results
6e0e310c   tangwang   1. Translator 类增强
383
      
3ec5bfe6   tangwang   1. get_translatio...
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
      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 类增强
434
435
436
437
438
      def _get_cached_translation(
          self,
          text: str,
          target_lang: str,
          source_lang: Optional[str] = None,
0064e946   tangwang   feat: 增量索引服务、租户配置...
439
440
          context: Optional[str] = None,
          prompt: Optional[str] = None
6e0e310c   tangwang   1. Translator 类增强
441
442
      ) -> Optional[str]:
          """Get translation from cache if available."""
453992a8   tangwang   需求:
443
444
445
446
447
448
449
450
451
452
453
454
455
456
          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 类增强
457
458
              return None
          
453992a8   tangwang   需求:
459
460
461
462
463
464
465
466
467
          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)
70dab99f   tangwang   add logs
468
469
470
                  logger.debug(
                      f"[Translator] Redis cache hit | Original text: '{text}' | Target language: {target_lang} | "
                      f"Cache key: {cache_key} | Translation result: '{value}'"
3652f85f   tangwang   trans for index
471
                  )
453992a8   tangwang   需求:
472
                  return value
70dab99f   tangwang   add logs
473
474
475
476
              logger.debug(
                  f"[Translator] Redis cache miss | Original text: '{text}' | Target language: {target_lang} | "
                  f"Cache key: {cache_key}"
              )
453992a8   tangwang   需求:
477
478
              return None
          except Exception as e:
70dab99f   tangwang   add logs
479
              logger.error(f"[Translator] Redis error during get translation cache | Original text: '{text}' | Target language: {target_lang} | Error: {e}")
453992a8   tangwang   需求:
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
              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)
70dab99f   tangwang   add logs
498
499
500
              logger.debug(
                  f"[Translator] Redis cache write | Original text: '{text}' | Target language: {target_lang} | "
                  f"Cache key: {cache_key} | Translation result: '{translation}'"
3652f85f   tangwang   trans for index
501
              )
453992a8   tangwang   需求:
502
          except Exception as e:
70dab99f   tangwang   add logs
503
504
505
506
              logger.error(
                  f"[Translator] Redis cache write failed | Original text: '{text}' | Target language: {target_lang} | "
                  f"Error: {e}"
              )
6e0e310c   tangwang   1. Translator 类增强
507
508
509
510
511
512
      
      def _translate_async(
          self,
          text: str,
          target_lang: str,
          source_lang: Optional[str] = None,
0064e946   tangwang   feat: 增量索引服务、租户配置...
513
514
          context: Optional[str] = None,
          prompt: Optional[str] = None
6e0e310c   tangwang   1. Translator 类增强
515
516
517
518
      ):
          """Launch async translation task."""
          def _do_translate():
              try:
0064e946   tangwang   feat: 增量索引服务、租户配置...
519
                  result = self.translate(text, target_lang, source_lang, context, prompt)
6e0e310c   tangwang   1. Translator 类增强
520
521
522
523
524
525
                  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
526
  
522a3964   tangwang   多语言搜索翻译的优化(deepL添...
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
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
      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   需求:
609
610
611
612
613
614
      def translate_for_indexing(
          self,
          text: str,
          shop_language: str,
          source_lang: Optional[str] = None,
          context: Optional[str] = None,
345d960b   tangwang   1. 删除全局 enable_tr...
615
616
617
          prompt: Optional[str] = None,
          translate_to_en: bool = True,
          translate_to_zh: bool = True,
453992a8   tangwang   需求:
618
619
      ) -> Dict[str, Optional[str]]:
          """
345d960b   tangwang   1. 删除全局 enable_tr...
620
          Translate text for indexing based on shop language and tenant configuration.
453992a8   tangwang   需求:
621
          
345d960b   tangwang   1. 删除全局 enable_tr...
622
623
624
625
          Translation behavior:
          - If translate_to_zh=True and shop language is not 'zh', translate to Chinese (zh)
          - If translate_to_en=True and shop language is not 'en', translate to English (en)
          - If both flags are False, no translation is performed (returns None for both)
453992a8   tangwang   需求:
626
627
628
629
630
631
632
          
          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)
345d960b   tangwang   1. 删除全局 enable_tr...
633
634
              translate_to_en: Whether to translate to English (from tenant_config)
              translate_to_zh: Whether to translate to Chinese (from tenant_config)
453992a8   tangwang   需求:
635
636
              
          Returns:
345d960b   tangwang   1. 删除全局 enable_tr...
637
638
              Dictionary with 'zh' and 'en' keys containing translated text (or None if not needed/not enabled)
              Example: {'zh': '中文翻译', 'en': 'English translation'} or {'zh': None, 'en': None}
453992a8   tangwang   需求:
639
640
641
642
643
644
645
646
647
648
649
650
          """
          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 ""
          
345d960b   tangwang   1. 删除全局 enable_tr...
651
          # Determine which languages need translation based on tenant configuration
453992a8   tangwang   需求:
652
          targets = []
345d960b   tangwang   1. 删除全局 enable_tr...
653
          if translate_to_zh and "zh" not in shop_lang_lower:
453992a8   tangwang   需求:
654
              targets.append("zh")
345d960b   tangwang   1. 删除全局 enable_tr...
655
          if translate_to_en and "en" not in shop_lang_lower:
453992a8   tangwang   需求:
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
              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
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
      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   需求:
705
              return [lang for lang in supported_langs if detected_lang != lang]
be52af70   tangwang   first commit
706
707
708
  
          # Otherwise, translate to all supported languages
          return supported_langs
a5a6bab8   tangwang   多语言查询优化
709
710
711
712
713
714
715
716
717
718
719
720
721
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
      
      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()