def test_create_database(self):
dropdb()
create_database()
self.assertTrue(database_connectivity())
self.assertTrue(database_exists())
self.assertTrue(schema_is_sane())
self.assertFalse(schema_has_data())
#!/usr/bin/env python
r"""A helpber script to populate a local test database
It is expected that 'ag.biom' is in the cwd
"""
# ----------------------------------------------------------------------------
# Copyright (c) 2011-2015, The American Gut Development Team.
#
# Distributed under the terms of the Modified BSD License.
#
# The full license is in the file COPYING.txt, distributed with this software.
# ----------------------------------------------------------------------------
from psycopg2 import connect
from psycopg2.extensions import ISOLATION_LEVEL_AUTOCOMMIT
from agr.schema import create_database
from agr.check_and_load import generate_per_sample_biom, insert_biom_sample
create_database()
c = connect(user='******', host='localhost', database='ag_rest')
c.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT)
cur = c.cursor()
it = generate_per_sample_biom('ag.biom', limit=10)
for sample_id, biomv1, biomtxt in it:
insert_biom_sample(cur, sample_id, biomv1, biomtxt)