DatabaseTests.h

/*
╔══════════════════════════════════════════════════════════════════════════════╗
║                       SIMPLY POWERFUL TOOLKIT (SPTK)                         ║
╟──────────────────────────────────────────────────────────────────────────────╢
║  copyright            © 1999-2022 Alexey Parshin. All rights reserved.       ║
║  email                alexeyp@gmail.com                                      ║
╚══════════════════════════════════════════════════════════════════════════════╝
┌──────────────────────────────────────────────────────────────────────────────┐
│   This library is free software; you can redistribute it and/or modify it    │
│   under the terms of the GNU Library General Public License as published by  │
│   the Free Software Foundation; either version 2 of the License, or (at your │
│   option) any later version.                                                 │
│                                                                              │
│   This library is distributed in the hope that it will be useful, but        │
│   WITHOUT ANY WARRANTY; without even the implied warranty of                 │
│   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library   │
│   General Public License for more details.                                   │
│                                                                              │
│   You should have received a copy of the GNU Library General Public License  │
│   along with this library; if not, write to the Free Software Foundation,    │
│   Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.               │
│                                                                              │
│   Please report all bugs and problems to alexeyp@gmail.com.                  │
└──────────────────────────────────────────────────────────────────────────────┘
*/
 
#pragma once
 
#include "AutoDatabaseConnection.h"
#include "DatabaseConnectionString.h"
 
namespace sptk {
 
class SP_EXPORT DatabaseTests
{
public:
    DatabaseTests();
 
    void addDatabaseConnection(const DatabaseConnectionString& connectionString);
 
    std::vector<DatabaseConnectionString> connectionStrings() const;
 
    DatabaseConnectionString connectionString(const String& driverName) const;
 
    static void testConnect(const DatabaseConnectionString& connectionString);
 
    static void testSelect(const DatabaseConnectionString& connectionString);
 
    static void testSelect(DatabaseConnectionPool& connectionPool);
 
    static void testDDL(const DatabaseConnectionString& connectionString);
 
    static void testQueryInsertDate(const DatabaseConnectionString& connectionString);
 
    static void testQueryInsertDateTime(const DatabaseConnectionString& connectionString);
 
    static void testQueryParameters(const DatabaseConnectionString& connectionString);
 
    static void testInsertQuery(const DatabaseConnectionString& connectionString);
 
    static void testInsertQueryDirect(const DatabaseConnectionString& connectionString);
 
    static void testTransaction(const DatabaseConnectionString& connectionString);
 
    static void testBulkInsert(const DatabaseConnectionString& connectionString);
 
    static void testBulkInsertPerformance(const DatabaseConnectionString& connectionString, size_t recordCount);
 
    static void testBatchSQL(const DatabaseConnectionString& connectionString);
 
 
    static void testBLOB(const DatabaseConnectionString& connectionString);
 
    static DatabaseTests& tests();
 
private:
    static DatabaseTests _databaseTests;
 
    std::map<String, DatabaseConnectionString> m_connectionStrings;
 
    static size_t countRowsInTable(const DatabaseConnection& db, const String& table);
 
    static void testTransaction(DatabaseConnection db, bool commit);
 
    static void createTestTable(DatabaseConnection db, bool autoPrepare = true, bool withBlob = false);
 
    static void createTestTableWithSerial(DatabaseConnection db);
 
    static void createOracleAutoIncrement(const DatabaseConnection& db, const String& tableName, const String& columnName);
};
 
} // namespace sptk