def main_loop():
# requested query
inputServiceID = request.query.serviceid
csv = pt.fromcsv('clinicservicelocations.csv')
response.headers['Content-type'] = 'application/json'
response.headers['Access-Control-Allow-Origin'] = '*'
for i in csv:
if inputServiceID == i[0]:
# select the data according to the given requested query
dataSelect = pt.select(
csv, "{ServiceID} == '" + str(inputServiceID) + "'")
# cutting out the required column names
jsonData = pt.cut(dataSelect, 'Name', 'Service', 'Suburb', 'State',
'Email', 'Lat', 'Lon')
# convert the dictionary data into json data
jsonData = json.JSONEncoder().encode(list(pt.dicts(jsonData)))
# return the json data
return jsonData
# this is requested link of getting all the distinct list of
# clinics offering any service.
if inputServiceID == "0":
anyServices = pt.unique(csv, key='Name')
jsonData = pt.cut(anyServices, 'Name', 'Service', 'Suburb',
'State', 'Email', 'Lat', 'Lon')
jsonData = json.JSONEncoder().encode(list(pt.dicts(jsonData)))
return jsonData
else:
jsonData = json.JSONEncoder().encode('Unable to find this id.')
return jsonData
def main_loop():
# requested query
Service = request.query.Service
#Converting the Service value to String
Service = str(Service)
csv = petl.fromcsv(file)
response.headers['Content-type'] = 'application/json'
response.headers['Access-Control-Allow-Origin'] = '*'
for i in csv:
if Service == i[1]:
# select the data according to the given requested query
dataSelect = petl.select(csv, "{Service} == '" + Service + "'")
# cutting out the required column names
jsonData = petl.cut(dataSelect, 'ClinicID', 'Suburb', 'Lat', 'Lon')
# convert the dictionary data into json data
jsonData = json.JSONEncoder().encode(list(petl.dicts(jsonData)))
# return the json data
return jsonData
# this is requested link of getting all the distinct list of clinics offering any service.
if Service == "0":
anyServices = petl.unique(csv, key='Name')
jsonData = petl.cut(anyServices, 'ClinicID', 'Suburb', 'Lat',
'Lon')
jsonData = json.JSONEncoder().encode(list(petl.dicts(jsonData)))
return jsonData
else:
jsonData = json.JSONEncoder().encode('Please Enter a Service.')
return jsonData
# unique
table1 = (('foo', 'bar', 'baz'),
('A', 1, 2),
('B', '2', '3.4'),
('D', 'xyz', 9.0),
('B', u'3', u'7.8'),
('B', '2', 42),
('E', None, None),
('D', 4, 12.3),
('F', 7, 2.3))
from petl import unique, look
look(table1)
table2 = unique(table1, 'foo')
look(table2)
# isordered
table = (('foo', 'bar', 'baz'),
('a', 1, True),
('b', 3, True),
('b', 2))
from petl import isordered, look
look(table)
isordered(table, key='foo')
isordered(table, key='foo', strict=True)
isordered(table, key='foo', reverse=True)
# unique
table1 = (('foo', 'bar', 'baz'),
('A', 1, 2),
('B', '2', '3.4'),
('D', 'xyz', 9.0),
('B', u'3', u'7.8'),
('B', '2', 42),
('E', None, None),
('D', 4, 12.3),
('F', 7, 2.3))
from petl import unique, look
look(table1)
table2 = unique(table1, 'foo')
look(table2)
# isordered
table = (('foo', 'bar', 'baz'),
('a', 1, True),
('b', 3, True),
('b', 2))
from petl import isordered, look
look(table)
isordered(table, key='foo')
isordered(table, key='foo', strict=True)
isordered(table, key='foo', reverse=True)
# unique()
##########
import petl as etl
table1 = [['foo', 'bar', 'baz'],
['A', 1, 2],
['B', '2', '3.4'],
['D', 'xyz', 9.0],
['B', u'3', u'7.8'],
['B', '2', 42],
['E', None, None],
['D', 4, 12.3],
['F', 7, 2.3]]
table2 = etl.unique(table1, 'foo')
table2
# conflicts()
#############
import petl as etl
table1 = [['foo', 'bar', 'baz'],
['A', 1, 2.7],
['B', 2, None],
['D', 3, 9.4],
['B', None, 7.8],
['E', None],
['D', 3, 12.3],
['A', 2, None]]
table1 = [['foo', 'bar', 'baz'], ['A', 1, 2.0], ['B', 2, 3.4], ['D', 6, 9.3],
['B', 3, 7.8], ['B', 2, 12.3], ['E', None, 1.3], ['D', 4, 14.5]]
table2 = etl.duplicates(table1, 'foo')
table2
# compound keys are supported
table3 = etl.duplicates(table1, key=['foo', 'bar'])
table3
# unique()
##########
import petl as etl
table1 = [['foo', 'bar', 'baz'], ['A', 1, 2], ['B', '2', '3.4'],
['D', 'xyz', 9.0], ['B', u'3', u'7.8'], ['B', '2', 42],
['E', None, None], ['D', 4, 12.3], ['F', 7, 2.3]]
table2 = etl.unique(table1, 'foo')
table2
# conflicts()
#############
import petl as etl
table1 = [['foo', 'bar', 'baz'], ['A', 1, 2.7], ['B', 2, None], ['D', 3, 9.4],
['B', None, 7.8], ['E', None], ['D', 3, 12.3], ['A', 2, None]]
table2 = etl.conflicts(table1, 'foo')
table2
# isunique()
############
import petl as etl
