QxSqlCompare.h 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596
  1. /****************************************************************************
  2. **
  3. ** https://www.qxorm.com/
  4. ** Copyright (C) 2013 Lionel Marty (contact@qxorm.com)
  5. **
  6. ** This file is part of the QxOrm library
  7. **
  8. ** This software is provided 'as-is', without any express or implied
  9. ** warranty. In no event will the authors be held liable for any
  10. ** damages arising from the use of this software
  11. **
  12. ** Commercial Usage
  13. ** Licensees holding valid commercial QxOrm licenses may use this file in
  14. ** accordance with the commercial license agreement provided with the
  15. ** Software or, alternatively, in accordance with the terms contained in
  16. ** a written agreement between you and Lionel Marty
  17. **
  18. ** GNU General Public License Usage
  19. ** Alternatively, this file may be used under the terms of the GNU
  20. ** General Public License version 3.0 as published by the Free Software
  21. ** Foundation and appearing in the file 'license.gpl3.txt' included in the
  22. ** packaging of this file. Please review the following information to
  23. ** ensure the GNU General Public License version 3.0 requirements will be
  24. ** met : http://www.gnu.org/copyleft/gpl.html
  25. **
  26. ** If you are unsure which license is appropriate for your use, or
  27. ** if you have questions regarding the use of this file, please contact :
  28. ** contact@qxorm.com
  29. **
  30. ****************************************************************************/
  31. #ifndef _QX_SQL_COMPARE_H_
  32. #define _QX_SQL_COMPARE_H_
  33. #ifdef _MSC_VER
  34. #pragma once
  35. #endif
  36. /*!
  37. * \file QxSqlCompare.h
  38. * \author Lionel Marty
  39. * \ingroup QxDao
  40. * \brief SQL element to compare value (==, <, >, <=, >=, LIKE, NOT LIKE, etc.)
  41. */
  42. #include <QxDao/QxSqlElement/IxSqlElement.h>
  43. namespace qx {
  44. namespace dao {
  45. namespace detail {
  46. /*!
  47. * \ingroup QxDao
  48. * \brief qx::dao::detail::QxSqlCompare : SQL element to compare value (==, <, >, <=, >=, LIKE, NOT LIKE, etc.)
  49. */
  50. class QX_DLL_EXPORT QxSqlCompare : public IxSqlElement
  51. {
  52. public:
  53. enum type { _is_equal_to, _is_not_equal_to, _is_greater_than,
  54. _is_greater_than_or_equal_to, _is_less_than, _is_less_than_or_equal_to,
  55. _like, _not_like, _starts_with, _ends_with, _contains_string, _custom_operator,
  56. _is_equal_to_select, _is_not_equal_to_select };
  57. protected:
  58. QxSqlCompare::type m_type; //!< Compare type
  59. QString m_sCustomOperator; //!< Possibility to define a custom operator with enum _custom_operator (for example <@ for PostgreSQL ltree type)
  60. public:
  61. QxSqlCompare();
  62. QxSqlCompare(int index, QxSqlCompare::type t, const QString & sCustomOperator = QString());
  63. virtual ~QxSqlCompare();
  64. virtual QString toString() const;
  65. virtual void resolve(QSqlQuery & query) const;
  66. virtual void postProcess(QString & sql) const;
  67. virtual IxSqlElement::type_class getTypeClass() const;
  68. protected:
  69. virtual QString getExtraSettings() const;
  70. virtual void setExtraSettings(const QString & s);
  71. };
  72. typedef std::shared_ptr<QxSqlCompare> QxSqlCompare_ptr;
  73. } // namespace detail
  74. } // namespace dao
  75. } // namespace qx
  76. #endif // _QX_SQL_COMPARE_H_