/// <inheritdoc/>
public bool GetQuery(string name, out IQuery query)
{
using (SqlConnection conn = sql_connection_provider_.CreateConnection())
using (var builder = new CommandBuilder(conn)) {
IDbCommand cmd = builder
.SetText(sql_connection_provider_.Schema + kGetQuery)
.SetType(CommandType.StoredProcedure)
.AddParameter("@name", name, DbType.String, 260)
.Build();
try {
conn.Open();
using (IDataReader dr = cmd.ExecuteReader()) {
query = CreateQueryFromDataReader(dr);
return(true);
}
} catch (SqlException e) {
logger_.Error(
string.Format(StringResources.Log_MethodThrowsException, kClassName,
"GetQuery"), e);
}
}
query = null;
return(false);
}
public override void OnMessage(IRubyMessage request)
{
try {
switch (request.Type)
{
case (int)MessageType.kQueryRequestMessage:
QueryRequestMessage query =
QueryRequestMessage.ParseFrom(request.Message);
requests_timer_.Time(() => ProcessQuery(request, query));
break;
}
} catch (Exception e) {
logger_.Error(
string.Format(R.Log_MethodThrowsException, "OnMessage", kClassName), e);
service_host_
.SendError(request.Id, (int)StatusCode.kServerError, request.Sender,
e);
}
}
public override bool GetConnectionProvider(IQuery query,
out IConnectionProvider provider)
{
try {
if (!cache_.GetIfPresent(query.Name, out provider))
{
provider = CreateConnectionProvider(query.Options);
cache_.Put(query.Name, provider);
}
return(true);
} catch (Exception e) {
logger_.Error(
string.Format(StringResources.Log_MethodThrowsException, kClassName,
"GetConnectionProvider"),
e);
}
provider = null;
return(false);
}
