public static void QuoteIdentifier_GivenNameWithQuoteAtStartAndEnd_ReturnsQuotedIdentifier()
{
const string input = "\"test\"table";
const string expected = "\"\"\"test\"\"table\"";
var dialect = new PostgreSqlDialect();
var result = dialect.QuoteIdentifier(input);
Assert.That(result, Is.EqualTo(expected));
}
public static void QuoteIdentifier_GivenRegularLocalName_ReturnsQuotedIdentifier()
{
const string input = "test_table";
const string expected = "\"test_table\"";
var dialect = new PostgreSqlDialect();
var result = dialect.QuoteIdentifier(input);
Assert.That(result, Is.EqualTo(expected));
}
public static void QuoteIdentifier_GivenNameWithDotSeparators_ReturnsQuotedIdentifier()
{
const string input = "test.table.name";
const string expected = "\"test.table.name\"";
var dialect = new PostgreSqlDialect();
var result = dialect.QuoteIdentifier(input);
Assert.That(result, Is.EqualTo(expected));
}
public static void QuoteIdentifier_GivenNullOrWhiteSpaceIdentifier_ThrowsArgumentNullException(string identifier)
{
var dialect = new PostgreSqlDialect();
Assert.That(() => dialect.QuoteIdentifier(identifier), Throws.ArgumentNullException);
}