def test_db(tmpdir, dataset, mocker, capsys):
db = Database(str(tmpdir.join('lexibank.sqlite')))
db.load(dataset)
db.create(exists_ok=True)
with pytest.raises(ValueError):
db.create()
db.create(force=True)
db.load(dataset)
db.load_glottolog_data(dataset.glottolog)
db.load_concepticon_data(mocker.Mock(conceptsets={}))
for sql in db.sql:
db.fetchall(sql)
with db.connection() as conn:
db.fetchall('select * from dataset', conn=conn, verbose=True)
out, _ = capsys.readouterr()
assert 'select' in out
db.create(force=True)
db.load(dataset)
cldf_ds = dataset.cldf_reader()
cols = cldf_ds['FormTable'].tableSchema.columns
cols.append(Column(name='custom'))
cldf_ds.write_metadata()
db.load(dataset)
cols.pop()
cols.append(Column(name='custom', datatype='integer'))
cldf_ds.write_metadata()
with pytest.raises(ValueError):
db.load(dataset)
cols.pop()
cldf_ds.write_metadata()
db.load(dataset)
def _load(ds, **kw):
db = Database(kw['db'])
db.create(exists_ok=True)
db.load(ds)
db.load_concepticon_data(ds.concepticon)
db.load_glottolog_data(ds.glottolog)