Mercurial > mozilla > hg > talosnames

comparison talosnames/api.py @ 2:c98f2a383595

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
make some tables
author Jeff Hammel <jhammel@mozilla.com>
date Sun, 08 Jul 2012 13:53:06 -0700
parents a10ae1ea8325
children 90e477181404
comparison
equal deleted inserted replaced
1:a10ae1ea8325 2:c98f2a383595
3 3
4 class TalosNames(object): 4 class TalosNames(object):
5 graphserver_sql = 'http://hg.mozilla.org/graphs/raw-file/tip/sql/data.sql' 5 graphserver_sql = 'http://hg.mozilla.org/graphs/raw-file/tip/sql/data.sql'
6 schema = 'http://hg.mozilla.org/graphs/raw-file/tip/sql/schema.sql' 6 schema = 'http://hg.mozilla.org/graphs/raw-file/tip/sql/schema.sql'
7 7
8 tables = ['os_list', 8 tables = {'os_list': '(id, name text)',
9 'branches', 9 'branches': '(id, name text)'
10 'machines', 10 'machines': '(id, os_id int, is_throttling int, cpu_speed text, name text, is_active int, date_added int)',
11 'pagesets', 11 'pagesets': '(id, name text)',
12 'tests'] 12 'tests': '(id, name text, pretty_name text, is_chrome int, is_active int, pageset_id int)'
13 }
13 14
14 def __init__(self): 15 def __init__(self):
15 self.db = sqlite3.connect(':memory:') 16 self.db = sqlite3.connect(':memory:')
16 for table in self.tables: 17 data = urllib2.urlopen(self.graphserver_sql).read()
17 pass
18 schema = urllib2.urlopen(self.schema).read()
19 cursor = self.db.cursor() 18 cursor = self.db.cursor()
20 cursor.executescript(schema) 19 for table, schema in self.tables.items():
20 cursor.execute("""CREATE TABLE %s %s""" % (table, schema))
21 self.db.commit()
22 cursor.close()
21 23