def test_get_key_names_with_column_fn(self): wheres = [(self.emp.salary > 25000), self.dept] project = [self.emp.name, ip_ntoa(self.emp.salary), self.dept.building] pipe = SelectPipe('server', wheres=wheres, project=project) self.assertTupleEqual((None, None, None), tuple(second_items(pipe._get_key_names(project, ())[1]))) join = [self.dept.id, self.emp.department_id] pipe = SelectPipe('server', wheres=wheres, project=project, join=join) self.assertTupleEqual((None, None, None, None), tuple(second_items(pipe._get_key_names(project, join)[1])))
def test_get_key_names_with_column_fn(self): wheres = [(self.emp.salary > 25000), self.dept] project = [self.emp.name, ip_ntoa(self.emp.salary), self.dept.building] pipe = SelectPipe('server', wheres=wheres, project=project) self.assertTupleEqual( (None, None, None), tuple(second_items(pipe._get_key_names(project, ())[1]))) join = [self.dept.id, self.emp.department_id] pipe = SelectPipe('server', wheres=wheres, project=project, join=join) self.assertTupleEqual( (None, None, None, None), tuple(second_items(pipe._get_key_names(project, join)[1])))
def test_get_key_names(self): wheres = [(self.emp.salary > 25000), self.dept] project = [self.emp.name, self.emp.salary, self.dept.building] pipe = SelectPipe('server', wheres=wheres, project=project) self.assertTupleEqual(('name', 'salary', None), tuple(pipe._get_key_names(project, ())[0])) self.assertTupleEqual((None, None, 'building'), tuple(pipe._get_key_names(project, ())[1])) join = [self.dept.id, self.emp.department_id] pipe = SelectPipe('server', wheres=wheres, project=project, join=join) self.assertTupleEqual(('department_id', 'name', 'salary', None), tuple(pipe._get_key_names(project, join)[0])) self.assertTupleEqual(('id', None, None, 'building'), tuple(pipe._get_key_names(project, join)[1])) project = [self.dept.building, self.emp.name, self.emp.salary] pipe = SelectPipe('server', wheres=wheres, project=project, join=join) self.assertTupleEqual(('department_id', None, 'name', 'salary'), tuple(pipe._get_key_names(project, join)[0])) self.assertTupleEqual(('id', 'building', None, None), tuple(pipe._get_key_names(project, join)[1]))
def test_get_key_names(self): wheres = [(self.emp.salary > 25000), self.dept] project = [self.emp.name, self.emp.salary, self.dept.building] pipe = SelectPipe('server', wheres=wheres, project=project) self.assertTupleEqual( ('name', 'salary', None), tuple(first_items(pipe._get_key_names(project, ())[0]))) self.assertTupleEqual( (None, None, 'building'), tuple(first_items(pipe._get_key_names(project, ())[1]))) join = [self.dept.id, self.emp.department_id] pipe = SelectPipe('server', wheres=wheres, project=project, join=join) self.assertTupleEqual( ('department_id', 'name', 'salary', None), tuple(first_items(pipe._get_key_names(project, join)[0]))) self.assertTupleEqual( ('id', None, None, 'building'), tuple(first_items(pipe._get_key_names(project, join)[1]))) project = [self.dept.building, self.emp.name, self.emp.salary] pipe = SelectPipe('server', wheres=wheres, project=project, join=join) self.assertTupleEqual( ('department_id', None, 'name', 'salary'), tuple(first_items(pipe._get_key_names(project, join)[0]))) self.assertTupleEqual( ('id', 'building', None, None), tuple(first_items(pipe._get_key_names(project, join)[1])))