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); }