Add 'Test Connection' on Data Sources

[hennlo]

Affected Areas

DB, UI

Feature Description

To verify that the connection with the specified credentials to the data source system works as intended a 'Test Connection' button for the UI or a internal call could be implemented.

Use Case(s)

When creating data source adapters but also for existing adapters.
This could also later on feed back some information and avoid accessing sources that might be currently offline or unreachable

Possible Solutions

Check when creating the connection Handler and do dummy executions on data source e.g. at PSQL SELECT 1

Possible Alternatives

No response

[hrithik2200]

Hi, I am a newbie trying to get started with my journey of open source development. Can I get this issue assigned to me and some insight if possible on how to go about the issue?

[Ahmed-Elgamel]

I want to work ob this issue.So in order for every adapter to have test connection feature , we need to do 2 things.
First in the Polypheny-UI , add the necessary button in order to request the server to test the connection.And in Polypheny-DB we need to add in the DataSource abstract class an abstract method called testConnection().Then every class extending DataSource abstract class needs to provide its own implementation ex: csv data source and the other types of data sources available need to provide their own implementation

[hennlo]

Hi @Ahmed-Elgamel I've assigned the issue to you.