def ajax_get_layer_data(request):
layer_id = request.GET.get('layer_id')
if layer_id:
layer = WorkspaceLayer.objects.get(pk=layer_id)
table_columns = TableColumnDescriptor.objects.filter(table=layer.table)
fields = []
columns = []
for table_column in table_columns:
fields.append({'name':table_column.id, 'type':change_to_extjs_field_type(table_column.data_type)})
columns.append({'name':table_column.id, 'header':table_column.name, 'dataIndex':table_column.id})
metadata = {'idProperty':'id', 'root':'rows','sort_info':{'field':'id','direction':'ASC'},'fields':fields}
from project.functions import get_table_data
data = get_table_data(layer.table)
rows = []
for datum in data:
datum_columns = {'id':datum.id}
for table_column in table_columns:
datum_columns[table_column.id] = getattr(datum, table_column.db_column_name)
rows.append(datum_columns)
table_data = {'metaData':metadata, 'success':True, 'results':len(data), 'rows':rows, 'columns':columns}
return HttpResponse(simplejson.dumps(table_data))
return HttpResponse('')
def ajax_get_layer_schema(request):
layer_id = request.GET.get('layer_id')
layer = WorkspaceLayer.objects.get(pk=layer_id)
table_columns = TableColumnDescriptor.objects.filter(table=layer.table)
columns = []
for column in table_columns:
columns.append({'id':column.id, 'name':column.name, 'type':change_to_extjs_field_type(column.data_type)})
return HttpResponse(simplejson.dumps(columns))
