Beispiel #1
0
 /**
  * Analyze the given query, producing a semantic representation of the most important elements
  * as well as related schema information.
  * 
  * @param \DataBundle\Connection $connection
  * @param type $db
  * @param type $query
  * @return QueryAnalysis
  */
 public function analyzeQuery(Connection $connection, $db, $query)
 {
     $driver = $this->drivers->getDriver($connection->getType());
     $analysis = $driver->analyzeQuery($query);
     $model = new QueryAnalysis();
     $model->setValid($analysis->valid);
     if (!$analysis->valid) {
         return $model;
     }
     $selection = array();
     if (isset($analysis->selection)) {
         foreach ($analysis->selection as $select) {
             $selection[] = new QuerySelection($select->column, $select->alias);
         }
     }
     $model->setSelection($selection);
     // Fetch the schemas
     $froms = array();
     if (isset($analysis->from)) {
         foreach ($analysis->from as $source) {
             $from = new QuerySource();
             $from->setName($source->name);
             $from->setColumns($this->schema->getTableSchema($connection, $db, $source->name));
             $froms[] = $from;
         }
     }
     $model->setFrom($froms);
     return $model;
 }
Beispiel #2
0
 /**
  * Establish a new database connection
  * 
  * @param string $type
  * @param string $hostname
  * @param int $port
  * @param string $username
  * @param string $password
  * @param string $key
  * 
  * @return Connection
  */
 public function establishConnection($type, $hostname, $port, $username, $password, &$key)
 {
     $key = NULL;
     $connection = Connection::create($type, $hostname, $port, $username, $password, $key);
     $driver = $this->drivers->getDriver($type);
     // Test the connection
     if (!$driver->testConnection($connection)) {
         return null;
     }
     // Success, build and store the connection
     $store = $this->getStore();
     $store->add($connection);
     // Lock (encrypt) the credentials and return the private key
     $connection->lock();
     return $connection;
 }
Beispiel #3
0
 /**
  * Retrieve a set of Columns representing the schema of the given table.
  * 
  * @param \DataBundle\Connection $connection
  * @param string $db
  * @param string $tableName
  * @return Column[]
  */
 public function getTableSchema(Connection $connection, $db, $tableName)
 {
     $driver = $this->drivers->getDriver($connection->getType());
     $columns = array();
     foreach ($driver->getSchema($connection, $db, $tableName) as $column) {
         $columnModel = $this->modelForColumn($column);
         $columns[] = $columnModel;
     }
     return $columns;
 }
Beispiel #4
0
 public function getSchema(Connection $connection, $db, $table)
 {
     if (isset($schemaCache["{$connection->getId()}:{$db}:{$table}"])) {
         return $schemaCache["{$connection->getId()}:{$db}:{$table}"];
     }
     $rows = $this->rawQuery($connection, $db, 'SHOW FULL COLUMNS FROM ' . $this->quoteSchema($table));
     $columns = array();
     foreach ($rows as $row) {
         $row = (array) $row;
         $description = (object) array('name' => $row['Field'], 'type' => $row['Type'], 'nullable' => $row['Null'] == 'YES', 'default' => $row['Default'], 'encoding' => $row['Collation'], 'comment' => $row['Comment'], 'isPrimary' => $row['Key'] == 'PRI', 'isIndexed' => $row['Key'] ? true : false, 'auto' => strpos($row['Extra'], 'auto_increment'));
         $columns[] = $description;
     }
     return $schemaCache["{$connection->getId()}:{$db}:{$table}"] = $columns;
 }