PHP Connection::lastInsertId方法代码示例

 public function testLastInsertId()
 {
     $this->createTable();
     $this->connection->query("INSERT INTO cat (name, colour) VALUES (?, ?)", array('Nennek', 'black'));
     $this->assertEquals(3, $this->connection->lastInsertId('cat'));
     $this->assertEquals(3, $this->connection->lastInsertId());
     $this->connection->query("INSERT INTO cat (name, colour) VALUES (?, ?)", array('Misia', 'white-black-gray stripes'));
     $this->assertEquals(4, $this->connection->lastInsertId());
 }

 /**
  * @param Model $model
  * @return Model|null
  * @throws Exception
  */
 public function replace(Model $model)
 {
     $rtn = null;
     $data = $model->toArray();
     $modified = $model->getModified();
     $cols = [];
     $values = [];
     $params = [];
     foreach ($modified as $key) {
         $cols[] = $key;
         $values[] = ':' . $key;
         $params[':' . $key] = $data[$key];
     }
     if (count($cols)) {
         $cols = '`' . implode('`, `', $cols) . '`';
         $vals = implode(', ', $values);
         $query = "REPLACE INTO `{$this->table}` ({$cols}) VALUES ({$vals});";
         $stmt = $this->connection->prepare($query);
         if ($stmt->execute($params)) {
             $modelId = !empty($data[$this->key]) ? $data[$this->key] : $this->connection->lastInsertId();
             $this->cacheSet($data[$this->key], null);
             $rtn = $this->getByPrimaryKey($modelId, 'write');
             $this->cacheSet($modelId, $rtn);
         }
     }
     return $rtn;
 }

 public static function insert($attributes)
 {
     $sql = 'INSERT INTO ' . static::table();
     $sql .= ' (' . implode(',', array_keys($attributes)) . ') VALUES (';
     $sql .= implode(',', array_fill(0, count($attributes), '?')) . ')';
     $statement = Connection::prepare($sql);
     $statement->execute(array_values($attributes));
     $id = Connection::lastInsertId();
     $attributes['id'] = $id;
     $cls = static::className();
     $model = new $cls();
     $model->setAttributes($attributes);
     return $model;
 }

 public function save()
 {
     $db = new Connection();
     $table = strtolower(get_class($this));
     $prefixe = substr($table, 0, 3) . "_";
     $props = get_object_vars($this);
     unset($props["id"]);
     foreach ($props as $prop => $value) {
         $column[] = $prefixe . $prop;
         $prop = ":" . $prop;
         $params[] = $prop;
     }
     $query = "INSERT INTO " . $table . "(" . implode(',', $column) . ") VALUES(" . implode(',', $params) . ")";
     $request = $db->prepare($query);
     $request->execute($props);
     $id = $db->lastInsertId();
     $db = null;
     return $id;
 }

 /**
  * Inserts row in a table.
  * @param  mixed array($column => $value)|Traversable for single row insert or Selection|string for INSERT ... SELECT
  * @return TableRow or FALSE in case of an error or number of affected rows for INSERT ... SELECT
  */
 public function insert($data)
 {
     if ($data instanceof TableSelection) {
         $data = $data->getSql();
     } elseif ($data instanceof Traversable) {
         $data = iterator_to_array($data);
     }
     $return = $this->connection->query($this->sqlBuilder->buildInsertQuery(), $data);
     $this->checkReferenced = TRUE;
     if (!is_array($data)) {
         return $return->rowCount();
     }
     if (!isset($data[$this->primary]) && ($id = $this->connection->lastInsertId($this->getPrimarySequence()))) {
         $data[$this->primary] = $id;
         return $this->rows[$id] = $this->createRow($data);
     } else {
         return $this->createRow($data);
     }
 }

	/**
	 * Save row to table "$table". $params is a map of values. Key is a table field name. Value is a value.
	 * When id = 0 row is inserted. When id <> 0 then row is updated.
	 * Primary key should'n be inside $params array.
	 * @param $table
	 * @param array $params
	 * @param int $id
	 * @param string $idColumn
	 * @return int
	 */
	public function save($table, array $params, $id = 0, $idColumn = 'id') {
		if (!is_string($table) || !strlen($table)) {
			throw new \InvalidArgumentException("Table name must be a string with length greather than 1.");
		}
		// if array is assoc
		if (!is_array($params) || 0 === count(array_diff_key($params, array_keys(array_keys($params))))) {
			throw new \InvalidArgumentException('Second parameter must be an associative array!');
		}
		$query = '';
		if ($id) {
			$query = $this->strategy->update($table, $params, $idColumn);
			$params[] = $id;
			$this->connection->query($query, $params);
			return $id;
		}
		else {
			$query = $this->strategy->insert($table, $params);
			$this->connection->query($query, $params);
			return $this->connection->lastInsertId($table, $idColumn);
		}
	}