Revert "set cascade_update => 0 on might_have relationships"

[dbsrgits/DBIx-Class-Schema-Loader.git] / t / lib / make_dbictest_db_with_unique.pm

diff --git a/t/lib/make_dbictest_db_with_unique.pm b/t/lib/make_dbictest_db_with_unique.pm
index 87c7316..a0b47bf 100644 (file)
--- a/t/lib/make_dbictest_db_with_unique.pm
+++ b/t/lib/make_dbictest_db_with_unique.pm
@@ -3,15 +3,18 @@ package make_dbictest_db_with_unique;
 use strict;
 use warnings;
 use DBI;
+use dbixcsl_test_dir qw/$tdir/;
+
 
 eval { require DBD::SQLite };
 my $class = $@ ? 'SQLite2' : 'SQLite';
 
-my $fn = './t/dbictest_with_unique.db';
+my $fn = "$tdir/dbictest_with_unique.db";
 
 unlink($fn);
 our $dsn = "dbi:$class:dbname=$fn";
 my $dbh = DBI->connect($dsn);
+$dbh->do('PRAGMA SYNCHRONOUS = OFF');
 
 $dbh->do($_) for (
     q|CREATE TABLE foos (
@@ -36,6 +39,11 @@ $dbh->do($_) for (
         id INTEGER PRIMARY KEY,
         quuxs_id INTEGER REFERENCES quuxs (quuxid)
       )|,
+    q|CREATE TABLE RouteChange (
+        id INTEGER PRIMARY KEY,
+        QuuxsId INTEGER REFERENCES quuxs (quuxid),
+        Foo2Bar INTEGER
+      )|,
     q|CREATE TABLE email (
         id INTEGER PRIMARY KEY,
         to_id INTEGER REFERENCES foos (fooid),
@@ -54,6 +62,7 @@ $dbh->do($_) for (
     q|INSERT INTO quuxs VALUES (1,20)|,
     q|INSERT INTO quuxs VALUES (2,19)|,
     q|INSERT INTO stations_visited VALUES (1,1)|,
+    q|INSERT INTO RouteChange VALUES (1,1,3)|,
 );
 
 END { unlink($fn); }