MuditaOS/module-db/Tables/Table.hpp

// Copyright (c) 2017-2022, Mudita Sp. z.o.o. All rights reserved.
// For licensing, see https://github.com/mudita/MuditaOS/LICENSE.md

#pragma once

#include "Record.hpp"
#include <Database/Database.hpp>

#include <functional>
#include <stdint.h>
#include <vector>

template <typename T, typename F>
class Table
{

  protected:
    explicit Table(Database *db) : db(db)
    {}

    virtual ~Table()
    {}

    virtual bool create()     = 0;
    virtual bool add(T entry) = 0;
    virtual bool removeAll()
    {
        return false;
    }
    virtual bool removeById(uint32_t id) = 0;
    virtual bool removeByField([[maybe_unused]] F field, [[maybe_unused]] const char *str)
    {
        return false;
    }
    virtual bool update(T entry)                                                                            = 0;
    virtual T getById(uint32_t id)                                                                          = 0;
    virtual std::vector<T> getLimitOffset(uint32_t offset, uint32_t limit)                                  = 0;
    virtual std::vector<T> getLimitOffsetByField(uint32_t offset, uint32_t limit, F field, const char *str) = 0;
    virtual uint32_t count()                                                                                = 0;
    virtual uint32_t countByFieldId(const char *field, uint32_t id)                                         = 0;

    uint32_t getLastInsertRowId()
    {
        return db->getLastInsertRowId();
    }

    virtual std::vector<T> retQueryUnpack(std::unique_ptr<QueryResult> retQuery) const
    {
        if ((retQuery == nullptr) || (retQuery->getRowCount() == 0) || (createTableRow == nullptr)) {
            return {};
        }

        std::vector<T> outVector;
        outVector.reserve(retQuery->getRowCount());

        do {
            outVector.push_back(createTableRow(*retQuery));
        } while (retQuery->nextRow());
        return outVector;
    }

    Database *db                                               = nullptr;
    std::function<T(const QueryResult &result)> createTableRow = nullptr;
};