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);
}
}
