Legacy-Definition sicher vergleichen
Diese Detailansicht zeigt den unveränderten Legacy-Dateistand. Von hier aus lässt sich die Definition als Draft in die Workbench übernehmen und dort weiter bearbeiten, ohne das Original im Dateisystem anzutasten.
Diese Detailansicht zeigt den unveränderten Legacy-Dateistand. Von hier aus lässt sich die Definition als Draft in die Workbench übernehmen und dort weiter bearbeiten, ohne das Original im Dateisystem anzutasten.
Raw YAML
Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.
#Connections
Source_Config: enhanceEngine
Target_Config: exportEngine
#Source
Source_Datapool: iwm_articles_texte_txt40
Mysql_Engine: InnoDB
Default_Charset: utf8
Index: [text_hash]
#Read_Conditions: #notice for first time use: if export_texts_scanned_lastrun does not exist, commment Read_Conditions here and run the engine, then uncomment it and run engine again - text_hash has to have an index in both tables
# - dg_supplierdata_export.export_texts_scanned_lastrun.arte IS NULL
#Joins:
# - Left_Join: #each condition is joined with "AND"
# Datapool: dg_supplierdata_export.export_texts_scanned_lastrun
# Join_Condition: iwm_articles_texte_txt40.arte = export_texts_scanned_lastrun.arte and iwm_articles_texte_txt40.firma = export_texts_scanned_lastrun.firma
#Read_Conditions: #notice for first time use: if export_texts_scanned_lastrun does not exist, commment Read_Conditions here and run the engine, then uncomment it and run engine again - text_hash has to have an index in both tables
# - iwm_articles_texte_txt40.text_hash NOT IN (SELECT text_hash FROM dg_supplierdata_export.export_texts_scanned_lastrun)
Datapool_Definition:
firma: VARCHAR(2) NOT NULL
arte: VARCHAR(10) NOT NULL
text: TEXT DEFAULT NULL
text_hash: VARCHAR(50) DEFAULT NULL
text_scanned: VARCHAR(2) DEFAULT NULL
forbid_text_generation: VARCHAR(2) DEFAULT NULL
append_text: VARCHAR(2) DEFAULT NULL
Mapping:
firma:
Source: iwm_articles_texte_txt40.firma
arte:
Source: iwm_articles_texte_txt40.arte
text:
Source: iwm_articles_texte_txt40.text
text_hash:
Source: iwm_articles_texte_txt40.text
Field_Adapter:
- md5
text_scanned: (1)
forbid_text_generation:
Source: iwm_articles_texte_txt40.firma
File_Field_Adapter:
File: export_texts_scanned.forbid_text_generation
append_text:
Source: iwm_articles_texte_txt40.firma
File_Field_Adapter:
File: export_texts_scanned.append_text
#Target
Datapool: export_texts_scanned #sql table
Primary_Key: [arte, firma]
Metadata
Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.
| Source_Config | enhanceEngine |
|---|---|
| Target_Config | exportEngine |
| Source_Datapool | iwm_articles_texte_txt40 |
| Mysql_Engine | InnoDB |
| Default_Charset | utf8 |
| Index | [ "text_hash" ] |
| Datapool_Definition | { "firma": "VARCHAR(2) NOT NULL", "arte": "VARCHAR(10) NOT NULL", "text": "TEXT DEFAULT NULL", "text_hash": "VARCHAR(50) DEFAULT NULL", "text_scanned": "VARCHAR(2) DEFAULT NULL", "forbid_text_generation": "VARCHAR(2) DEFAULT NULL", "append_text": "VARCHAR(2) DEFAULT NULL" } |
| Mapping | { "firma": { "Source": "iwm_articles_texte_txt40.firma" }, "arte": { "Source": "iwm_articles_texte_txt40.arte" }, "text": { "Source": "iwm_articles_texte_txt40.text" }, "text_hash": { "Source": "iwm_articles_texte_txt40.text", "Field_Adapter": [ "md5" ] }, "text_scanned": "(1)", "forbid_text_generation": { "Source": "iwm_articles_texte_txt40.firma", "File_Field_Adapter": { "File": "export_texts_scanned.forbid_text_generation" } }, "append_text": { "Source": "iwm_articles_texte_txt40.firma", "File_Field_Adapter": { "File": "export_texts_scanned.append_text" } } } |
| Datapool | export_texts_scanned |
| Primary_Key | [ "arte", "firma" ] |