public void Test_GetBusinessObjectForProp_ID_WithDatabase() { ClassDef.ClassDefs.Clear(); TestUsingDatabase.SetupDBDataAccessor(); BOWithIntID.DeleteAllBOWithIntID(); IClassDef autoIncClassDef = BOWithIntID.LoadClassDefWithIntID(); IBusinessObject businessObject = GetBusinessObjectStub(); BOPropLookupList boProp = (BOPropLookupList)businessObject.Props[_propDef_int.PropertyName]; BOWithIntID bo1 = new BOWithIntID { TestField = "PropValue", IntID = 55 }; object expectedID = bo1.IntID; bo1.Save(); //---------------Assert Precondition---------------- Assert.AreEqual(typeof(int), _propDef_int.PropertyType); Assert.IsNull(boProp.Value); Assert.IsFalse(bo1.Status.IsNew); Assert.IsNotNull(bo1.IntID); //---------------Execute Test ---------------------- boProp.Value = expectedID; IBusinessObject objectForProp = boProp.GetBusinessObjectForProp(autoIncClassDef); //---------------Test Result ----------------------- Assert.IsNotNull(objectForProp); }
public void Test_AddedChild_UpdatesRelatedPropertiesOnlyWhenParentSaves_DB_CompositeKey() { //---------------Set up test pack------------------- TestUsingDatabase.SetupDBDataAccessor(); Car car = new Car(); car.Save(); ContactPersonCompositeKey contactPerson = new ContactPersonCompositeKey(); contactPerson.PK1Prop1 = TestUtil.GetRandomString(); contactPerson.PK1Prop2 = TestUtil.GetRandomString(); contactPerson.Save(); contactPerson.GetCarsDriven().Add(car); //---------------Assert PreConditions--------------- Assert.AreEqual(contactPerson.PK1Prop1, car.DriverFK1); Assert.AreEqual(contactPerson.PK1Prop2, car.DriverFK2); //---------------Execute Test ---------------------- contactPerson.Save(); FixtureEnvironment.ClearBusinessObjectManager(); Car loadedCar = Broker.GetBusinessObject <Car>(car.ID); //---------------Test Result ----------------------- Assert.AreEqual(contactPerson.PK1Prop1, loadedCar.DriverFK1); Assert.AreEqual(contactPerson.PK1Prop2, loadedCar.DriverFK2); }
public override void SetupTest() { base.SetupTest(); TestUsingDatabase.SetupDBDataAccessor(); OrganisationTestBO.DeleteAllOrganisations(); ContactPersonTestBO.DeleteAllContactPeople(); }
public override void SetupTest() { base.SetupTest(); FixtureEnvironment.ResetBORegistryBusinessObjectManager(); TestUsingDatabase.SetupDBDataAccessor(); OrganisationTestBO.DeleteAllOrganisations(); ContactPersonTestBO.DeleteAllContactPeople(); }
public void SetupFixture() { TestUsingDatabase.SetupDBDataAccessor(); ClassDef.ClassDefs.Clear(); XmlClassLoader loader = new XmlClassLoader(new DtdLoader(), new DefClassFactory()); _itsClassDef = loader.LoadClass (@" <class name=""MyBO"" assembly=""Habanero.Test""> <property name=""MyBoID"" type=""Guid"" /> <property name=""TestProp"" type=""Habanero.Util.LongText"" assembly=""Habanero.Base"" /> <primaryKey> <prop name=""MyBoID"" /> </primaryKey> </class> " ); ClassDef.ClassDefs.Add(_itsClassDef); }
public void TestPersistSqlParameterType() { TestUsingDatabase.SetupDBOracleConnection(); IBusinessObject bo = _itsClassDef.CreateNewBusinessObject(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append('*', 2500); string value = stringBuilder.ToString(); bo.SetPropertyValue("TestProp", value); var sqlCol = new TransactionalBusinessObjectDB(bo, DatabaseConnection.CurrentConnection).GetPersistSql(); ISqlStatement sqlStatement = sqlCol.First(); IList parameters = sqlStatement.Parameters; IDbDataParameter longTextParam = (IDbDataParameter)parameters[1]; string oracleTypeEnumString = ReflectionUtilities.GetEnumPropertyValue(longTextParam, "OracleType"); Assert.IsTrue(oracleTypeEnumString == "Clob"); }
public void PersistSQLparamaterValue_WhenByteArrayNull_WhenMySQL_ShouldNotExist_FIXBUG1741() { //---------------Set up test pack------------------- TestUsingDatabase.SetupDBDataAccessor(); var bo = _classDef.CreateNewBusinessObject(); bo.SetPropertyValue("ByteArrayProp", null); //---------------Assert Precondition---------------- //---------------Execute Test ---------------------- var sqlCol = new TransactionalBusinessObjectDB(bo, DatabaseConnection.CurrentConnection).GetPersistSql(); var sqlStatement = sqlCol.First(); //IList parameters = sqlStatement.Parameters; DatabaseConnection.CurrentConnection.ExecuteSql(sqlStatement); //---------------Test Result ----------------------- Assert.Pass("If it got here then it is OK"); }
public virtual void Test_SetParent_PersistedChild_FindLoadLookupListError() { //---------------Set up test pack------------------- TestUsingDatabase.SetupDBDataAccessor(); BORegistry.DataAccessor = new DataAccessorDB(); OrganisationTestBO organisation = OrganisationTestBO.CreateSavedOrganisation(); GetAssociationRelationship(organisation); ContactPersonTestBO contactPerson = ContactPersonTestBO.CreateSavedContactPerson(); //---------------Assert Precondition ----------------------- Assert.IsNotNull(organisation.OrganisationID); //---------------Execute Test ---------------------- contactPerson.Organisation = organisation; //---------------Test Result ----------------------- Assert.AreSame(contactPerson, organisation.ContactPerson); Assert.AreSame(organisation, contactPerson.Organisation); }
public void Test_AddedChild_UpdatesRelatedPropertiesOnlyWhenParentSaves_DB() { //---------------Set up test pack------------------- TestUsingDatabase.SetupDBDataAccessor(); OrganisationTestBO organisation = OrganisationTestBO.CreateSavedOrganisation(); SingleRelationship <ContactPersonTestBO> relationship = GetAssociationRelationship(organisation); relationship.OwningBOHasForeignKey = false; ContactPersonTestBO contactPerson = ContactPersonTestBO.CreateSavedContactPerson(); organisation.ContactPerson = contactPerson; contactPerson.Surname = TestUtil.GetRandomString(); //---------------Execute Test ---------------------- organisation.Save(); FixtureEnvironment.ClearBusinessObjectManager(); ContactPersonTestBO loadedContactPerson = Broker.GetBusinessObject <ContactPersonTestBO>(contactPerson.ID); //---------------Test Result ----------------------- Assert.AreEqual(contactPerson.OrganisationID, loadedContactPerson.OrganisationID); }
public void TestPersistSqlParameterValue() { TestUsingDatabase.SetupDBOracleConnection(); IBusinessObject bo = _classDef.CreateNewBusinessObject(); bo.SetPropertyValue("TestProp", "test"); var sqlCol = new TransactionalBusinessObjectDB(bo, DatabaseConnection.CurrentConnection).GetPersistSql(); ISqlStatement sqlStatement = sqlCol.First(); IList parameters = sqlStatement.Parameters; IDbDataParameter byteStringParam = (IDbDataParameter)parameters[2]; Assert.IsTrue(byteStringParam.Value is byte[], "Should be a byte array"); byte[] paramValue = (byte[])byteStringParam.Value; Assert.AreEqual(paramValue.Length, itsByteArrSpelling_test.Length); Assert.AreEqual(paramValue[0], itsByteArrSpelling_test[0]); Assert.AreEqual(paramValue[1], itsByteArrSpelling_test[1]); Assert.AreEqual(paramValue[2], itsByteArrSpelling_test[2]); Assert.AreEqual(paramValue[3], itsByteArrSpelling_test[3]); Assert.AreEqual(paramValue[4], itsByteArrSpelling_test[4]); Assert.AreEqual(paramValue[5], itsByteArrSpelling_test[5]); Assert.AreEqual(paramValue[6], itsByteArrSpelling_test[6]); Assert.AreEqual(paramValue[7], itsByteArrSpelling_test[7]); }
public void Test_UpdateSqlStatement_CompositeKey() { //---------------Set up test pack------------------- TestUsingDatabase.SetupDBDataAccessor(); Car car = new Car(); car.Save(); ContactPersonCompositeKey contactPerson = new ContactPersonCompositeKey(); contactPerson.PK1Prop1 = TestUtil.GetRandomString(); contactPerson.PK1Prop2 = TestUtil.GetRandomString(); contactPerson.Save(); contactPerson.GetCarsDriven().Add(car); SingleRelationship <ContactPersonCompositeKey> singleRelationship = car.Relationships.GetSingle <ContactPersonCompositeKey>("Driver"); singleRelationship.SetRelatedObject(contactPerson); IRelationship relationship = contactPerson.Relationships.GetMultiple <Car>("Driver"); var generator = CreateUpdateStatementGenerator(car, DatabaseConfig.MySql); //---------------Assert PreConditions--------------- //---------------Execute Test ---------------------- var sql = generator.GenerateForRelationship(relationship, car); //---------------Test Result ----------------------- var sqlStatements = sql.ToList(); Assert.AreEqual(1, sqlStatements.Count); Assert.AreEqual("UPDATE `car_table` SET `Driver_FK1` = ?Param0, `Driver_FK2` = ?Param1 WHERE `CAR_ID` = ?Param2", sqlStatements[0].Statement.ToString()); Assert.AreEqual(contactPerson.PK1Prop1, sqlStatements[0].Parameters[0].Value); Assert.AreEqual(contactPerson.PK1Prop2, sqlStatements[0].Parameters[1].Value); Assert.AreEqual(car.CarID.ToString("B").ToUpper(), sqlStatements[0].Parameters[2].Value); //---------------Tear Down ------------------------- }
protected override void SetupDataAccess() { TestUsingDatabase.SetupDBDataAccessor(); }
public override void SetupTest() { base.SetupTest(); TestUsingDatabase.SetupDBDataAccessor(); }
private void SetupDataAccessor() { TestUsingDatabase.SetupDBDataAccessor(); }