public static async Task AnalyseViews_GivenViewWithColumnNameContainingReservedKeyword_ProducesMessages() { var rule = new ReservedKeywordNameRule(CreateFakeDialect(), RuleLevel.Error); var viewName = new Identifier("test"); var testColumn = new DatabaseColumn( "SELECT", Mock.Of <IDbType>(), false, null, null ); var view = new DatabaseView( viewName, "select 1", new List <IDatabaseColumn> { testColumn } ); var views = new[] { view }; var hasMessages = await rule.AnalyseViews(views).AnyAsync().ConfigureAwait(false); Assert.That(hasMessages, Is.True); }
public static async Task AnalyseTables_GivenTableWithColumnNameContainingReservedKeyword_ProducesMessages() { var rule = new ReservedKeywordNameRule(CreateFakeDialect(), RuleLevel.Error); var testColumn = new DatabaseColumn( "SELECT", Mock.Of <IDbType>(), false, null, null ); var table = new RelationalDatabaseTable( "test", new List <IDatabaseColumn> { testColumn }, null, Array.Empty <IDatabaseKey>(), Array.Empty <IDatabaseRelationalKey>(), Array.Empty <IDatabaseRelationalKey>(), Array.Empty <IDatabaseIndex>(), Array.Empty <IDatabaseCheckConstraint>(), Array.Empty <IDatabaseTrigger>() ); var tables = new[] { table }; var hasMessages = await rule.AnalyseTables(tables).AnyAsync().ConfigureAwait(false); Assert.That(hasMessages, Is.True); }
public static async Task AnalyseRoutines_GivenRoutineWithNameContainingReservedKeyword_ProducesMessages() { var rule = new ReservedKeywordNameRule(CreateFakeDialect(), RuleLevel.Error); var routineName = new Identifier("SELECT"); var routine = new DatabaseRoutine(routineName, "routine_definition"); var routines = new[] { routine }; var hasMessages = await rule.AnalyseRoutines(routines).AnyAsync().ConfigureAwait(false); Assert.That(hasMessages, Is.True); }
public static async Task AnalyseSynonyms_GivenSynonymWithNameContainingReservedKeyword_ProducesMessages() { var rule = new ReservedKeywordNameRule(CreateFakeDialect(), RuleLevel.Error); var synonymName = new Identifier("SELECT"); var synonym = new DatabaseSynonym(synonymName, "target"); var synonyms = new[] { synonym }; var hasMessages = await rule.AnalyseSynonyms(synonyms).AnyAsync().ConfigureAwait(false); Assert.That(hasMessages, Is.True); }
public static async Task AnalyseViews_GivenViewWithNameContainingReservedKeyword_ProducesMessages() { var rule = new ReservedKeywordNameRule(CreateFakeDialect(), RuleLevel.Error); var viewName = new Identifier("SELECT"); var view = new DatabaseView( viewName, "select 1", Array.Empty <IDatabaseColumn>() ); var views = new[] { view }; var hasMessages = await rule.AnalyseViews(views).AnyAsync().ConfigureAwait(false); Assert.That(hasMessages, Is.True); }
public static async Task AnalyseSequences_GivenSequenceWithNameContainingReservedKeyword_ProducesMessages() { var rule = new ReservedKeywordNameRule(CreateFakeDialect(), RuleLevel.Error); var sequenceName = new Identifier("SELECT"); var sequence = new DatabaseSequence( sequenceName, 1, 1, 1, 100, true, 10 ); var sequences = new[] { sequence }; var hasMessages = await rule.AnalyseSequences(sequences).AnyAsync().ConfigureAwait(false); Assert.That(hasMessages, Is.True); }
public static async Task AnalyseTables_GivenTableWithRegularName_ProducesNoMessages() { var rule = new ReservedKeywordNameRule(CreateFakeDialect(), RuleLevel.Error); var tableName = new Identifier("test"); var table = new RelationalDatabaseTable( tableName, new List <IDatabaseColumn>(), null, Array.Empty <IDatabaseKey>(), Array.Empty <IDatabaseRelationalKey>(), Array.Empty <IDatabaseRelationalKey>(), Array.Empty <IDatabaseIndex>(), Array.Empty <IDatabaseCheckConstraint>(), Array.Empty <IDatabaseTrigger>() ); var tables = new[] { table }; var hasMessages = await rule.AnalyseTables(tables).AnyAsync().ConfigureAwait(false); Assert.That(hasMessages, Is.False); }
public static void AnalyseRoutines_GivenNullRoutines_ThrowsArgumentNullException() { var rule = new ReservedKeywordNameRule(CreateFakeDialect(), RuleLevel.Error); Assert.That(() => rule.AnalyseRoutines(null), Throws.ArgumentNullException); }