Gamesubmissions.h

/**
 *
 *  Gamesubmissions.h
 *  DO NOT EDIT. This file is generated by drogon_ctl
 *
 */

#pragma once
#include <drogon/orm/Field.h>
#include <drogon/orm/Mapper.h>
#include <drogon/orm/Result.h>
#include <drogon/orm/Row.h>
#include <drogon/orm/SqlBinder.h>
#ifdef __cpp_impl_coroutine
#include <drogon/orm/CoroMapper.h>
#endif
#include <json/json.h>
#include <stdint.h>
#include <trantor/utils/Date.h>
#include <trantor/utils/Logger.h>
#include <iostream>
#include <memory>
#include <string>
#include <tuple>
#include <vector>

namespace drogon {
namespace orm {
class DbClient;
using DbClientPtr = std::shared_ptr<DbClient>;
}  // namespace orm
}  // namespace drogon
namespace drogon_model {
namespace cavoke {

class Gamesubmissions {
public:
    struct Cols {
        static const std::string _id;
        static const std::string _game_id;
        static const std::string _package_type;
        static const std::string _git_repo;
        static const std::string _review_status;
        static const std::string _submitted_at;
        static const std::string _display_name;
    };

    const static int primaryKeyNumber;
    const static std::string tableName;
    const static bool hasPrimaryKey;
    const static std::string primaryKeyName;
    using PrimaryKeyType = std::string;
    const PrimaryKeyType &getPrimaryKey() const;

    /**
     * @brief constructor
     * @param r One row of records in the SQL query result.
     * @param indexOffset Set the offset to -1 to access all columns by column
     * names, otherwise access all columns by offsets.
     * @note If the SQL is not a style of 'select * from table_name ...' (select
     * all columns by an asterisk), please set the offset to -1.
     */
    explicit Gamesubmissions(const drogon::orm::Row &r,
                             const ssize_t indexOffset = 0) noexcept;

    /**
     * @brief constructor
     * @param pJson The json object to construct a new instance.
     */
    explicit Gamesubmissions(const Json::Value &pJson) noexcept(false);

    /**
     * @brief constructor
     * @param pJson The json object to construct a new instance.
     * @param pMasqueradingVector The aliases of table columns.
     */
    Gamesubmissions(
        const Json::Value &pJson,
        const std::vector<std::string> &pMasqueradingVector) noexcept(false);

    Gamesubmissions() = default;

    void updateByJson(const Json::Value &pJson) noexcept(false);
    void updateByMasqueradedJson(
        const Json::Value &pJson,
        const std::vector<std::string> &pMasqueradingVector) noexcept(false);
    static bool validateJsonForCreation(const Json::Value &pJson,
                                        std::string &err);
    static bool validateMasqueradedJsonForCreation(
        const Json::Value &,
        const std::vector<std::string> &pMasqueradingVector,
        std::string &err);
    static bool validateJsonForUpdate(const Json::Value &pJson,
                                      std::string &err);
    static bool validateMasqueradedJsonForUpdate(
        const Json::Value &,
        const std::vector<std::string> &pMasqueradingVector,
        std::string &err);
    static bool validJsonOfField(size_t index,
                                 const std::string &fieldName,
                                 const Json::Value &pJson,
                                 std::string &err,
                                 bool isForCreation);

    /**  For column id  */
    /// Get the value of the column id, returns the default value if the column
    /// is null
    const std::string &getValueOfId() const noexcept;
    /// Return a shared_ptr object pointing to the column const value, or an
    /// empty shared_ptr object if the column is null
    const std::shared_ptr<std::string> &getId() const noexcept;
    /// Set the value of the column id
    void setId(const std::string &pId) noexcept;
    void setId(std::string &&pId) noexcept;

    /**  For column game_id  */
    /// Get the value of the column game_id, returns the default value if the
    /// column is null
    const std::string &getValueOfGameId() const noexcept;
    /// Return a shared_ptr object pointing to the column const value, or an
    /// empty shared_ptr object if the column is null
    const std::shared_ptr<std::string> &getGameId() const noexcept;
    /// Set the value of the column game_id
    void setGameId(const std::string &pGameId) noexcept;
    void setGameId(std::string &&pGameId) noexcept;
    void setGameIdToNull() noexcept;

    /**  For column package_type  */
    /// Get the value of the column package_type, returns the default value if
    /// the column is null
    const std::string &getValueOfPackageType() const noexcept;
    /// Return a shared_ptr object pointing to the column const value, or an
    /// empty shared_ptr object if the column is null
    const std::shared_ptr<std::string> &getPackageType() const noexcept;
    /// Set the value of the column package_type
    void setPackageType(const std::string &pPackageType) noexcept;
    void setPackageType(std::string &&pPackageType) noexcept;
    void setPackageTypeToNull() noexcept;

    /**  For column git_repo  */
    /// Get the value of the column git_repo, returns the default value if the
    /// column is null
    const std::string &getValueOfGitRepo() const noexcept;
    /// Return a shared_ptr object pointing to the column const value, or an
    /// empty shared_ptr object if the column is null
    const std::shared_ptr<std::string> &getGitRepo() const noexcept;
    /// Set the value of the column git_repo
    void setGitRepo(const std::string &pGitRepo) noexcept;
    void setGitRepo(std::string &&pGitRepo) noexcept;
    void setGitRepoToNull() noexcept;

    /**  For column review_status  */
    /// Get the value of the column review_status, returns the default value if
    /// the column is null
    const int32_t &getValueOfReviewStatus() const noexcept;
    /// Return a shared_ptr object pointing to the column const value, or an
    /// empty shared_ptr object if the column is null
    const std::shared_ptr<int32_t> &getReviewStatus() const noexcept;
    /// Set the value of the column review_status
    void setReviewStatus(const int32_t &pReviewStatus) noexcept;
    void setReviewStatusToNull() noexcept;

    /**  For column submitted_at  */
    /// Get the value of the column submitted_at, returns the default value if
    /// the column is null
    const ::trantor::Date &getValueOfSubmittedAt() const noexcept;
    /// Return a shared_ptr object pointing to the column const value, or an
    /// empty shared_ptr object if the column is null
    const std::shared_ptr<::trantor::Date> &getSubmittedAt() const noexcept;
    /// Set the value of the column submitted_at
    void setSubmittedAt(const ::trantor::Date &pSubmittedAt) noexcept;
    void setSubmittedAtToNull() noexcept;

    /**  For column display_name  */
    /// Get the value of the column display_name, returns the default value if
    /// the column is null
    const std::string &getValueOfDisplayName() const noexcept;
    /// Return a shared_ptr object pointing to the column const value, or an
    /// empty shared_ptr object if the column is null
    const std::shared_ptr<std::string> &getDisplayName() const noexcept;
    /// Set the value of the column display_name
    void setDisplayName(const std::string &pDisplayName) noexcept;
    void setDisplayName(std::string &&pDisplayName) noexcept;
    void setDisplayNameToNull() noexcept;

    static size_t getColumnNumber() noexcept {
        return 7;
    }
    static const std::string &getColumnName(size_t index) noexcept(false);

    Json::Value toJson() const;
    Json::Value toMasqueradedJson(
        const std::vector<std::string> &pMasqueradingVector) const;
    /// Relationship interfaces
private:
    friend drogon::orm::Mapper<Gamesubmissions>;
#ifdef __cpp_impl_coroutine
    friend drogon::orm::CoroMapper<Gamesubmissions>;
#endif
    static const std::vector<std::string> &insertColumns() noexcept;
    void outputArgs(drogon::orm::internal::SqlBinder &binder) const;
    const std::vector<std::string> updateColumns() const;
    void updateArgs(drogon::orm::internal::SqlBinder &binder) const;
    /// For mysql or sqlite3
    void updateId(const uint64_t id);
    std::shared_ptr<std::string> id_;
    std::shared_ptr<std::string> gameId_;
    std::shared_ptr<std::string> packageType_;
    std::shared_ptr<std::string> gitRepo_;
    std::shared_ptr<int32_t> reviewStatus_;
    std::shared_ptr<::trantor::Date> submittedAt_;
    std::shared_ptr<std::string> displayName_;
    struct MetaData {
        const std::string colName_;
        const std::string colType_;
        const std::string colDatabaseType_;
        const ssize_t colLength_;
        const bool isAutoVal_;
        const bool isPrimaryKey_;
        const bool notNull_;
    };
    static const std::vector<MetaData> metaData_;
    bool dirtyFlag_[7] = {false};

public:
    static const std::string &sqlForFindingByPrimaryKey() {
        static const std::string sql =
            "select * from " + tableName + " where id = $1";
        return sql;
    }

    static const std::string &sqlForDeletingByPrimaryKey() {
        static const std::string sql =
            "delete from " + tableName + " where id = $1";
        return sql;
    }
    std::string sqlForInserting(bool &needSelection) const {
        std::string sql = "insert into " + tableName + " (";
        size_t parametersCount = 0;
        needSelection = false;
        sql += "id,";
        ++parametersCount;
        if (!dirtyFlag_[0]) {
            needSelection = true;
        }
        if (dirtyFlag_[1]) {
            sql += "game_id,";
            ++parametersCount;
        }
        if (dirtyFlag_[2]) {
            sql += "package_type,";
            ++parametersCount;
        }
        if (dirtyFlag_[3]) {
            sql += "git_repo,";
            ++parametersCount;
        }
        sql += "review_status,";
        ++parametersCount;
        if (!dirtyFlag_[4]) {
            needSelection = true;
        }
        sql += "submitted_at,";
        ++parametersCount;
        if (!dirtyFlag_[5]) {
            needSelection = true;
        }
        if (dirtyFlag_[6]) {
            sql += "display_name,";
            ++parametersCount;
        }
        if (parametersCount > 0) {
            sql[sql.length() - 1] = ')';
            sql += " values (";
        } else
            sql += ") values (";

        int placeholder = 1;
        char placeholderStr[64];
        size_t n = 0;
        if (dirtyFlag_[0]) {
            n = sprintf(placeholderStr, "$%d,", placeholder++);
            sql.append(placeholderStr, n);
        } else {
            sql += "default,";
        }
        if (dirtyFlag_[1]) {
            n = sprintf(placeholderStr, "$%d,", placeholder++);
            sql.append(placeholderStr, n);
        }
        if (dirtyFlag_[2]) {
            n = sprintf(placeholderStr, "$%d,", placeholder++);
            sql.append(placeholderStr, n);
        }
        if (dirtyFlag_[3]) {
            n = sprintf(placeholderStr, "$%d,", placeholder++);
            sql.append(placeholderStr, n);
        }
        if (dirtyFlag_[4]) {
            n = sprintf(placeholderStr, "$%d,", placeholder++);
            sql.append(placeholderStr, n);
        } else {
            sql += "default,";
        }
        if (dirtyFlag_[5]) {
            n = sprintf(placeholderStr, "$%d,", placeholder++);
            sql.append(placeholderStr, n);
        } else {
            sql += "default,";
        }
        if (dirtyFlag_[6]) {
            n = sprintf(placeholderStr, "$%d,", placeholder++);
            sql.append(placeholderStr, n);
        }
        if (parametersCount > 0) {
            sql.resize(sql.length() - 1);
        }
        if (needSelection) {
            sql.append(") returning *");
        } else {
            sql.append(1, ')');
        }
        LOG_TRACE << sql;
        return sql;
    }
};
}  // namespace cavoke
}  // namespace drogon_model