enhance / enhance_articles_test

#Connections
Source_Config: unitizeEngine #config - credetials of source connection service
Target_Config: enhanceEngine #config - credentials of target connection service

Enhance_Mode: flexible

#Engine Mode
Engine_Mode: full


#Source
Source_Datapool: iwm_articles  #sql from


Joins:
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_stock
  Join_Condition: iwm_articles.attr1 = iwm_articles_stock.firma and iwm_articles.ordernumber = iwm_articles_stock.ordernumber
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_kojen_per_article
  Join_Condition: iwm_articles.attr1 = iwm_articles_kojen_per_article.firma and iwm_articles.mainnumber = iwm_articles_kojen_per_article.mainnumber


#Target
Datapool: articles_test #sql table
Target_Datapool: articles_test  #sql from
Primary_Key: [ordernumber, attr1]



#Mapping -> Mappings source fields are detected by Mapping
Mapping:
   active_ost: iwm_articles.active_ost
   active_tre: iwm_articles.active_tre
   active_oms: iwm_articles.active_oms
   active_bil: iwm_articles.active_bil
   added: iwm_articles.added
   changed: iwm_articles.changed
   unitID: iwm_articles.unitID
   ean: iwm_articles.ean
   categories: iwm_articles.categories
   metaTitle: iwm_articles.metaTitle
   packUnit: iwm_articles.packUnit
   configuratorType: iwm_articles.configuratorType
   configuratorOptions: iwm_articles.configuratorOptions
   suppliernumber: iwm_articles.suppliernumber
   weight: iwm_articles.weight
   height: iwm_articles.height
   width: iwm_articles.width
   propertyGroupName: iwm_articles.propertyGroupName
   propertyValueName: iwm_articles.propertyValueName
   accessory: iwm_articles.accessory
   attr2: iwm_articles.attr2
   attr3: iwm_articles.attr3
   attr4: iwm_articles.attr4
   attr5: iwm_articles.attr5
   attr6: iwm_articles.attr6
   attr7: iwm_articles.attr7
   attr8: iwm_articles.attr8
   attr10: iwm_articles.attr10
   attr11: iwm_articles.attr11
   attr17: iwm_articles.attr17
   attr19: iwm_articles.attr19
   attr20: iwm_articles.attr20
   swag_attr21: kojencode
   swag_attr23: iwm_articles.swag_attr23
   swag_attr24: iwm_articles.swag_attr24
   swag_attr25: iwm_articles.swag_attr25
   swag_attr26: iwm_articles.swag_attr26
   swag_attr27: iwm_articles.swag_attr27
   swag_attr28: iwm_articles.swag_attr28
   swag_attr29: iwm_articles.swag_attr29
   swag_attr30: iwm_articles.swag_attr30
   stockmin_ost: iwm_articles.stockmin_ost
   stockmin_tre: iwm_articles.stockmin_tre
   stockmin_oms: iwm_articles.stockmin_oms
   stockmin_bil: iwm_articles.stockmin_bil
   LBNTEK: iwm_articles.LBNTEK
   LBKALK: iwm_articles.LBKALK
   LBMARGE: iwm_articles.LBMARGE
   LBWAEISA: iwm_articles.LBWAEISA
   AbsatzMenge3M: iwm_articles.AbsatzMenge3M
   name_oms:
     Source: iwm_articles.name_oms
     Field_Adapter:
      - addslashes:
   name_tre:
     Source: iwm_articles.name_tre
     Field_Adapter:
      - addslashes:
   name_ost:
     Source: iwm_articles.name_ost
     Field_Adapter:
      - addslashes:
   name_bil:
     Source: iwm_articles.name_bil
     Field_Adapter:
      - addslashes:
   referenceUnit: (1)
   attr1: iwm_articles.attr1
   attr9:
     Source: iwm_articles.attr9
     Field_Adapter:
      - addslashes:
   attr12:
     Source: iwm_articles.attr12
     Field_Adapter:
       - select_max_field: ['attr12', 'lieferzeitinwochen']
       - replace_empty: 0
       - replace_smaller: [0,0] #replace negative shipping time with 0
   attr13:
     Source: iwm_articles.attr13
     File_Field_Adapter:
      File: articles_test.attr13
   attr14:
     Source: iwm_articles.attr14
     File_Field_Adapter:
       File: articles_test.attr14
     Field_Adapter:
       - replace_empty: 0
       - replace_smaller: [0,0]
   attr15:
     Source: iwm_articles.attr15
     Field_Adapter:
       - replace_empty: 0
       - replace_smaller: [0,0]
   attr16:
     Source: iwm_articles.attr16
     Field_Adapter:
       - replace_empty: 0
       - replace_smaller: [0,0]
   attr18:
     Source: iwm_articles.attr18
     Field_Adapter:
       - replace_not_equals: [2, 0]
   instock:
     Source: iwm_articles.attr18
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: iwm_articles_stock #name of cross datapool
        Cross_Field: stock #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace_empty: 0
   stock_witten:
     Source: iwm_articles.attr18
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: iwm_articles_stock #name of cross datapool
        Cross_Field: witten #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace_empty: 0
   categoryPath_ost:
     Source: iwm_articles.categoryPath_ost
     File_Field_Adapter:
      File: articles_test.categoryPath_ost
   categoryPath_tre:
     Source: iwm_articles.categoryPath_tre
     File_Field_Adapter:
      File: articles_test.categoryPath_tre
   categoryPath_oms:
     Source: iwm_articles.categoryPath_oms
     File_Field_Adapter:
      File: articles_test.categoryPath_oms
   categoryPath_bil:
     Source: iwm_articles.categoryPath_bil
     File_Field_Adapter:
      File: articles_test.categoryPath_bil
   description:
     Source: iwm_articles.description
     Field_Adapter:
       - addslashes:
       - replace: ['http://', 'https://']
   description_long_ost:
     Source: iwm_articles.description_long_ost
     Field_Adapter:
       - replace: ['http://', 'https://']
     File_Field_Adapter:
      File: articles_test.description_long_ost
   description_long_tre:
     Source: iwm_articles.description_long_tre
     Field_Adapter:
       - replace: ['http://', 'https://']
     File_Field_Adapter:
      File: articles_test.description_long_tre
   description_long_oms:
     Source: iwm_articles.description_long_oms
     Field_Adapter:
       - replace: ['http://', 'https://']
     File_Field_Adapter:
      File: articles_test.description_long_oms
   description_long_bil:
     Source: iwm_articles.description_long_bil
     Field_Adapter:
       - replace: ['http://', 'https://']
     File_Field_Adapter:
      File: articles_test.description_long_bil
   ordernumber: iwm_articles.ordernumber
   mainnumber:
     Source: iwm_articles.mainnumber
     File_Field_Adapter:
      File: articles_test.mainnumber
   imageUrl:
     Source: iwm_articles.imageUrl
     File_Field_Adapter:
      File: articles_test.imageUrl
   ItemImageDate:
     Source: iwm_articles.ItemImageDate
     File_Field_Adapter:
      File: articles_test.ItemImageDate
   kind:
     Source: iwm_articles.kind
     File_Field_Adapter:
      File: articles_test.kind
   baseprice:
     Source: iwm_articles.baseprice
     Field_Adapter:
      - replace: [',','.']
   configSetId:
      Source: IF(iwm_articles.configSetId = '', 1, 0) AS configSetId
   height:
      Source: iwm_articles.height
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   price_ost:
     Source: iwm_articles.price_ost
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_ost #name of cross datapool
        Cross_Field: price_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
        - replace: [',','.']
        - float_pricision: 2
   price_tre:
      Source: iwm_articles.price_tre
      Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_tre #name of cross datapool
        Cross_Field: price_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   price_oms:
      Source: iwm_articles.price_oms
      Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool
        Cross_Field: price_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   price_bil:
      Source: iwm_articles.price_oms
      Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool
        Cross_Field: price_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   pseudoprice_ost:
     Source: iwm_articles.pseudoprice_ost
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_ost #name of cross datapool
        Cross_Field: pseudoprice_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   pseudoprice_tre:
     Source: iwm_articles.pseudoprice_tre
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_tre #name of cross datapool
        Cross_Field: pseudoprice_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   pseudoprice_oms:
     Source: iwm_articles.pseudoprice_oms
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool
        Cross_Field: pseudoprice_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   pseudoprice_bil:
      Source: iwm_articles.pseudoprice_bil
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   purchaseprice:
      Source: iwm_articles.purchaseprice
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   purchaseUnit:
      Source: iwm_articles.purchaseUnit
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   referenceUnit: (1)
   supplier_ost:
     Source: iwm_articles.supplier_ost
     Field_Adapter:
      - addslashes:
   supplier_tre:
     Source: iwm_articles.supplier_tre
     Field_Adapter:
      - addslashes:
   supplier_oms:
     Source: iwm_articles.supplier_oms
     Field_Adapter:
      - addslashes:
   supplier_bil:
     Source: iwm_articles.supplier_bil
     Field_Adapter:
      - addslashes:
   swag_attr22:
     Source: iwm_articles.swag_attr22
     Field_Adapter:
      - addslashes:
   tax:
      Source: iwm_articles.tax
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   shippingfree:
     Source: iwm_articles.shippingfree
   bestellsperre:
      Source: iwm_articles.name_oms
      Cross_Field_Adapter:
        Config: unitizeEngine
        Cross_Datapool: iwm_articles_new_bssp_and_auslauf #name of cross datapool
        Cross_Field: bestellsperre #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   auslaufkennzeichen:
      Source: iwm_articles.name_oms
      Cross_Field_Adapter:
        Config: unitizeEngine
        Cross_Datapool: iwm_articles_new_bssp_and_auslauf #name of cross datapool
        Cross_Field: auslaufkennzeichen #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   stock_ir:
      Source: iwm_articles.name_oms
      Cross_Field_Adapter:
        Config: unitizeEngine
        Cross_Datapool: iwm_articles_stock #name of cross datapool
        Cross_Field: stock_inventory #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool

Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - Filter:
    name: kein Bild  #there must always be a space between the key and the comparision operator and between the parentheses
    condition:
      Cross_Dataset_Filter_Adapter: enhance_articles_ost__filterNoPicture
    reason: 'kein Bild'
 - Filter:
    name: Weihnachtsartikel #there must always be a space between the key and the comparision operator and between the parentheses
    condition: (attr2 == 92) and (attr3 == 54)
    reason: Weihnachtsartikel
 - Filter:
    name: Weihnachtsartikel Lager 150
    condition:
      In_Pool_Filter_Adapter:
        Config: enhanceEngine
        Datapool: filter_weihnachtsartikellager150
        Local_Key: ordernumber
        Cross_Key: ordernumber
    reason: 'Weihnachtsartikel Lager 150'
 - Filter:
    name: Wiederbeschaffungszeit
    condition: (attr12 < 1) and (instock == 0)
    reason: Wiederbeschaffungszeit fehlerhaft
 - Filter:
    name: Auslauf und kein Bestand in Witten - Lagerware
    condition: (auslaufkennzeichen == 'J') and (stock_witten == 0) and (price_ost < 149) and (attr11 == 'L')
    reason: Auslauf und kein Bestand in Witten - Lagerware
 - Filter:
    name: Auslauf und nirgendwo Bestand - Lagerware
    condition: (auslaufkennzeichen == 'J') and (instock == 0) and (price_ost > 149) and (attr11 == 'L')
    reason: Auslauf und nirgendwo Bestand - Lagerware
 - Filter:
    name: Auslauf und nirgendwo Bestand - Bestellware
    condition: (auslaufkennzeichen == 'J') and (attr1 == 1) and (attr2 > 80) and (attr11 == 'B') and (instock == 0)
    reason: Auslauf und nirgendwo Bestand - Bestellware
 - Filter:
    name: Bestellsperre und kein Bestand
    condition: (bestellsperre == 'J') and (instock == 0)
    reason: Bestellsperre und kein Bestand