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)); }