I'm not an expert at symfony and some help would be much appreciated.
I'm using an API to receive live match data(sports). I get the data and update it every minute, but somehow it gets updated every 8 to 15 minutes on live. (I was using predis for cache, removed it, still the same). It's also not updated on the db, I check to see if they're updated with dump, they look fine.
Code I'm using is;
foreach ($response['result'] as $result) {
$findFixture = $this->em->getRepository('App:Fixtures')->findOneBy(['fixtureId' => $result['fixture_id']]);
if(is_null($findFixture)){
$cannotFind[] = $result['fixture_id'];
continue;
}else{
$updateFixture[$findFixture->getFixtureId()]['elapsedFirst'] = $findFixture->getElapsed();
}
$eventDate = new DateTime();
$eventDate->setTimezone(new \DateTimeZone('Europe/Istanbul'));
$eventDate->setTimestamp($result['event_timestamp']);
$firstHalfStart = new DateTime();
$eventDate->setTimezone(new \DateTimeZone('Europe/Istanbul'));
$firstHalfStart->setTimestamp($result['firstHalfStart']);
$secondHalfStart = new DateTime();
$eventDate->setTimezone(new \DateTimeZone('Europe/Istanbul'));
$secondHalfStart->setTimestamp($result['secondHalfStart']);
if($findFixture->getElapsed() !== $result['elapsed']){
$persist = true;
}else{
$persist = false;
}
$findFixture
->setScore($result['score'])
->setElapsed($result['elapsed'])
->setStatus($result['statusShort'])
->setVenue($result['venue'])
->setReferee($result['referee'])
->setGoalsAwayTeam($result['goalsAwayTeam'])
->setGoalsHomeTeam($result['goalsHomeTeam']);
if($persist) $this->em->persist($findFixture);
$updateFixture[$findFixture->getFixtureId()]['persist'] = $persist;
if(isset($result['events']) && is_array($result['events'])){
foreach ($result['events'] AS $k => $v){
$result['events'][$k]['fixture_id'] = $findFixture->getFixtureId();
}
$this->renderFixtureEvents([$findFixture->getFixtureId() => $result['events'] ],false);
}
$this->em->flush();
$updateFixture[$findFixture->getFixtureId()]['elapsedLast'] = $result['elapsed'];
}
Thanks a lot in advance.
My Answer:
In Symfony 4, you can use the entity manager to persist changes to your entities and flush them to the database. To do this, you can call the `flush()` method on the entity manager object.
Here's an example of how you can use the entity manager to persist changes and flush them:
php
// Get the entity manager
$entityManager = $this->getDoctrine()->getManager();
// Create a new entity
$entity = new YourEntity();
$entity->setProperty('value');
// Persist the entity
$entityManager->persist($entity);
// Flush the changes to the database
$entityManager->flush();
In this example, we first get the entity manager using `$this->getDoctrine()->getManager()`. Then, we create a new entity object and set its properties. We use the `persist()` method to tell the entity manager to keep track of this entity. Finally, we call the `flush()` method to save the changes to the database.
Make sure to replace `YourEntity` with the name of your entity class and `setProperty('value')` with the actual property and value you want to set.
Rate this post
5 of 5 based on 6992 votesComments