Getting Datasource parameters

Module Development
1

I have seen that with the IA Labs Scripting module I can add a datasource and browse tags. Is there any way to browse or get a list of datasources properties? I read in the forum that I can invoke system.db.getConnections() using

GatewayInterface gi = GatewayConnectionManager.getInstance().getGatewayInterface();
List<SerializableDatasourceMeta> datasources = 
         (List<SerializableDatasourceMeta>) gi.invoke("DatasourceMeta.getConnections");

for (SerializableDatasourceMeta datasource : datasources){
	System.out.println("DB Vendor: " + datasource.getVendor());
	System.out.println("DB Description: " + datasource.getDescription());
}

but it looks like this only gives me access to information like vendor name and description. I was hoping to get access to the parameters jdbcDriver, connectURL, username, & password similar to when adding a datasource in IA LAbs.

system.db.addDatasource(jdbcDriver="MySQL ConnectorJ", name="MySQL", connectURL="jdbc:mysql://localhost:3306/test", username="root", password="password", props="zeroDateTimeBehavior=convertToNull;")

This way I can use this info to do things like add a table to the database from the module. Unless there is already some way to do this.

2

I am not sure which version you are using but at least in version 7.6.x, you can access a database connection in the Gateway (which is all you need to create a table) using

gatewayContext.getDatasourceManager()...

But creating a table is simply a matter of executing a query with a create table statement, so I am not sure you even need to access the DatasourceManager as long as you have a connection to the database available (assuming the user has enough permission to create a table).

You can also try to use the good tools available in the Ignition platform such as the com.inductiveautomation.ignition.gateway.db.schema.DBTableSchema class (again on the Gateway only).

HTH,
Nicolas