public override void SetUp()
{
// Generic Dialect inherits all of the Quoting functions from
// Dialect (which is abstract)
d = new MsSql2000Dialect();
tableWithNothingToBeQuoted = new string[] { "plainname", "[plainname]" };
tableAlreadyQuoted = new string[] { "[Quote[d[Na]]$`]", "[Quote[d[Na]]$`]", "Quote[d[Na]$`" };
tableThatNeedsToBeQuoted = new string[] { "Quote[d[Na]$`", "[Quote[d[Na]]$`]", "Quote[d[Na]$`" };
}
public void OrderByMultiColumn()
{
Dialect.Dialect dialect = new MsSql2000Dialect();
string orderBy = "col1 asc, col2 desc, col3";
string expectedOrderBy = "$PlaceHolder$.col1 asc, $PlaceHolder$.col2 desc, $PlaceHolder$.col3";
Assert.AreEqual(expectedOrderBy, Template.RenderOrderByStringTemplate(orderBy, dialect, functionRegistry));
}
public void NoLeadingUnderscores()
{
var alias = new Alias("suffix");
Dialect.Dialect dialect = new MsSql2000Dialect();
Assert.That(alias.ToAliasString("__someIdentifier", dialect), Does.Not.StartWith("_"));
Assert.That(alias.ToUnquotedAliasString("__someIdentifier", dialect), Does.Not.StartsWith("_"));
}
public void SchemaNameQuoted()
{
Table tbl = new Table();
tbl.Schema = "`schema`";
tbl.Name = "name";
Dialect.Dialect dialect = new MsSql2000Dialect();
Assert.AreEqual("[schema].name", tbl.GetQualifiedName(dialect));
}
public void NoLeadingUnderscores()
{
Alias alias = new Alias("suffix");
Dialect.Dialect dialect = new MsSql2000Dialect();
Assert.IsFalse(
alias.ToAliasString("__someIdentifier", dialect)
.StartsWith("_"));
Assert.IsFalse(
alias.ToUnquotedAliasString("__someIdentifier", dialect)
.StartsWith("_"));
}
public void TableNameNotQuoted()
{
Table tbl = new Table();
tbl.Name = "notkeyword";
Dialect.Dialect dialect = new MsSql2000Dialect();
Assert.AreEqual("notkeyword", tbl.GetQuotedName(dialect));
Assert.AreEqual("dbo.notkeyword", tbl.GetQualifiedName(dialect, null, "dbo"));
Assert.AreEqual("notkeyword", tbl.GetQualifiedName(dialect, null, null));
tbl.Schema = "sch";
Assert.AreEqual("sch.notkeyword", tbl.GetQualifiedName(dialect));
}
