/**
* @param YoPdo $yo_pdo
* @return void
*/
protected function transactionalDown(YoPdo $yo_pdo)
{
$sql = <<<SQL
ALTER TABLE buffered_jobs
DROP COLUMN mutex_id;
ALTER TABLE queued_jobs
DROP COLUMN mutex_id;
ALTER TABLE successful_jobs
DROP COLUMN mutex_id;
ALTER TABLE failed_jobs
DROP COLUMN mutex_id;
SQL;
$yo_pdo->queryMultiple($sql);
}
/**
* @param YoPdo $yo_pdo
* @return string
*/
public function createTable(YoPdo $yo_pdo)
{
$table_name = 'test_' . uniqid();
$sql = <<<SQL
CREATE SEQUENCE {$table_name}_id_seq;
CREATE TABLE {$table_name} (
id INT NOT NULL PRIMARY KEY DEFAULT NEXTVAL('{$table_name}_id_seq'::regclass),
a INT NOT NULL,
b INT NOT NULL,
c INT
);
SQL;
$yo_pdo->queryMultiple($sql);
return $table_name;
}
/**
* @return fluent
*/
public function createSchema()
{
$sql = <<<SQL
CREATE SCHEMA migrations;
CREATE TABLE migrations.migrations
(
version VARCHAR PRIMARY KEY,
migrated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
migration_hash VARCHAR NOT NULL
);
CREATE TABLE migrations.rollbacks
(
version VARCHAR NOT NULL,
migrated_at TIMESTAMP WITH TIME ZONE NOT NULL,
migration_hash VARCHAR NOT NULL,
rolled_back_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
rollback_hash VARCHAR NOT NULL
);
SQL;
$this->yo_pdo->queryMultiple($sql);
return $this;
}
/**
* @param YoPdo $yo_pdo
* @return void
*/
protected function transactionalDown(YoPdo $yo_pdo)
{
$sql = <<<SQL
DROP TABLE buffered_jobs;
DROP TABLE queued_jobs;
DROP TABLE successful_jobs;
DROP TABLE failed_jobs;
SQL;
$yo_pdo->queryMultiple($sql);
}
