def test_create_dataset_with_parent_geometry(self):
ds2 = SpatialiteDriver.create_dataset_with_parent_geometry(
'geometry derived dataset',
self.ds,
columns_definitions=(('name', 'TEXT'), ('i', 'INTEGER'), ('j',
'REAL')))
ds3 = SpatialiteDriver.create_dataset_with_parent_geometry(
'geometry dervied dataset 2', self.ds)
self.assertListEqual([
'OGC_FID', 'GEOMETRY', 'name', 'i', 'j'
], ds2.resource.schema(
), 'empty dataset with three columns should have had three columns, but had {schema}'
.format(schema=ds2.resource.schema()))
self.assertListEqual(
['OGC_FID', 'GEOMETRY'], ds3.resource.schema(),
'empty dataset schema should have had nothing in it, had {schema}'.
format(schema=ds3.resource.schema()))
ds3.resource.add_column('name', 'TEXT')
ds3.resource.add_column('i', 'TEXT')
ds3.resource.add_column('j', 'TEXT')
self.assertListEqual(
ds3.resource.schema(), ['OGC_FID', 'GEOMETRY', 'name', 'i', 'j'],
"added columns, but they didn't show up right: {schema}".format(
schema=ds3.resource.schema()))
def create_dataset_with_parent_geometry(request, slug):
user = authorize(request)
title = request.REQUEST.get('title', 'Untitled dataset')
parent_dataresource = slug
srid = int(request.REQUEST.get('srid', 4326))
geometry_type = request.REQUEST.get('geometry_type', 'GEOMETRY')
columns_definitions = json.loads(request.REQUEST.get('columns_definitions', "{}"))
columns_definitions = ((key, value) for key, value in columns_definitions.items())
parent_key = request.REQUEST.get('parent_key', None)
child_key = request.REQUEST.get('child_key', None)
csv = None
if len(request.FILES.keys()) > 0:
csvfile = NamedTemporaryFile(suffix='csv')
csvfile.write(request.FILES[request.FILES.keys().next()].read())
csvfile.flush()
csv = pandas.DataFrame.from_csv(csvfile.name)
if 'parent_page' in request.REQUEST:
parent_page = Page.objects.get(slug=request.REQUEST['parent_page'])
authorize(request, parent_page, add=True)
else:
parent_page = get_data_page_for_user(request.user)
parent_dataresource = DataResource.objects.get(slug=parent_dataresource)
authorize(request, parent_page, view=True)
if csv:
ds = SpatialiteDriver.join_data_with_existing_geometry(
title=title,
parent=parent_page,
new_data=csv,
join_field_in_existing_data=parent_key,
join_field_in_new_data=child_key,
parent_dataresource=parent_dataresource,
srid=srid,
geometry_type=geometry_type,
owner=request.user
)
else:
ds = SpatialiteDriver.create_dataset_with_parent_geometry(
title=title,
parent=parent_page,
parent_dataresource=parent_dataresource,
srid=srid,
columns_definitions=columns_definitions,
geometry_type=geometry_type,
owner=request.user
)
dispatch.api_accessed.send(sender=DataResource, instance=ds, user=user)
dispatch.dataset_created.send(sender=ds, user=user)
return json_or_jsonp(request, {'path': ds.slug}, code=201)
def create_dataset_with_parent_geometry(request, slug):
user = authorize(request)
title = request.REQUEST.get('title', 'Untitled dataset')
parent_dataresource = slug
srid = int(request.REQUEST.get('srid', 4326))
geometry_type = request.REQUEST.get('geometry_type', 'GEOMETRY')
columns_definitions = json.loads(request.REQUEST.get('columns_definitions', "{}"))
columns_definitions = ((key, value) for key, value in columns_definitions.items())
parent_key = request.REQUEST.get('parent_key', None)
child_key = request.REQUEST.get('child_key', None)
csv = None
if len(request.FILES.keys()) > 0:
csvfile = NamedTemporaryFile(suffix='csv')
csvfile.write(request.FILES[request.FILES.keys().next()].read())
csvfile.flush()
csv = pandas.DataFrame.from_csv(csvfile.name)
if 'parent_page' in request.REQUEST:
parent_page = Page.objects.get(slug=request.REQUEST['parent_page'])
authorize(request, parent_page, add=True)
else:
parent_page = get_data_page_for_user(request.user)
parent_dataresource = DataResource.objects.get(slug=parent_dataresource)
authorize(request, parent_page, view=True)
if csv:
ds = SpatialiteDriver.join_data_with_existing_geometry(
title=title,
parent=parent_page,
new_data=csv,
join_field_in_existing_data=parent_key,
join_field_in_new_data=child_key,
parent_dataresource=parent_dataresource,
srid=srid,
geometry_type=geometry_type,
owner=request.user
)
else:
ds = SpatialiteDriver.create_dataset_with_parent_geometry(
title=title,
parent=parent_page,
parent_dataresource=parent_dataresource,
srid=srid,
columns_definitions=columns_definitions,
geometry_type=geometry_type,
owner=request.user
)
dispatch.api_accessed.send(sender=DataResource, instance=ds, user=user)
dispatch.dataset_created.send(sender=ds, user=user)
return json_or_jsonp(request, {'path': ds.slug}, code=201)
def test_create_dataset_with_parent_geometry(self):
ds2 = SpatialiteDriver.create_dataset_with_parent_geometry(
'geometry derived dataset',
self.ds,
columns_definitions=(('name', 'TEXT'), ('i', 'INTEGER'), ('j', 'REAL'))
)
ds3 = SpatialiteDriver.create_dataset_with_parent_geometry(
'geometry dervied dataset 2',
self.ds
)
self.assertListEqual(['OGC_FID', 'GEOMETRY', 'name', 'i', 'j'], ds2.resource.schema(),
'empty dataset with three columns should have had three columns, but had {schema}'.format(
schema=ds2.resource.schema()))
self.assertListEqual(['OGC_FID', 'GEOMETRY'], ds3.resource.schema(),
'empty dataset schema should have had nothing in it, had {schema}'.format(
schema=ds3.resource.schema()))
ds3.resource.add_column('name', 'TEXT')
ds3.resource.add_column('i', 'TEXT')
ds3.resource.add_column('j', 'TEXT')
self.assertListEqual(ds3.resource.schema(), ['OGC_FID', 'GEOMETRY', 'name', 'i', 'j'],
"added columns, but they didn't show up right: {schema}".format(schema=ds3.resource.schema()))
