Airship\Engine\Database::cell PHP Метод

cell() публичный метод

Variadic version of $this->single()
public cell ( string $statement, $params ) : mixed
$statement string SQL query without user data
$params Parameters
Результат mixed
    public function cell(string $statement, ...$params)
    {
        return $this->single($statement, $params);
    }

Usage Example

Пример #1
0
 /**
  * We're storing metadata about a package in the database.
  *
  * @param TreeUpdate $update
  * @param int $treeUpdateID
  */
 protected function updatePackageQueue(TreeUpdate $update, int $treeUpdateID)
 {
     $packageId = $this->db->cell('SELECT
               packageid 
          FROM
               airship_package_cache
          WHERE 
              packagetype = ?
              AND supplier = ?
              AND name = ? 
         ', $update->getPackageType(), $update->getSupplierName(), $update->getPackageName());
     if (empty($packageId)) {
         $packageId = $this->db->insertGet('airship_package_cache', ['packagetype' => $update->getPackageType(), 'supplier' => $update->getSupplierName(), 'name' => $update->getPackageName()], 'packageid');
     }
     $data = $update->getNodeData();
     $this->db->insert('airship_package_versions', ['package' => $packageId, 'version' => $data['version'], 'checksum' => $data['checksum'], 'commithash' => $data['commit'] ?? null, 'date_released' => $data['date_released'], 'treeupdateid' => $treeUpdateID]);
 }