| mbligh | d5c33db | 2006-10-08 21:34:16 +0000 | [diff] [blame] | 1 | import sqlite |
| 2 | |
| 3 | class db: |
| 4 | def __init__(self): |
| 5 | self.con = sqlite.connect('tko_db') |
| 6 | self.cur = self.con.cursor() |
| 7 | |
| 8 | |
| 9 | def select(self, cmd): |
| mbligh | 056d0d3 | 2006-10-08 22:31:10 +0000 | [diff] [blame^] | 10 | print 'select ' + cmd |
| mbligh | d5c33db | 2006-10-08 21:34:16 +0000 | [diff] [blame] | 11 | self.cur.execute('select ' + cmd) |
| 12 | return self.cur.fetchall() |
| 13 | |
| mbligh | 056d0d3 | 2006-10-08 22:31:10 +0000 | [diff] [blame^] | 14 | |
| 15 | def insert_job(self, tag, job): |
| 16 | command = 'insert into jobs ' + \ |
| 17 | '(job, version, status, reason, machine, kernel) ' +\ |
| 18 | 'values (%s, %s, %s, %s, %s, %s) ' |
| 19 | values = (tag, job.kernel, job.status_num, job.reason, \ |
| 20 | job.machine, job.kernel) |
| 21 | self.cur.execute(command, values) |
| 22 | self.con.commit(); |
| 23 | |
| 24 | |
| 25 | def find_job(self, tag): |
| 26 | command = 'select * from jobs where job = %s' |
| 27 | self.cur.execute(command, tag) |
| 28 | return self.cur.fetchall() |