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 Github

copy

Full Screen

...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...

Full Screen

Full Screen

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.

LambdaTest Learning Hubs:

YouTube

You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.

Run autotest automation tests on LambdaTest cloud grid

Perform automation testing on 3000+ real desktop and mobile devices online.

Try LambdaTest Now !!

Get 100 minutes of automation test minutes FREE!!

Next-Gen App & Browser Testing Cloud

Was this article helpful?

Helpful

NotHelpful