// Copyright (c) 2017-2020, Mudita Sp. z.o.o. All rights reserved. // For licensing, see https://github.com/mudita/MuditaOS/LICENSE.md #pragma once #include "module-db/Common/Common.hpp" #include "module-db/Databases/EventsDB.hpp" #include "Record.hpp" #include #include #include #include #include // fw declarations namespace db::query::events { class Get; class GetResult; class GetAll; class GetAllResult; class GetAllLimited; class GetAllLimitedResult; class GetFiltered; class GetFilteredResult; class Add; class AddResult; class Remove; class RemoveResult; class RemoveICS; class RemoveICSResult; class Edit; class EditResult; class EditICS; class EditICSResult; class SelectFirstUpcoming; class SelectFirstUpcomingResult; } // namespace db::query::events struct EventsRecord : public Record { std::string UID; std::string title; calendar::TimePoint date_from; calendar::TimePoint date_till; uint32_t reminder = 0; uint32_t repeat = 0; calendar::TimePoint reminder_fired; std::string provider_type; std::string provider_id; std::string provider_iCalUid; EventsRecord() = default; ~EventsRecord() = default; EventsRecord(const EventsTableRow &tableRow); }; enum class EventsRecordField { start, end, reminder }; class EventsRecordInterface : public RecordInterface { public: EventsRecordInterface(EventsDB *eventsDb); ~EventsRecordInterface() override = default; bool Add(const EventsRecord &rec) override final; bool RemoveByID(uint32_t id) override final; bool RemoveByUID(const std::string &UID); bool RemoveByField(EventsRecordField field, const char *str) override final; bool Update(const EventsRecord &rec) override final; bool UpdateByUID(const EventsRecord &rec); EventsRecord GetByID(uint32_t id) override final; EventsRecord GetByUID(const std::string &uid); uint32_t GetCount() override final; uint32_t GetCountFiltered(calendar::TimePoint from, calendar::TimePoint till); std::vector Select(calendar::TimePoint filter_from, calendar::TimePoint filter_till, uint32_t offset, uint32_t limit); std::unique_ptr> GetLimitOffset(uint32_t offset, uint32_t limit) override final; std::unique_ptr> GetLimitOffsetByField(uint32_t offset, uint32_t limit, EventsRecordField field, const char *str) override final; std::vector GetLimitOffsetByDate(uint32_t offset, uint32_t limit); std::vector SelectFirstUpcoming(calendar::TimePoint filter_from, calendar::TimePoint filter_till); std::unique_ptr runQuery(std::shared_ptr query) override; private: EventsDB *eventsDb = nullptr; std::unique_ptr runQueryImplGetResult(std::shared_ptr query); std::unique_ptr runQueryImplGetAllResult(std::shared_ptr query); std::unique_ptr runQueryImplGetAllLimitedResult( std::shared_ptr query); std::unique_ptr runQueryImplGetFilteredResult( std::shared_ptr query); std::unique_ptr runQueryImplAdd(std::shared_ptr query); std::unique_ptr runQueryImplRemove(std::shared_ptr query); std::unique_ptr runQueryImplRemoveICS(std::shared_ptr query); std::unique_ptr runQueryImplEdit(std::shared_ptr query); std::unique_ptr runQueryImplEditICS(std::shared_ptr query); std::unique_ptr runQueryImplSelectFirstUpcoming( std::shared_ptr query); };