ezsystems / ezpublish-kernel

     *

     * @return \Doctrine\DBAL\Driver\Statement

     */

    private function getStatementContentSince(DateTime $since, $count = false)

    {

        $q = $this->connection->createQueryBuilder()

            ->select($count ? 'count(c.id)' : 'c.id')

            ->from('ezcontentobject', 'c')

            ->where('c.status = :status')->andWhere('c.modified >= :since')

            ->orderBy('c.modified')

            ->setParameter('status', ContentInfo::STATUS_PUBLISHED, PDO::PARAM_INT)

            ->setParameter('since', $since->getTimestamp(), PDO::PARAM_INT);

        return $q->execute();

    }

    /**

     * @param mixed $locationId

        return $query;

    }

    private function markContentAsPublished(int $contentId, int $versionNo): void

    {

        $query = $this->connection->createQueryBuilder();

        $query

            ->update('ezcontentobject')

            ->set('status', ':status')

            ->set('current_version', ':versionNo')

            ->where('id =:contentId')

            ->setParameter('status', ContentInfo::STATUS_PUBLISHED, ParameterType::INTEGER)

            ->setParameter('versionNo', $versionNo, ParameterType::INTEGER)

            ->setParameter('contentId', $contentId, ParameterType::INTEGER);

        $query->execute();

    }

    /**

     * Inserts a new field.