public StringBuilder Execute(Dictionary <string, StringBuilder> values, IWorkspace theWorkspace)
{
var msg = new ExecuteMessage();
var serializer = new Dev2JsonSerializer();
try
{
Dev2Logger.Info("Test Sqlite Service", GlobalConstants.WarewolfInfo);
values.TryGetValue("SqlQuery", out StringBuilder QueryString);
var source = new SqliteDBSource();
var res = new SqliteDBService
{
Method = new ServiceMethod("TestService", "TestService", QueryString.ToString(), new OutputDescription(), new List <MethodOutput>()),
ResourceName = "TestService",
ResourceID = Guid.NewGuid(),
Source = source
};
var services = new ServiceModel.Services();
Recordset output = null;
Common.Utilities.PerformActionInsideImpersonatedContext(Common.Utilities.OrginalExecutingUser, () =>
{
output = services.SqliteDbTest(res, GlobalConstants.ServerWorkspaceID, Guid.Empty);
if (output.HasErrors)
{
msg.HasError = true;
var errorMessage = output.ErrorMessage;
msg.Message = new StringBuilder(errorMessage);
Dev2Logger.Error(errorMessage, GlobalConstants.WarewolfError);
}
else
{
var result = ToDataTable(output);
msg.HasError = false;
msg.Message = serializer.SerializeToBuilder(result);
}
});
}
catch (Exception err)
{
msg.HasError = true;
msg.Message = new StringBuilder(err.Message);
Dev2Logger.Error(err, GlobalConstants.WarewolfError);
}
return(serializer.SerializeToBuilder(msg));
}
protected virtual TDbServer CreateSqliteDbServer(SqliteDBSource dbSource) => new TDbServer();
