annotate talosnames/api.py @ 10:1029ddf7b806

get the buildbot config
author Jeff Hammel <jhammel@mozilla.com>
date Tue, 10 Jul 2012 16:22:58 -0700
parents 82aad57c7d1d
children a4aa9f83e3be
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
6
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
1 import re
10
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
2 import require
1
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
3 import sqlite3
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
4 import urllib2
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
5
0
Jeff Hammel <jhammel@mozilla.com>
parents:
diff changeset
6 class TalosNames(object):
Jeff Hammel <jhammel@mozilla.com>
parents:
diff changeset
7 graphserver_sql = 'http://hg.mozilla.org/graphs/raw-file/tip/sql/data.sql'
1
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
8 schema = 'http://hg.mozilla.org/graphs/raw-file/tip/sql/schema.sql'
10
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
9 project_branches = 'http://hg.mozilla.org/build/buildbot-configs/raw-file/tip/mozilla/project_branches.py'
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
10 buildbot_config = 'http://hg.mozilla.org/build/buildbot-configs/raw-file/tip/mozilla-tests/config.py'
1
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
11
5
2d883dd59a1a stub tbpl_mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 3
diff changeset
12 # mapping file from builbot-configs name to tbpl codes:
2d883dd59a1a stub tbpl_mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 3
diff changeset
13 # http://hg.mozilla.org/users/mstange_themasta.com/tinderboxpushlog/file/tip/js/Config.js
6
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
14 tbpl_map = 'http://hg.mozilla.org/users/mstange_themasta.com/tinderboxpushlog/raw-file/tip/js/Data.js'
5
2d883dd59a1a stub tbpl_mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 3
diff changeset
15
2
c98f2a383595 make some tables
Jeff Hammel <jhammel@mozilla.com>
parents: 1
diff changeset
16 tables = {'os_list': '(id, name text)',
3
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
17 'branches': '(id, name text)',
2
c98f2a383595 make some tables
Jeff Hammel <jhammel@mozilla.com>
parents: 1
diff changeset
18 'machines': '(id, os_id int, is_throttling int, cpu_speed text, name text, is_active int, date_added int)',
c98f2a383595 make some tables
Jeff Hammel <jhammel@mozilla.com>
parents: 1
diff changeset
19 'pagesets': '(id, name text)',
c98f2a383595 make some tables
Jeff Hammel <jhammel@mozilla.com>
parents: 1
diff changeset
20 'tests': '(id, name text, pretty_name text, is_chrome int, is_active int, pageset_id int)'
c98f2a383595 make some tables
Jeff Hammel <jhammel@mozilla.com>
parents: 1
diff changeset
21 }
1
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
22
10
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
23 ### initialization functions
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
24
0
Jeff Hammel <jhammel@mozilla.com>
parents:
diff changeset
25 def __init__(self):
5
2d883dd59a1a stub tbpl_mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 3
diff changeset
26 self.setup_database()
2d883dd59a1a stub tbpl_mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 3
diff changeset
27 self.tbpl_mapping()
10
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
28 self.setup_buildbot()
5
2d883dd59a1a stub tbpl_mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 3
diff changeset
29
6
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
30 def setup_database(self):
1
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
31 self.db = sqlite3.connect(':memory:')
3
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
32 sql_lines = urllib2.urlopen(self.graphserver_sql).readlines()
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
33
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
34 # XXX remove the machines since they require a function, unix_timestamp(), sqlite does not have
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
35 sql_lines = [line for line in sql_lines
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
36 if 'unix_timestamp' not in line]
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
37 sql = '\n'.join(sql_lines)
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
38
1
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
39 cursor = self.db.cursor()
2
c98f2a383595 make some tables
Jeff Hammel <jhammel@mozilla.com>
parents: 1
diff changeset
40 for table, schema in self.tables.items():
c98f2a383595 make some tables
Jeff Hammel <jhammel@mozilla.com>
parents: 1
diff changeset
41 cursor.execute("""CREATE TABLE %s %s""" % (table, schema))
3
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
42 cursor.executescript(sql)
2
c98f2a383595 make some tables
Jeff Hammel <jhammel@mozilla.com>
parents: 1
diff changeset
43 self.db.commit()
c98f2a383595 make some tables
Jeff Hammel <jhammel@mozilla.com>
parents: 1
diff changeset
44 cursor.close()
1
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
45
3
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
46 # create data structures
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
47 self.names = {}
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
48 self.chrome = set()
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
49 cursor = self.db.cursor()
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
50 cursor.execute("SELECT * FROM tests")
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
51 for _, short_name, graphserver_name, is_chrome, _, _ in cursor.fetchall():
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
52 self.names[short_name] = graphserver_name
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
53 if is_chrome:
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
54 self.chrome.add(short_name)
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
55 cursor.close()
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
56
5
2d883dd59a1a stub tbpl_mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 3
diff changeset
57 def tbpl_mapping(self):
6
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
58 self.tbpl_regexs = {}
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
59 lines = [line.strip()
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
60 for line in urllib2.urlopen(self.tbpl_map).readlines()]
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
61 lines = [line for line in lines
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
62 if line.startswith('/talos.*')]
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
63 regex = re.compile('\/talos\.\*(.*)\/.*\?.*\"([^"].*)\".*')
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
64 for line in lines:
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
65 match = regex.match(line)
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
66 assert match
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
67 _regex, name = match.groups()
82aad57c7d1d add regex mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 5
diff changeset
68 self.tbpl_regexs[name] = _regex
5
2d883dd59a1a stub tbpl_mapping
Jeff Hammel <jhammel@mozilla.com>
parents: 3
diff changeset
69
10
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
70 def setup_buildbot(self):
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
71 # project_branches = require.require(self.project_branches)
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
72 module = require.require(self.buildbot_config)
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
73 self.suites = module.SUITES
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
74
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
75 ### functions for fetching information
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
76
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
77 def tbpl_name(self, name):
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
78 """returns the TBPL long name"""
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
79 for tbplname, regex in self.tbpl_regexs.items():
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
80 regex = re.compile(regex)
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
81 if regex.match(name):
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
82 return tbplname
1029ddf7b806 get the buildbot config
Jeff Hammel <jhammel@mozilla.com>
parents: 6
diff changeset
83
3
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
84 def __call__(self, name=None):
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
85 retval = []
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
86 for short_name, graphserver_name in self.names.items():
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
87 if (name is None) or (name == short_name or short_name.startswith(name + '_')):
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
88 retval.append((short_name, graphserver_name))
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
89 retval.sort(key=lambda x: x[0])
90e477181404 now basically works
Jeff Hammel <jhammel@mozilla.com>
parents: 2
diff changeset
90 return retval