def test_carbonDVRDatabase_insertRawVideoLocation(self):
self.insertShow('show', 'EP', 'foo')
self.insertEpisode('show', 'episode', 'foo', 'foo')
self.insertRecording(1, 'show', 'episode', '1970-01-01',
timedelta(minutes=30), 'R')
db = CarbonDVRDatabase(self.dbConnection)
rowsInserted = db.insertRawVideoLocation(recordingID='1', filename='1')
def test_carbonDVRDatabase_insertRecording(self):
self.insertShow('show', 'EP', 'foo')
self.insertEpisode('show', 'episode', 'foo', 'foo')
db = CarbonDVRDatabase(self.dbConnection)
rowsInserted = db.insertRecording(recordingID='1',
showID='show',
episodeID='episode',
duration='1',
rerunCode='R')
def test_carbonDVRDatabase_getTuners(self):
self.assertEqual(1, self.insertTuner('foo','192.168.1.1',1))
self.assertEqual(1, self.insertTuner('baz','10.10.10.1',0))
db = CarbonDVRDatabase(self.dbConnection)
tuners = sorted(db.getTuners(), key=lambda tuner:tuner.deviceID)
self.assertEqual(2, len(tuners))
self.assertEqual('baz', tuners[0].deviceID)
self.assertEqual('10.10.10.1', tuners[0].ipAddress)
self.assertEqual(0, tuners[0].tunerID)
self.assertEqual('foo', tuners[1].deviceID)
self.assertEqual('192.168.1.1', tuners[1].ipAddress)
self.assertEqual(1, tuners[1].tunerID)
def test_carbonDVRDatabase_getTuners(self):
self.assertEqual(1, self.insertTuner('foo', '192.168.1.1', 1))
self.assertEqual(1, self.insertTuner('baz', '10.10.10.1', 0))
db = CarbonDVRDatabase(self.dbConnection)
tuners = sorted(db.getTuners(), key=lambda tuner: tuner.deviceID)
self.assertEqual(2, len(tuners))
self.assertEqual('baz', tuners[0].deviceID)
self.assertEqual('10.10.10.1', tuners[0].ipAddress)
self.assertEqual(0, tuners[0].tunerID)
self.assertEqual('foo', tuners[1].deviceID)
self.assertEqual('192.168.1.1', tuners[1].ipAddress)
self.assertEqual(1, tuners[1].tunerID)
def test_carbonDVRDatabase_getChannels(self):
self.assertEqual(1, self.insertChannel(4,1,5,1))
self.assertEqual(1, self.insertChannel(19,3,18,2))
self.assertEqual(1, self.insertChannel(5,2,37,3))
db = CarbonDVRDatabase(self.dbConnection)
channels = sorted(db.getChannels(), key=lambda channel:channel.channelMajor)
self.assertEqual(3, len(channels))
self.assertEqual(4, channels[0].channelMajor)
self.assertEqual(1, channels[0].channelMinor)
self.assertEqual(5, channels[0].channelActual)
self.assertEqual(1, channels[0].program)
self.assertEqual(5, channels[1].channelMajor)
self.assertEqual(2, channels[1].channelMinor)
self.assertEqual(37, channels[1].channelActual)
self.assertEqual(3, channels[1].program)
self.assertEqual(19, channels[2].channelMajor)
self.assertEqual(3, channels[2].channelMinor)
self.assertEqual(18, channels[2].channelActual)
self.assertEqual(2, channels[2].program)
def test_carbonDVRDatabase_getChannels(self):
self.assertEqual(1, self.insertChannel(4, 1, 5, 1))
self.assertEqual(1, self.insertChannel(19, 3, 18, 2))
self.assertEqual(1, self.insertChannel(5, 2, 37, 3))
db = CarbonDVRDatabase(self.dbConnection)
channels = sorted(db.getChannels(),
key=lambda channel: channel.channelMajor)
self.assertEqual(3, len(channels))
self.assertEqual(4, channels[0].channelMajor)
self.assertEqual(1, channels[0].channelMinor)
self.assertEqual(5, channels[0].channelActual)
self.assertEqual(1, channels[0].program)
self.assertEqual(5, channels[1].channelMajor)
self.assertEqual(2, channels[1].channelMinor)
self.assertEqual(37, channels[1].channelActual)
self.assertEqual(3, channels[1].program)
self.assertEqual(19, channels[2].channelMajor)
self.assertEqual(3, channels[2].channelMinor)
self.assertEqual(18, channels[2].channelActual)
self.assertEqual(2, channels[2].program)
def test_carbonDVRDatabase_insertRawVideoLocation(self):
self.insertShow('show','EP','foo')
self.insertEpisode('show','episode','foo','foo')
self.insertRecording(1,'show','episode', '1970-01-01', timedelta(minutes=30), 'R')
db = CarbonDVRDatabase(self.dbConnection)
rowsInserted = db.insertRawVideoLocation(recordingID='1',filename='1')
def test_carbonDVRDatabase_insertRecording(self):
self.insertShow('show','EP','foo')
self.insertEpisode('show','episode','foo','foo')
db = CarbonDVRDatabase(self.dbConnection)
rowsInserted = db.insertRecording(recordingID='1',showID='show', episodeID='episode',duration='1',rerunCode='R')
def test_carbonDVRDatabase_getPendingRecordings(self):
db = CarbonDVRDatabase(self.dbConnection)
pendingRecordings = db.getPendingRecordings(timedelta(hours=12))
def test_carbonDVRDatabase_getPendingRecordings(self):
db = CarbonDVRDatabase(self.dbConnection)
pendingRecordings = db.getPendingRecordings(timedelta(hours=12))