CDbException

391      * An empty array is returned if the query results in nothing.
392      * @throws CException execution failed
393      */
394     public function queryAll($fetchAssociative=true,$params=array())
395     {
396         return $this->queryInternal('fetchAll',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params);
397     }
398 
399     /**
400      * Executes the SQL statement and returns the first row of the result.
401      * This is a convenient method of {@link query} when only the first row of data is needed.

273     WHERE nspname=:schema))
274 EOD;
275         $command=$this->getDbConnection()->createCommand($sql);
276         $command->bindValue(':table',$table->name);
277         $command->bindValue(':schema',$table->schemaName);
278         foreach($command->queryAll() as $row)
279         {
280             if($row['contype']==='p') // primary key
281                 $this->findPrimaryKey($table,$row['indkey']);
282             elseif($row['contype']==='f') // foreign key
283                 $this->findForeignKey($table,$row['consrc']);

110     {
111         $table=new CPgsqlTableSchema;
112         $this->resolveTableNames($table,$name);
113         if(!$this->findColumns($table))
114             return null;
115         $this->findConstraints($table);
116 
117         if(is_string($table->primaryKey) && isset($this->_sequences[$table->rawName.'.'.$table->primaryKey]))
118             $table->sequenceName=$this->_sequences[$table->rawName.'.'.$table->primaryKey];
119         elseif(is_array($table->primaryKey))
120         {

091             {
092                 $key='yii:dbschema'.$this->_connection->connectionString.':'.$this->_connection->username.':'.$name;
093                 $table=$cache->get($key);
094                 if($refresh===true || $table===false)
095                 {
096                     $table=$this->loadTable($realName);
097                     if($table!==null)
098                         $cache->set($key,$table,$duration);
099                 }
100                 $this->_tables[$name]=$table;
101             }

127      * to the constructor of the application class.
128      * @return mixed the application instance
129      */
130     public static function createApplication($class,$config=null)
131     {
132         return new $class($config);
133     }
134 
135     /**
136      * Returns the application singleton or null if the singleton has not been created yet.
137      * @return CApplication the application singleton, null if the singleton has not been created yet.