annotate data_manager/vsnp_excel_fetcher.py @ 2:089ee96573aa draft default tip

Uploaded
author greg
date Mon, 10 Feb 2020 14:27:50 +0000
parents 54389d791983
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
f7183dcf0430 Uploaded
greg
parents:
diff changeset
1 import argparse
f7183dcf0430 Uploaded
greg
parents:
diff changeset
2 import json
f7183dcf0430 Uploaded
greg
parents:
diff changeset
3 import os
1
54389d791983 Uploaded
greg
parents: 0
diff changeset
4 import sys
0
f7183dcf0430 Uploaded
greg
parents:
diff changeset
5 try:
f7183dcf0430 Uploaded
greg
parents:
diff changeset
6 # For Python 3.0 and later
f7183dcf0430 Uploaded
greg
parents:
diff changeset
7 from urllib.request import Request, urlopen
f7183dcf0430 Uploaded
greg
parents:
diff changeset
8 except ImportError:
f7183dcf0430 Uploaded
greg
parents:
diff changeset
9 # Fall back to Python 2 imports
f7183dcf0430 Uploaded
greg
parents:
diff changeset
10 from urllib2 import Request, urlopen
f7183dcf0430 Uploaded
greg
parents:
diff changeset
11
f7183dcf0430 Uploaded
greg
parents:
diff changeset
12
1
54389d791983 Uploaded
greg
parents: 0
diff changeset
13 def url_download(url, workdir):
54389d791983 Uploaded
greg
parents: 0
diff changeset
14 file_path = os.path.abspath(os.path.join(workdir, os.path.basename(url)))
0
f7183dcf0430 Uploaded
greg
parents:
diff changeset
15 src = None
f7183dcf0430 Uploaded
greg
parents:
diff changeset
16 dst = None
f7183dcf0430 Uploaded
greg
parents:
diff changeset
17 try:
f7183dcf0430 Uploaded
greg
parents:
diff changeset
18 req = Request(url)
f7183dcf0430 Uploaded
greg
parents:
diff changeset
19 src = urlopen(req)
f7183dcf0430 Uploaded
greg
parents:
diff changeset
20 with open(file_path, 'wb') as dst:
f7183dcf0430 Uploaded
greg
parents:
diff changeset
21 while True:
f7183dcf0430 Uploaded
greg
parents:
diff changeset
22 chunk = src.read(2**10)
f7183dcf0430 Uploaded
greg
parents:
diff changeset
23 if chunk:
f7183dcf0430 Uploaded
greg
parents:
diff changeset
24 dst.write(chunk)
f7183dcf0430 Uploaded
greg
parents:
diff changeset
25 else:
f7183dcf0430 Uploaded
greg
parents:
diff changeset
26 break
1
54389d791983 Uploaded
greg
parents: 0
diff changeset
27 except Exception as e:
54389d791983 Uploaded
greg
parents: 0
diff changeset
28 sys.exit(str(e))
0
f7183dcf0430 Uploaded
greg
parents:
diff changeset
29 finally:
f7183dcf0430 Uploaded
greg
parents:
diff changeset
30 if src:
f7183dcf0430 Uploaded
greg
parents:
diff changeset
31 src.close()
f7183dcf0430 Uploaded
greg
parents:
diff changeset
32 return file_path
f7183dcf0430 Uploaded
greg
parents:
diff changeset
33
f7183dcf0430 Uploaded
greg
parents:
diff changeset
34
1
54389d791983 Uploaded
greg
parents: 0
diff changeset
35 def download(dbkey, name, url, out_file):
0
f7183dcf0430 Uploaded
greg
parents:
diff changeset
36
f7183dcf0430 Uploaded
greg
parents:
diff changeset
37 with open(out_file) as fh:
f7183dcf0430 Uploaded
greg
parents:
diff changeset
38 params = json.loads(fh.read())
f7183dcf0430 Uploaded
greg
parents:
diff changeset
39
1
54389d791983 Uploaded
greg
parents: 0
diff changeset
40 workdir = params['output_data'][0]['extra_files_path']
54389d791983 Uploaded
greg
parents: 0
diff changeset
41 os.makedirs(workdir)
54389d791983 Uploaded
greg
parents: 0
diff changeset
42 file_path = url_download(url, workdir)
54389d791983 Uploaded
greg
parents: 0
diff changeset
43 entry_name = os.path.basename(file_path)
0
f7183dcf0430 Uploaded
greg
parents:
diff changeset
44
f7183dcf0430 Uploaded
greg
parents:
diff changeset
45 data_manager_json = {"data_tables": {}}
f7183dcf0430 Uploaded
greg
parents:
diff changeset
46 data_manager_entry = {}
f7183dcf0430 Uploaded
greg
parents:
diff changeset
47 data_manager_entry['value'] = dbkey
f7183dcf0430 Uploaded
greg
parents:
diff changeset
48 data_manager_entry['name'] = entry_name
f7183dcf0430 Uploaded
greg
parents:
diff changeset
49 data_manager_entry['path'] = file_path
1
54389d791983 Uploaded
greg
parents: 0
diff changeset
50 data_manager_entry['description'] = "Excel file for %s" % name
0
f7183dcf0430 Uploaded
greg
parents:
diff changeset
51 data_manager_json["data_tables"]["vsnp_excel"] = data_manager_entry
f7183dcf0430 Uploaded
greg
parents:
diff changeset
52
f7183dcf0430 Uploaded
greg
parents:
diff changeset
53 with open(out_file, 'w') as fh:
f7183dcf0430 Uploaded
greg
parents:
diff changeset
54 fh.write(json.dumps(data_manager_json, sort_keys=True))
f7183dcf0430 Uploaded
greg
parents:
diff changeset
55
f7183dcf0430 Uploaded
greg
parents:
diff changeset
56
f7183dcf0430 Uploaded
greg
parents:
diff changeset
57 parser = argparse.ArgumentParser()
f7183dcf0430 Uploaded
greg
parents:
diff changeset
58
f7183dcf0430 Uploaded
greg
parents:
diff changeset
59 parser.add_argument('--dbkey', dest='dbkey', help='Genome reference dbkey')
1
54389d791983 Uploaded
greg
parents: 0
diff changeset
60 parser.add_argument('--name', dest='name', help='Reference display name')
0
f7183dcf0430 Uploaded
greg
parents:
diff changeset
61 parser.add_argument('--url', dest='url', help='URL to download Excel file')
f7183dcf0430 Uploaded
greg
parents:
diff changeset
62 parser.add_argument('--out_file', dest='out_file', help='JSON output file')
f7183dcf0430 Uploaded
greg
parents:
diff changeset
63
f7183dcf0430 Uploaded
greg
parents:
diff changeset
64 args = parser.parse_args()
f7183dcf0430 Uploaded
greg
parents:
diff changeset
65
1
54389d791983 Uploaded
greg
parents: 0
diff changeset
66 download(args.dbkey, args.name, args.url, args.out_file)