annotate talosnames/api.py @ 1:a10ae1ea8325

WIP
author Jeff Hammel <jhammel@mozilla.com>
date Sun, 08 Jul 2012 10:09:51 -0700
parents 3e1f069ac608
children c98f2a383595
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
1 import sqlite3
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
2 import urllib2
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
3
0
Jeff Hammel <jhammel@mozilla.com>
parents:
diff changeset
4 class TalosNames(object):
Jeff Hammel <jhammel@mozilla.com>
parents:
diff changeset
5 graphserver_sql = 'http://hg.mozilla.org/graphs/raw-file/tip/sql/data.sql'
1
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
6 schema = 'http://hg.mozilla.org/graphs/raw-file/tip/sql/schema.sql'
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
7
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
8 tables = ['os_list',
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
9 'branches',
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
10 'machines',
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
11 'pagesets',
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
12 'tests']
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
13
0
Jeff Hammel <jhammel@mozilla.com>
parents:
diff changeset
14 def __init__(self):
1
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
15 self.db = sqlite3.connect(':memory:')
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
16 for table in self.tables:
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
17 pass
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
18 schema = urllib2.urlopen(self.schema).read()
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
19 cursor = self.db.cursor()
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
20 cursor.executescript(schema)
Jeff Hammel <jhammel@mozilla.com>
parents: 0
diff changeset
21