# Customer1 Configuration
# Test customer for cross-border e-commerce search

customer_name: "Customer1 Test Instance"

# MySQL Database Configuration
mysql_config:
  host: "120.79.247.228"
  port: 3316
  database: "saas"
  username: "saas"
  password: "P89cZHS5d7dFyc9R"

# Table Configuration
main_table: "shoplazza_product_sku"
extension_table: "customer1_extension"

# Elasticsearch Index
es_index_name: "search_customer1"

# ES Index Settings
es_settings:
  number_of_shards: 1
  number_of_replicas: 0
  refresh_interval: "30s"

# Field Definitions
fields:
  # Primary Key
  - name: "skuId"
    type: "LONG"
    source_table: "main"
    source_column: "id"
    required: true
    index: true
    store: true

  # Text Fields - Multi-language
  - name: "name"
    type: "TEXT"
    source_table: "extension"
    source_column: "name"
    analyzer: "chinese_ecommerce"
    boost: 2.0
    index: true
    store: true

  - name: "name_pinyin"
    type: "TEXT"
    source_table: "extension"
    source_column: "name_pinyin"
    analyzer: "standard"
    boost: 1.5
    index: true
    store: false

  - name: "ruSkuName"
    type: "TEXT"
    source_table: "extension"
    source_column: "ruSkuName"
    analyzer: "russian"
    boost: 2.0
    index: true
    store: true

  - name: "enSpuName"
    type: "TEXT"
    source_table: "extension"
    source_column: "enSpuName"
    analyzer: "english"
    boost: 2.0
    index: true
    store: true

  # Category and Brand
  - name: "categoryName"
    type: "TEXT"
    source_table: "extension"
    source_column: "categoryName"
    analyzer: "chinese_ecommerce"
    boost: 1.5
    index: true
    store: true

  - name: "brandName"
    type: "TEXT"
    source_table: "extension"
    source_column: "brandName"
    analyzer: "chinese_ecommerce"
    boost: 1.5
    index: true
    store: true

  - name: "supplierName"
    type: "TEXT"
    source_table: "extension"
    source_column: "supplierName"
    analyzer: "chinese_ecommerce"
    boost: 1.0
    index: true
    store: true

  # Keyword Fields
  - name: "categoryName_keyword"
    type: "KEYWORD"
    source_table: "extension"
    source_column: "categoryName"
    index: true
    store: false

  - name: "brandName_keyword"
    type: "KEYWORD"
    source_table: "extension"
    source_column: "brandName"
    index: true
    store: false

  - name: "supplierName_keyword"
    type: "KEYWORD"
    source_table: "extension"
    source_column: "supplierName"
    index: true
    store: false

  # Price Fields
  - name: "price"
    type: "DOUBLE"
    source_table: "extension"
    source_column: "price"
    index: true
    store: true

  # Text Embedding Fields
  - name: "name_embedding"
    type: "TEXT_EMBEDDING"
    source_table: "extension"
    source_column: "name"
    embedding_dims: 1024
    embedding_similarity: "dot_product"
    index: true

  - name: "enSpuName_embedding"
    type: "TEXT_EMBEDDING"
    source_table: "extension"
    source_column: "enSpuName"
    embedding_dims: 1024
    embedding_similarity: "dot_product"
    index: true

  # Image Fields
  - name: "imageUrl"
    type: "KEYWORD"
    source_table: "extension"
    source_column: "imageUrl"
    index: true
    store: true

  - name: "image_embedding"
    type: "IMAGE_EMBEDDING"
    source_table: "extension"
    source_column: "imageUrl"
    embedding_dims: 1024
    embedding_similarity: "dot_product"
    nested: false
    index: true

  # Metadata Fields
  - name: "create_time"
    type: "DATE"
    source_table: "extension"
    source_column: "create_time"
    index: true
    store: true

  - name: "days_since_last_update"
    type: "INT"
    source_table: "extension"
    source_column: "days_since_last_update"
    index: true
    store: true

# Index Structure (Query Domains)
indexes:
  - name: "default"
    label: "默认索引"
    fields:
      - "name"
      - "enSpuName"
      - "ruSkuName"
      - "categoryName"
      - "brandName"
    analyzer: "chinese_ecommerce"
    boost: 1.0
    example: 'query=default:"消防套"'
    language_field_mapping:
      zh:
        - "name"
        - "categoryName"
        - "brandName"
      en:
        - "enSpuName"
      ru:
        - "ruSkuName"

  - name: "title"
    label: "标题索引"
    fields:
      - "name"
      - "enSpuName"
      - "ruSkuName"
    analyzer: "chinese_ecommerce"
    boost: 2.0
    example: 'query=title:"芭比娃娃"'
    language_field_mapping:
      zh:
        - "name"
      en:
        - "enSpuName"
      ru:
        - "ruSkuName"

  - name: "category"
    label: "类目索引"
    fields:
      - "categoryName"
    analyzer: "chinese_ecommerce"
    boost: 1.5
    example: 'query=category:"玩具"'

  - name: "brand"
    label: "品牌索引"
    fields:
      - "brandName"
    analyzer: "chinese_ecommerce"
    boost: 1.5
    example: 'query=brand:"ZHU LIN"'

# Query Configuration
query_config:
  supported_languages:
    - "zh"
    - "en"
    - "ru"
  default_language: "zh"
  enable_translation: true
  enable_text_embedding: true
  enable_query_rewrite: true

  # Translation API (DeepL)
  translation_service: "deepl"
  translation_api_key: null  # Set via environment variable

# Ranking Configuration
ranking:
  expression: "bm25() + 0.2*text_embedding_relevance()"
  description: "BM25 text relevance combined with semantic embedding similarity"

# SPU Aggregation (disabled for customer1)
spu_config:
  enabled: false
  spu_field: null
  inner_hits_size: 3