public override void Invoke(AWSCredentials creds, RegionEndpoint region, int maxItems)
{
AmazonGlueConfig config = new AmazonGlueConfig();
config.RegionEndpoint = region;
ConfigureClient(config);
AmazonGlueClient client = new AmazonGlueClient(creds, config);
GetDatabasesResponse resp = new GetDatabasesResponse();
do
{
GetDatabasesRequest req = new GetDatabasesRequest
{
NextToken = resp.NextToken
,
MaxResults = maxItems
};
resp = client.GetDatabases(req);
CheckError(resp.HttpStatusCode, "200");
foreach (var obj in resp.DatabaseList)
{
AddObject(obj);
}
}while (!string.IsNullOrEmpty(resp.NextToken));
}
public DatabaseList GetDatabases(ConnectionInfo connection)
{
var request = new GetDatabasesRequest {
Connection = connection
};
var response = _databaseRepository.GetDatabaseList(request);
return(response);
}
public override async Task <GetDatabasesReply> GetDatabases(GetDatabasesRequest request, ServerCallContext callContext)
{
var databases = await _dbSchemaReader.GetDatabasesAsync(new ConnectionInfo(request.ConnectionString));
var reply = new GetDatabasesReply();
reply.Databases.AddRange(databases.Select(d => new database()
{
Name = d.Name
}));
return(reply);
}
public DatabaseList GetDatabaseList(GetDatabasesRequest request)
{
const string query = "SELECT name FROM sys.databases;";
var dbRequest = new CommonDbRequest
{
Connection = ResolveConnectionWithCache(request.Connection),
CommandText = query
};
return(SqlHelper.DoQueryOperation <CommonDbRequest, DatabaseList>(dbRequest, (req, response, reader) =>
{
var databaseList = new List <string>();
while (reader.Read())
{
var name = reader.GetValue(0).ToString();
databaseList.Add(name);
}
response.Databases = databaseList;
//response.State = ResponseState.Success;
}));
}
public GetDatabasesResponse GetDatabases(GetDatabasesRequest request)
{
return(ExecuteAction <GetDatabasesResponse>(request));
}
public GetDatabasesResponse GetDatabases(GetDatabasesRequest request)
{
return(Execute(() => InternalService.GetDatabases(request)));
}
