def isFirstId_tableAddedFirstItemRemoved_returnsFalse(self):
DataGenerator.createGarbage(self._connectionPool)
container = self.SQLContainer(TableQuery('garbage', self._connectionPool, AllTests.sqlGen))
first = container.addItem()
container.addItem()
Assert.assertSame(first, container.firstItemId())
Assert.assertTrue(container.removeItem(first))
Assert.assertFalse(container.isFirstId(first))
def firstItemId_tableNewlyAddedFirstItemRemoved_resultChanges(self):
DataGenerator.createGarbage(self._connectionPool)
container = self.SQLContainer(TableQuery('garbage', self._connectionPool, AllTests.sqlGen))
first = container.addItem()
second = container.addItem()
Assert.assertSame(first, container.firstItemId())
Assert.assertTrue(container.removeItem(first))
Assert.assertSame(second, container.firstItemId())
def getCount_delegateRegisteredZeroRows_returnsZero(self):
DataGenerator.createGarbage(self._connectionPool)
query = FreeformQuery('SELECT * FROM GARBAGE', Arrays.asList('ID'), self._connectionPool)
delegate = EasyMock.createMock(FreeformQueryDelegate)
EasyMock.expect(delegate.getCountQuery()).andReturn('SELECT COUNT(*) FROM GARBAGE')
EasyMock.replay(delegate)
query.setDelegate(delegate)
Assert.assertEquals(0, query.getCount())
EasyMock.verify(delegate)
def isFirstId_tableEmptyResultSet_returnsFirstAddedItem(self):
DataGenerator.createGarbage(self._connectionPool)
container = self.SQLContainer(TableQuery('garbage', self._connectionPool, AllTests.sqlGen))
id = container.addItem()
Assert.assertTrue(container.isFirstId(id))
