def test_delete(self):
db = DB('sqlite://')
db.create_schema()
job = Job(change_num="change_num", project_name="project")
with db.get_session() as session:
session.add(job)
job.db = db
jobs = Job.getAllWhere(db)
self.assertEqual(len(jobs), 1)
Job.deleteWhere(db)
jobs = Job.getAllWhere(db)
self.assertEqual(len(jobs), 0)
def test_delete(self):
db = DB('sqlite://')
db.create_schema()
job = Job(change_num="change_num", project_name="project")
with db.get_session() as session:
session.add(job)
job.db = db
jobs = Job.getAllWhere(db)
self.assertEqual(len(jobs), 1)
Job.deleteWhere(db)
jobs = Job.getAllWhere(db)
self.assertEqual(len(jobs), 0)
def test_recent_jobs(self, now):
now.return_value = NOW
db = DB('sqlite://')
db.create_schema()
job1 = Job(change_num="change_num1", project_name="project")
job2 = Job(change_num="change_num2", project_name="project")
with db.get_session() as session:
session.add(job1)
job1.created=PAST
job1.db = db
job1.state=constants.RUNNING
job1.updated=PAST
session.add(job2)
recent_jobs = Job.getRecent(db)
self.assertEqual(len(recent_jobs), 1)
recent_jobs = Job.getRecent(db, 200000)
self.assertEqual(len(recent_jobs), 2)
def test_recent_jobs(self, now):
now.return_value = NOW
db = DB('sqlite://')
db.create_schema()
job1 = Job(change_num="change_num1", project_name="project")
job2 = Job(change_num="change_num2", project_name="project")
with db.get_session() as session:
session.add(job1)
job1.created=PAST
job1.db = db
job1.state=constants.RUNNING
job1.updated=PAST
session.add(job2)
recent_jobs = Job.getRecent(db)
self.assertEqual(len(recent_jobs), 1)
recent_jobs = Job.getRecent(db, 200000)
self.assertEqual(len(recent_jobs), 2)
def test_start_test_clears_time(self, now):
now.return_value = NOW
db = DB('sqlite://')
db.create_schema()
job = Job(change_num="change_num", project_name="project")
with db.get_session() as session:
session.add(job)
job.created=PAST
job.db = db
job.update(db, state=constants.RUNNING)
with db.get_session() as session:
job, = session.query(Job).all()
self.assertEquals(job.updated, NOW)
self.assertEquals(job.state, constants.RUNNING)
self.assertEquals(job.test_started, NOW)
self.assertEquals(job.test_stopped, None)
self.assertEquals("project", job.project_name)
self.assertEquals("change_num", job.change_num)
def test_start_test_clears_time(self, now):
now.return_value = NOW
db = DB('sqlite://')
db.create_schema()
job = Job(change_num="change_num", project_name="project")
with db.get_session() as session:
session.add(job)
job.created=PAST
job.db = db
job.update(db, state=constants.RUNNING)
with db.get_session() as session:
job, = session.query(Job).all()
self.assertEquals(job.updated, NOW)
self.assertEquals(job.state, constants.RUNNING)
self.assertEquals(job.test_started, NOW)
self.assertEquals(job.test_stopped, None)
self.assertEquals("project", job.project_name)
self.assertEquals("change_num", job.change_num)
def test_update(self, now):
now.return_value = NOW
db = DB('sqlite://')
db.create_schema()
job = Job(change_num="change_num", project_name="project")
with db.get_session() as session:
session.add(job)
job.created=PAST
job.db = db
self.assertEqual(job.state, constants.QUEUED)
job.update(db, state=constants.FINISHED)
with db.get_session() as session:
job, = session.query(Job).all()
self.assertEquals(NOW, job.updated)
self.assertEquals(constants.FINISHED, job.state)
self.assertEquals("project", job.project_name)
self.assertEquals("change_num", job.change_num)
def test_update(self, now):
now.return_value = NOW
db = DB('sqlite://')
db.create_schema()
job = Job(change_num="change_num", project_name="project")
with db.get_session() as session:
session.add(job)
job.created=PAST
job.db = db
self.assertEqual(job.state, constants.QUEUED)
job.update(db, state=constants.FINISHED)
with db.get_session() as session:
job, = session.query(Job).all()
self.assertEquals(NOW, job.updated)
self.assertEquals(constants.FINISHED, job.state)
self.assertEquals("project", job.project_name)
self.assertEquals("change_num", job.change_num)
