);
}
-ok(-e $sqlt_diff, 'Found sqlt-diff script');
+ok(-e $sqlt_diff, 'Found sqlt-diff script');
my @cmd = ($^X, $sqlt_diff, "$create1=SQLite", "$create2=SQLite");
my $out = `@cmd`;
like($out, qr/-- Target database SQLite is untested/, "Detected 'untested' comment");
like($out, qr/ALTER TABLE person CHANGE iq/, "Detected altered 'iq' field");
-like($out, qr/ALTER TABLE person ADD is_rock_star/,
+like($out, qr/ALTER TABLE person ADD is_rock_star/,
"Detected missing rock star field");
-
+
@cmd = ($^X, $sqlt_diff, "$create1=SQLite", "$create1=SQLite");
$out = `@cmd`;
like($out, qr/ALTER TABLE person CHANGE iq/, "Detected altered 'iq' field");
like($out, qr/ALTER TABLE person CHANGE name/, "Detected altered 'name' field");
like($out, qr/ALTER TABLE person CHANGE age/, "Detected altered 'age' field");
-like($out, qr/ALTER TABLE person ADD is_rock_star/,
+like($out, qr/ALTER TABLE person ADD is_rock_star/,
"Detected missing rock star field");
-like($out, qr/ALTER TABLE person ADD UNIQUE UC_person_id/,
+like($out, qr/ALTER TABLE person ADD UNIQUE UC_person_id/,
"Detected missing unique constraint");
-like($out, qr/CREATE UNIQUE INDEX unique_name/,
+like($out, qr/CREATE UNIQUE INDEX unique_name/,
"Detected unique index with different name");
-like($out, qr/ALTER TABLE person ENGINE=InnoDB;/,
+like($out, qr/ALTER TABLE person ENGINE=InnoDB;/,
"Detected altered table option");
-like($out, qr/ALTER TABLE employee DROP FOREIGN KEY FK5302D47D93FE702E/,
+like($out, qr/ALTER TABLE employee DROP FOREIGN KEY FK5302D47D93FE702E/,
"Detected drop foreign key");
-like($out, qr/ALTER TABLE employee ADD CONSTRAINT FK5302D47D93FE702E_diff/,
+like($out, qr/ALTER TABLE employee ADD CONSTRAINT FK5302D47D93FE702E_diff/,
"Detected add constraint");
unlike($out, qr/ALTER TABLE employee ADD PRIMARY KEY/, "Primary key looks different when it shouldn't");
$out = `@cmd`;
unlike($out, qr/-- Target database Oracle is untested/, "Did not detect 'untested' comment");
-like($out, qr/ALTER TABLE TABLE1 DROP FOREIGN KEY/,
+like($out, qr/ALTER TABLE TABLE1 DROP FOREIGN KEY/,
"Detected drop foreign key");
-like($out, qr/ALTER TABLE TABLE1 ADD CONSTRAINT/,
+like($out, qr/ALTER TABLE TABLE1 ADD CONSTRAINT/,
"Detected add constraint");