Package org.eclipse.lemminx.customservice.synapse.dynamic.db

Class DatabaseService

java.lang.Object

org.eclipse.lemminx.customservice.synapse.dynamic.db.DatabaseService

public class DatabaseService
extends Object

Constructor Summary

Constructors

Constructor	Description
DatabaseService()

Method Summary

Modifier and Type	Method	Description
List<DynamicField>	getStoredProcedureParameters(String connectionUrl, String username, String password, String procedureName, String fieldName)	Retrieves the parameters of a specified stored procedure from the database and returns them as a list of DynamicField objects.
List<DynamicField>	getTableColumns(String connectionUrl, String username, String password, String table, String fieldName, boolean markNull)	Retrieves the columns of a specified table from the database and returns them as a list of DynamicField objects.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

DatabaseService

public DatabaseService()

Method Details

getTableColumns

public List<DynamicField> getTableColumns(String connectionUrl,
 String username,
 String password,
 String table,
 String fieldName,
 boolean markNull)

Retrieves the columns of a specified table from the database and returns them as a list of DynamicField objects.

Parameters:

connectionUrl -

username -

password -

table -

fieldName -

markNull -

Returns:

List containing the columns of the table.

getStoredProcedureParameters

public List<DynamicField> getStoredProcedureParameters(String connectionUrl,
 String username,
 String password,
 String procedureName,
 String fieldName)

Retrieves the parameters of a specified stored procedure from the database and returns them as a list of DynamicField objects.

Parameters:

connectionUrl -

username -

password -

procedureName -

fieldName -

Returns:

List containing the parameters of the stored procedure.