/**
* @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);
}
