public function reduceExclusivityIndex()
    {
        $q = $this->getEntityManager()->getConnection()->createQueryBuilder();
        $q->update(MAUTIC_TABLE_PREFIX.$this->getTableName());
        $q->where(
            $q->expr()->isNotNull('exclusive_expire_date'),
            $q->expr()->lte('exclusive_expire_date', 'NOW()')
        );
        $q->set('exclusive_expire_date', 'NULL');
        $q->set('exclusive_pattern', 'NULL');
        $q->set('exclusive_scope', 'NULL');
        $q->execute();
    }
public function reduceExclusivityIndex()
    {
        $q = $this->getEntityManager()->getConnection()->createQueryBuilder();
        $q->update(MAUTIC_TABLE_PREFIX.$this->getTableName());
        $q->where(
            $q->expr()->isNotNull('exclusive_expire_date'),
            $q->expr()->lte('exclusive_expire_date', 'NOW()')
        );
        $q->set('exclusive_expire_date', 'NULL');
        $q->set('exclusive_pattern', 'NULL');
        $q->set('exclusive_scope', 'NULL');
        $q->execute();
    }
public function reduceExclusivityIndex ( ) { $ q = $ this -> getEntityManager ( ) -> getConnection ( ) -> createQueryBuilder ( ) ; $ q -> update ( MAUTIC_TABLE_PREFIX . $ this -> getTableName ( ) ) ; $ q -> where ( $ q -> expr ( ) -> isNotNull ( 'exclusive_expire_date' ) , $ q -> expr ( ) -> lte ( 'exclusive_expire_date' , 'NOW()' ) ) ; $ q -> set ( 'exclusive_expire_date' , 'NULL' ) ; $ q -> set ( 'exclusive_pattern' , 'NULL' ) ; $ q -> set ( 'exclusive_scope' , 'NULL' ) ; $ q -> execute ( ) ; }
Update exclusivity rows to reduce the index size and thus reduce processing required to check exclusivity.
Update exclusivity rows to reduce the index size and thus reduce processing required to check exclusivity .