internal static ServerListResult DeserializeServerListResult(JsonElement element)
{
Optional <IReadOnlyList <SqlServerData> > value = default;
Optional <string> nextLink = default;
foreach (var property in element.EnumerateObject())
{
if (property.NameEquals("value"))
{
if (property.Value.ValueKind == JsonValueKind.Null)
{
property.ThrowNonNullablePropertyIsNull();
continue;
}
List <SqlServerData> array = new List <SqlServerData>();
foreach (var item in property.Value.EnumerateArray())
{
array.Add(SqlServerData.DeserializeSqlServerData(item));
}
value = array;
continue;
}
if (property.NameEquals("nextLink"))
{
nextLink = property.Value.GetString();
continue;
}
}
return(new ServerListResult(Optional.ToList(value), nextLink.Value));
}
SqlServer IOperationSource <SqlServer> .CreateResult(Response response, CancellationToken cancellationToken)
{
using var document = JsonDocument.Parse(response.ContentStream);
var data = SqlServerData.DeserializeSqlServerData(document.RootElement);
return(new SqlServer(_armClient, data));
}
private async Task <SqlServer> CreateOrUpdateSqlServer(string sqlServerName)
{
SqlServerData data = new SqlServerData(AzureLocation.WestUS2)
{
AdministratorLogin = "******" + sqlServerName,
AdministratorLoginPassword = CreateGeneralPassword(),
};
var SqlServer = await _resourceGroup.GetSqlServers().CreateOrUpdateAsync(WaitUntil.Completed, sqlServerName, data);
return(SqlServer.Value);
}
public void ShouldUpdateData()
{
// Arrange
var correlationId = Guid.NewGuid();
var testDataJson = "{\"CorrelationId\":\"e845f0a0-4af0-4d1e-a324-790d49d540ae\",\"Name\":\"TestDataOriginal\"}";
IProcessManagerData data = new TestSqlServerData {
CorrelationId = correlationId, Name = "TestDataOriginal"
};
var xmlSerializer = new XmlSerializer(data.GetType());
var sww = new StringWriter();
XmlWriter writer = XmlWriter.Create(sww);
xmlSerializer.Serialize(writer, data);
var dataXml = sww.ToString();
SetupTestDbData(new List <TestDbRow> {
new TestDbRow {
Id = correlationId.ToString(), DataXml = dataXml
}
});
IProcessManagerData updatedData = new TestSqlServerData {
CorrelationId = correlationId, Name = "TestDataUpdated"
};
var sqlServerData = new SqlServerData <IProcessManagerData> {
Data = updatedData, Id = correlationId
};
IProcessManagerFinder processManagerFinder = new SqlServerProcessManagerFinder(_connectionString, string.Empty);
// Act
//processManagerFinder.FindData<TestSqlServerData>(correlationId);
processManagerFinder.FindData <TestSqlServerData>(_mapper, new Message(correlationId));
processManagerFinder.UpdateData(sqlServerData);
// Assert
var results = GetTestDbData(correlationId);
Assert.Equal(1, results.Count);
Assert.Equal(correlationId.ToString(), results[0].Id);
Assert.False(results[0].DataXml.Contains("TestDataOriginal"));
Assert.True(results[0].DataXml.Contains("TestDataUpdated"));
}
static void Main(string[] args)
{
var t = new Transform();
var source = new DelimitedData();
source.FileName = "CSV.csv";
source.DirectoryName = @"C:\Users\Ehasanul\Desktop\CSV";
source.FirstRowHasColumnName = true;
var target = new SqlServerData();
target.ServerName = "(local)";
target.DatabaseName = "ImportTest";
target.UserName = "******";
target.Password = "******";
WriteSchemaIniFile(source.DirectoryName, source.FileName);
List <ColumnMapping> columnMappings = GetMappingColumn();
t.Execute(source, target, "CSVTest", columnMappings);
}
public void ShouldDeleteData()
{
// Arrange
var correlationId = Guid.NewGuid();
IProcessManagerData data = new TestSqlServerData {
CorrelationId = correlationId, Name = "TestDataUpdated"
};
var xmlSerializer = new XmlSerializer(data.GetType());
var sww = new StringWriter();
XmlWriter writer = XmlWriter.Create(sww);
xmlSerializer.Serialize(writer, data);
var dataXml = sww.ToString();
SetupTestDbData(new List <TestDbRow> {
new TestDbRow {
Id = correlationId.ToString(), DataXml = dataXml, Version = 1
}
});
IProcessManagerFinder processManagerFinder = new SqlServerProcessManagerFinder(_connectionString, string.Empty);
var sqlServerDataToBeDeleted = new SqlServerData <IProcessManagerData> {
Data = data, Id = correlationId, Version = 1
};
// Act
processManagerFinder.FindData <TestData>(_mapper, new Message(correlationId));
processManagerFinder.DeleteData(sqlServerDataToBeDeleted);
// Assert
var results = GetTestDbData(correlationId);
Assert.Equal(0, results.Count);
}
public void ShouldDeleteData()
{
// Arrange
var correlationId = Guid.NewGuid();
IProcessManagerData data = new TestSqlServerData { CorrelationId = correlationId, Name = "TestDataUpdated" };
var xmlSerializer = new XmlSerializer(data.GetType());
var sww = new StringWriter();
XmlWriter writer = XmlWriter.Create(sww);
xmlSerializer.Serialize(writer, data);
var dataXml = sww.ToString();
SetupTestDbData(new List<TestDbRow> { new TestDbRow { Id = correlationId.ToString(), DataXml = dataXml, Version = 1 } });
IProcessManagerFinder processManagerFinder = new SqlServerProcessManagerFinder(_connectionString, string.Empty);
var sqlServerDataToBeDeleted = new SqlServerData<IProcessManagerData> { Data = data, Id = correlationId, Version = 1};
// Act
processManagerFinder.FindData<TestData>(_mapper, new Message(correlationId));
processManagerFinder.DeleteData(sqlServerDataToBeDeleted);
// Assert
var results = GetTestDbData(correlationId);
Assert.Equal(0, results.Count);
}
public void ShouldUpdateData()
{
// Arrange
var correlationId = Guid.NewGuid();
var testDataJson = "{\"CorrelationId\":\"e845f0a0-4af0-4d1e-a324-790d49d540ae\",\"Name\":\"TestDataOriginal\"}";
IProcessManagerData data = new TestSqlServerData { CorrelationId = correlationId, Name = "TestDataOriginal" };
var xmlSerializer = new XmlSerializer(data.GetType());
var sww = new StringWriter();
XmlWriter writer = XmlWriter.Create(sww);
xmlSerializer.Serialize(writer, data);
var dataXml = sww.ToString();
SetupTestDbData(new List<TestDbRow> { new TestDbRow { Id = correlationId.ToString(), DataXml = dataXml } });
IProcessManagerData updatedData = new TestSqlServerData { CorrelationId = correlationId, Name = "TestDataUpdated" };
var sqlServerData = new SqlServerData<IProcessManagerData> { Data = updatedData, Id = correlationId };
IProcessManagerFinder processManagerFinder = new SqlServerProcessManagerFinder(_connectionString, string.Empty);
// Act
//processManagerFinder.FindData<TestSqlServerData>(correlationId);
processManagerFinder.FindData<TestSqlServerData>(_mapper, new Message(correlationId));
processManagerFinder.UpdateData(sqlServerData);
// Assert
var results = GetTestDbData(correlationId);
Assert.Equal(1, results.Count);
Assert.Equal(correlationId.ToString(), results[0].Id);
Assert.False(results[0].DataXml.Contains("TestDataOriginal"));
Assert.True(results[0].DataXml.Contains("TestDataUpdated"));
}
public RabbitListener(SqlServerData db)
{
this.db = db;
db.Database.Migrate();
}
public async Task WebAppSqlConnectionCRUD()
{
string resourceGroupName = Recording.GenerateAssetName("SdkRg");
string webAppName = Recording.GenerateAssetName("SdkWeb");
string sqlServerName = Recording.GenerateAssetName("SdkSql");
string sqlDatabaseName = Recording.GenerateAssetName("SdkSql");
string sqlUserName = Recording.GenerateAssetName("SdkSql");
string sqlPassword = Recording.GenerateAssetName("SdkPa5$");
string linkerName = Recording.GenerateAssetName("SdkLinker");
// create resource group
await ResourceGroups.CreateOrUpdateAsync(WaitUntil.Completed, resourceGroupName, new Resources.ResourceGroupData(DefaultLocation));
ResourceGroupResource resourceGroup = await ResourceGroups.GetAsync(resourceGroupName);
// // create web app
WebSiteCollection webSites = resourceGroup.GetWebSites();
await webSites.CreateOrUpdateAsync(WaitUntil.Completed, webAppName, new WebSiteData(DefaultLocation));
WebSiteResource webapp = await webSites.GetAsync(webAppName);
// create sql database
SqlServerCollection sqlServers = resourceGroup.GetSqlServers();
SqlServerData sqlServerData = new SqlServerData(DefaultLocation)
{
AdministratorLogin = sqlUserName,
AdministratorLoginPassword = sqlPassword,
};
await sqlServers.CreateOrUpdateAsync(WaitUntil.Completed, sqlServerName, sqlServerData);
SqlServerResource sqlServer = await sqlServers.GetAsync(sqlServerName);
SqlDatabaseCollection sqlDatabases = sqlServer.GetSqlDatabases();
await sqlDatabases.CreateOrUpdateAsync(WaitUntil.Completed, sqlDatabaseName, new SqlDatabaseData(DefaultLocation));
SqlDatabaseResource sqlDatabase = await sqlDatabases.GetAsync(sqlDatabaseName);
// create service linker
LinkerResourceCollection linkers = webapp.GetLinkerResources();
var linkerData = new LinkerResourceData
{
TargetService = new Models.AzureResource
{
Id = sqlDatabase.Id,
},
AuthInfo = new SecretAuthInfo
{
Name = sqlUserName,
SecretInfo = new ValueSecretInfo
{
Value = sqlPassword,
},
},
ClientType = ClientType.Dotnet,
};
await linkers.CreateOrUpdateAsync(WaitUntil.Completed, linkerName, linkerData);
// list service linker
var linkerResources = await linkers.GetAllAsync().ToEnumerableAsync();
Assert.AreEqual(1, linkerResources.Count);
Assert.AreEqual(linkerName, linkerResources[0].Data.Name);
// get service linker
LinkerResource linker = await linkers.GetAsync(linkerName);
Assert.IsTrue(linker.Id.ToString().StartsWith(webapp.Id.ToString(), StringComparison.InvariantCultureIgnoreCase));
Assert.AreEqual(sqlDatabase.Id.ToString(), (linker.Data.TargetService as AzureResource).Id);
Assert.AreEqual(AuthType.Secret, linker.Data.AuthInfo.AuthType);
// get service linker configurations
SourceConfigurationResult configurations = await linker.GetConfigurationsAsync();
foreach (var configuration in configurations.Configurations)
{
Assert.IsNotNull(configuration.Name);
Assert.IsNotNull(configuration.Value);
}
// delete service linker
var operation = await linker.DeleteAsync(WaitUntil.Completed);
Assert.IsTrue(operation.HasCompleted);
}
