public void SqlScope_AddChildScopeTest()
{
var sut = new SqlScope();
var a = sut.CreateChildScope();
var b = a.CreateChildScope();
var c = b.CreateChildScope();
var d = b.CreateChildScope();
a.Add(SqlName.Parse("a", ObjectLevel.Local), "1");
b.Add(SqlName.Parse("b", ObjectLevel.Local), "2");
c.Add(SqlName.Parse("c", ObjectLevel.Local), "3");
d.Add(SqlName.Parse("d", ObjectLevel.Local), "4");
Assert.Equal("1", a.ResolveObject(SqlName.Parse("a", ObjectLevel.Local), null));
Assert.Null(a.ResolveObject(SqlName.Parse("b", ObjectLevel.Local), null));
Assert.Null(a.ResolveObject(SqlName.Parse("c", ObjectLevel.Local), null));
Assert.Null(a.ResolveObject(SqlName.Parse("d", ObjectLevel.Local), null));
Assert.Equal("1", b.ResolveObject(SqlName.Parse("a", ObjectLevel.Local), null));
Assert.Equal("2", b.ResolveObject(SqlName.Parse("b", ObjectLevel.Local), null));
Assert.Null(b.ResolveObject(SqlName.Parse("c", ObjectLevel.Local), null));
Assert.Null(b.ResolveObject(SqlName.Parse("d", ObjectLevel.Local), null));
Assert.Equal("1", c.ResolveObject(SqlName.Parse("a", ObjectLevel.Local), null));
Assert.Equal("2", c.ResolveObject(SqlName.Parse("b", ObjectLevel.Local), null));
Assert.Equal("3", c.ResolveObject(SqlName.Parse("c", ObjectLevel.Local), null));
Assert.Null(c.ResolveObject(SqlName.Parse("d", ObjectLevel.Local), null));
Assert.Equal("1", d.ResolveObject(SqlName.Parse("a", ObjectLevel.Local), null));
Assert.Equal("2", d.ResolveObject(SqlName.Parse("b", ObjectLevel.Local), null));
Assert.Null(d.ResolveObject(SqlName.Parse("c", ObjectLevel.Local), null));
Assert.Equal("4", d.ResolveObject(SqlName.Parse("d", ObjectLevel.Local), null));
}
public void SqlName_EqualsTest()
{
Assert.True(SqlName.Parse("a.b", ObjectLevel.Child).Equals(SqlName.Parse("a.b", ObjectLevel.Child)));
Assert.False(SqlName.Parse("a", ObjectLevel.Child).Equals(SqlName.Parse("b", ObjectLevel.Child)));
Assert.False(SqlName.Parse("a.b", ObjectLevel.Child).Equals(SqlName.Parse("b", ObjectLevel.Child)));
Assert.False(SqlName.Parse("a", ObjectLevel.Child).Equals(null));
}
public void SqlScope_GetTest()
{
var sut = new SqlScope();
sut.Add(SqlName.Parse("a", ObjectLevel.Unknown), "42");
Assert.Equal("42", sut.ResolveObject(SqlName.Parse("a", ObjectLevel.Unknown), null));
}
public void SqlName_ParseTest()
{
Assert.Equal("a", SqlName.Parse("a", ObjectLevel.Child).GetQFullName(null, 0));
Assert.Equal("a.b", SqlName.Parse("a.b", ObjectLevel.Child).GetQFullName(null, 0));
Assert.Equal("a.b.c", SqlName.Parse("a.b.c", ObjectLevel.Child).GetQFullName(null, 0));
Assert.Equal("a.b.c.d", SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetQFullName(null, 0));
Assert.Equal("a.b.c.d.e", SqlName.Parse("a.b.c.d.e", ObjectLevel.Child).GetQFullName(null, 0));
Assert.Equal(ObjectLevel.Server, SqlName.Parse("a", ObjectLevel.Server).ObjectLevel);
Assert.Equal(ObjectLevel.Database, SqlName.Parse("a.b", ObjectLevel.Database).ObjectLevel);
Assert.Equal(ObjectLevel.Server, SqlName.Parse("a.b", ObjectLevel.Database).Parent.ObjectLevel);
Assert.Equal(ObjectLevel.Schema, SqlName.Parse("a.b.c", ObjectLevel.Schema).ObjectLevel);
Assert.Equal(ObjectLevel.Database, SqlName.Parse("a.b.c", ObjectLevel.Schema).Parent.ObjectLevel);
Assert.Equal(ObjectLevel.Server, SqlName.Parse("a.b.c", ObjectLevel.Schema).Parent.Parent.ObjectLevel);
Assert.Equal(ObjectLevel.Object, SqlName.Parse("a.b.c.d", ObjectLevel.Object).ObjectLevel);
Assert.Equal(ObjectLevel.Schema, SqlName.Parse("a.b.c.d", ObjectLevel.Object).Parent.ObjectLevel);
Assert.Equal(ObjectLevel.Database, SqlName.Parse("a.b.c.d", ObjectLevel.Object).Parent.Parent.ObjectLevel);
Assert.Equal(ObjectLevel.Server, SqlName.Parse("a.b.c.d", ObjectLevel.Object).Parent.Parent.Parent.ObjectLevel);
Assert.Equal(ObjectLevel.Child, SqlName.Parse("a.b.c.d.e", ObjectLevel.Child).ObjectLevel);
Assert.Equal(ObjectLevel.Object, SqlName.Parse("a.b.c.d.e", ObjectLevel.Child).Parent.ObjectLevel);
Assert.Equal(ObjectLevel.Schema, SqlName.Parse("a.b.c.d.e", ObjectLevel.Child).Parent.Parent.ObjectLevel);
Assert.Equal(ObjectLevel.Database, SqlName.Parse("a.b.c.d.e", ObjectLevel.Child).Parent.Parent.Parent.ObjectLevel);
Assert.Equal(ObjectLevel.Server, SqlName.Parse("a.b.c.d.e", ObjectLevel.Child).Parent.Parent.Parent.Parent.ObjectLevel);
}
public void SqlScope_ResolveTest()
{
var sut = new SqlScope(null);
var a = sut.CreateChildScope();
sut.Add(SqlName.Parse("a", ObjectLevel.Unknown), "42");
Assert.Equal("42", a.ResolveObject(SqlName.Parse("a", ObjectLevel.Local), null));
}
public void SqlName_GetQNameTest()
{
Assert.Equal("d", SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetQName(null));
Assert.Equal("c", SqlName.Parse("a.b.c", ObjectLevel.Child).GetQName(null));
Assert.Equal("b", SqlName.Parse("a.b", ObjectLevel.Child).GetQName(null));
Assert.Equal("a", SqlName.Parse("a", ObjectLevel.Child).GetQName(null));
Assert.Equal("[d]", SqlName.Parse("[d]", ObjectLevel.Child).GetQName("["));
Assert.Equal("[c]", SqlName.Parse("[c]", ObjectLevel.Child).GetQName("["));
Assert.Equal("[b]", SqlName.Parse("[b]", ObjectLevel.Child).GetQName("["));
Assert.Equal("[a]", SqlName.Parse("[a]", ObjectLevel.Child).GetQName("["));
}
public void SqlName_GetQFullNameTest()
{
Assert.Equal("d", SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetQFullName(null, 1));
Assert.Equal("c", SqlName.Parse("a.b.c", ObjectLevel.Child).GetQFullName(null, 1));
Assert.Equal("b", SqlName.Parse("a.b", ObjectLevel.Child).GetQFullName(null, 1));
Assert.Equal("a", SqlName.Parse("a", ObjectLevel.Child).GetQFullName(null, 1));
Assert.Equal("d", SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetQFullName(null, 1));
Assert.Equal("c.d", SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetQFullName(null, 2));
Assert.Equal("b.c.d", SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetQFullName(null, 3));
Assert.Equal("a.b.c.d", SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetQFullName(null, 4));
Assert.Equal("[d]", SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetQFullName("[", 1));
Assert.Equal("[c].[d]", SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetQFullName("[", 2));
Assert.Equal("[b].[c].[d]", SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetQFullName("[", 3));
Assert.Equal("[a].[b].[c].[d]", SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetQFullName("[", 4));
}
public void SqlName_GetHashCodeTest()
{
Assert.Equal(SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetHashCode(), SqlName.Parse("A.B.C.D", ObjectLevel.Child).GetHashCode());
Assert.NotEqual(SqlName.Parse("a.b.c.d", ObjectLevel.Child).GetHashCode(), SqlName.Parse("A.B.C.DE", ObjectLevel.Child).GetHashCode());
}
public void SqlName_EqualsTest1()
{
Assert.True(SqlName.Parse("a.b.c.d", ObjectLevel.Unknown).Equals(SqlName.Parse("a.b.c.d", ObjectLevel.Unknown)));
}
public void SqlName_IsRootTest()
{
Assert.True(SqlName.Parse("a", ObjectLevel.Child).Parent.IsRoot());
Assert.True(SqlName.Parse("a", ObjectLevel.Child).IsRoot());
Assert.False(SqlName.Parse("a.b", ObjectLevel.Child).IsRoot());
}
