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