Join the 1-day Testing & QA Summit featuring 15+ Expert Speakers.Register for FREE! Join TestMu Conference

How to use _check_for_multiple_atomic_group_hosts method in autotest

Best Python code snippet using autotest_python

monitor_db_cleanup.py

Source:monitor_db_cleanup.py

...176        logging.info('Checking for uncleanable DB inconsistencies')177        self._check_for_active_and_complete_queue_entries()178        self._check_for_multiple_platform_hosts()179        self._check_for_no_platform_hosts()180        self._check_for_multiple_atomic_group_hosts()181    def _check_for_active_and_complete_queue_entries(self):182        query = models.HostQueueEntry.objects.filter(active=True, complete=True)183        if query.count() != 0:184            subject = ('%d queue entries found with active=complete=1'185                       % query.count())186            lines = [str(entry.get_object_dict()) for entry in query]187            self._send_inconsistency_message(subject, lines)188    def _check_for_multiple_platform_hosts(self):189        rows = self._db.execute("""190            SELECT afe_hosts.id, hostname, COUNT(1) AS platform_count,191                   GROUP_CONCAT(afe_labels.name)192            FROM afe_hosts193            INNER JOIN afe_hosts_labels ON194                    afe_hosts.id = afe_hosts_labels.host_id195            INNER JOIN afe_labels ON afe_hosts_labels.label_id = afe_labels.id196            WHERE afe_labels.platform197            GROUP BY afe_hosts.id198            HAVING platform_count > 1199            ORDER BY hostname""")200        if rows:201            subject = '%s hosts with multiple platforms' % self._db.rowcount202            lines = [' '.join(str(item) for item in row)203                     for row in rows]204            self._send_inconsistency_message(subject, lines)205    def _check_for_no_platform_hosts(self):206        rows = self._db.execute("""207            SELECT hostname208            FROM afe_hosts209            LEFT JOIN afe_hosts_labels210              ON afe_hosts.id = afe_hosts_labels.host_id211              AND afe_hosts_labels.label_id IN (SELECT id FROM afe_labels212                                                WHERE platform)213            WHERE NOT afe_hosts.invalid AND afe_hosts_labels.host_id IS NULL""")214        if rows:215            logging.warn('%s hosts with no platform\n%s', self._db.rowcount,216                         ', '.join(row[0] for row in rows))217    def _check_for_multiple_atomic_group_hosts(self):218        rows = self._db.execute("""219            SELECT afe_hosts.id, hostname,220                   COUNT(DISTINCT afe_atomic_groups.name) AS atomic_group_count,221                   GROUP_CONCAT(afe_labels.name),222                   GROUP_CONCAT(afe_atomic_groups.name)223            FROM afe_hosts224            INNER JOIN afe_hosts_labels ON225                    afe_hosts.id = afe_hosts_labels.host_id226            INNER JOIN afe_labels ON afe_hosts_labels.label_id = afe_labels.id227            INNER JOIN afe_atomic_groups ON228                       afe_labels.atomic_group_id = afe_atomic_groups.id229            WHERE NOT afe_hosts.invalid AND NOT afe_labels.invalid230            GROUP BY afe_hosts.id231            HAVING atomic_group_count > 1...

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.