Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@PavelPenkov
Created July 3, 2019 14:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save PavelPenkov/3432fe522e02aa3a8a597020d4ee7361 to your computer and use it in GitHub Desktop.
Save PavelPenkov/3432fe522e02aa3a8a597020d4ee7361 to your computer and use it in GitHub Desktop.
{
"schema": {
"type": "struct",
"fields": [
{
"type": "struct",
"fields": [
{
"type": "int32",
"optional": false,
"field": "id"
},
{
"type": "int32",
"optional": true,
"name": "io.debezium.time.Date",
"version": 1,
"field": "date_field"
},
{
"type": "int64",
"optional": true,
"name": "io.debezium.time.NanoTimestamp",
"version": 1,
"field": "datetime2_field"
},
{
"type": "int64",
"optional": true,
"name": "io.debezium.time.Timestamp",
"version": 1,
"field": "datetime_field"
},
{
"type": "string",
"optional": true,
"name": "io.debezium.time.ZonedTimestamp",
"version": 1,
"field": "datetimeoffset_field"
},
{
"type": "int64",
"optional": true,
"name": "io.debezium.time.Timestamp",
"version": 1,
"field": "smalldatetime_field"
},
{
"type": "int64",
"optional": true,
"name": "io.debezium.time.MicroTime",
"version": 1,
"field": "time_field"
}
],
"optional": true,
"name": "ng_mssql.dbo.time_test.Value",
"field": "before"
},
{
"type": "struct",
"fields": [
{
"type": "int32",
"optional": false,
"field": "id"
},
{
"type": "int32",
"optional": true,
"name": "io.debezium.time.Date",
"version": 1,
"field": "date_field"
},
{
"type": "int64",
"optional": true,
"name": "io.debezium.time.NanoTimestamp",
"version": 1,
"field": "datetime2_field"
},
{
"type": "int64",
"optional": true,
"name": "io.debezium.time.Timestamp",
"version": 1,
"field": "datetime_field"
},
{
"type": "string",
"optional": true,
"name": "io.debezium.time.ZonedTimestamp",
"version": 1,
"field": "datetimeoffset_field"
},
{
"type": "int64",
"optional": true,
"name": "io.debezium.time.Timestamp",
"version": 1,
"field": "smalldatetime_field"
},
{
"type": "int64",
"optional": true,
"name": "io.debezium.time.MicroTime",
"version": 1,
"field": "time_field"
}
],
"optional": true,
"name": "ng_mssql.dbo.time_test.Value",
"field": "after"
},
{
"type": "struct",
"fields": [
{
"type": "string",
"optional": true,
"field": "version"
},
{
"type": "string",
"optional": true,
"field": "connector"
},
{
"type": "string",
"optional": false,
"field": "name"
},
{
"type": "int64",
"optional": true,
"field": "ts_ms"
},
{
"type": "string",
"optional": true,
"field": "change_lsn"
},
{
"type": "string",
"optional": true,
"field": "commit_lsn"
},
{
"type": "boolean",
"optional": true,
"field": "snapshot"
}
],
"optional": false,
"name": "io.debezium.connector.sqlserver.Source",
"field": "source"
},
{
"type": "string",
"optional": false,
"field": "op"
},
{
"type": "int64",
"optional": true,
"field": "ts_ms"
}
],
"optional": false,
"name": "ng_mssql.dbo.time_test.Envelope"
},
"payload": {
"before": null,
"after": {
"id": 4,
"date_field": 18073,
"datetime2_field": 1561575449010000000,
"datetime_field": 1561575449010,
"datetimeoffset_field": "2019-06-26T18:57:29.01Z",
"smalldatetime_field": 1561575420000,
"time_field": 68249010000
},
"source": {
"version": "0.9.5.Final",
"connector": "sqlserver",
"name": "ng-mssql",
"ts_ms": 1561575449013,
"change_lsn": "0008c3bf:0003cc47:0003",
"commit_lsn": "0008c3bf:0003cc47:0004",
"snapshot": false
},
"op": "c",
"ts_ms": 1561564654556
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment