public void GIVEN___EmployeeArrayType_class_with_common_data_type___WHEN___write_to_orientdb___THEN___should_be_able_to_read() { using (TestDatabaseContext testContext = new TestDatabaseContext()) using (var db = new ODatabase(TestConnection.GlobalTestDatabaseAlias)) { var employeeClassName = "EmployeeArrayType"; var clusterid = db.Create.Class(employeeClassName).Run(); var employee = new EmployeeArrayType(); employee.Id = Guid.NewGuid(); employee.Name = new string[2]; employee.Name[0] = "Andrew"; employee.Name[1] = ("Jack"); employee.Age = new int[2]; employee.Age[0] = (1); employee.Age[1] = (2); employee.BirthDate = new DateTime[2]; employee.BirthDate[0] = (DateTime.Now); employee.BirthDate[1] = (DateTime.Now.AddDays(-3)); employee.Childs = new EmployeeCommonType[2]; employee.Childs[0] = (new EmployeeCommonType() { Id = Guid.NewGuid() }); employee.Childs[1] = (new EmployeeCommonType() { Id = Guid.NewGuid() }); employee.FavoriteColor = new Color[2]; employee.FavoriteColor[0] = (Color.Red); employee.FavoriteColor[1] = (Color.Blue); employee.Height = new short[2]; employee.Height[0] = (323); employee.Height[1] = (333); employee.Ids = new Guid[2]; employee.Ids[0] = (Guid.NewGuid()); employee.Ids[1] = (Guid.NewGuid()); employee.IsMarried = new bool[2]; employee.IsMarried[0] = (true); employee.IsMarried[1] = (false); employee.Salary = new decimal[2]; employee.Salary[0] = ((decimal)1234567890.123456789); employee.Salary[1] = ((decimal)1234567890.123456799); employee.Tall = new long[2]; employee.Tall[0] = (3233); employee.Tall[1] = (3234); employee.YearlyIncome = new double[2]; employee.YearlyIncome[0] = (3233); employee.YearlyIncome[1] = (1234); var document = db.Insert <EmployeeArrayType>(employee).Run(); var result = db.Query <EmployeeArrayType>("SELECT * FROM " + employeeClassName + " WHERE Id = '" + employee.Id + "'").SingleOrDefault(); Assert.AreEqual(employee.Id, result.Id); Assert.AreEqual(employee.Ids[0], result.Ids[0]); Assert.AreEqual(employee.Ids[1], result.Ids[1]); Assert.AreEqual(employee.Name[0], result.Name[0]); Assert.AreEqual(employee.Name[1], result.Name[1]); Assert.AreEqual(employee.Age[0], result.Age[0]); Assert.AreEqual(employee.Age[1], result.Age[1]); Assert.AreEqual(employee.Age[0], result.Age[0]); Assert.AreEqual(employee.Salary[0], result.Salary[0]); Assert.AreEqual(employee.Salary[1], result.Salary[1]); Assert.AreEqual(employee.IsMarried[0], result.IsMarried[0]); Assert.AreEqual(employee.IsMarried[1], result.IsMarried[1]); Assert.AreEqual(employee.Childs[0].Id, result.Childs[0].Id); Assert.AreEqual(employee.Childs[1].Id, result.Childs[1].Id); Assert.AreEqual(employee.BirthDate[0].ToLongDateString(), result.BirthDate[0].ToLongDateString()); Assert.AreEqual(employee.BirthDate[1].ToLongDateString(), result.BirthDate[1].ToLongDateString()); Assert.AreEqual(employee.YearlyIncome[0], result.YearlyIncome[0]); Assert.AreEqual(employee.YearlyIncome[1], result.YearlyIncome[1]); Assert.AreEqual(employee.FavoriteColor[0], result.FavoriteColor[0]); Assert.AreEqual(employee.FavoriteColor[1], result.FavoriteColor[1]); Assert.AreEqual(employee.Height[0], result.Height[0]); Assert.AreEqual(employee.Height[1], result.Height[1]); Assert.AreEqual(employee.Tall[0], result.Tall[0]); Assert.AreEqual(employee.Tall[1], result.Tall[1]); } }
public void GIVEN___EmployeeArrayType_class_with_common_data_type___WHEN___write_to_orientdb___THEN___should_be_able_to_read() { using (TestDatabaseContext testContext = new TestDatabaseContext()) using (var db = new ODatabase(TestConnection.GlobalTestDatabaseAlias)) { var employeeClassName = "EmployeeArrayType"; var clusterid = db.Create.Class(employeeClassName).Run(); var employee = new EmployeeArrayType(); employee.Id = Guid.NewGuid(); employee.Name = new string[2]; employee.Name[0] = "Andrew"; employee.Name[1] = ("Jack"); employee.Age = new int[2]; employee.Age[0] = (1); employee.Age[1] = (2); employee.BirthDate = new DateTime[2]; employee.BirthDate[0] = (DateTime.Now); employee.BirthDate[1] = (DateTime.Now.AddDays(-3)); employee.Childs = new EmployeeCommonType[2]; employee.Childs[0] = (new EmployeeCommonType() { Id = Guid.NewGuid() }); employee.Childs[1] = (new EmployeeCommonType() { Id = Guid.NewGuid() }); employee.FavoriteColor = new Color[2]; employee.FavoriteColor[0] = (Color.Red); employee.FavoriteColor[1] = (Color.Blue); employee.Height = new short[2]; employee.Height[0] = (323); employee.Height[1] = (333); employee.Ids = new Guid[2]; employee.Ids[0] = (Guid.NewGuid()); employee.Ids[1] = (Guid.NewGuid()); employee.IsMarried = new bool[2]; employee.IsMarried[0] = (true); employee.IsMarried[1] = (false); employee.Salary = new decimal[2]; employee.Salary[0] = ((decimal)1234567890.123456789); employee.Salary[1] = ((decimal)1234567890.123456799); employee.Tall = new long[2]; employee.Tall[0] = (3233); employee.Tall[1] = (3234); employee.YearlyIncome = new double[2]; employee.YearlyIncome[0] = (3233); employee.YearlyIncome[1] = (1234); var document = db.Insert<EmployeeArrayType>(employee).Run(); var result = db.Query<EmployeeArrayType>("SELECT * FROM " + employeeClassName + " WHERE Id = '" + employee.Id + "'").SingleOrDefault(); Assert.AreEqual(employee.Id, result.Id); Assert.AreEqual(employee.Ids[0], result.Ids[0]); Assert.AreEqual(employee.Ids[1], result.Ids[1]); Assert.AreEqual(employee.Name[0], result.Name[0]); Assert.AreEqual(employee.Name[1], result.Name[1]); Assert.AreEqual(employee.Age[0], result.Age[0]); Assert.AreEqual(employee.Age[1], result.Age[1]); Assert.AreEqual(employee.Age[0], result.Age[0]); Assert.AreEqual(employee.Salary[0], result.Salary[0]); Assert.AreEqual(employee.Salary[1], result.Salary[1]); Assert.AreEqual(employee.IsMarried[0], result.IsMarried[0]); Assert.AreEqual(employee.IsMarried[1], result.IsMarried[1]); Assert.AreEqual(employee.Childs[0].Id, result.Childs[0].Id); Assert.AreEqual(employee.Childs[1].Id, result.Childs[1].Id); Assert.AreEqual(employee.BirthDate[0].ToLongDateString(), result.BirthDate[0].ToLongDateString()); Assert.AreEqual(employee.BirthDate[1].ToLongDateString(), result.BirthDate[1].ToLongDateString()); Assert.AreEqual(employee.YearlyIncome[0], result.YearlyIncome[0]); Assert.AreEqual(employee.YearlyIncome[1], result.YearlyIncome[1]); Assert.AreEqual(employee.FavoriteColor[0], result.FavoriteColor[0]); Assert.AreEqual(employee.FavoriteColor[1], result.FavoriteColor[1]); Assert.AreEqual(employee.Height[0], result.Height[0]); Assert.AreEqual(employee.Height[1], result.Height[1]); Assert.AreEqual(employee.Tall[0], result.Tall[0]); Assert.AreEqual(employee.Tall[1], result.Tall[1]); } }