def test_excel_file(self):
data = {'url': 'http://0.0.0.0:50001/static/simple.xls',
'format': 'xls',
'id': 'uuid2'}
context = {'webstore_url': 'http://0.0.0.0:50002',
'site_url': 'http://0.0.0.0:50001',
'apikey': 'test',
'username': '******'}
tasks.webstorer_upload(json.dumps(context), json.dumps(data))
response = requests.get('http://0.0.0.0:50002/test/uuid2/data.json')
assert json.loads(response.content) == [{u'date': u'2011-01-01T00:00:00', u'place': u'Galway', u'__id__': 1, u'temperature': 1},
{u'date': u'2011-01-02T00:00:00', u'place': u'Galway', u'__id__': 2, u'temperature': -1},
{u'date': u'2011-01-03T00:00:00', u'place': u'Galway', u'__id__': 3, u'temperature': 0},
{u'date': u'2011-01-01T00:00:00', u'place': u'Berkeley', u'__id__': 4, u'temperature': 6},
{u'date': u'2011-01-02T00:00:00', u'place': u'Berkeley', u'__id__': 5, u'temperature': 8},
{u'date': u'2011-01-03T00:00:00', u'place': u'Berkeley', u'__id__': 6, u'temperature': 5}], json.loads(response.content)
response = requests.get('http://0.0.0.0:50001/last_request')
assert json.loads(response.content)['headers'] == {u'Content-Length': u'126',
u'Accept-Encoding': u'gzip',
u'Connection': u'close',
u'User-Agent': u'python-requests.org',
u'Host': u'0.0.0.0:50001',
u'Content-Type': u'application/json',
u'Authorization': u'test'}
assert json.loads(response.content)['data']['id'] == 'uuid2'
assert json.loads(response.content)['data']['webstore_url'] == 'http://0.0.0.0:50002/test/uuid2/data'
def test_messier_file(self):
file_path = os.path.join(os.path.dirname(__file__), "3ffdcd42-5c63-4089-84dd-c23876259973")
data = {'url': 'http://0.0.0.0:50001/static/3ffdcd42-5c63-4089-84dd-c23876259973',
'format': 'csv',
'id': 'uuid3'}
context = {'webstore_url': 'http://0.0.0.0:50002',
'site_url': 'http://0.0.0.0:50001',
'apikey': 'test',
'username': '******'}
tasks.webstorer_upload(json.dumps(context), json.dumps(data))
response = requests.get('http://0.0.0.0:50002/test/uuid3/data.json')
assert json.loads(response.content)[:3] == [
{u'Date': u'01/04/2009', u'Transaction Number': 136980, u'Amount': 2840.5, u'Expense Area': u'HOUSING HEALTH + COMMUNITY SAFETY',
u'__id__': 1, u'Supplier': u'B H HAYES + SONS', u'Body Name': u'Adur District Council'},
{u'Date': u'01/04/2009', u'Transaction Number': 139471, u'Amount': 997.80999999999995, u'Expense Area': u'STRATEGIC PERFORMANCE,HR&TRANSFORMATION',
u'__id__': 2, u'Supplier': u'BADENOCH + CLARK', u'Body Name': u'Adur District Council'},
{u'Date': u'01/04/2009', u'Transaction Number': 139723, u'Amount': 356.39999999999998, u'Expense Area': u'RECYCLING & WASTE DIVISION',
u'__id__': 3, u'Supplier': u'B-O-S RECRUITMENT SERVICES', u'Body Name': u'Adur District Council'}], json.loads(response.content)[:3]