Lines 57.89% 11 / 19
Functions and Methods 80.00% 4 / 5
Classes and Traits 0.00% 0 / 1
Name Lines Functions and Methods CRAP Classes and Traits
Session 57.89% 11 / 19 80.00% 4 / 5 6.87 0.00% 0 / 1
 getEntityMapping 100.00% 5 / 5 100.00% 1 / 1 1
 addConditionSessionId 100.00% 2 / 2 100.00% 1 / 1 1
 addConditionSessionName 100.00% 2 / 2 100.00% 1 / 1 1
 addConditionSessionDeleteInterval 0.00% 0 / 8 0.00% 0 / 1 2
 postProcess 100.00% 2 / 2 100.00% 1 / 1 1
1<?php
2
3namespace BO\Zmsbackend\Session\Repository;
4
5class Session extends \BO\Zmsbackend\Query\Base
6{
7    /**
8     * @var String TABLE mysql table reference
9     */
10    const string TABLE = 'sessiondata';
11
12    /**
13     * No resolving required here
14     */
15    protected $resolveLevel = 0;
16
17    const string QUERY_WRITE = '
18        REPLACE INTO
19            sessiondata
20        SET
21            sessionid=?,
22            sessionname=?,
23            sessioncontent=?
24    ';
25
26    const string QUERY_DELETE = '
27        DELETE FROM
28            sessiondata
29        WHERE
30            sessionid=? AND
31            sessionname=?
32    ';
33
34    const string QUERY_DELETE_BY_AGE = '
35        DELETE FROM `sessiondata`
36        WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`ts`) >= ?
37    ';
38
39    const string QUERY_DELETE_BY_AGE_AND_NAME = '
40        DELETE FROM `sessiondata`
41        WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`ts`) >= ?
42        AND `sessionname` = ?
43    ';
44
45    /**
46     * @psalm-api
47     *
48     * @return string[]
49     *
50     */
51    public function getEntityMapping(): array
52    {
53        return [
54            'id' => 'session.sessionid',
55            'name' => 'session.sessionname',
56            'content' => 'session.sessioncontent'
57        ];
58    }
59
60    public function addConditionSessionId(string|int $sessionId): static
61    {
62        $this->query->where('session.sessionid', '=', $sessionId);
63        return $this;
64    }
65
66    public function addConditionSessionName(string $sessionName): static
67    {
68        $this->query->where('session.sessionname', '=', $sessionName);
69        return $this;
70    }
71
72    public function addConditionSessionDeleteInterval(int $deleteInSeconds): static
73    {
74        $this->query->where(
75            self::expression(
76                'UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`session`.`ts`)'
77            ),
78            '>=',
79            $deleteInSeconds
80        );
81        return $this;
82    }
83
84    /**
85     * postProcess data if necessary
86     *
87     */
88    #[\Override]
89    public function postProcess(array $data)
90    {
91        $data[$this->getPrefixed('content')] = json_decode($data[$this->getPrefixed('content')], 1);
92        return $data;
93    }
94}