/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('page_versions', function (Blueprint $table) {
$table->string(PageVersion::ATTR_CHUNK_TYPE, 15);
$table->integer(PageVersion::ATTR_CHUNK_ID)->unsigned();
});
$versions = PageVersion::where(PageVersion::ATTR_EMBARGOED_UNTIL, null)->get();
$types = ['text', 'feature', 'asset', 'slideshow', 'linkset', 'link', 'location', 'timestamp', 'html', 'calendar', 'library'];
foreach ($versions as $version) {
foreach ($types as $type) {
$className = 'BoomCMS\\Database\\Models\\Chunk\\' . ucfirst($type);
$count = (new $className())->where('page_vid', $version->getId())->count();
if ($count === 1) {
$chunk = (new $className())->where('page_vid', $version->getId())->first();
$version->{PageVersion::ATTR_CHUNK_TYPE} = $type;
$version->{PageVersion::ATTR_CHUNK_ID} = $chunk->id;
$version->save();
break;
}
}
}
}
/**
* Find a version by page and version ID.
*
* @param PageModelInterface $page
* @param type $versionId
*
* @return Model
*/
public function find(PageModelInterface $page, $versionId)
{
return $this->model->where(Model::ATTR_PAGE, $page->getId())->where(Model::ATTR_ID, $versionId)->first();
}
