public void OffsetSqlServer_Should_Be_Ignored_If_Zero_Or_Negative(int offset)
{
var q = new Query().From("users").Offset(offset);
var c = Compilers.CompileFor(EngineCodes.SqlServer, q);
Assert.Equal("SELECT * FROM [users]", c.ToString());
}
public void BasicSelect_WithNoTableWhereRawClause()
{
var q = new Query().Select("c1").WhereRaw("1 = 1");
var c = Compilers.CompileFor(EngineCodes.SqlServer, q);
Assert.Equal("SELECT [c1] WHERE 1 = 1", c.ToString());
}
public void BasicSelectRaw_WithNoTable()
{
var q = new Query().SelectRaw("somefunction() as c1");
var c = Compilers.CompileFor(EngineCodes.SqlServer, q);
Assert.Equal("SELECT somefunction() as c1", c.ToString());
}
public void OffsetSqlServer_Should_Be_Incremented_By_One(int offset)
{
var q = new Query().From("users").Offset(offset);
var c = Compilers.CompileFor(EngineCodes.SqlServer, q);
Assert.Equal(
"SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS [row_num] FROM [users]) AS [results_wrapper] WHERE [row_num] >= " +
(offset + 1), c.ToString());
}
public void ShouldThrowIfInvalidEngineCode()
{
Assert.Throws <InvalidOperationException>(() => Compilers.CompileFor("XYZ", new Query()));
}
