-
Notifications
You must be signed in to change notification settings - Fork 0
/
tes.py
49 lines (37 loc) · 1.55 KB
/
tes.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
# to do:
# - make it so it can return multiple locations if an item is in multiple locations
# - add number out variable
from googleapiclient.discovery import build
from google.oauth2.credentials import Credentials
from pprint import pprint
from googleapiclient import discovery
from google.oauth2 import service_account
from flask import Flask, jsonify, render_template, request, redirect
import json
import git
import configparser
config = configparser.ConfigParser()
config.read('auth.ini')
SPREADSHEET_ID = config.get('auth', 'SPREADSHEET_ID')
# Create a Credentials object from the service account's credentials and the scopes the application needs access to
SERVICE_ACCOUNT_FILE = 'keys.json'
SCOPES = ['https://www.googleapis.com/auth/spreadsheets']
creds = None
creds = service_account.Credentials.from_service_account_file(
SERVICE_ACCOUNT_FILE, scopes=SCOPES)
app = Flask(__name__)
@app.route('/pick_container', methods=["GET"])
def pick_container(container):
service = build('sheets', 'v4', credentials=creds)
# Call the Sheets API
sheet = service.spreadsheets()
value = [[container]]
body = {'values': value}
#get items to change
result1 = sheet.values().get(spreadsheetId=SPREADSHEET_ID, range="digital_organizer", majorDimension="COLUMNS").execute()
values = result1.get('values', [])
# update container
service.spreadsheets().values().update(
spreadsheetId=SPREADSHEET_ID, range="digital_organizer!G"+str(len(values[0])),
valueInputOption="USER_ENTERED", body=body).execute()
pick_container("pi")