Concava-adapter-mysql NPM

ConCaVa MySQL adapter

ConCaVa adapter for authorization, metadata and storage through MySQL.

Requires ConCaVa v0.6+.

Note: The MQTT server is lazy loaded, so it becomes available after processing the first sensor data.

See ConCaVa with MySQL and InfluxDB for a working setup.

Install

npm install concava-adapter-mysql

Configure

A ConCaVa configuration example:

const adapter = require('concava-adapter-mysql')

// Connection configuration
var config = {
	host: 'mysql',
	user: process.env['MYSQL_USER'],
	password: process.env['MYSQL_PASS'],
	database: process.env['ON_CREATE_DB'],
	timeout: 3000, // ms
}

module.exports = {
	debug: true,
	auth: {
		enabled: true,
		method: adapter.auth,
		config: config,
		sql: '', // Custom query
	},
	metadata: {
		method: adapter.metadata,
		config: config,
		attributeSql: '', // Custom query
		converterSql: '', // Custom query
		calibratorSql: '', // Custom query
		validatorSql: '', // Custom query
	},
	storage: {
		method: adapter.storage,
		config: config,
		sql: '', // Custom query
	},
}

Provide a custom SQL query with auth.sql. In this query all values from req.auth will be replaced. By default these are: