function test_extractColumns()
{
$result = firstWord(' test test2 test3 ');
$expected = 'test';
$this->assertEqual($expected, $result);
$result = firstWord('test');
$this->assertEqual($expected, $result);
$result = $this->markkitQuery4->extractColumns();
$expected = 2;
$this->assertEqual($expected, count($result));
$expected = array(new Column('pageUrl'), new Column('text'));
$this->assertEqual($expected, $result);
}
function extractColumns()
{
eregi('create +table +[^(]+\\(([^)]+)', $this->code, $strings);
$columns = split(',', $strings[1]);
for ($i = 0; $i < count($columns); $i++) {
$c = new Column(firstWord($columns[$i]));
$columns[$i] = $c;
}
return $columns;
}