14 Mayıs 2023 Pazar

Debezium Connector Json Çıktı

Örnek
Şöyledir. Update işlemi
{
    "_index": "ecommerce-cdc.ecommerce.product",
    "_id": "4a7f1ebe-ece2-11ed-9bc5-0242ac120003",
    "_version": 6,
    "_seq_no": 2,
    "_primary_term": 1,
    "found": true,
    "_source": {
        "before": {
            "id": "4a7f1ebe-ece2-11ed-9bc5-0242ac120003",
            "brand": "Coca-Cola",
            "category": "Drinks/Fizzy Drinks",
            "name": "Coca-Cola Zero Sugar 24 x 330ml",
            "price": 10
        },
        "after": {
            "id": "4a7f1ebe-ece2-11ed-9bc5-0242ac120003",
            "brand": "Coca-Cola",
            "category": "Drinks/Fizzy Drinks",
            "name": "Coca-Cola Zero Sugar 24 x 330ml",
            "price": 20
        },
        "source": {
            "version": "2.0.0.Final",
            "connector": "mysql",
            "name": "ecommerce-cdc",
            "ts_ms": 1683472083000,
            "snapshot": "false",
            "db": "ecommerce",
            "sequence": null,
            "table": "product",
            "server_id": 1,
            "gtid": null,
            "file": "binlog.000002",
            "pos": 399,
            "row": 0,
            "thread": 60,
            "query": null
        },
        "op": "u",
        "ts_ms": 1683472083922,
        "transaction": null
    }
}


Hiç yorum yok:

Yorum Gönder

CREATE EVENT - Scheduled Task İçindir

Örnek Şöyle yaparız CREATE EVENT myevent     ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR     DO       UPDATE myschema.mytable SET myc...