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