Common_Test.cs 2.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475
  1. using Microsoft.VisualStudio.TestTools.UnitTesting;
  2. namespace Vitorm.MsTest.CommonTest
  3. {
  4. public class User : Vitorm.MsTest.CommonTest.UserBase
  5. {
  6. }
  7. [TestClass]
  8. public partial class Common_Test : UserTest<User>
  9. {
  10. [TestMethod]
  11. public void Test()
  12. {
  13. Init();
  14. Test_DbContext();
  15. //Test_Transaction();
  16. Test_Get();
  17. Test_Query();
  18. //Test_QueryJoin();
  19. Test_ToExecuteString();
  20. //Test_ExecuteUpdate();
  21. //Test_ExecuteDelete();
  22. Test_Create();
  23. Test_Update();
  24. Test_Delete();
  25. }
  26. [TestMethod]
  27. public async Task TestAsync()
  28. {
  29. Init();
  30. await Test_GetAsync();
  31. await Test_QueryAsync();
  32. //await Test_QueryJoinAsync();
  33. //await Test_ExecuteUpdateAsync();
  34. //await Test_ExecuteDeleteAsync();
  35. await Test_UpdateAsync();
  36. await Test_DeleteAsync();
  37. }
  38. public override User NewUser(int id, bool forAdd = false) => new User { id = id, name = "testUser" + id };
  39. public override void WaitForUpdate() => Thread.Sleep(2000);
  40. public void Init()
  41. {
  42. using var dbContext = Data.DataProvider<User>()?.CreateDbContext();
  43. dbContext.TryDropTable<User>();
  44. dbContext.TryCreateTable<User>();
  45. var users = new List<User> {
  46. new User { id=1, name="u146", fatherId=4, motherId=6 },
  47. new User { id=2, name="u246", fatherId=4, motherId=6 },
  48. new User { id=3, name="u356", fatherId=5, motherId=6 },
  49. new User { id=4, name="u400" },
  50. new User { id=5, name="u500" },
  51. new User { id=6, name="u600" },
  52. };
  53. users.ForEach(user => { user.birth = DateTime.Parse("2021-01-01 00:00:00").AddHours(user.id); });
  54. dbContext.AddRange(users);
  55. WaitForUpdate();
  56. }
  57. }
  58. }