Merge branch 'master' of github.com:adamhrv/megapixels_dev

1 files changed, 6 insertions, 6 deletions

diff --git a/scraper/s2-geocode-server.py b/scraper/s2-geocode-server.py
index ed7ab4e7..67da62d7 100644
--- a/scraper/s2-geocode-server.py
+++ b/scraper/s2-geocode-server.py
@@ -13,9 +13,6 @@ load_dotenv()
 
 from util import *
 
-locations_worksheet = fetch_worksheet('paper_locations')
-verifications_worksheet = fetch_worksheet('verifications')
-paper_lookup = fetch_google_lookup('citation_lookup')
 addresses = AddressBook()
 
 app = Flask(__name__, static_url_path="/reports", static_folder=os.path.abspath("reports"))
@@ -41,6 +38,7 @@ def list_locations():
 
 @app.route('/api/papers', methods=['GET'])
 def list_papers():
+  paper_lookup = fetch_google_lookup('citation_lookup')
   return jsonify({
     'papers': paper_lookup,
   })
@@ -73,6 +71,7 @@ def add_address():
   form = request.get_json()
   print(form)
   # id, title, institution_1, institution_2, institution_3, institution_4, notes
+  locations_worksheet = fetch_worksheet('paper_locations')
   locations_worksheet.append_row([
     form['paper_id'],
     form['title'],
@@ -121,9 +120,10 @@ def find_verification(sha256):
 
 @app.route('/api/verify/add', methods=['POST'])
 def add_verification():
+  worksheet = fetch_worksheet('verifications')
   form = request.get_json()
   print(form)
-  keys = verifications_worksheet.row_values(1)
+  keys = worksheet.row_values(1)
   row = [ form[key] if key in form else '' for key in keys ]
   try:
     cell = worksheet.find(form['paper_id'])
@@ -132,9 +132,9 @@ def add_verification():
 
   if cell:
     for item, i in enumerate(row):
-      verifications_worksheet.update_cell(cell.row, i+1, item)
+      worksheet.update_cell(cell.row, i+1, item)
   else:
-    verifications_worksheet.append_row(row)
+    worksheet.append_row(row)
 
   return jsonify({
     'status': 'ok'