sqlite.php 462 B

123456789101112131415161718192021222324
  1. <?php namespace Laravel\Database\Query\Grammars;
  2. use Laravel\Database\Query;
  3. class SQLite extends Grammar
  4. {
  5. /**
  6. * Compile the ORDER BY clause for a query.
  7. *
  8. * @param Query $query
  9. * @return string
  10. */
  11. protected function orderings(Query $query)
  12. {
  13. foreach ($query->orderings as $ordering)
  14. {
  15. $sql[] = $this->wrap($ordering['column']).' COLLATE NOCASE '.strtoupper($ordering['direction']);
  16. }
  17. return 'ORDER BY '.implode(', ', $sql);
  18. }
  19. }