private static Workspace PostWorkspaceInner(Workspace input) { var body = JsonSerializer.Serialize(input); var request = JsonApiRequest.Create("adamo", RequestAction.Save, body); var logger = LoggerFactory.Create(config => config.AddDebug()).CreateLogger("AzureHttpFunction"); var repo = new Repository <Workspace>(LocalDb.GetConnectionString(DbName), logger); var function = new SampleFunction <Workspace>(request, logger, repo); return((function.ExecuteAsync().Result as OkObjectResult).Value as Workspace); }
public void DeleteWorkspace() { var result = CreateWorkspaceInner(WsName); var id = result.Id; var request = JsonApiRequest.Create("adamo", RequestAction.Delete, null, query: new Dictionary <string, object>() { ["id"] = id }); var logger = LoggerFactory.Create(config => config.AddDebug()).CreateLogger("AzureHttpFunction"); var repo = new Repository <Workspace>(LocalDb.GetConnectionString(DbName), logger); var function = new SampleFunction <Workspace>(request, logger, repo); function.ExecuteAsync().Wait(); using var cn = LocalDb.GetConnection(DbName); Assert.IsTrue(!cn.RowExistsAsync("[dbo].[Workspace] WHERE [Name]=@name", new { name = WsName }).Result); }
public void WithDataResult() { var config = ConfigHelper.GetConfig(); var smtp = new SmtpClient( config["SendGrid:Server"], int.Parse(config["SendGrid:Port"])); smtp.Credentials = new NetworkCredential("apikey", config["SendGrid:ApiKey"]); var querySource = new QuerySource("*****@*****.**", LocalDb.GetConnectionString(DbName)) { Queries = new Query[] { SampleQuery() } }; var service = new SqlQueryNotificationService(smtp, querySource, null); service.ExecuteAsync().Wait(); }
public void BlobDataResult() { var config = ConfigHelper.GetConfig(); var smtp = new SmtpClient( config["SendGrid:Server"], int.Parse(config["SendGrid:Port"])); smtp.Credentials = new NetworkCredential("apikey", config["SendGrid:ApiKey"]); var querySource = new BlobQuerySource( config["Azure:ConnectionString"], LocalDb.GetConnectionString(DbName), "*****@*****.**", config["Azure:ContainerName"], config["Azure:BlobPrefix"]); CreateSampleQueryBlob(config); var service = new SqlQueryNotificationService(smtp, querySource, null); service.ExecuteAsync().Wait(); }
public TestService() : base(LocalDb.GetConnectionString(dbName), new DummyUser("adamo"), new SqlServerCrudProvider <int>(id => Convert.ToInt32(id))) { }
private static DapperCX <int, UserProfile> GetService() => new DapperCX <int, UserProfile>(LocalDb.GetConnectionString(dbName), GetUser(), GetProvider());