def getAllTroveInfo(self, troveInfoTag):
        cu = self.db.cursor()
        cu.execute("""
            SELECT troveName, version, timeStamps, flavor, data FROM TroveInfo
                JOIN Instances USING (instanceId)
                JOIN Flavors USING (flavorId)
                JOIN Versions ON Instances.versionId = Versions.versionId
                WHERE infoType = ?
        """, troveInfoTag)

        versionCache = VersionCache()
        flavorCache = FlavorCache()
        return [ (
                TroveTuple(name=x[0],
                    version=versionCache.get(x[1], x[2]),
                    flavor=flavorCache.get(x[3])),
                x[4]) for x in cu ]