public function getTables() { /** @var Table[] $tables */ $tables = array(Identity::table(), IdentityProvider::table(), Session::table(), User::table(), UserIdentity::table(), Album::table(), ExifTag::table(), Image::table(), ImageExif::table()); return $tables; }
public function getUsersByIdentityId($identityId) { $users = User::statement()->innerJoin('? ON ? = ? AND ? = ?', UserIdentity::table(), UserIdentity::columns()->userId, User::columns()->id, UserIdentity::columns()->identityId, $identityId)->query()->fetchAll(); return $users; }