Exemple #1
0
 /**
  * Configures database definitions.
  *
  * @param string|array $config Either a path to the JSON encoded
  *      configuration file, or the configuration as an array.
  */
 public static function configure($config)
 {
     DB::disconnectAll();
     Config::load($config);
 }
Exemple #2
0
 /**
  * Prepares, then executes a statement and returns the number of affected
  * rows.
  *
  * The method is useful for updates or deletes, which do
  * not return anything.
  *
  * @param string $query The SQL query to execute.
  * @param array $arguments The arguments used to substitute params.
  * @return integer Number of rows affected by the query.
  */
 public function preparedExecute($query, $arguments = array())
 {
     DB::getConnection($this->name);
     // Handles transactions
     Event::emit(Event::QUERY_STARTED, array($query, $arguments, $this));
     $stmt = $this->pdoPrepare($query, $arguments);
     $this->pdoExecute($query, $arguments, $stmt);
     Event::emit(Event::QUERY_COMPLETED, array($query, $arguments, $this, null));
     return $stmt->rowCount();
 }
Exemple #3
0
 /** Performs a prepared query and returns only a single column. */
 private function singleColumnQuery($query, $args, $column)
 {
     $conn = DB::getConnection($this->meta->database);
     $pdo = $conn->getPDO();
     $stmt = $pdo->prepare($query);
     $stmt->execute($args);
     $data = array();
     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
         $data[] = $row[$column];
     }
     return $data;
 }