Hugging Face's logo

Spaces:
chrisbryan17
/
mautic
No application file

App Files Community
mautic
File size: 4,140 Bytes 
d2897cd
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
 
<?php

declare(strict_types=1);

namespace Mautic\IntegrationsBundle\Tests\Functional\Entity;

use Mautic\CoreBundle\Test\MauticMysqlTestCase;
use Mautic\IntegrationsBundle\Entity\FieldChange;
use Mautic\IntegrationsBundle\Entity\FieldChangeRepository;
use Mautic\LeadBundle\Entity\Lead;
use PHPUnit\Framework\Assert;

final class FieldChangeRepositoryTest extends MauticMysqlTestCase
{
    private const INTEGRATION = 'someIntegration';
    private const COLUMN_NAME = 'some_column';
    private const OBJECT_ID   = 100;

    private FieldChangeRepository $repository;

    protected function setUp(): void
    {
        parent::setUp();
        $this->repository = $this->em->getRepository(FieldChange::class);
    }

    public function testThatFindChangesBeforeMethodReturnsChangesInCorrectOrder(): void
    {
        $lead1        = $this->createLead();
        $lead2        = $this->createLead();
        $lead3        = $this->createLead();
        $lead4        = $this->createLead();
        $fieldChanges = $this->generateFieldChanges(4);
        $fieldChanges[0]->setObjectId((int) $lead3->getId());
        $fieldChanges[1]->setObjectId((int) $lead4->getId());
        $fieldChanges[2]->setObjectId((int) $lead1->getId());
        $fieldChanges[3]->setObjectId((int) $lead2->getId());

        foreach ($fieldChanges as $fieldChange) {
            $this->em->persist($fieldChange);
        }

        $this->em->flush();

        $this->deleteLead($lead2);

        $changes = $this->repository->findChangesBefore(
            static::INTEGRATION,
            Lead::class,
            $this->getNow()->modify('+30 seconds'),
            null,
            2
        );

        Assert::assertEquals($lead1->getId(), $changes[0]['object_id']);
        Assert::assertEquals($lead3->getId(), $changes[1]['object_id'], 'Lead 2 record is not fetched as lead 2 is deleted');
    }

    public function testThatItDoesntDeleteObjectsThatCameDuringInternalSynchronization(): void
    {
        $now          = $this->getNow();
        $fieldChanges = $this->generateFieldChanges(2);
        $aDayLater    = (clone $now)->modify('+1 day'); // Don't use \DateTimeImmutable because entity expects \DateTime
        $fieldChanges[1]->setModifiedAt($aDayLater);

        foreach ($fieldChanges as $fieldChange) {
            $this->em->persist($fieldChange);
        }

        $this->em->flush();

        $this->repository->deleteEntitiesForObject(
            static::OBJECT_ID,
            Lead::class,
            static::INTEGRATION,
            $now->modify('+30 seconds')
        );

        $remainingChanges = $this->repository->findAll();
        Assert::assertCount(1, $remainingChanges);
        Assert::assertSame($fieldChanges[1]->getId(), $remainingChanges[0]->getId());
    }

    /**
     * @return FieldChange[]
     */
    private function generateFieldChanges(int $quantity): array
    {
        $fieldChanges = [];
        $now          = $this->getNow();
        for ($i = 1; $i <= $quantity; ++$i) {
            $fieldChange = new FieldChange();
            $fieldChange->setIntegration(static::INTEGRATION);
            $fieldChange->setObjectId(static::OBJECT_ID);
            $fieldChange->setObjectType(Lead::class);
            $fieldChange->setModifiedAt($now);
            $fieldChange->setColumnName(static::COLUMN_NAME);
            $fieldChange->setColumnType('string');
            $fieldChange->setColumnValue((string) $i);

            $fieldChanges[] = $fieldChange;
        }

        return $fieldChanges;
    }

    private function createLead(): Lead
    {
        $lead = new Lead();
        $this->em->persist($lead);
        $this->em->flush();

        return $lead;
    }

    private function deleteLead(Lead $lead): void
    {
        $qb2 = $this->em->getConnection()->createQueryBuilder();
        $qb2->delete(MAUTIC_TABLE_PREFIX.'leads')
            ->where(
                $qb2->expr()->eq('id', $lead->getId())
            );

        $qb2->executeStatement();
    }

    private function getNow(): \DateTime
    {
        return new \DateTime('now', new \DateTimeZone('UTC'));
    }
}