/** @test */ public function it_will_create_sequence() { $connection = $this->getConnection(); $sequence = new Sequence($connection); $connection->shouldReceive('statement')->andReturn(true); $success = $sequence->create('users_id_seq'); $this->assertEquals(true, $success); }
/** * drop sequence and triggers if exists, autoincrement objects * * @param string $table * @return null */ public function dropAutoIncrementObjects($table) { // drop sequence and trigger object $prefix = $this->connection->getTablePrefix(); // get the actual primary column name from table $col = $this->getPrimaryKey($prefix . $table); // if primary key col is set, drop auto increment objects if (isset($col) and !empty($col)) { // drop sequence for auto increment $sequenceName = $this->createObjectName($prefix, $table, $col, 'seq'); $this->sequence->drop($sequenceName); // drop trigger for auto increment work around $triggerName = $this->createObjectName($prefix, $table, $col, 'trg'); $this->trigger->drop($triggerName); } }