public static void RemoveLogging_GivenNonLoggedConnection_ThrowsNothing()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(dbConnection, dialect);
Assert.That(() => connection.RemoveLogging(), Throws.Nothing);
}
public static void IsLoggingConfigured_GivenConfiguredConnection_ReturnsTrue()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var connection = new SchematicConnection(dbConnection, Mock.Of <IDatabaseDialect>());
Logging.AddLogging(connection, Mock.Of <ILogger>(), LogLevel.Information);
Assert.That(Logging.IsLoggingConfigured(dbConnection), Is.True);
}
public static void SetMaxConcurrentQueries_GivenValidConnection_ThrowsNothing()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(dbConnection, dialect);
Assert.That(() => connection.SetMaxConcurrentQueries(123), Throws.Nothing);
}
public static void ConnectionId_PropertyGetWhenNoCtorArgProvided_IsNotEmpty()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(dbConnection, dialect);
Assert.That(connection.ConnectionId, Is.Not.EqualTo(Guid.Empty));
}
public static void GetRoutine_GivenNullIdentifier_ThrowsArgumentNullException()
{
var connection = new SchematicConnection(Mock.Of <IDbConnectionFactory>(), Mock.Of <IDatabaseDialect>());
var identifierDefaults = Mock.Of <IIdentifierDefaults>();
var database = new SqlServerRelationalDatabase(connection, identifierDefaults);
Assert.That(() => database.GetRoutine(null), Throws.ArgumentNullException);
}
public static void Dialect_PropertyGet_ReturnsCtorArg()
{
var identifier = Guid.NewGuid();
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(identifier, dbConnection, dialect);
Assert.That(connection.Dialect, Is.EqualTo(dialect));
}
public static void GetSynonym_GivenNullIdentifier_ThrowsArgumentNullException()
{
var connection = new SchematicConnection(Mock.Of <IDbConnectionFactory>(), Mock.Of <IDatabaseDialect>());
var identifierDefaults = Mock.Of <IIdentifierDefaults>();
var identifierResolver = new DefaultOracleIdentifierResolutionStrategy();
var database = new OracleRelationalDatabase(connection, identifierDefaults, identifierResolver);
Assert.That(() => database.GetSynonym(null), Throws.ArgumentNullException);
}
public static void GetRules_WhenInvoked_RetrievesRulesFromTestRuleProvider()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(dbConnection, dialect);
var rules = RuleProvider.GetRules(connection, RuleLevel.Error);
Assert.That(rules, Has.Exactly(TestRuleProvider.RuleCount).Items);
}
public static void GetRules_GivenValidInput_ReturnsEmptySet()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(dbConnection, dialect);
var rules = RuleProvider.GetRules(connection, RuleLevel.Error);
Assert.That(rules, Is.Empty);
}
public static void GetRules_GivenNoProviders_ReturnsEmptySet()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(dbConnection, dialect);
var ruleProvider = new CompositeRuleProvider(Array.Empty <IRuleProvider>());
var rules = ruleProvider.GetRules(connection, RuleLevel.Error);
Assert.That(rules, Is.Empty);
}
public static void GetRules_GivenDefaultProvider_ReturnsNonEmptySet()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(dbConnection, dialect);
var ruleProvider = new CompositeRuleProvider(new[] { new DefaultRuleProvider() });
var rules = ruleProvider.GetRules(connection, RuleLevel.Error);
Assert.That(rules, Is.Not.Empty);
}
public static void Test()
{
var ruleProvider = new Html.Lint.ReportingRuleProvider();
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = new Sqlite.SqliteDialect();
var connection = new SchematicConnection(dbConnection, dialect);
var rules = ruleProvider.GetRules(connection, Lint.RuleLevel.Error);
Assert.That(rules, Is.Not.Empty);
}
public static void Build_GivenNoProviders_ReturnsEmptyRuleSet()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(dbConnection, dialect);
var ruleProvider = new RuleProviderBuilder().Build();
var rules = ruleProvider.GetRules(connection, RuleLevel.Error);
Assert.That(rules, Is.Empty);
}
public static void GetRules_WhenInvokedWithMatchingDialect_RetrievesRulesFromTestRuleProviderAndTestDialectProvider()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = new Fakes.FakeDatabaseDialect();
var connection = new SchematicConnection(dbConnection, dialect);
var rules = RuleProvider.GetRules(connection, RuleLevel.Error);
const int expectedCount = TestRuleProvider.RuleCount + TestDialectRuleProvider.RuleCount;
Assert.That(rules, Has.Exactly(expectedCount).Items);
}
public static void SchemaName_PropertyGet_MatchesCtorArg()
{
var dialectMock = new Mock <IDatabaseDialect>();
dialectMock.Setup(dialect => dialect.QuoteIdentifier(It.IsAny <string>())).Returns("test");
var connection = new SchematicConnection(Mock.Of <IDbConnectionFactory>(), dialectMock.Object);
const string schemaName = "test";
var dbPragma = new DatabasePragma(connection, schemaName);
Assert.That(dbPragma.SchemaName, Is.EqualTo(schemaName));
}
public static void AddLogging_GivenValidConnection_ThrowsNothing()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(dbConnection, dialect);
var loggerFactory = new Mock <ILoggerFactory>();
loggerFactory.Setup(factory => factory.CreateLogger(It.IsAny <string>())).Returns(Mock.Of <ILogger>());
Assert.That(() => connection.AddLogging(loggerFactory.Object, LogLevel.Information), Throws.Nothing);
}
public static void Build_GivenDefaultProviderViaGeneric_ReturnsNonEmptyRuleSet()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(dbConnection, dialect);
var ruleProvider = new RuleProviderBuilder()
.AddRuleProvider <DefaultRuleProvider>()
.Build();
var rules = ruleProvider.GetRules(connection, RuleLevel.Error);
Assert.That(rules, Is.Not.Empty);
}
public static void Stop_WhenNotStarted_ShouldDoNothing()
{
var connectionFactory = Mock.Of <IDbConnectionFactory>(MockBehavior.Strict);
var logger = Mock.Of <ILogger>();
const string sql = "select 1";
var connection = new SchematicConnection(connectionFactory, Mock.Of <IDatabaseDialect>());
Logging.AddLogging(connection, logger, LogLevel.Information);
var loggingContext = new QueryLoggingContext(connectionFactory, sql, null);
Assert.That(() => loggingContext.Stop(), Throws.Nothing);
}
public static void GetRules_GivenMultipleProviders_ReturnsExpectedRuleCount()
{
var dbConnection = Mock.Of <IDbConnectionFactory>();
var dialect = Mock.Of <IDatabaseDialect>();
var connection = new SchematicConnection(dbConnection, dialect);
var defaultProvider = new DefaultRuleProvider();
var ruleProvider = new CompositeRuleProvider(new[] { defaultProvider, defaultProvider });
var defaultRules = defaultProvider.GetRules(connection, RuleLevel.Error).ToList();
var expectedCount = defaultRules.Count * 2;
var compositeRules = ruleProvider.GetRules(connection, RuleLevel.Error);
Assert.That(compositeRules, Has.Exactly(expectedCount).Items);
}
private static ISqliteDatabasePragma CreateDatabasePragma(IDbConnectionFactory connectionFactory, string schemaName)
{
var conn = new SchematicConnection(Guid.NewGuid(), connectionFactory, new SqliteDialect());
return(new DatabasePragma(conn, schemaName));
}
private static ISqliteConnectionPragma CreateConnectionPragma(IDbConnectionFactory connectionFactory)
{
var conn = new SchematicConnection(Guid.NewGuid(), connectionFactory, new SqliteDialect());
return(new ConnectionPragma(conn));
}
