/**
* @test
* it should scaffold new blog tables
*/
public function it_should_scaffold_new_blog_tables(FunctionalTester $I)
{
$I->haveMultisiteInDatabase();
$id = $I->haveBlogInDatabase('test');
$I->useBlog($id);
foreach (Tables::newBlogTables() as $table) {
$I->seeTableInDatabase($I->grabPrefixedTableNameFor($table));
}
}
private function scaffoldBlogTables($blogId, $subdomain = null)
{
$stylesheet = $this->grabOptionFromDatabase('stylesheet');
$data = ['subdomain' => $subdomain, 'domain' => $this->getSiteDomain(), 'subfolder' => $this->getSiteSubfolder(), 'stylesheet' => $stylesheet];
$dbh = $this->driver->getDbh();
$dropQuery = $this->tables->getBlogDropQuery($this->config['tablePrefix'], $blogId);
$sth = $dbh->prepare($dropQuery);
$this->debugSection('Query', $sth->queryString);
$sth->execute();
$scaffoldQuery = $this->tables->getBlogScaffoldQuery($this->config['tablePrefix'], $blogId, $data);
$sth = $dbh->prepare($scaffoldQuery);
$this->debugSection('Query', $sth->queryString);
$sth->execute();
$this->scaffoldedBlogIds[] = $blogId;
}
