public void FieldWithCarriageReturn_IsScriptedWithBrackets()
{
string fieldName = "Crazy\rtown";
var fieldInfo = SchemaScriptingTests.FakeColumn(fieldName, "test", 32, "int", false, 0, 0);
Assert.AreEqual("[Crazy\rtown]", FieldScripting.FieldNameOrDefault(fieldInfo, 0));
}
public void FieldWithCloseSquareBracket_IsScriptedWithBracketsAndAlsoFurtherEscaped()
{
string fieldName = "test]ing";
var fieldInfo = SchemaScriptingTests.FakeColumn(fieldName, "test", 32, "int", false, 0, 0);
Assert.AreEqual("[test]]ing]", FieldScripting.FieldNameOrDefault(fieldInfo, 0));
}
public void FieldWithLineFeed_IsScriptedWithBrackets()
{
string fieldName = "This\nis";
var fieldInfo = SchemaScriptingTests.FakeColumn(fieldName, "test", 32, "int", false, 0, 0);
Assert.AreEqual("[This\nis]", FieldScripting.FieldNameOrDefault(fieldInfo, 0));
}
public void FieldWithSpaces_IsScriptedWithBrackets()
{
string fieldName = "What We Should Be Sending";
var fieldInfo = SchemaScriptingTests.FakeColumn(fieldName, "test", 32, "int", false, 0, 0);
Assert.AreEqual("[What We Should Be Sending]", FieldScripting.FieldNameOrDefault(fieldInfo, 0));
}
public void ReservedWord_IsScriptedWithBrackets()
{
string fieldName = "Drop";
var fieldInfo = SchemaScriptingTests.FakeColumn(fieldName, "test", 32, "int", false, 0, 0);
Assert.AreEqual("[Drop]", FieldScripting.FieldNameOrDefault(fieldInfo, 0));
}
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));
}
