public void NameTest()
{
Schema schema = new Schema("test");
Assert.IsNotNull(schema);
string expected = "test";
Assert.IsNotNull(schema.Name);
Assert.IsTrue(schema.Name.Length > 0);
string actual = schema.Name;
Assert.AreEqual(expected, actual);
}
public void TestInterface()
{
var schema = new Schema("s");
var table = new Table(schema, "t");
Sql.From(table)
.GroupBy(table["c0"])
.Having(table["c1"].Equal(57))
.OrderBy(table["c2"].Desc()
);
}
public void TestExample1()
{
var nolock = new TableHint(TableHints.NoLock);
var s = new Schema("s");
}
public void TestNestedScalarSelect()
{
TableHint nolock = new TableHint(TableHints.NoLock);
var schema = new Schema("s");
var t0 = new Table("b", "b", null, nolock);
var t1 = new Table("mb", "mb", null, nolock);
var t2 = new Table(schema, "s", "s0", null, nolock);
var t3 = new Table(schema, "s", "s1", null, nolock);
var t4 = new Table(schema, "p", "p", null, nolock);
var table = Sql.From(
t0
.Join.Inner(t1, t0["mb_id"].Equal(t1["id"]))
.Join.Left(t2, t0["sid"].Equal(t2["sid"])
.And(t2["f0"].Equal("Y"))
.And(t2["f1"].Equal("N"))
.And(t2["dtm"].Equal(
Sql.From(
t3
.Join.Inner(t4, t4["gid"].Equal(t3["gid"])
.And(t4["n0"].In("YYZ", "ABC")
.And(t4["n1"].Equal("XYZ")))))
.Where(
t3["sid"].Equal(t2["sid"])
.And(t3["f0"].Equal("Y")
.And(t3["f1"].Equal("N"))))
.ScalarSelect(
new Max(t3["dtm"])
)
)
)
)
)
.Where(
t0["mb_id"].Equal("id")
.And(t0["seq"].GreaterThanOrEqual(1))
.And(t0["seq"].LessThanOrEqual(5))
)
.Select(
t0["sid"], t0["gid"], t1["eval_usr_nm"], t2["gid"]
);
AssertClause(table, @"SELECT b.sid, b.gid, mb.eval_usr_nm, s0.gid
FROM [b] AS [b] WITH (NOLOCK)
INNER JOIN [mb] AS [mb] WITH (NOLOCK) ON b.mb_id = mb.id
LEFT OUTER JOIN [s].[s] AS [s0] WITH (NOLOCK) ON b.sid = s0.sid AND s0.f0 = 'Y' AND s0.f1 = 'N' AND s0.dtm =
(SELECT MAX(s1.dtm)
FROM [s].[s] AS [s1] WITH (NOLOCK)
INNER JOIN [s].[p] AS [p] WITH (NOLOCK) ON p.gid = s1.gid AND p.n0 IN ('YYZ', 'ABC') AND p.n1 = 'XYZ'
WHERE s1.sid = s0.sid AND s1.f0 = 'Y' AND s1.f1 = 'N')
WHERE b.mb_id = 'id' AND b.seq >= 1 AND b.seq <= 5;");
}
public Table(Schema schema, string name, string alias, ClauseTableSample tableSampleClause, TableHint tableHints)
: this(schema, name, alias, tableSampleClause)
{
TableHints = tableHints;
}
public Table(Schema schema, string name, string alias, ClauseTableSample tableSampleClause)
: this(schema, name, alias)
{
SampleClause = tableSampleClause;
}
public Table(Schema schema, string name, string alias)
: this(schema, name)
{
Alias = alias;
}
public Table(Schema schema, string name)
{
Name = name;
Schema = schema;
}
public Table(Schema schema, string name, string alias, TableHint tableHints)
: this(schema, name, alias, null, tableHints)
{
//
}
public void SchemaConstructorTest()
{
string name = string.Empty; // TODO: Initialize to an appropriate value
Schema target = new Schema(name);
Assert.IsNotNull(target);
}