SqliteExpressionBuilder.php 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. <?php
  2. /**
  3. * @copyright Copyright (c) 2017 Robin Appelman <robin@icewind.nl>
  4. *
  5. * @author Robin Appelman <robin@icewind.nl>
  6. * @author Roeland Jago Douma <roeland@famdouma.nl>
  7. *
  8. * @license GNU AGPL version 3 or any later version
  9. *
  10. * This program is free software: you can redistribute it and/or modify
  11. * it under the terms of the GNU Affero General Public License as
  12. * published by the Free Software Foundation, either version 3 of the
  13. * License, or (at your option) any later version.
  14. *
  15. * This program is distributed in the hope that it will be useful,
  16. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  17. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  18. * GNU Affero General Public License for more details.
  19. *
  20. * You should have received a copy of the GNU Affero General Public License
  21. * along with this program. If not, see <http://www.gnu.org/licenses/>.
  22. *
  23. */
  24. namespace OC\DB\QueryBuilder\ExpressionBuilder;
  25. class SqliteExpressionBuilder extends ExpressionBuilder {
  26. /**
  27. * @inheritdoc
  28. */
  29. public function like($x, $y, $type = null): string {
  30. return parent::like($x, $y, $type) . " ESCAPE '\\'";
  31. }
  32. public function iLike($x, $y, $type = null): string {
  33. return $this->like($this->functionBuilder->lower($x), $this->functionBuilder->lower($y), $type);
  34. }
  35. }