def app(request): """Create a clean database, return test client""" db.drop_all() db.create_all() def fin(): db.drop_all() request.addfinalizer(fin) return ckan_app.test_client()
#!/usr/bin/env python ## Import data from CKAN json file from ckan.catalog import db, Dataset, Distribution import json ## todo: ``CREATE EXTENSION hstore`` too? db.create_all() data = json.load(open("/tmp/ckandb.json", "r")) def row_to_hstore(row): hstorable = {} for key, val in row.iteritems(): if isinstance(val, (list, tuple)): val = ", ".join(val) elif isinstance(val, (int, float)): val = str(val) elif isinstance(val, basestring): pass else: val = json.dumps(val) # val = json.dumps(val) hstorable[key] = val return hstorable
#!/usr/bin/env python ## Import data from CKAN json file from ckan.catalog import db, Dataset, Distribution import json ## todo: ``CREATE EXTENSION hstore`` too? db.create_all() data = json.load(open('/tmp/ckandb.json', 'r')) def row_to_hstore(row): hstorable = {} for key, val in row.iteritems(): if isinstance(val, (list, tuple)): val = ", ".join(val) elif isinstance(val, (int, float)): val = str(val) elif isinstance(val, basestring): pass else: val = json.dumps(val) #val = json.dumps(val) hstorable[key] = val return hstorable