Skip to content

A native macOS / windows / Linux database IDE built with Swift and AppKit. Connect to PostgreSQL, MySQL, SQLite, and Redis from a single app with a fast, keyboard-driven interface.

C++
3.4 KB
Raw Blame
#pragma once
#include "DatabaseAdapter.h"
#include <string>

// Forward declare MariaDB/MySQL C API types
struct st_mysql;
typedef struct st_mysql MYSQL;

namespace DBModels
{
    class MySQLAdapter : public DatabaseAdapter
    {
    public:
        MySQLAdapter();
        ~MySQLAdapter() override;

        // Connection
        void connect(const ConnectionConfig& config, const std::wstring& password) override;
        void disconnect() override;
        bool testConnection(const ConnectionConfig& config, const std::wstring& password) override;
        bool isConnected() const override;

        // Query Execution
        QueryResult execute(const std::wstring& sql) override;
        QueryResult fetchRows(
            const std::wstring& table, const std::wstring& schema,
            int limit, int offset,
            const std::wstring& orderBy, bool ascending) override;

        // Schema Inspection
        std::vector<std::wstring> listDatabases() override;
        std::vector<std::wstring> listSchemas() override;
        std::vector<TableInfo> listTables(const std::wstring& schema) override;
        std::vector<TableInfo> listViews(const std::wstring& schema) override;
        std::vector<ColumnInfo> describeTable(
            const std::wstring& table, const std::wstring& schema) override;
        std::vector<IndexInfo> listIndexes(
            const std::wstring& table, const std::wstring& schema) override;
        std::vector<ForeignKeyInfo> listForeignKeys(
            const std::wstring& table, const std::wstring& schema) override;
        std::vector<std::wstring> listFunctions(const std::wstring& schema) override;
        std::wstring getFunctionSource(
            const std::wstring& name, const std::wstring& schema) override;
        std::wstring getCreateTableSQL(
            const std::wstring& table, const std::wstring& schema) override;

        // Data Manipulation
        QueryResult insertRow(
            const std::wstring& table, const std::wstring& schema,
            const TableRow& values) override;
        QueryResult updateRow(
            const std::wstring& table, const std::wstring& schema,
            const TableRow& setValues, const TableRow& whereValues) override;
        QueryResult deleteRow(
            const std::wstring& table, const std::wstring& schema,
            const TableRow& whereValues) override;

        // Transactions
        void beginTransaction() override;
        void commitTransaction() override;
        void rollbackTransaction() override;

        // Server Info
        std::wstring serverVersion() override;
        std::wstring currentDatabase() override;

        // SQL string assembly
        std::wstring quoteSqlLiteral(const std::wstring& value) const override;
        std::wstring quoteSqlIdentifier(const std::wstring& name) const override;

    private:
        MYSQL* conn_ = nullptr;
        bool connected_ = false;

        static std::string toUtf8(const std::wstring& wstr);
        static std::wstring fromUtf8(const std::string& str);
        static std::string quoteIdentifier(const std::wstring& name);
        static std::string quoteLiteral(const std::wstring& value);
        std::wstring resolveSchema(const std::wstring& schema);
        std::string qualifyTable(const std::wstring& schema, const std::wstring& table);
        void ensureConnected() const;
        QueryResult executeInternal(const std::string& sql);
    };
}