Slide 62
Slide 62 text
62
Data Semantics
[ {"name": "test.movies.movies.Key" }, "payload": { "id": "{\"$oid\": \"1002\"}" } },
{"payload": {
"before": null,
"after": "{\"_id\": {\"$oid\": \"1002\"},\"title\": \"Black Panther\",\"rating\": \"PG-13\",\"imdb\":
7.3}",
"source": { "connector": "mysql","name": "test","ts_ms": 1670357925000, "snapshot":
"false","db": "movies", … },
"op": "c",
"ts_ms": 1670357926132,
"transaction": null
}
}]
[ {"name": "test.movies.movies.Key" }, "payload": { "id": "{\"$oid\": \"1002\"}" } },
{"payload": {
"before": null,
"after": "{\"_id\": {\"$oid\": \"1002\"},\"title\": \"Black Panther\",\"rating\": \"PG-13\",\"imdb\":
7.3}",
"source": { "connector": "mysql","name": "test","ts_ms": 1670357925000, "snapshot":
"false","db": "movies", ... },
"op": "c",
"ts_ms": 1670357926132,
"transaction": null
}
}]
movie_id movie_title rating imdb_score timestamp
1002 Black Panther PG-13 7.3 2022-12-06 20:18:46
Update record by primary key
Dealing with Data Semantics