public void EmptyColumnName_IsScriptedAnonymously()
{
string fieldName = "";
var fieldInfo = SchemaScriptingTests.FakeColumn(fieldName, "test", 32, "int", false, 0, 0);
Assert.AreEqual(false, TSqlRules.IsReservedWord(fieldName));
Assert.AreEqual("anonymousColumn1", FieldScripting.FieldNameOrDefault(fieldInfo, 0));
}
public void NonReservedWord_IsScriptedWithoutBrackets()
{
string fieldName = "TestColumnName";
var fieldInfo = SchemaScriptingTests.FakeColumn(fieldName, "test", 32, "int", false, 0, 0);
Assert.AreEqual(false, TSqlRules.IsReservedWord(fieldName));
Assert.AreEqual("TestColumnName", FieldScripting.FieldNameOrDefault(fieldInfo, 0));
}
public void ReservedWord_IsConsideredReserved()
{
Assert.AreEqual(true, TSqlRules.IsReservedWord("select"));
}
public void StringWithoutSquareBracket_IsNotConsideredAsHavingOne()
{
Assert.AreEqual(false, TSqlRules.ContainsSquareBracket("ab"));
}
public void StringsWithSquareBrackets_AreConsideredAsHavingOne()
{
Assert.AreEqual(true, TSqlRules.ContainsSquareBracket("a[b"));
Assert.AreEqual(true, TSqlRules.ContainsSquareBracket("a]b"));
}
public void CarriageReturn_IsConsideredWhitespace()
{
Assert.AreEqual(true, TSqlRules.ContainsWhitespace("a\rb"));
}
public void LineFeed_IsConsideredWhitespace()
{
Assert.AreEqual(true, TSqlRules.ContainsWhitespace("a\nb"));
}
public void Tab_IsConsideredWhitespace()
{
Assert.AreEqual(true, TSqlRules.ContainsWhitespace("a\tb"));
}
public void NonReservedWord_IsNotConsideredReserved()
{
Assert.AreEqual(false, TSqlRules.IsReservedWord("SomeSillyThing"));
}
