1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
# Copyright 2009 Canonical Ltd. This software is licensed under the
# GNU Affero General Public License version 3 (see the file LICENSE).
"""Confirm nobody has broken sampledata.
By editing the sampledata manually, it is possible to corrupt the data
silently switching off some of our constraints. We can detect this by
doing a dump and restore - this will fail if the data is corrupt.
"""
__metaclass__ = type
__all__ = []
import subprocess
from lp.testing import TestCase
from lp.testing.layers import DatabaseLayer
from lp.testing.pgsql import PgTestSetup
class SampleDataTestCase(TestCase):
layer = DatabaseLayer
def setUp(self):
super(SampleDataTestCase, self).setUp()
self.pg_fixture = PgTestSetup(template='template1')
self.pg_fixture.setUp()
def tearDown(self):
self.pg_fixture.tearDown()
super(SampleDataTestCase, self).tearDown()
def test_testSampledata(self):
"""Test the sample data used by the test suite."""
self.dump_and_restore('launchpad_ftest_template')
# XXX bug 365385
def disabled_test_devSampledata(self):
"""Test the sample data used by developers for manual testing."""
self.dump_and_restore('launchpad_dev_template')
def dump_and_restore(self, source_dbname):
cmd = (
"pg_dump --format=c --compress=0 --no-privileges --no-owner"
" %s | pg_restore "
" --exit-on-error --dbname=%s" % (
source_dbname, self.pg_fixture.dbname))
proc = subprocess.Popen(
cmd, shell=True, stdout=subprocess.PIPE, stderr=subprocess.STDOUT,
stdin=subprocess.PIPE)
(stdout, stderr) = proc.communicate()
rv = proc.wait()
self.failUnlessEqual(rv, 0, "Dump/Restore failed: %s" % stdout)
|