Example #1
0
 /**
  * Test table structure
  */
 public function testTable()
 {
     $table = new Table();
     $column = new Property('dummy');
     $table->addColumn($column);
     $row = new TableRow($table);
     $expected = 'value';
     $row->addData($column, $expected);
     $result = $row->getData($column);
     $this->assertEquals($expected, $result);
     $expected = array(array('dummy' => $expected));
     $table->addRow($row);
     $this->assertEquals($table->toArray(), $expected);
     $expected = array('dummy' => $column);
     $result = $table->getColumns();
     $this->assertEquals($expected, $result);
     $expected = TRUE;
     $result = $table->columnExists($column);
     $this->assertEquals($expected, $result);
     $expected = array(array('dummy' => 'value'));
     $table->reset();
     $column = new Property('dummy');
     $table->addColumn($column);
     $table->importArray($expected);
     $result = $table->toArray();
     $this->assertEquals($expected, $result);
     $expected = "dummy\nvalue\n";
     $result = $table->toCSV();
     $this->assertEquals($expected, $result);
     $expected = array(array());
     $table->removeColumn('dummy');
     $result = $table->toArray();
     $this->assertEquals($expected, $result);
 }
Example #2
0
 /**
  * Gets all table properties
  * 
  * @param boolean $cache The cached information
  * 
  * @return array Returns all columns
  */
 public function getColumns($cache = true)
 {
     if (!$cache) {
         $this->columns->reset();
         $result = $this->database->getPDO()->query($this->database->getColumns($this));
         while ($item = $result->fetch(\PDO::FETCH_ASSOC)) {
             $property = new Property($item['name']);
             $this->addColumn($property);
         }
     }
     return parent::getColumns();
 }