{
    "debezium.connect.server": "connect:8083",
    "tpc": {
        "count": 100000,
        "commit.intervals": [
            1,
            100,
            1000,
            10000
        ]
    },
    "jdbc": {
        "db2": {
            "jdbcdriver": "com.ibm.db2.jcc.DB2Driver",
            "jar": "jcc.jar",
            "tpctable": "CREATE TABLE TPC.TEST ( USERNAME VARCHAR(32) NOT NULL, NAME VARCHAR(64), BLOOD_GROUP CHAR(3), RESIDENCE VARCHAR(200), COMPANY VARCHAR(128), ADDRESS VARCHAR(200), BIRTHDATE DATE, SEX CHAR(1), JOB VARCHAR(128), SSN CHAR(11), MAIL VARCHAR(128), ID INTEGER not null GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1), T0 TIMESTAMP NOT NULL     GENERATED BY DEFAULT     FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP, PRIMARY KEY (ID) ) ORGANIZE BY ROW",
            "initsql": [
                "CALL ASNCDC.REMOVETABLE('TPC','TEST')",
                "VALUES ASNCDC.ASNCDCSERVICES('stop','asncdc')",
                "python.time.sleep 10",
                "DROP TABLE TPC.TEST"
            ],
            "enablecdctablesql": [ 
                "CALL ASNCDC.ADDTABLE('TPC','TEST')",
                "UPDATE ASNCDC.IBMSNAP_CAPPARMS SET COMMIT_INTERVAL=1 , SLEEP_INTERVAL=1",
                "VALUES ASNCDC.ASNCDCSERVICES('start','asncdc')",
                "python.time.sleep 10",
                "VALUES ASNCDC.ASNCDCSERVICES('status','asncdc')",
                "VALUES ASNCDC.ASNCDCSERVICES('reinit','asncdc')",
                "VALUES ASNCDC.ASNCDCSERVICES('status','asncdc')"
            ]
        },
        "mysql": {
            "jdbcdriver": "com.mysql.cj.jdbc.Driver",
            "jar": "mysql.jar",
            "tpctable": "CREATE TABLE TPC.TEST ( USERNAME VARCHAR(32) NOT NULL, NAME VARCHAR(64), BLOOD_GROUP CHAR(3), RESIDENCE VARCHAR(200), COMPANY VARCHAR(128), ADDRESS VARCHAR(200), BIRTHDATE DATE, SEX CHAR(1), JOB VARCHAR(128), SSN CHAR(11), MAIL VARCHAR(128), ID INTEGER NOT NULL AUTO_INCREMENT, T0 TIMESTAMP  DEFAULT CURRENT_TIMESTAMP ) ",
            "initsql": [],
            "enablecdctablesql": []
        },
        "oracle": {
            "jdbcdriver": "com.oracle.ojdbc",
            "jar": "ojdbc10.jar",
            "tpctable": "",
            "initsql": [],
            "enablecdctablesql": []
        },
        "sqlserver": {
            "jdbcdriver": "com.microsoft.sqlserver",
            "jar": "mssql-jdbc-8.2.0.jre8.jar",
            "tpctable": "CREATE TABLE TPC.TEST ( USERNAME VARCHAR(32) NOT NULL, NAME VARCHAR(64), BLOOD_GROUP CHAR(3), RESIDENCE VARCHAR(200), COMPANY VARCHAR(128), ADDRESS VARCHAR(200), BIRTHDATE DATE, SEX CHAR(1), JOB VARCHAR(128), SSN CHAR(11), MAIL VARCHAR(128), ID INT IDENTITY(1,1) PRIMARY KEY, T0 TIMESTAMP DATETIME NULL DEFAULT GETDATE() )",
            "initsql": [],
            "enablecdctablesql": []
        },
        "postgresql": {
            "jdbcdriver": "org.postgresql.Driver",
            "jar": "postgresql.jar",
            "tpctable": "CREATE TABLE INVENTORY.TEST ( USERNAME VARCHAR(32) NOT NULL, NAME VARCHAR(64), BLOOD_GROUP CHAR(3), RESIDENCE VARCHAR(200), COMPANY VARCHAR(128), ADDRESS VARCHAR(200), BIRTHDATE DATE, SEX CHAR(1), JOB VARCHAR(128), SSN CHAR(11), MAIL VARCHAR(128), ID INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY, T0 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP )",
            "initsql": [],
            "enablecdctablesql": [],
	    "table": "inventory.test",
	    "lowercase": "true"
        }
    },
    "sql": {
        "insert": "INSERT INTO INVENTORY.TEST (USERNAME, NAME, BLOOD_GROUP ,RESIDENCE, COMPANY, ADDRESS, SEX) VALUES ( 'USERNAMEDAT', 'NAME', 'AB+', 'WELCOME TO EARTH', 'WORK TO WORK GMBH', 'HELP WORKING', 'M' )"
    }
}
