public function testSelectJoinsComditionsAndLimit()
{
$join = NimbleAssociation::process_join(new User(), 'photos');
$query = new NimbleQuery();
$query->from = NimbleRecord::table_name('User');
$query->where = '`users`.id = 5';
$query->limit = '0,5';
$query->join = $join;
$this->assertEquals('SELECT * FROM `users` ' . $join . ' WHERE `users`.id = 5 LIMIT 0,5', $query->build());
}
public function testJoinsBelongsToStringLowerCaseBelongsTo()
{
$out = NimbleAssociation::process_join('user', 'photos');
$match = 'INNER JOIN `photos` ON (`users`.id = `photos`.user_id)';
$this->assertEquals($match, $out);
}
