\i Infrastructure-TestHeader.sql

\echo '$Id: 0-integrity-UnreportedBallots.sql 95 2007-03-19 13:59:35Z dflater $'
\echo
\echo 'Verify that unreported ballots are detected by the integrity check.'
\echo 'The "All results should be empty" notice does not apply to this test'
\echo 'case.  Refer instead to the "Expected results" printed at the bottom.'

\i 0-integrity-common.sql

delete from BallotStyleReportingContextAssociation where StyleId = 2;
insert into BallotReportingContextAssociation (BallotId,
					       ReportingContext) values
  (12, 'District 2'),
  (12, 'Precinct 1'),
  (12, 'Jurisdiction'),
  (14, 'District 2'),
  (14, 'Precinct 2'),
  (14, 'Jurisdiction');

\i Infrastructure-IntegrityChecks.sql

\echo 'Expected results:'
\echo 'Unreported Ballots'
\echo ' ballotid '
\echo '----------'
\echo '       13'
\echo '(1 row)'

\i Infrastructure-TestFooter.sql
