OD_TRIP Datax脚本 - mouse3150/mouse3150.github.io GitHub Wiki

{
	"job":{
		"content":[
			{
                "reader": {
                    "name": "txtfilereader",
                    "parameter": {
                        "path": ["D:/echarts/od_trip/normal_data.csv"],
                        "encoding": "UTF-8",
                        "column": [
                            {
                                "index": 0,
                                "type": "string"
                            },
							{
                                "index": 1,
                                "type": "date",
                                "format": "yyyy-MM-dd HH:mm:ss"
                            },
							{
                                "index": 2,
                                "type": "string"
                            },
							{
                                "index": 3,
                                "type": "string"
                            },
							{
                                "index": 4,
                                "type": "string"
                            },
							{
                                "index": 5,
                                "type": "string"
                            }
                        ],
                        "fieldDelimiter": ","
                    }
                },
				"writer":{
					"name":"postgresqlwriter",
					"parameter":{
						"column":[
							"card",
							"swip_time",
							"station",
							"mode",
							"station_code",
							"label"
						],
						"connection":[
							{
								"jdbcUrl":"jdbc:postgresql://*.*.*.*:3432/od_trip",
								"table":[
									"od_trip_geom_3"
								]
							}
						],
						"pgType":{"station":"geometry"},
						"geometryColumn":[
							"station"
						],
						"geometryHolder":"ST_GeomFromText(?,4326)",
						"password":"***",
						"username":"***"
					}
				}
			}
		],
		"setting":{
			"speed":{
				"channel":6
			}
		}
	}
}