ezsystems / ezpublish-kernel

    /**

     * Create select query to query content name data.

     */

    public function createNamesQuery(): DoctrineQueryBuilder

    {

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

        $query

            ->select(

                'contentobject_id AS ezcontentobject_name_contentobject_id',

                'content_version AS ezcontentobject_name_content_version',

                'name AS ezcontentobject_name_name',

                'content_translation AS ezcontentobject_name_content_translation'

            )

            ->from(Gateway::CONTENT_NAME_TABLE);

        return $query;

    }

    /**

     * Create a select query for content relations.

    /**

     * Create a select query for content relations.

     */

    public function createRelationFindQueryBuilder(): DoctrineQueryBuilder

    {

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

        $query

            ->select(

                'l.id AS ezcontentobject_link_id',

                'l.contentclassattribute_id AS ezcontentobject_link_contentclassattribute_id',

                'l.from_contentobject_id AS ezcontentobject_link_from_contentobject_id',

                'l.from_contentobject_version AS ezcontentobject_link_from_contentobject_version',

                'l.relation_type AS ezcontentobject_link_relation_type',

                'l.to_contentobject_id AS ezcontentobject_link_to_contentobject_id'

            )

            ->from(

                Gateway::CONTENT_RELATION_TABLE, 'l'

            );

        return $query;

    }

    /**

     * Create an update query for setting Content item Version status.