def get_allworksheet(user):
scope = [
"https://spreadsheets.google.com/feeds",
"https://www.googleapis.com/auth/spreadsheets",
"https://www.googleapis.com/auth/drive.file",
"https://www.googleapis.com/auth/drive"
]
try:
Database.Code("./Database/json/creds.json",
Database.Function) # DeCoding
creds = ServiceAccountCredentials.from_json_keyfile_name(
"./Database/json/creds.json", scope)
Database.Code("./Database/json/creds.json",
Database.Function) # Coding
client = gspread.authorize(creds)
spreadsheets = client.list_spreadsheet_files()
for sh in spreadsheets:
if sh["name"] == user: # there is user spreadsheet
sheet = client.open(user)
sheetAdmin = client.open("*****@*****.**")
worksheets = sheet.worksheets()
worksheetsGlobal = sheetAdmin.worksheets() # global tags
# return data and their successfull key
return worksheets, True, worksheetsGlobal, True
try: # if there is no Spreadsheet with user
sh = client.create(user)
return [], True, [], False
except: # handle Exception
return [], False, [], False
except:
return [], False, [], False
def download_Database(user, filename, filepath):
scope = [
"https://spreadsheets.google.com/feeds",
"https://www.googleapis.com/auth/spreadsheets",
"https://www.googleapis.com/auth/drive.file",
"https://www.googleapis.com/auth/drive"
]
try:
Database.Code("./Database/json/creds.json",
Database.Function) # DeCoding
creds = ServiceAccountCredentials.from_json_keyfile_name(
"./Database/json/creds.json", scope)
Database.Code("./Database/json/creds.json",
Database.Function) # Coding
client = gspread.authorize(creds)
sh = client.open(user)
sheet = sh.worksheet(filename)
data = sheet.get_all_values()
# return result of writing data to csv
return set_csvData(filepath, data)
except:
return False
def upload_Database(user, filename, filepath):
scope = [
"https://spreadsheets.google.com/feeds",
"https://www.googleapis.com/auth/spreadsheets",
"https://www.googleapis.com/auth/drive.file",
"https://www.googleapis.com/auth/drive"
]
try:
Database.Code("./Database/json/creds.json",
Database.Function) # DeCoding
creds = ServiceAccountCredentials.from_json_keyfile_name(
"./Database/json/creds.json", scope)
Database.Code("./Database/json/creds.json",
Database.Function) # Coding
client = gspread.authorize(creds)
spreadsheets = client.list_spreadsheet_files()
data = get_csvData(filepath)
for sh in spreadsheets:
if sh["name"] == user: # there is user spreadsheet
sh = client.open(user)
worksheets = sh.worksheets()
for wsh in worksheets:
if wsh.title == filename: # there is worksheet for tags or not
sheet = sh.worksheet(filename)
sheet.delete_rows(1, len(sheet.get_all_values()))
sheet.insert_rows(data)
return True
# create new worksheet if there in no worksheet for tags
sheet = sh.add_worksheet(title=filename, rows=10000, cols=20)
sheet.insert_rows(data)
return True
return False
except:
return False
