/** * @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); }