/** * @covers flowcode\ceibo\domain\Query::orderBy */ public function testOrderBy() { $this->object->orderBy("name"); $this->object->orderBy("name", "DESC"); $stmt = $this->object->buildStatement(); $this->assertEquals("SELECT * FROM ovni ORDER BY name ASC, name DESC", $stmt); }
public function index() { $query = new Query(); $query->orderBy('id', 'DESC'); $query->limit(4); $posts = $query->find('Posts'); $this->render('index.html.twig', array('posts' => $posts)); }
public function testOrdering() { $path = __DIR__ . '/fixtures/datastore/querytest'; $config = new Config($path . '/'); $repo = new Repository('countries', $config); $query = new Query($repo); $query->orderBy('capital DESC'); $result = $query->execute(); $this->assertEquals('Croatia', $result->first()->id); $this->assertEquals('Heard Island and McDonald Islands', $result[$result->count() - 1]->id); }
/** * Get public latest releases with artist name * * @param Query $query * @return Query */ public function scopePublicLatestReleases($query) { return $query->orderBy('released_at', 'desc')->join('artists', 'artists.id', '=', 'releases.artist_id')->select(['releases.title', 'releases.permalink', 'releases.coverart_thumbnail', 'releases.coverart_alt', 'releases.genre', DB::raw('artists.name as artist_name')])->where('releases.active', true); }
/** * Se obtienen todos los posts con su categoria y seccion activos * * @param Query $query * @return Query */ public function scopeLatest($query) { return $query->orderBy('posts.created_at', 'desc')->join('categories', 'categories.id', '=', 'posts.category_id')->select(['posts.id', 'posts.category_id', 'posts.title', 'posts.permalink', 'posts.active', DB::raw('categories.name as category_name'), DB::raw('categories.permalink as category_permalink')]); }
<?php require_once 'autoloader.php'; $query = new Query(); $query->orderBy('id', 'DESC'); $query->limit(2, 4); $user = $query->isEntity('Users'); var_dump($user); $user = new Users(); $user->setPseudo('Luke Skywalker'); $user->setAge('26'); $user->setPassword('LoveMySister'); $user->save();
/** * Aplica ordenação em objetos Query. * * @param Query $query * @return Query * */ private function _sorterQueryObject($query) { foreach ($this->_orderByList as $colName => $order) { $query->orderBy(array($colName => $order)); } return $query; }
public function testSelectDistinctStatement_Order_By_Array() { $query = new Query("SELECT DISTINCT id, description FROM `test`"); $query->orderBy(array("name", "description", "checksum")); $this->assertEquals("SELECT DISTINCT id, description FROM `test` ORDER BY `name`, `description`, `checksum`", (string) $query); }