public function onSetUp() { // mysql from version 5.5.7 does not like to truncate tables with foreign key references: http://bugs.mysql.com/bug.php?id=58788 $this->getConnection()->getConnection()->exec('SET foreign_key_checks = 0'); parent::onSetUp(); $this->getConnection()->getConnection()->exec('SET foreign_key_checks = 1'); }
public function onSetUp() { parent::onSetUp(); $pdo = $this->getConnection()->getConnection(); // update next serial/autoincrement value to max foreach ($pdo->query("SELECT table_name, column_name FROM information_schema.columns WHERE column_default LIKE 'nextval%';")->fetchAll(\PDO::FETCH_ASSOC) as $info) { $query = "SELECT setval((SELECT pg_get_serial_sequence('" . $info['table_name'] . "', '" . $info['column_name'] . "') as sequence), (SELECT max(" . $info['column_name'] . ") FROM " . $info['table_name'] . "));"; $pdo->query($query); } }