我需要自动生成id序列。
我正在使用jenssegers
.
我从这里开始UseAutoIncrementID trait
。
并将其用作:
use AppTraitsUseAutoIncrementID;
....
....
$data['_id'] = $this->getID('request_feeds'); // request_feeds is collection name.
我收到此错误:
(1/1) FatalThrowableError
Call to undefined method IlluminateDatabaseMySqlConnection::getCollection()
如何使用jenssegers
获取自动生成的 id 序列?
- 在您的模型中,添加以下方法:
public function nextid()
{
// ref is the counter - change it to whatever you want to increment
$this->ref = self::getID();
}
public static function bootUseAutoIncrementID()
{
static::creating(function ($model) {
$model->sequencial_id = self::getID($model->getTable());
});
}
public function getCasts()
{
return $this->casts;
}
private static function getID()
{
$seq = DB::connection('mongodb')->getCollection('counters')->findOneAndUpdate(
['ref' => 'ref'],
['$inc' => ['seq' => 1]],
['new' => true, 'upsert' => true, 'returnDocument' => FindOneAndUpdate::RETURN_DOCUMENT_AFTER]
);
return $seq->seq;
}
- 在控制器中,创建一个新集合并使用 nextid(( 方法 - 示例:
$car = new Car();
$car->nextid(); // auto-increment
$car->name = "Ferrari",
$car->save();