def load_pac_committees(self):
        self.log(" Loading PAC committees")

        sql = """
            INSERT INTO %(committee_model)s (
                filer_id,
                filer_id_raw,
                xref_filer_id,
                name,
                committee_type,
                party,
                level_of_government,
                effective_date,
                status
            )
            SELECT
                %(filer_model)s.`id`,
                %(filer_model)s.`filer_id_raw`,
                %(filer_model)s.`xref_filer_id`,
                %(filer_model)s.`name`,
                %(filer_model)s.`filer_type`,
                %(filer_model)s.`party`,
                metadata.`level_of_government`,
                metadata.`effective_date`,
                metadata.`status`
            FROM %(filer_model)s
            LEFT OUTER JOIN tmp_max_filer_metadata as metadata
            ON %(filer_model)s.`filer_id_raw` = metadata.`filer_id`
            WHERE filer_type = 'pac';
        """ % dict(
            committee_model=models.Committee._meta.db_table,
            filer_model=models.Filer._meta.db_table,
        )

        self.conn.execute(sql)
Returns the string 'active' if request url starts with pattern.
dataset/ETHPy150Open california-civic-data-coalition/django-calaccess-campaign-browser/calaccess_campaign_browser/management/commands/loadcalaccesscampaignfilers.py/Command.load_pac_committees--crossover with--dataset/ETHPy150Open Tivix/django-common/django_common/templatetags/custom_tags.py/active_starts