public async Task Test_1_Batch_Add_PublisherEntityAsync() { IList <PublisherEntity> publishers = Mocker.GetPublishers(); var transactionContext = await database.BeginTransactionAsync <PublisherEntity>(isolationLevel).ConfigureAwait(false); DatabaseResult result = DatabaseResult.Failed(); try { result = await database.BatchAddAsync <PublisherEntity>(publishers, "tester", transactionContext); if (!result.IsSucceeded()) { output.WriteLine(result.Exception?.Message); throw new Exception(); } await database.CommitAsync(transactionContext); } catch (Exception ex) { output.WriteLine(ex.Message); await database.RollbackAsync(transactionContext); throw ex; } Assert.True(result.IsSucceeded()); }
public void Test_1_Batch_Add_PublisherEntity() { IList <PublisherEntity> publishers = Mocker.GetPublishers(); var transactionContext = database.BeginTransaction <PublisherEntity>(isolationLevel); DatabaseResult result = DatabaseResult.Failed(); try { result = database.BatchAdd <PublisherEntity>(publishers, "tester", transactionContext); if (!result.IsSucceeded()) { output.WriteLine(result.Exception?.Message); throw new Exception(); } database.Commit(transactionContext); } catch (Exception ex) { output.WriteLine(ex.Message); database.Rollback(transactionContext); throw ex; } Assert.True(result.IsSucceeded()); }
public void RandomDeleteSomeUserAsync() { TransactionContext transContext = database.BeginTransaction <User>(); List <long> ids = new List <long>(); DatabaseResult result = null; try { long userCount = _db.Count <User>(transContext); for (int i = 0; i < userCount; i += 10) { int userId = i; User user = _db.ScalarAsync <User>(i, transContext).Result; if (user == null) { continue; } ids.Add(userId); result = _db.DeleteAsync <User>(user, transContext).Result; Assert.True(result.IsSucceeded()); if (!result.IsSucceeded()) { database.Rollback(transContext); break; } } database.Commit(transContext); Assert.True(transContext.Status == TransactionStatus.Commited); if (transContext.Status == TransactionStatus.Commited) { IList <User> updatedUsers = _db.Retrieve <User>(u => SQLUtil.In(u.Id, false, ids), null); if (updatedUsers.Count == 0) { result = DatabaseResult.Succeeded(); } result = DatabaseResult.Failed(); } result = DatabaseResult.Failed(); } catch (Exception) { database.Rollback(transContext); } }
public void AddSomeUserClaims() { int userCount = _userList.Count; DatabaseResult result = DatabaseResult.Failed(); for (int i = 1; i < userCount; i += 39) { UserClaim uc = new UserClaim() { UserGuid = i.ToString(), ClaimValue = "Nothing", ClaimType = "HB.Nothing" }; result = _db.AddAsync(uc, null).Result; } Assert.True(result.IsSucceeded()); }
public void AddUsers() { TransactionContext transContext = database.BeginTransaction <User>(); DatabaseResult result = DatabaseResult.Failed(); foreach (User item in _userList) { result = _db.AddAsync(item, transContext).Result; if (!result.IsSucceeded()) { database.Rollback(transContext); break; } } database.Commit(transContext); Assert.True(result.IsSucceeded()); }
public void AddSomeUserRole() { int userCount = _userList.Count; DatabaseResult result = DatabaseResult.Failed(); int roleId = 1; for (int i = 1; i < userCount; i += 7) { UserRole ur = new UserRole() { RoleGuid = roleId++.ToString(), UserGuid = i.ToString() }; if (roleId == 5) { roleId = 1; } result = _db.AddAsync(ur, null).Result; } Assert.True(result.IsSucceeded()); }
public void RandomUpdateSomeUserAsync() { TransactionContext transContext = database.BeginTransaction <User>(); string userNamePrefix = DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss"); List <long> ids = new List <long>(); DatabaseResult result = null; try { long userCount = _db.Count <User>(transContext); for (int i = 0; i < userCount; i += 10) { int userId = i; User user = _db.ScalarAsync <User>(i, transContext).Result; if (user == null) { continue; } ids.Add(userId); user.UserName = userNamePrefix + "_update_" + i; result = _db.UpdateAsync <User>(user, transContext).Result; Assert.True(result.IsSucceeded()); if (!result.IsSucceeded()) { _output.WriteLine($"user id {userId} update failed."); database.Rollback(transContext); break; } } database.Commit(transContext); Assert.Equal(TransactionStatus.Commited, transContext.Status); if (transContext.Status == TransactionStatus.Commited) { IList <User> updatedUsers = _db.Retrieve <User>(u => SQLUtil.In(u.Id, false, ids), null); foreach (User u in updatedUsers) { _output.WriteLine(u.UserName); } } } catch (Exception) { database.Rollback(transContext); result = DatabaseResult.Failed(); } Assert.True(result.IsSucceeded()); }