diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-10 18:07:22 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-10 18:07:22 +0000 |
commit | c04dcc2e7d834218ef2d4194331e383402495ae1 (patch) | |
tree | 7333e38d10d75386e60f336b80c2443c1166031d /xbmc/dbwrappers/DatabaseQuery.h | |
parent | Initial commit. (diff) | |
download | kodi-c04dcc2e7d834218ef2d4194331e383402495ae1.tar.xz kodi-c04dcc2e7d834218ef2d4194331e383402495ae1.zip |
Adding upstream version 2:20.4+dfsg.upstream/2%20.4+dfsg
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'xbmc/dbwrappers/DatabaseQuery.h')
-rw-r--r-- | xbmc/dbwrappers/DatabaseQuery.h | 150 |
1 files changed, 150 insertions, 0 deletions
diff --git a/xbmc/dbwrappers/DatabaseQuery.h b/xbmc/dbwrappers/DatabaseQuery.h new file mode 100644 index 0000000..a15f377 --- /dev/null +++ b/xbmc/dbwrappers/DatabaseQuery.h @@ -0,0 +1,150 @@ +/* + * Copyright (C) 2013-2018 Team Kodi + * This file is part of Kodi - https://kodi.tv + * + * SPDX-License-Identifier: GPL-2.0-or-later + * See LICENSES/README.md for more information. + */ + +#pragma once + +#include <memory> +#include <set> +#include <string> +#include <vector> + +#define DATABASEQUERY_RULE_VALUE_SEPARATOR " / " + +class CDatabase; +class CVariant; +class TiXmlNode; + +class CDatabaseQueryRule +{ +public: + CDatabaseQueryRule(); + virtual ~CDatabaseQueryRule() = default; + + enum SEARCH_OPERATOR + { + OPERATOR_START = 0, + OPERATOR_CONTAINS, + OPERATOR_DOES_NOT_CONTAIN, + OPERATOR_EQUALS, + OPERATOR_DOES_NOT_EQUAL, + OPERATOR_STARTS_WITH, + OPERATOR_ENDS_WITH, + OPERATOR_GREATER_THAN, + OPERATOR_LESS_THAN, + OPERATOR_AFTER, + OPERATOR_BEFORE, + OPERATOR_IN_THE_LAST, + OPERATOR_NOT_IN_THE_LAST, + OPERATOR_TRUE, + OPERATOR_FALSE, + OPERATOR_BETWEEN, + OPERATOR_END + }; + + enum FIELD_TYPE + { + TEXT_FIELD = 0, + REAL_FIELD, + NUMERIC_FIELD, + DATE_FIELD, + PLAYLIST_FIELD, + SECONDS_FIELD, + BOOLEAN_FIELD, + TEXTIN_FIELD + }; + + virtual bool Load(const TiXmlNode* node, const std::string& encoding = "UTF-8"); + virtual bool Load(const CVariant& obj); + virtual bool Save(TiXmlNode* parent) const; + virtual bool Save(CVariant& obj) const; + + static std::string GetLocalizedOperator(SEARCH_OPERATOR oper); + static void GetAvailableOperators(std::vector<std::string>& operatorList); + + std::string GetParameter() const; + void SetParameter(const std::string& value); + void SetParameter(const std::vector<std::string>& values); + + virtual std::string GetWhereClause(const CDatabase& db, const std::string& strType) const; + + int m_field; + SEARCH_OPERATOR m_operator; + std::vector<std::string> m_parameter; + +protected: + virtual std::string GetField(int field, const std::string& type) const = 0; + virtual FIELD_TYPE GetFieldType(int field) const = 0; + virtual int TranslateField(const char* field) const = 0; + virtual std::string TranslateField(int field) const = 0; + std::string ValidateParameter(const std::string& parameter) const; + virtual std::string FormatParameter(const std::string& negate, + const std::string& oper, + const CDatabase& db, + const std::string& type) const; + virtual std::string FormatWhereClause(const std::string& negate, + const std::string& oper, + const std::string& param, + const CDatabase& db, + const std::string& type) const; + virtual SEARCH_OPERATOR GetOperator(const std::string& type) const { return m_operator; } + virtual std::string GetOperatorString(SEARCH_OPERATOR op) const; + virtual std::string GetBooleanQuery(const std::string& negate, const std::string& strType) const + { + return ""; + } + + static SEARCH_OPERATOR TranslateOperator(const char* oper); + static std::string TranslateOperator(SEARCH_OPERATOR oper); +}; + +class CDatabaseQueryRuleCombination; + +typedef std::vector<std::shared_ptr<CDatabaseQueryRule>> CDatabaseQueryRules; +typedef std::vector<std::shared_ptr<CDatabaseQueryRuleCombination>> CDatabaseQueryRuleCombinations; + +class IDatabaseQueryRuleFactory +{ +public: + virtual ~IDatabaseQueryRuleFactory() = default; + virtual CDatabaseQueryRule* CreateRule() const = 0; + virtual CDatabaseQueryRuleCombination* CreateCombination() const = 0; +}; + +class CDatabaseQueryRuleCombination +{ +public: + virtual ~CDatabaseQueryRuleCombination() = default; + + typedef enum + { + CombinationOr = 0, + CombinationAnd + } Combination; + + void clear(); + virtual bool Load(const TiXmlNode* node, const std::string& encoding = "UTF-8") { return false; } + virtual bool Load(const CVariant& obj, const IDatabaseQueryRuleFactory* factory); + virtual bool Save(TiXmlNode* parent) const; + virtual bool Save(CVariant& obj) const; + + std::string GetWhereClause(const CDatabase& db, const std::string& strType) const; + std::string TranslateCombinationType() const; + + Combination GetType() const { return m_type; } + void SetType(Combination combination) { m_type = combination; } + + bool empty() const { return m_combinations.empty() && m_rules.empty(); } + +protected: + friend class CGUIDialogSmartPlaylistEditor; + friend class CGUIDialogMediaFilter; + + Combination m_type = CombinationAnd; + CDatabaseQueryRuleCombinations m_combinations; + CDatabaseQueryRules m_rules; +}; |