Legacy YAML / Detail

unitize / unitize_suggestions_beny_all_marketplaces

Unveränderter Legacy-Dateistand mit sicherem Importpfad in die Workbench und direkter Sicht auf Roh-YAML, Metadaten und erkannte Features.

RLS aktiv Host ortho-live
Zurück zum Browser
Managed Definition öffnen

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.

Zum Raw YAML Zu den Metadaten
engine Typ
valid Parse-Status
Managed Status
draft
beny_suggestions_all_marketplaces Kurzinfo

Raw YAML

Dateiinhalt

Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.

Engine: Unitize
Source_Config: importEngine
Target_Config: unitizeEngine
Mysql_Engine: InnoDB
Default_Charset: utf8
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService
Source_Datapool: beny_suggestions_idealo
Source_Primary_Key: [ID, SHOP, RANKING]
Target_Primary_Key: [ID, SHOP, RANKING, MARKETPLACE] #always primary key for target datapool. primary key of source pool can be read from the pool itself.
Datapool: beny_suggestions_all_marketplaces


Datapool_Definition:
   MARKETPLACE: VARCHAR(50) NOT NULL
   FIRMA: VARCHAR(5) NOT NULL
   ARTE: VARCHAR(10) NOT NULL
   APNR: VARCHAR(10) NOT NULL
   ORDERNUMBER: VARCHAR(50) NOT NULL
   ID: VARCHAR(50) NOT NULL
   PRODUCTNAME: TEXT DEFAULT NULL
   CATEGORY: VARCHAR(255) DEFAULT NULL
   MANUFACTURER: VARCHAR(50) DEFAULT NULL
   MODEL: VARCHAR(50) DEFAULT NULL
   EAN: VARCHAR(50) DEFAULT NULL
   MPN: VARCHAR(50) DEFAULT NULL
   STATUS: VARCHAR(50) DEFAULT NULL
   RANKING: VARCHAR(50) NOT NULL
   SHIPPINGCOSTS: VARCHAR(50) DEFAULT NULL
   SHOP: VARCHAR(150) NOT NULL
   SHOP_URL: TEXT DEFAULT NULL
   NEWPRICE: VARCHAR(50) DEFAULT NULL
   OLDPRICE: VARCHAR(50) DEFAULT NULL
   PRICECHANGE: VARCHAR(50) DEFAULT NULL
   LASTUPDATE: VARCHAR(50) DEFAULT NULL
   BESTOFFERER: TEXT DEFAULT NULL
   BESTPRICE: VARCHAR(50) DEFAULT NULL
   TOTALPRICE: VARCHAR(50) DEFAULT NULL
   NEWTOTALPRICE: VARCHAR(50) DEFAULT NULL
   AVAILABILITY: VARCHAR(50) DEFAULT NULL
   DEEPLINK: TEXT DEFAULT NULL
   LISTED: VARCHAR(50) DEFAULT NULL
   CURRENTPRICE: VARCHAR(50) DEFAULT NULL
   AnbieterPreis: TEXT DEFAULT NULL


#Sql: SELECT * FROM (
#         SELECT t1.*, GROUP_CONCAT(CONCAT(CONCAT(t1.SHOP, ':'), t1.OLDPRICE) SEPARATOR ';') as AnbieterPreis, MAX(CAST(NEWPRICE AS DECIMAL(10,2))) AS MINNEWPRICE FROM (
#              SELECT * FROM (
#                 SELECT 'idealo.de' as MARKETPLACE, SUBSTRING(ID, 2, 1) AS FIRMA, SUBSTRING(ID, 4, 7) AS ARTE, SUBSTRING(ID, 11, 5) AS APNR, TRIM(TRAILING '-' FROM (CONCAT(CONCAT(TRIM(LEADING 0 FROM SUBSTRING(ID, 4, 7)),'-'), TRIM(LEADING 0 FROM SUBSTRING(ID, 11, 5))))) AS ORDERNUMBER, beny_suggestions_idealo.* FROM beny_suggestions_idealo
#                  UNION
#                 SELECT 'google.de' as MARKETPLACE, SUBSTRING(ID, 2, 1) AS FIRMA, SUBSTRING(ID, 4, 7) AS ARTE, SUBSTRING(ID, 11, 5) AS APNR, TRIM(TRAILING '-' FROM (CONCAT(CONCAT(TRIM(LEADING 0 FROM SUBSTRING(ID, 4, 7)),'-'), TRIM(LEADING 0 FROM SUBSTRING(ID, 11, 5))))) AS ORDERNUMBER, beny_suggestions_google.* FROM beny_suggestions_google
#              ) as t0
#         ) as t1 GROUP BY t1.MANUFACTURER, t1.MPN
#      ) as t2


Sql: SELECT t1.*, GROUP_CONCAT(CONCAT(CONCAT(t1.SHOP, ':'), t1.OLDPRICE) SEPARATOR ';') as AnbieterPreis, MAX(CAST(NEWPRICE AS DECIMAL(10,2))) AS MINNEWPRICE FROM (
          SELECT * FROM (
             SELECT 'idealo.de' as MARKETPLACE, SUBSTRING(ID, 2, 1) AS FIRMA, SUBSTRING(ID, 4, 7) AS ARTE, SUBSTRING(ID, 11, 5) AS APNR, TRIM(TRAILING '-' FROM (CONCAT(CONCAT(TRIM(LEADING 0 FROM SUBSTRING(ID, 4, 7)),'-'), TRIM(LEADING 0 FROM SUBSTRING(ID, 11, 5))))) AS ORDERNUMBER, beny_suggestions_idealo.* FROM beny_suggestions_idealo
              UNION
             SELECT 'google.de' as MARKETPLACE, SUBSTRING(ID, 2, 1) AS FIRMA, SUBSTRING(ID, 4, 7) AS ARTE, SUBSTRING(ID, 11, 5) AS APNR, TRIM(TRAILING '-' FROM (CONCAT(CONCAT(TRIM(LEADING 0 FROM SUBSTRING(ID, 4, 7)),'-'), TRIM(LEADING 0 FROM SUBSTRING(ID, 11, 5))))) AS ORDERNUMBER, beny_suggestions_google.* FROM beny_suggestions_google
          ) as t1
     ) as t1 GROUP BY t1.MANUFACTURER, t1.EAN



Mapping:
   MARKETPLACE: t1.MARKETPLACE
   FIRMA: t1.FIRMA
   ARTE: t1.ARTE
   APNR: t1.APNR
   ORDERNUMBER: t1.ORDERNUMBER
   ID: t1.ID
   PRODUCTNAME: t1.PRODUCTNAME
   CATEGORY: t1.CATEGORY
   MANUFACTURER: t1.MANUFACTURER
   MODEL: t1.MODEL
   EAN: t1.EAN
   MPN: t1.MPN
   STATUS: t1.STATUS
   RANKING: t1.RANKING
   SHIPPINGCOSTS: t1.SHIPPINGCOSTS
   SHOP: t1.SHOP
   SHOP_URL: t1.SHOP_URL
   NEWPRICE: t1.MINNEWPRICE
   OLDPRICE: t1.OLDPRICE
   PRICECHANGE: t1.PRICECHANGE
   LASTUPDATE: t1.LASTUPDATE
   BESTOFFERER: t1.BESTOFFERER
   BESTPRICE: t1.BESTPRICE
   TOTALPRICE: t1.TOTALPRICE
   NEWTOTALPRICE: t1.NEWTOTALPRICE
   AVAILABILITY: t1.AVAILABILITY
   DEEPLINK: t1.DEEPLINK
   LISTED: t1.LISTED
   CURRENTPRICE: t1.CURRENTPRICE
   AnbieterPreis: t1.AnbieterPreis

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Engine Unitize
Source_Config importEngine
Target_Config unitizeEngine
Mysql_Engine InnoDB
Default_Charset utf8
Source_Connection_Type database
Source_Database_Connection_Service DatabaseConnectionService
Source_Datapool beny_suggestions_idealo
Source_Primary_Key [ "ID", "SHOP", "RANKING" ]
Target_Primary_Key [ "ID", "SHOP", "RANKING", "MARKETPLACE" ]
Datapool beny_suggestions_all_marketplaces
Datapool_Definition { "MARKETPLACE": "VARCHAR(50) NOT NULL", "FIRMA": "VARCHAR(5) NOT NULL", "ARTE": "VARCHAR(10) NOT NULL", "APNR": "VARCHAR(10) NOT NULL", "ORDERNUMBER": "VARCHAR(50) NOT NULL", "ID": "VARCHAR(50) NOT NULL", "PRODUCTNAME": "TEXT DEFAULT NULL", "CATEGORY": "VARCHAR(255) DEFAULT NULL", "MANUFACTURER": "VARCHAR(50) DEFAULT NULL", "MODEL": "VARCHAR(50) DEFAULT NULL", "EAN": "VARCHAR(50) DEFAULT NULL", "MPN": "VARCHAR(50) DEFAULT NULL", "STATUS": "VARCHAR(50) DEFAULT NULL", "RANKING": "VARCHAR(50) NOT NULL", "SHIPPINGCOSTS": "VARCHAR(50) DEFAULT NULL", "SHOP": "VARCHAR(150) NOT NULL", "SHOP_URL": "TEXT DEFAULT NULL", "NEWPRICE": "VARCHAR(50) DEFAULT NULL", "OLDPRICE": "VARCHAR(50) DEFAULT NULL", "PRICECHANGE": "VARCHAR(50) DEFAULT NULL", "LASTUPDATE": "VARCHAR(50) DEFAULT NULL", "BESTOFFERER": "TEXT DEFAULT NULL", "BESTPRICE": "VARCHAR(50) DEFAULT NULL", "TOTALPRICE": "VARCHAR(50) DEFAULT NULL", "NEWTOTALPRICE": "VARCHAR(50) DEFAULT NULL", "AVAILABILITY": "VARCHAR(50) DEFAULT NULL", "DEEPLINK": "TEXT DEFAULT NULL", "LISTED": "VARCHAR(50) DEFAULT NULL", "CURRENTPRICE": "VARCHAR(50) DEFAULT NULL", "AnbieterPreis": "TEXT DEFAULT NULL" }
Sql SELECT t1.*, GROUP_CONCAT(CONCAT(CONCAT(t1.SHOP, ':'), t1.OLDPRICE) SEPARATOR ';') as AnbieterPreis, MAX(CAST(NEWPRICE AS DECIMAL(10,2))) AS MINNEWPRICE FROM ( SELECT * FROM ( SELECT 'idealo.de' as MARKETPLACE, SUBSTRING(ID, 2, 1) AS FIRMA, SUBSTRING(ID, 4, 7) AS ARTE, SUBSTRING(ID, 11, 5) AS APNR, TRIM(TRAILING '-' FROM (CONCAT(CONCAT(TRIM(LEADING 0 FROM SUBSTRING(ID, 4, 7)),'-'), TRIM(LEADING 0 FROM SUBSTRING(ID, 11, 5))))) AS ORDERNUMBER, beny_suggestions_idealo.* FROM beny_suggestions_idealo UNION SELECT 'google.de' as MARKETPLACE, SUBSTRING(ID, 2, 1) AS FIRMA, SUBSTRING(ID, 4, 7) AS ARTE, SUBSTRING(ID, 11, 5) AS APNR, TRIM(TRAILING '-' FROM (CONCAT(CONCAT(TRIM(LEADING 0 FROM SUBSTRING(ID, 4, 7)),'-'), TRIM(LEADING 0 FROM SUBSTRING(ID, 11, 5))))) AS ORDERNUMBER, beny_suggestions_google.* FROM beny_suggestions_google ) as t1 ) as t1 GROUP BY t1.MANUFACTURER, t1.EAN
Mapping { "MARKETPLACE": "t1.MARKETPLACE", "FIRMA": "t1.FIRMA", "ARTE": "t1.ARTE", "APNR": "t1.APNR", "ORDERNUMBER": "t1.ORDERNUMBER", "ID": "t1.ID", "PRODUCTNAME": "t1.PRODUCTNAME", "CATEGORY": "t1.CATEGORY", "MANUFACTURER": "t1.MANUFACTURER", "MODEL": "t1.MODEL", "EAN": "t1.EAN", "MPN": "t1.MPN", "STATUS": "t1.STATUS", "RANKING": "t1.RANKING", "SHIPPINGCOSTS": "t1.SHIPPINGCOSTS", "SHOP": "t1.SHOP", "SHOP_URL": "t1.SHOP_URL", "NEWPRICE": "t1.MINNEWPRICE", "OLDPRICE": "t1.OLDPRICE", "PRICECHANGE": "t1.PRICECHANGE", "LASTUPDATE": "t1.LASTUPDATE", "BESTOFFERER": "t1.BESTOFFERER", "BESTPRICE": "t1.BESTPRICE", "TOTALPRICE": "t1.TOTALPRICE", "NEWTOTALPRICE": "t1.NEWTOTALPRICE", "AVAILABILITY": "t1.AVAILABILITY", "DEEPLINK": "t1.DEEPLINK", "LISTED": "t1.LISTED", "CURRENTPRICE": "t1.CURRENTPRICE", "AnbieterPreis": "t1.AnbieterPreis" }