public async Task CheckPermissionCreation()
{
// Deploy AS Model based of the following pramaters
var dataStore = await TestManager.GetDataStore();
dataStore.AddToDataStore("ASServerUrl", "asazure://westus.asazure.windows.net/testmo");
dataStore.AddToDataStore("SqlConnectionString", SqlCreds.GetSqlPagePayload("modb1"));
dataStore.AddToDataStore("SqlServerIndex", "0");
dataStore.AddToDataStore("SqlScriptsFolder", "Database/");
dataStore.AddToDataStore("ASServerName", "testmo");
dataStore.AddToDataStore("ASLocation", "westcentralus");
dataStore.AddToDataStore("ASSku", "D1");
dataStore.AddToDataStore("xmlaFilePath", "Service/AzureAS/SalesManagement.xmla");
dataStore.AddToDataStore("ASDatabase", "testdb");
dataStore.AddToDataStore("UserToAdd", "*****@*****.**");
var response = await TestManager.ExecuteActionAsync("Microsoft-ValidateConnectionToAS", dataStore);
Assert.IsTrue(response.IsSuccess);
response = await TestManager.ExecuteActionAsync("Microsoft-DeployAzureASModel", dataStore, "Microsoft-CRMSalesManagement");
Assert.IsTrue(response.IsSuccess);
response = await TestManager.ExecuteActionAsync("Microsoft-AssignPermissionsForUser", dataStore, "Microsoft-CRMSalesManagement");
Assert.IsTrue(response.IsSuccess);
}
public async Task DeployASModelTest()
{
// Deploy AS Model based of the following pramaters
var dataStore = await TestManager.GetDataStore();
// Deploy Twitter Database Scripts
dataStore.AddToDataStore("SqlConnectionString", SqlCreds.GetSqlPagePayload("modb1"));
dataStore.AddToDataStore("SqlServerIndex", "0");
dataStore.AddToDataStore("SqlScriptsFolder", "Database/");
var response = await TestManager.ExecuteActionAsync("Microsoft-DeploySQLScripts", dataStore, "Microsoft-CRMSalesManagement");
Assert.IsTrue(response.Status == ActionStatus.Success);
dataStore.AddToDataStore("ASServerName", "asservermo2345");
dataStore.AddToDataStore("ASLocation", "westcentralus");
dataStore.AddToDataStore("ASSku", "D1");
dataStore.AddToDataStore("xmlaFilePath", "Service/AzureAS/SalesManagement.xmla");
dataStore.AddToDataStore("ASDatabase", "testdb");
response = await TestManager.ExecuteActionAsync("Microsoft-DeployAzureAnalysisServices", dataStore, "Microsoft-CRMSalesManagement");
Assert.IsTrue(response.IsSuccess);
response = await TestManager.ExecuteActionAsync("Microsoft-ValidateConnectionToAS", dataStore, "Microsoft-CRMSalesManagement");
Assert.IsTrue(response.IsSuccess);
//response = await TestManager.ExecuteActionAsync("Microsoft-DeployAzureASModel", dataStore, "Microsoft-CRMSalesManagement");
//Assert.IsTrue(response.IsSuccess);
}
public async Task DeploySqlScriptsTest()
{
// Deploy AS Model based of the following pramaters
var dataStore = await TestManager.GetDataStore();
// Deploy Twitter Database Scripts
dataStore.AddToDataStore("SqlConnectionString", SqlCreds.GetSqlPagePayload("ssas"));
dataStore.AddToDataStore("SqlServerIndex", "0");
dataStore.AddToDataStore("SqlScriptsFolder", "Service/Database/LogicApps");
var response = await TestManager.ExecuteActionAsync("Microsoft-DeploySQLScripts", dataStore, "Microsoft-TwitterTemplate");
Assert.IsTrue(response.Status == ActionStatus.Success);
// Deploy AS Model based of the following pramaters
dataStore = await TestManager.GetDataStore();
// Deploy Twitter Database Scripts
dataStore.AddToDataStore("SqlConnectionString", SqlCreds.GetSqlPagePayload("ssas"));
dataStore.AddToDataStore("SqlServerIndex", "0");
dataStore.AddToDataStore("SqlScriptsFolder", "Service/Database");
response = await TestManager.ExecuteActionAsync("Microsoft-DeploySQLScripts", dataStore, "Microsoft-NewsTemplate");
Assert.IsTrue(response.Status == ActionStatus.Success);
}
public async Task ValidateAPIManagementDBScripts()
{
DataStore ds = new DataStore();
ds.AddToDataStore("SqlConnectionString", SqlCreds.GetSqlPagePayload("yashti"));
ds.AddToDataStore("SqlScriptsFolder", "Database");
Assert.IsTrue(await TestManager.IsSuccessAsync("Microsoft-DeploySQLScripts", ds, "Microsoft-APIManagementTemplate"));
}
public async Task ValidatePowerAppDeployment()
{
DataStore ds = await TestManager.GetDataStore();
ds.AddToDataStore("PowerAppFileName", "TwitterTemplate.msapp");
ds.AddToDataStore("SqlConnectionString", SqlCreds.GetSqlPagePayload("yashti"));
Assert.IsTrue(await TestManager.IsSuccessAsync("Microsoft-GetPowerAppEnvironment", ds));
Assert.IsTrue(await TestManager.IsSuccessAsync("Microsoft-CreatePowerAppSqlConnection", ds));
//Assert.IsTrue(await TestManager.IsSuccessAsync("Microsoft-DeployPowerApp", ds, "Microsoft-TwitterTemplate"));
}
public async Task ValidateConfigurePowerAppTables()
{
var ds = new DataStore();
ds.AddToDataStore("SqlConnectionString", SqlCreds.GetSqlPagePayload("yashti"));
ds.AddToDataStore("SqlScriptsFolder", "Service/Database/LogicApps");
Assert.IsTrue(await TestManager.IsSuccessAsync("Microsoft-DeploySQLScripts", ds, "Microsoft-TwitterTemplate"));
//ds.AddToDataStore("SearchQuery", "cricket rights OR english cricket OR \"Sky AND cricket\"");
ds.AddToDataStore("SearchQuery", "FA and women's performance");
Assert.IsTrue(await TestManager.IsSuccessAsync("Microsoft-ConfigurePowerAppTables", ds));
}
public async Task DeployIoTContinuousDataExport()
{
// Deploy AS Model based of the following pramaters
var dataStore = await TestManager.GetDataStore();
dataStore.AddToDataStore("SqlConnectionString", SqlCreds.GetSqlPagePayload("continuousDataExportDB"));
dataStore.AddToDataStore("SqlServerIndex", "0");
dataStore.AddToDataStore("SqlScriptsFolder", "Database");
dataStore.AddToDataStore("enableTransaction", "false");
var response = await TestManager.ExecuteActionAsync("Microsoft-DeploySQLScripts", dataStore, "Microsoft-IoTContinuousDataExportTemplate");
Assert.IsTrue(response.Status == ActionStatus.Success);
}
