public function restIndexScaffold()
 {
     $adapter = Api::_()->getDbAdapter();
     $metadata = new Metadata($adapter);
     $tables = $metadata->getTableNames();
     return array('tables' => $tables);
 }
Beispiel #2
0
 public function restGetItem()
 {
     $query = $this->getRequest()->getQuery();
     $tab = $this->getEvent()->getRouteMatch()->getParam('id');
     $adapter = Api::_()->getDbAdapter();
     $metadata = new Metadata($adapter);
     $columns = $metadata->getColumns($tab);
     $props = array('name', 'ordinal_position', 'column_default', 'is_nullable', 'data_type', 'character_maximum_length', 'character_octet_length', 'numeric_precision', 'numeric_scale', 'numeric_unsigned', 'erratas', 'column_type');
     foreach ($columns as $column) {
         $columnName = $column->getName();
         foreach ($props as $prop) {
             $res[$columnName][$prop] = $column->{'get' . str_replace('_', '', $prop)}();
         }
     }
     return array('columns' => $res, 'table' => $tab);
 }
 public function check($elementName)
 {
     if ($this->columns) {
         $res = $this->columns;
     } else {
         $tabs = array("eva_user_users", "eva_user_profiles");
         $adapter = Api::_()->getDbAdapter();
         $metadata = new Metadata($adapter);
         foreach ($tabs as $tab) {
             $columns = $metadata->getColumns($tab);
             foreach ($columns as $column) {
                 $columnName = $column->getName();
                 $res[$columnName] = $columnName;
             }
         }
         $this->columns = $res;
     }
     return empty($res[$elementName]) ? false : true;
 }