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();