json数据

来源:互联网 发布:设a是2n 1阶矩阵 编辑:程序博客网 时间:2024/06/03 23:47

delete操作:

{

    "table": "GG.TCUSTORD",
    "op_type": "D",
    "op_ts": "2013-06-02 22:14:41.000000",
    "current_ts": "2015-09-18T13:39:35.766000",
    "pos": "00000000000000004338",
    "tokens": {
        "6": "9.0.80330",
        "L": "206080450",
        "R": "AADPkvAAEAAEqLzAAC"
    },
    "before": {
        "CUST_CODE": "DAVE",
        "ORDER_DATE": "1993-11-03:07:51:35",
        "PRODUCT_CODE": "PLANE",
        "ORDER_ID": "600"
    }

}

insert操作:

{
    "table": "GG.TCUSTORD",
    "op_type": "I",
    "op_ts": "2013-06-02 22:14:36.000000",
    "current_ts": "2015-09-18T13:39:35.447000",
    "pos": "00000000000000001444",
    "tokens": {
        "R": "AADPkvAAEAAEqL2AAA"
    },
    "after": {
        "CUST_CODE": "WILL",
        "ORDER_DATE": "1994-09-30:15:33:00",
        "PRODUCT_CODE": "CAR",
        "ORDER_ID": "144",
        "PRODUCT_PRICE": 17520,
        "PRODUCT_AMOUNT": 3,
        "TRANSACTION_ID": "100"
    }
}

update操作:

{
    "table": "GG.TCUSTORD",
    "op_type": "U",
    "op_ts": "2013-06-02 22:14:41.000000",
    "current_ts": "2015-09-18T13:39:35.748000",
    "pos": "00000000000000002891",
    "tokens": {
        "R": "AADPkvAAEAAEqLzAAA"
    },
    "before": {
        "CUST_CODE": "BILL",
        "ORDER_DATE": "1995-12-31:15:00:00",
        "PRODUCT_CODE": "CAR",
        "ORDER_ID": "765",
        "PRODUCT_PRICE": 15000,
        "PRODUCT_AMOUNT": 3,
        "TRANSACTION_ID": "100"
    },
    "after": {
        "CUST_CODE": "BILL",
        "ORDER_DATE": "1995-12-31:15:00:00",
        "PRODUCT_CODE": "CAR",
        "ORDER_ID": "765",
        "PRODUCT_PRICE": 14000,
        "PRODUCT_AMOUNT": 3,
        "TRANSACTION_ID": "100"
    }
}

原创粉丝点击