database::query::tests Namespace Reference

Classes
class	CrossDialectTest
class	PostgreSQLDialectTest
class	SQLiteDialectTest

Functions
	TEST_F (PostgreSQLDialectTest, PlaceholderStyle)
	TEST_F (PostgreSQLDialectTest, QuoteIdentifier)
	TEST_F (PostgreSQLDialectTest, QuoteIdentifierWithSpecialChars)
	TEST_F (PostgreSQLDialectTest, EscapeString)
	TEST_F (PostgreSQLDialectTest, ReturningClause)
	TEST_F (PostgreSQLDialectTest, UpsertClause)
	TEST_F (PostgreSQLDialectTest, UpsertClauseDoNothing)
	TEST_F (PostgreSQLDialectTest, UpsertClauseMultipleConflictColumns)
	TEST_F (PostgreSQLDialectTest, SupportsFeatureReturning)
	TEST_F (SQLiteDialectTest, PlaceholderStyle)
	TEST_F (SQLiteDialectTest, QuoteIdentifier)
	TEST_F (SQLiteDialectTest, QuoteIdentifierWithQuotes)
	TEST_F (SQLiteDialectTest, EscapeString)
	TEST_F (SQLiteDialectTest, ReturningClause)
	TEST_F (SQLiteDialectTest, UpsertClause)
	TEST_F (SQLiteDialectTest, UpsertClauseDoNothing)
	TEST_F (SQLiteDialectTest, SupportsFeatureReturning)
	TEST_F (SQLiteDialectTest, LimitClauseSyntax)
	TEST (SqlDialectFactoryTest, CreatePostgreSQLDialect)
	TEST (SqlDialectFactoryTest, CreateSQLiteDialect)
	TEST (SqlDialectFactoryTest, CreateUnsupportedDialectThrows)
	TEST_F (CrossDialectTest, PlaceholderStylesDiffer)
	TEST_F (CrossDialectTest, QuoteIdentifierStyles)
	TEST_F (CrossDialectTest, ConcatOperatorDiffers)
	TEST_F (CrossDialectTest, AutoIncrementSyntax)
	TEST_F (CrossDialectTest, CurrentTimestampFunction)

Function Documentation

TEST() [1/3]

database::query::tests::TEST	(	SqlDialectFactoryTest	,
		CreatePostgreSQLDialect	)

Definition at line 205 of file sql_dialect_test.cpp.

{
    auto dialect = sql_dialect::create(database_types::postgres);
    ASSERT_NE(dialect, nullptr);
    EXPECT_EQ(dialect->placeholder(1), "$1");
}

References database::query::sql_dialect::create(), and database::postgres.

Here is the call graph for this function:

TEST() [2/3]

database::query::tests::TEST	(	SqlDialectFactoryTest	,
		CreateSQLiteDialect	)

Definition at line 212 of file sql_dialect_test.cpp.

{
    auto dialect = sql_dialect::create(database_types::sqlite);
    ASSERT_NE(dialect, nullptr);
    EXPECT_EQ(dialect->placeholder(1), "?1");
}

References database::query::sql_dialect::create(), and database::sqlite.

Here is the call graph for this function:

TEST() [3/3]

database::query::tests::TEST	(	SqlDialectFactoryTest	,
		CreateUnsupportedDialectThrows	)

Definition at line 219 of file sql_dialect_test.cpp.

{
    EXPECT_THROW(
        sql_dialect::create(database_types::mongodb),
        std::invalid_argument
    );
    EXPECT_THROW(
        sql_dialect::create(database_types::redis),
        std::invalid_argument
    );
}

References database::query::sql_dialect::create(), database::mongodb, and database::redis.

Here is the call graph for this function:

TEST_F() [1/23]

database::query::tests::TEST_F	(	CrossDialectTest	,
		AutoIncrementSyntax	)

Definition at line 270 of file sql_dialect_test.cpp.

{
    EXPECT_EQ(postgres_->auto_increment(), "SERIAL");
    EXPECT_EQ(sqlite_->auto_increment(), "AUTOINCREMENT");
}

TEST_F() [2/23]

database::query::tests::TEST_F	(	CrossDialectTest	,
		ConcatOperatorDiffers	)

Definition at line 263 of file sql_dialect_test.cpp.

{
    // PostgreSQL and SQLite use ||
    EXPECT_EQ(postgres_->concat_operator(), "||");
    EXPECT_EQ(sqlite_->concat_operator(), "||");
}

TEST_F() [3/23]

database::query::tests::TEST_F	(	CrossDialectTest	,
		CurrentTimestampFunction	)

Definition at line 276 of file sql_dialect_test.cpp.

{
    EXPECT_EQ(postgres_->current_timestamp(), "CURRENT_TIMESTAMP");
    EXPECT_EQ(sqlite_->current_timestamp(), "CURRENT_TIMESTAMP");
}

TEST_F() [4/23]

database::query::tests::TEST_F	(	CrossDialectTest	,
		PlaceholderStylesDiffer	)

Definition at line 248 of file sql_dialect_test.cpp.

{
    // Both dialects should produce different placeholders
    EXPECT_NE(postgres_->placeholder(1), sqlite_->placeholder(1));
}

TEST_F() [5/23]

database::query::tests::TEST_F	(	CrossDialectTest	,
		QuoteIdentifierStyles	)

Definition at line 254 of file sql_dialect_test.cpp.

{
    std::string col = "user_id";
 
    // PostgreSQL and SQLite use double quotes
    EXPECT_EQ(postgres_->quote_identifier(col), "\"user_id\"");
    EXPECT_EQ(sqlite_->quote_identifier(col), "\"user_id\"");
}

TEST_F() [6/23]

database::query::tests::TEST_F	(	PostgreSQLDialectTest	,
		EscapeString	)

Definition at line 60 of file sql_dialect_test.cpp.

{
    EXPECT_EQ(dialect_->escape_string("hello"), "hello");
    EXPECT_EQ(dialect_->escape_string("it's"), "it''s");  // Single quote doubled
    EXPECT_EQ(dialect_->escape_string("back\\slash"), "back\\\\slash");  // Backslash escaped
    EXPECT_EQ(dialect_->escape_string("O'Brien's"), "O''Brien''s");
}

TEST_F() [7/23]

database::query::tests::TEST_F	(	PostgreSQLDialectTest	,
		PlaceholderStyle	)

Definition at line 39 of file sql_dialect_test.cpp.

{
    EXPECT_EQ(dialect_->placeholder(1), "$1");
    EXPECT_EQ(dialect_->placeholder(2), "$2");
    EXPECT_EQ(dialect_->placeholder(10), "$10");
    EXPECT_EQ(dialect_->placeholder(100), "$100");
}

TEST_F() [8/23]

database::query::tests::TEST_F	(	PostgreSQLDialectTest	,
		QuoteIdentifier	)

Definition at line 47 of file sql_dialect_test.cpp.

{
    EXPECT_EQ(dialect_->quote_identifier("users"), "\"users\"");
    EXPECT_EQ(dialect_->quote_identifier("user_name"), "\"user_name\"");
    EXPECT_EQ(dialect_->quote_identifier("SELECT"), "\"SELECT\"");  // Reserved word
}

TEST_F() [9/23]

database::query::tests::TEST_F	(	PostgreSQLDialectTest	,
		QuoteIdentifierWithSpecialChars	)

Definition at line 54 of file sql_dialect_test.cpp.

{
    // Double quotes should be escaped by doubling
    EXPECT_EQ(dialect_->quote_identifier("user\"name"), "\"user\"\"name\"");
}

TEST_F() [10/23]

database::query::tests::TEST_F	(	PostgreSQLDialectTest	,
		ReturningClause	)

Definition at line 68 of file sql_dialect_test.cpp.

{
    EXPECT_EQ(dialect_->returning_clause("id"), " RETURNING \"id\"");
    EXPECT_EQ(dialect_->returning_clause(""), " RETURNING *");
}

TEST_F() [11/23]

database::query::tests::TEST_F	(	PostgreSQLDialectTest	,
		SupportsFeatureReturning	)

Definition at line 108 of file sql_dialect_test.cpp.

{
    EXPECT_TRUE(dialect_->supports_feature("returning"));
    EXPECT_TRUE(dialect_->supports_feature("upsert"));
    EXPECT_TRUE(dialect_->supports_feature("full_outer_join"));
}

TEST_F() [12/23]

database::query::tests::TEST_F	(	PostgreSQLDialectTest	,
		UpsertClause	)

Definition at line 74 of file sql_dialect_test.cpp.

{
    std::vector<std::string> conflict_cols = {"id"};
    std::vector<std::string> update_cols = {"name", "email"};
 
    std::string result = dialect_->upsert_clause(conflict_cols, update_cols);
 
    EXPECT_TRUE(result.find("ON CONFLICT") != std::string::npos);
    EXPECT_TRUE(result.find("\"id\"") != std::string::npos);
    EXPECT_TRUE(result.find("DO UPDATE SET") != std::string::npos);
    EXPECT_TRUE(result.find("EXCLUDED") != std::string::npos);
}

TEST_F() [13/23]

database::query::tests::TEST_F	(	PostgreSQLDialectTest	,
		UpsertClauseDoNothing	)

Definition at line 87 of file sql_dialect_test.cpp.

{
    std::vector<std::string> conflict_cols = {"id"};
    std::vector<std::string> update_cols;  // Empty = DO NOTHING
 
    std::string result = dialect_->upsert_clause(conflict_cols, update_cols);
 
    EXPECT_TRUE(result.find("DO NOTHING") != std::string::npos);
}

TEST_F() [14/23]

database::query::tests::TEST_F	(	PostgreSQLDialectTest	,
		UpsertClauseMultipleConflictColumns	)

Definition at line 97 of file sql_dialect_test.cpp.

{
    std::vector<std::string> conflict_cols = {"tenant_id", "user_id"};
    std::vector<std::string> update_cols = {"updated_at"};
 
    std::string result = dialect_->upsert_clause(conflict_cols, update_cols);
 
    EXPECT_TRUE(result.find("\"tenant_id\"") != std::string::npos);
    EXPECT_TRUE(result.find("\"user_id\"") != std::string::npos);
}

TEST_F() [15/23]

database::query::tests::TEST_F	(	SQLiteDialectTest	,
		EscapeString	)

Definition at line 151 of file sql_dialect_test.cpp.

{
    EXPECT_EQ(dialect_->escape_string("hello"), "hello");
    EXPECT_EQ(dialect_->escape_string("it's"), "it''s");  // Single quote doubled
    EXPECT_EQ(dialect_->escape_string("O'Brien's"), "O''Brien''s");
}

TEST_F() [16/23]

database::query::tests::TEST_F	(	SQLiteDialectTest	,
		LimitClauseSyntax	)

Definition at line 195 of file sql_dialect_test.cpp.

{
    EXPECT_EQ(dialect_->limit_clause(10, 0), "LIMIT 10");
    EXPECT_EQ(dialect_->limit_clause(10, 20), "LIMIT 10 OFFSET 20");
}

TEST_F() [17/23]

database::query::tests::TEST_F	(	SQLiteDialectTest	,
		PlaceholderStyle	)

Definition at line 130 of file sql_dialect_test.cpp.

{
    // SQLite uses ?N numbered placeholders
    EXPECT_EQ(dialect_->placeholder(1), "?1");
    EXPECT_EQ(dialect_->placeholder(2), "?2");
    EXPECT_EQ(dialect_->placeholder(10), "?10");
}

TEST_F() [18/23]

database::query::tests::TEST_F	(	SQLiteDialectTest	,
		QuoteIdentifier	)

Definition at line 138 of file sql_dialect_test.cpp.

{
    EXPECT_EQ(dialect_->quote_identifier("users"), "\"users\"");
    EXPECT_EQ(dialect_->quote_identifier("user_name"), "\"user_name\"");
    EXPECT_EQ(dialect_->quote_identifier("SELECT"), "\"SELECT\"");
}

TEST_F() [19/23]

database::query::tests::TEST_F	(	SQLiteDialectTest	,
		QuoteIdentifierWithQuotes	)

Definition at line 145 of file sql_dialect_test.cpp.

{
    // Double quotes should be escaped by doubling
    EXPECT_EQ(dialect_->quote_identifier("user\"name"), "\"user\"\"name\"");
}

TEST_F() [20/23]

database::query::tests::TEST_F	(	SQLiteDialectTest	,
		ReturningClause	)

Definition at line 158 of file sql_dialect_test.cpp.

{
    // SQLite 3.35+ supports RETURNING
    EXPECT_EQ(dialect_->returning_clause("id"), " RETURNING \"id\"");
    EXPECT_EQ(dialect_->returning_clause(""), " RETURNING *");
}

TEST_F() [21/23]

database::query::tests::TEST_F	(	SQLiteDialectTest	,
		SupportsFeatureReturning	)

Definition at line 188 of file sql_dialect_test.cpp.

{
    EXPECT_TRUE(dialect_->supports_feature("returning"));
    EXPECT_TRUE(dialect_->supports_feature("upsert"));
    EXPECT_FALSE(dialect_->supports_feature("full_outer_join"));
}

TEST_F() [22/23]

database::query::tests::TEST_F	(	SQLiteDialectTest	,
		UpsertClause	)

Definition at line 165 of file sql_dialect_test.cpp.

{
    std::vector<std::string> conflict_cols = {"id"};
    std::vector<std::string> update_cols = {"name", "email"};
 
    std::string result = dialect_->upsert_clause(conflict_cols, update_cols);
 
    EXPECT_TRUE(result.find("ON CONFLICT") != std::string::npos);
    EXPECT_TRUE(result.find("\"id\"") != std::string::npos);
    EXPECT_TRUE(result.find("DO UPDATE SET") != std::string::npos);
    EXPECT_TRUE(result.find("excluded") != std::string::npos);  // SQLite uses lowercase
}

TEST_F() [23/23]

database::query::tests::TEST_F	(	SQLiteDialectTest	,
		UpsertClauseDoNothing	)

Definition at line 178 of file sql_dialect_test.cpp.

{
    std::vector<std::string> conflict_cols = {"id"};
    std::vector<std::string> update_cols;
 
    std::string result = dialect_->upsert_clause(conflict_cols, update_cols);
 
    EXPECT_TRUE(result.find("DO NOTHING") != std::string::npos);
}