# DATABASE DEFINITION
source:
  driver: pdo_mysql
  # driver: pdo_sqlite
  host: 192.168.178.24:3307
  user: smartmeter
  password: ***
  dbname: ***
  # path: sqlite.db3		# path is only used if driver = pdo_sqlite

target:
  driver: pdo_mysql
  host: localhost
  user: vz-admin
  password: secure
  dbname: volkszaehler

# influxdb target database connection
influx:
  dsn: influxdb://localhost:8086
  dbname: volkszaehler
  measurement: data

# TABLE DEFINITION
# ----------------
# tables will be processed in the order they are mentioned:
#		- foreign keys on target will be dropped
#		- if a table is not listed here, it will not be touched
# transfer mode
#		skip:		table will not be copied
#		copy:		entire table will be truncated on target and copied from source
#		pk:			selective copy by primary key. only data not present on target
# 					will be copied from source.
tables:
  entities: copy
  properties: copy
  entities_in_aggregator: copy
  data: copy
  aggregate: skip
