예제 #1
0
 public function testColumn()
 {
     $query = new Query();
     $query->from('yiitest', 'user');
     $result = $query->orderBy(['name' => SORT_ASC])->column('name', $this->getConnection());
     $this->assertEquals(['user1', 'user2', 'user3', 'user4'], $result);
     $result = $query->column('noname', $this->getConnection());
     $this->assertEquals([null, null, null, null], $result);
     $result = $query->where(['name' => 'user5'])->scalar('name', $this->getConnection());
     $this->assertNull($result);
 }