Stu\Component\Admin\Reset\SequenceReset::resetSequences()

Complexity

Conditions	2
Paths	2

Size

Total Lines	38
Code Lines	25

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	6

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function resetSequences(): int
    {
        $connection = $this->entityManager->getConnection();

        $result = $connection->executeQuery(
            "SELECT  'SELECT SETVAL(' ||quote_literal(S.relname)|| ',
                        (SELECT COALESCE(MAX(' ||quote_ident(C.attname)|| '), 1)
                        FROM ' ||quote_ident(T.relname)  || '));'
            FROM pg_class S
            JOIN pg_depend D
                ON S.oid = D.objid
            JOIN pg_class T
                ON D.refobjid = T.oid
            JOIN pg_attribute C
                ON D.refobjid = C.attrelid
                AND D.refobjsubid = C.attnum
            WHERE S.relkind = 'S'
            ORDER BY S.relname"
        );

        $count = 0;

        while ($query = $result->fetchOne()) {
            $connection->executeQuery(
                $query
            );

            $count++;
        }

        $connection->executeQuery(
            sprintf(
                "SELECT SETVAL('stu_user_id_seq', %d)",
                UserEnum::USER_FIRST_ID
            )
        );

        return $count;
    }