public function testSaveStatus()
 {
     $jobRepo = new JobRepository();
     $clientRepo = new ClientRepository();
     $portfolioRepo = new PortfolioRepository();
     $job = $jobRepo->findFirst();
     $client = $clientRepo->findClientByEmail('*****@*****.**');
     $portfolio = $portfolioRepo->findPortfolioByClient($client);
     $rebalancerActions = $this->repository->findByPortfolioAndJob($portfolio, $job);
     /** @var RebalancerAction $rebalancerAction */
     $rebalancerAction = $rebalancerActions->first();
     $sql = "SELECT * FROM " . BaseRepository::TABLE_REBALANCER_ACTION . " ra where ra.id = :id";
     $connection = WealthbotMySqlSqliteConnection::getInstance();
     $pdo = $connection->getPdo();
     $statement = $pdo->prepare($sql);
     $statement->execute(array('id' => $rebalancerAction->getId()));
     $result = $statement->fetch(\PDO::FETCH_ASSOC);
     $this->assertNotEquals(Job::REBALANCE_TYPE_NO_ACTIONS, $result['status']);
     $tmpStatus = $result['status'];
     $rebalancerAction->setStatus(Job::REBALANCE_TYPE_NO_ACTIONS);
     $this->repository->saveStatus($rebalancerAction);
     $statement = $pdo->prepare($sql);
     $statement->execute(array('id' => $rebalancerAction->getId()));
     $result = $statement->fetch(\PDO::FETCH_ASSOC);
     $this->assertEquals(Job::REBALANCE_TYPE_NO_ACTIONS, $result['status']);
     $rebalancerAction->setStatus($tmpStatus);
     $this->repository->saveStatus($rebalancerAction);
 }