protected override void Arrange() { const string message = "insert or update on table \"DependentTable\" violates foreign key constraint \"FK_MainTable_DependentTable\""; exception = NHibernateExceptionBuilder.CreatePostgresException(GenericSqlExceptionMessage, message); }
protected override void Arrange() { _suppliedInsertException = NHibernateExceptionBuilder.CreateException( "could not execute batch command.[SQL: SQL not available]", $"The INSERT statement conflicted with the FOREIGN KEY constraint \"FK_StudentAddress_AddressType_AddressTypeId\". The conflict occurred in database \"EdFi_Ods\", table \"edfi.AddressType\", column 'AddressTypeId'.{Environment.NewLine}The statement has been terminated.{Environment.NewLine}"); }
protected override void Arrange() { const string message = "update or delete on table \"DoublePrimaryKeys\" violates foreign key constraint \"FK_DoubleDependent_DoublePrimaryKeys\" on table \"DoubleDependent\""; exception = NHibernateExceptionBuilder.CreatePostgresException(GenericSqlExceptionMessage, message); }
protected override void Arrange() { const string slightlyWrongMessage = "VViolation of PRIMARY KEY constraint 'PK_Session'. Cannot insert duplicate key in object 'edfi.Session'. The duplicate key value is (900007, 9, 2014). The statement has been terminated."; exception = NHibernateExceptionBuilder.CreateException("Some generic SQL Exception message", slightlyWrongMessage); }
protected override void Arrange() { var mess = $"Violation of PRIMARY KEY constraint 'BackwardsPkName_PK'. Cannot insert duplicate key in object 'edfi.Session'. The duplicate key value is (900007, 9, 2014). {Environment.NewLine}The statement has been terminated."; exception = NHibernateExceptionBuilder.CreateException("Generic exception message", mess); suppliedMetadataProvider = Stub <IDatabaseMetadataProvider>(); A.CallTo(() => suppliedMetadataProvider.GetIndexDetails("BackwardsPkName_PK")) .Returns(null); }
protected override void EstablishContext() { var mess = "Violation of PRIMARY KEY constraint 'BackwardsPkName_PK'. Cannot insert duplicate key in object 'edfi.Session'. The duplicate key value is (900007, 9, 2014). \r\nThe statement has been terminated."; exception = NHibernateExceptionBuilder.CreateException("Generic exception message", mess); suppliedMetadataProvider = mocks.StrictMock <IDatabaseMetadataProvider>(); SetupResult.For(suppliedMetadataProvider.GetIndexDetails("BackwardsPkName_PK")) .Return(null); }
protected override void EstablishContext() { const string mess = "Violation of PRIMARY KEY constraint 'PK_Session'. Cannot insert duplicate key in object 'edfi.Session'. The duplicate key value is (900007, 9, 2014). \r\nThe statement has been terminated."; exception = NHibernateExceptionBuilder.CreateException("Generic SQL Exception message...", mess); suppliedMetadataProvider = mocks.StrictMock <IDatabaseMetadataProvider>(); SetupResult.For(suppliedMetadataProvider.GetIndexDetails("PK_Session")) .Return( new IndexDetails { IndexName = "SomeIndexName", TableName = "Session", ColumnNames = new List <string> { "Column1", "Column2", "Column3" } }); }
protected override void Arrange() { string mess = $"Violation of PRIMARY KEY constraint 'PK_Session'. Cannot insert duplicate key in object 'edfi.Session'. The duplicate key value is (900007, 9, 2014). {Environment.NewLine}The statement has been terminated."; exception = NHibernateExceptionBuilder.CreateException("Generic SQL Exception message...", mess); suppliedMetadataProvider = Stub <IDatabaseMetadataProvider>(); A.CallTo(() => suppliedMetadataProvider.GetIndexDetails("PK_Session")) .Returns( new IndexDetails { IndexName = "SomeIndexName", TableName = "Session", ColumnNames = new List <string> { "Column1", "Column2", "Column3" } }); }
protected override void Arrange() { _suppliedUpdateException = NHibernateExceptionBuilder.CreateException( "could not insert: [EdFi.Ods.Entities.AcademicHonorsTypeAggregate.AcademicHonorsType][SQL: INSERT INTO edfi.AcademicHonorsType (LastModifiedDate, CreateDate, Id, CodeValue, Description) VALUES (?, ?, ?, ?, ?); select SCOPE_IDENTITY()]", $"Cannot insert duplicate key row in object 'edfi.AcademicHonorsType' with unique index 'SomeIndexName'. The duplicate key value is (69).{Environment.NewLine}The statement has been terminated."); _suppliedMetadataProvider = A.Fake <IDatabaseMetadataProvider>(); A.CallTo(() => _suppliedMetadataProvider.GetIndexDetails("SomeIndexName")) .Returns( new IndexDetails { IndexName = "SomeIndexName", TableName = "SomeTableName", ColumnNames = new List <string> { "Column1" } }); }
protected override void Arrange() { const string slightlyWrongMessage = "duplicate key value violates index constraint \"PK_UsersId\""; exception = NHibernateExceptionBuilder.CreatePostgresException(GenericSqlExceptionMessage, slightlyWrongMessage); }
protected override void Arrange() { const string message = "duplicate key value violates unique constraint \"PK_ApplicationId\""; exception = NHibernateExceptionBuilder.CreatePostgresException(GenericSqlExceptionMessage, message); }
protected override void Arrange() { _suppliedUpdateException = NHibernateExceptionBuilder.CreateException( "could not delete: [something-a-rather][SQL: SQL not available]", $"The DELETE statement conflicted with the REFERENCE constraint \"FK_DisciplineAction_DisciplineIncident_SchoolId\". The conflict occurred in database \"EdFi_Ods\", table \"edfi.DisciplineAction\".{Environment.NewLine}The statement has been terminated."); }
protected override void Arrange() { _suppliedUpdateException = NHibernateExceptionBuilder.CreateException( "could not update: [something-a-rather][SQL: SQL not available]", $"The UPDATE statement conflicted with the FOREIGN KEY constraint \"FK_Student_LimitedEnglishProficiencyType_LimitedEnglishProficiencyTypeId\". The conflict occurred in database \"EdFi_Ods\", table \"edfi.LimitedEnglishProficiencyType\", column 'LimitedEnglishProficiencyTypeId'.{Environment.NewLine}The statement has been terminated.{Environment.NewLine}"); }
protected override void Arrange() { _suppliedUpdateException = NHibernateExceptionBuilder.CreateException( "could not delete: [something-a-rather][SQL: SQL not available]", $"The DELETE statement conflicted with the REFERENCE constraint \"FK_CourseTranscript_CourseAttemptResultType_CourseAttemptResultTypeId\". The conflict occurred in database \"EdFi_Ods\", table \"edfi.CourseTranscript\", column 'CourseAttemptResultTypeId'.{Environment.NewLine}The statement has been terminated."); }