public void AllParams_ReturnsProperlyQuoted() { TestDialect dialect = GetDialect(); string result = dialect.GetColumnName("bar", "foo", "al"); Assert.AreEqual("\"bar\".\"foo\" AS \"al\"", result); }
public void ContainsQuotes_DoesNotAddExtraQuotes() { TestDialect dialect = GetDialect(); string result = dialect.GetColumnName("\"bar\"", "\"foo\"", "\"al\""); Assert.AreEqual("\"bar\".\"foo\" AS \"al\"", result); }
public void PrefixColumnName_ReturnsProperlyQuoted() { TestDialect dialect = GetDialect(); string result = dialect.GetColumnName("bar", "foo", null); Assert.AreEqual("\"bar\".\"foo\"", result); }
public void TableNameOnly_ReturnsProperlyQuoted() { TestDialect dialect = GetDialect(); string result = dialect.GetTableName(null, "foo", null); Assert.AreEqual("\"foo\"", result); }
public void SchemaAndTable_ReturnsProperlyQuoted() { TestDialect dialect = GetDialect(); string result = dialect.GetTableName("bar", "foo", null); Assert.AreEqual("\"bar\".\"foo\"", result); }
public void CanQueryByDateTimeOffsetUtcNow() { if (!TestDialect.SupportsSqlType(SqlTypeFactory.DateTimeOffSet)) { Assert.Ignore("Dialect does not support DateTimeOffSet"); } var isSupported = IsFunctionSupported("current_utctimestamp_offset"); RunTest( isSupported, spy => { var testDate = DateTimeOffset.UtcNow.AddDays(-1); var x = db.Orders.Count(o => testDate < DateTimeOffset.UtcNow); Assert.That(x, Is.GreaterThan(0)); AssertFunctionInSql("current_utctimestamp_offset", spy); }); }
public void CanQueryByNewGuid() { if (!TestDialect.SupportsSqlType(SqlTypeFactory.Guid)) { Assert.Ignore("Guid are not supported by the target database"); } var isSupported = IsFunctionSupported("new_uuid"); RunTest( isSupported, spy => { var guid = Guid.NewGuid(); var x = db.Orders.Count(o => guid != Guid.NewGuid()); Assert.That(x, Is.GreaterThan(0)); AssertFunctionInSql("new_uuid", spy); }); }
public void CanSelectNewGuid() { if (!TestDialect.SupportsSqlType(SqlTypeFactory.Guid)) { Assert.Ignore("Guid are not supported by the target database"); } var isSupported = IsFunctionSupported("new_uuid"); RunTest( isSupported, spy => { var x = db .Orders.Select(o => new { id = o.OrderId, g = Guid.NewGuid() }) .OrderBy(o => o.id).Take(1).ToList(); Assert.That(x, Has.Count.GreaterThan(0)); AssertFunctionInSql("new_uuid", spy); }); }
public void CanSelectDateTimeOffsetUtcNow() { if (!TestDialect.SupportsSqlType(SqlTypeFactory.DateTimeOffSet)) { Assert.Ignore("Dialect does not support DateTimeOffSet"); } var isSupported = IsFunctionSupported("current_utctimestamp_offset"); RunTest( isSupported, spy => { var x = db .Orders.Select(o => new { id = o.OrderId, d = DateTimeOffset.UtcNow }) .OrderBy(o => o.id).Take(1).ToList(); Assert.That(x, Has.Count.GreaterThan(0)); Assert.That(x[0].d.Offset, Is.EqualTo(TimeSpan.Zero)); AssertFunctionInSql("current_utctimestamp_offset", spy); }); }
protected override bool AppliesTo(Dialect.Dialect dialect) { return(TestDialect.GetTestDialect(dialect).SupportsDistributedTransactions); }
public void Setup() { Dialect = new TestDialect(); }
protected override bool AppliesTo(Dialect.Dialect dialect) { return(TestDialect.GetTestDialect(dialect).SupportsFullJoin); }
public void IsQuoted_WithQuotes_ReturnsTrue() { TestDialect dialect = GetDialect(); Assert.IsTrue(dialect.IsQuoted("\"foo\"")); }
protected SqlDialectBaseFixtureBase() { Dialect = new TestDialect(); }
public void EmptyTableName_ReturnsProperlyQuoted() { TestDialect dialect = GetDialect(); Assert.Throws <ArgumentNullException>(() => dialect.GetTableName(null, string.Empty, null)); }
public void QuoteString_WithBothQuote_DoesNotAddQuotes() { TestDialect dialect = GetDialect(); Assert.AreEqual("\"foo\"", dialect.QuoteString("\"foo\"")); }
public void QuoteString_WithCloseQuote_AddsQuotes() { TestDialect dialect = GetDialect(); Assert.AreEqual("\"foo\"\"", dialect.QuoteString("foo\"")); }
public void IsQuoted_WithOnlyCloseQuotes_ReturnsFalse() { TestDialect dialect = GetDialect(); Assert.IsFalse(dialect.IsQuoted("foo\"")); }
public void IsQuoted_WithOnlyStartQuotes_ReturnsFalse() { TestDialect dialect = GetDialect(); Assert.IsFalse(dialect.IsQuoted("\"foo")); }
protected override bool AppliesTo(Dialect.Dialect dialect) => TestDialect.SupportsSqlType(SqlTypeFactory.DateTimeOffSet);
public SqlDialectBaseFixtureBase() { Dialect = new TestDialect(); }
protected override bool AppliesTo(Dialect.Dialect dialect) { return(TestDialect.SupportsSqlType(new SqlType(DbType.Xml))); }
public void NullColumnName_ReturnsProperlyQuoted() { TestDialect dialect = GetDialect(); Assert.Throws <ArgumentNullException>(() => dialect.GetColumnName(null, null, null)); }