public async Task <Row> CreateAsync(Row row)
{
await context.Rows.AddAsync(row);
await context.SaveChangesAsync();
return(row);
}
public async Task <Table> CreateAsync(Table table)
{
await context.Tables.AddAsync(table);
await context.SaveChangesAsync();
return(table);
}
public async Task <Database> CreateAsync(Database database)
{
await context.Databases.AddAsync(database);
await context.SaveChangesAsync();
return(database);
}
public async Task UpdateAsync()
{
// Arrange
var database = new Database
{
Id = Guid.NewGuid(),
Name = databaseName
};
using var context = new AzureSqlDbContext(DbContextUtilities.GetContextOptions());
await context.Databases.AddAsync(database);
await context.SaveChangesAsync();
var updatedName = "updatedTestDatabaseName";
database.Name = updatedName;
var databaseService = new SqlDatabaseService(context);
// Act
await databaseService.UpdateAsync(database);
// Assert
Assert.AreEqual(context.Databases.FirstOrDefault().Name, updatedName);
Assert.AreEqual(context.Databases.FirstOrDefault(), database);
}
public async Task SearchAsync()
{
// Arrange
var table = new Table
{
Id = Guid.NewGuid(),
DatabaseId = Guid.NewGuid(),
Name = tableName,
Schema = JsonConvert.SerializeObject(new BrandTableSchema {
Name = StringType, Country = StringType
})
};
var row1 = new Row
{
Id = Guid.NewGuid(),
TableId = table.Id,
Content = JsonConvert.SerializeObject(new BrandTableSchema {
Name = row1Name, Country = row1Country
})
};
var row2 = new Row
{
Id = Guid.NewGuid(),
TableId = table.Id,
Content = JsonConvert.SerializeObject(new BrandTableSchema {
Name = row2Name, Country = row2Country
})
};
using var context = new AzureSqlDbContext(DbContextUtilities.GetContextOptions());
await context.Rows.AddAsync(row1);
await context.Rows.AddAsync(row2);
await context.Tables.AddAsync(table);
await context.SaveChangesAsync();
var rowService = new SqlRowService(context);
// Act
var result = await rowService.SearchByKeywordAsync(table.Id, searchKeyword, searchColumn);
var resultResponse = result.Select(r => RowConverter.GetRowResponse(r)).ToList();
// Assert
Assert.IsNotNull(resultResponse);
Assert.AreEqual(1, resultResponse.Count);
Assert.AreEqual(row2Name, resultResponse.FirstOrDefault().Content["name"]);
}
public async Task DeleteAsync()
{
// Arrange
var database = new Database
{
Id = Guid.NewGuid(),
Name = databaseName
};
using var context = new AzureSqlDbContext(DbContextUtilities.GetContextOptions());
await context.Databases.AddAsync(database);
await context.SaveChangesAsync();
var databaseService = new SqlDatabaseService(context);
// Act
await databaseService.DeleteAsync(database.Id);
// Assert
Assert.AreEqual(context.Databases.Count(), 0);
}
public async Task GetAsync()
{
// Arrange
var database = new Database
{
Id = Guid.NewGuid(),
Name = databaseName
};
using var context = new AzureSqlDbContext(DbContextUtilities.GetContextOptions());
await context.Databases.AddAsync(database);
await context.SaveChangesAsync();
var databaseService = new SqlDatabaseService(context);
// Act
var result = await databaseService.GetAsync(database.Id);
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(database, result);
}
public Guid MergeClusters(List <ClusterEntity> clusters)
{
// Create new cluster
var newCluster = new ClusterEntity {
Id = Guid.NewGuid(), NewsCount = clusters.Sum(c => c.NewsCount)
};
// Add dependencies to Subcluster
foreach (ClusterEntity cluster in clusters)
{
context.Subclusters.Add(new SubclusterEntity {
ChildId = cluster.Id, ParentId = newCluster.Id
});
}
// Add average vector to TagCluster
context.SaveChangesAsync();
// Return new Guid
return(newCluster.Id);
}
public async Task CreateOrder(Order order)
{
context.Orders.Add(order);
await context.SaveChangesAsync();
}
public async Task CreateProduct(string name, string description, double price, string image, Guid categoryId, string userId)
{
await context.ShopItems.AddAsync(new ShopItem(name, description, price, image, categoryId, userId));
await context.SaveChangesAsync();
}
public async Task CreateCategory(string name, string description)
{
await context.Categories.AddAsync(new Category(name, description));
await context.SaveChangesAsync();
}
public async Task SaveNewsItemAsync(NewsEntity newsEntity)
{
context.NewsEntities.Add(newsEntity);
await context.SaveChangesAsync();
}
