{
	"name": "table/db_connection_preference.json",
	"info": "see: auth/connection.json",
	"prevent_database_update": ["bugzilla"],
	"default_language": "fi_fi",
	"default_database": "fi_demo2",
	"default_id": "demo-fi_demo2-0",
	"default_database_user": "manage_demo",
	"default_user": "test_user",
	"default_user_pw": "test_pw",
	"timeout": 30,
	"connection_timeout": 1,
	"substring_length": 200,
	"allow_database_schema_update": {
		"bugzilla": false,
		"demo-fi_demo2-0": true
	},
	"alias_id": {
		"postgre -do-not-set-to-debug-problems": "demo-fi_demo2-0",
		"4d": "demo-4d-0",
		"plg4d": "plg4d-plg4d-0",
		"pg": "demo-fi_demo2-0",
		"pg4d": "demo-fi_demo4d-0",
		"odbc": "demo-fastems-0",
		"moloni": "demo-moloni-0",
		"woocommerce": "demo-woocommerce-0"
	},
	"connection": {
		"timer_call": {
			"driver": "timer_call",
			"dbtype": "timer_call",
			"port": 5957,
			"connection_timeout": 4,
			"connection": [
				{
					"name": "timer call local",
					"host": "127.0.0.1",
					"disconnect": true
				}
			]
		},
		"rest_call": {
			"driver": "rest_call",
			"dbtype": "rest_call",
			"port": 5959,
			"connection_timeout": 4,
			"connection": [
				{
					"name": "tcp call local",
					"host": "127.0.0.1"
				},
				{
					"name": "tcp call srv",
					"host": "192.168.32.3"
				}
			]
		},
		"plg4d": {
			"driver": "plg4d",
			"dbtype": "4d",
			"port": "",
			"sql_lower": false,
			"connection": [
				{
					"name": "Manageri v12 plg4d local",
					"host": ""
				}
			]
		},
		"rest4d": {
			"driver": "rest4d",
			"dbtype": "4d",
			"port": 5949,
			"timeout": 120,
			"sql_lower": false,
			"connection": [
				{
					"name": "Manageri v12 rest4d local",
					"host": "127.0.0.1"
				},
				{
					"name": "Manageri v12 rest4d .32.5",
					"host": "192.168.32.5"
				},
				{
					"name": "Manageri v12 rest4d srv stunnel",
					"host": "127.0.0.1",
					"port": 49200,
					"disabled": true
				},
				{
					"name": "Manageri v12 rest4d srv .32.3",
					"host": "192.168.32.3",
					"disabled": true
				}
			]
		},
		"rest-moloni": {
			"driver": "rest_call",
			"dbtype": "rest_call",
			"connection_timeout": 3,
			"datetime_format": "%Y-%m-%dT%H:%M:%S",
			"connection": [
				{
					"name": "VA-Varuste Portugal Moloni rest",
					"query_parameter": {"access_token": ""},
					"auth": {
						"error_answer": "Invalid access token.",
						"auth_tag": "access_token",
						"call_function": "grant/?grant_type=password&client_id=vavarustepolandspolka&client_secret=7532c065af4b2f4c8a95a9213bf40c5bc4ee8ac8&username=manage@manageapp.com&password=17nP20um"
					},
					"host": "https://api.moloni.pt",
					"call_method": "POST",
					"call_path": "/v1/",
					"call_body": {"company_id": 86546},
					"error_tag": "error_description",
					"debug": false
				}
			]
		},
		"rest-woocommerce": {
			"driver": "rest_call",
			"dbtype": "rest_call",
			"connection_timeout": 3,
			"datetime_format": "%Y-%m-%dT%H:%M:%S",
			"connection": [
				{
					"name": "VA-Varuste Woocommerce rest",
					"host": "https://shop.va-varuste.fi",
					"call_method": "GET",
					"call_path": "/wp-json/wc/v3/",
					"page_count_header_name": "X-WP-TotalPages",
					"error_tag": "code",
					"debug": false,
					"user": "ck_40901dafaddd3ba4b87be22fc84088db1a4e115e",
					"password": "cs_b7ad99405684e96ac19da5b19f686982a20bc28a"
				},
				{
					"name": "Localhost Woocommerce rest",
					"host": "https://127.0.0.1",
					"call_method": "GET",
					"call_path": "/wordpress/wp-json/wc/v3/",
					"page_count_header_name": "X-WP-TotalPages",
					"error_tag": "code",
					"debug": false,
					"user": "ck_1d8190c0bb01b05d9c76e4ef2255cd8582c11027",
					"password": "cs_4b1a79bc1250271f219b2a45b724c1bf56b9e039"
				}
			]
		},
		"manageri.fi": {
			"driver": "postgre",
			"dbtype": "postgre",
			"port": 5432,
			"connection": [
				{
					"name": "postgre srv stunnel",
					"host": "127.0.0.1",
					"port": 5433
				},
				{
					"name": "postgre .32.3 srv",
					"host": "192.168.32.3"
				}
			]
		},
		"postgre-demo2": {
			"driver": "postgre",
			"dbtype": "postgre",
			"port": 5432,
			"connection": [
				{
					"name": "postgre local",
					"host": "127.0.0.1"
				},
				{
					"name": "postgre local socket",
					"host": "/var/run/postgresql",
					"port": ""
				},
				{
					"name": "postgre .32.5",
					"host": "192.168.32.5"
				}
			]
		},
		"postgre-demo4d": {
			"driver": "postgre",
			"dbtype": "postgre",
			"port": 5432,
			"connection": [
				{
					"name": "postgre local",
					"host": "127.0.0.1"
				},
				{
					"name": "postgre local socket",
					"host": "/var/run/postgresql",
					"port": ""
				},
				{
					"name": "postgre local socket",
					"host": "/tmp",
					"port": ""
				},
				{
					"name": "postgre .32.5",
					"host": "192.168.32.5"
				},
				{
					"name": "postgre .32.7",
					"host": "192.168.32.7"
				},
				{
					"name": "Manageri v12 pasi paralles",
					"host": "192.168.33.2"
				},
				{
					"name": "postgre srv stunnel",
					"host": "127.0.0.1",
					"port": 5433
				}
			]
		},
		"mysql": {
			"driver": "mysql",
			"dbtype": "mysql",
			"port": 3306,
			"connection": [
				{
					"name": "manageri mysql localhost",
					"host": "127.0.0.1"
				},
				{
					"name": "manageri mysql stunnel",
					"host": "127.0.0.1",
					"port": 5433
				},
				{
					"name": "manageri mysql .32.3",
					"host": "192.168.32.3",
					"port": 3306
				}
			]
		},
		"odbc": {
			"driver": "odbc",
			"dbtype": "postgre",
			"port": "",
			"connection": [
				{
					"name": "manageri pps oracle odbc",
					"host": "oraclefms32",
					"dbtype": "oracle",
					"database_user": "pps"
				},
				{
					"name": "manageri pps oracle-postgre odbc",
					"host": "oraclefms32-postgre",
					"database_user": "pps"
				},
				{
					"name": "manageri mysql odbc",
					"host": "mysql",
					"dbtype": "mysql",
					"database_user": ""
				}
			]
		},
		"odbc-nova": {
			"driver": "odbc",
			"dbtype": "postgre",
			"port": "",
			"connection": [
				{
					"name": "nova_asiakas odbc",
					"host": "nova_asiakas",
					"database_user": ""
				},
				{
					"name": "nova_asiakas_w odbc",
					"host": "nova_asiakas_w",
					"database_user": ""
				}
			]
		},
		"odbc-aj-mes": {
			"driver": "odbc",
			"dbtype": "postgre",
			"port": "",
			"connection": [
				{
					"name": "AJ-Automation MES odbc",
					"host": "aj-mes",
					"database_user": "sa",
					"password": "mysqlMaa"
				}
			]
		}
	}
}
