Best Python code snippet using autotest_python
monitor_db_cleanup.py
Source:monitor_db_cleanup.py  
...174        self._db.execute(sql)175    def _check_for_uncleanable_db_inconsistencies(self):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)...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.
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Get 100 minutes of automation test minutes FREE!!
