Implement Sheets and Telegram clients

1 files changed, 8 insertions, 40 deletions

diff --git a/hommaexceli_py/main.py b/hommaexceli_py/main.py
index 202606d..46d6acb 100644
--- a/hommaexceli_py/main.py
+++ b/hommaexceli_py/main.py
@@ -1,47 +1,13 @@
-import pickle
-import os.path
-from googleapiclient.discovery import build
-from google_auth_oauthlib.flow import InstalledAppFlow
-from google.auth.transport.requests import Request
+from dotenv import load_dotenv
 
-# If modifying these scopes, delete the file token.pickle.
-SCOPES = ["https://www.googleapis.com/auth/spreadsheets.readonly"]
+load_dotenv()
 
-# The ID and range of a sample spreadsheet.
-SPREADSHEET_ID = "1eKEcFRQBdM2b-pPxnSUEilAKdHnMUNXZljO_I6iqwBw"
-RANGE_NAME = "A4:C7"
+from sheets_client import authenticate_and_fetch_sheets_data
+from telegram_client import run_telegram
 
 
 def main():
-    """Shows basic usage of the Sheets API.
-    Prints values from a sample spreadsheet.
-    """
-    creds = None
-    # The file token.pickle stores the user's access and refresh tokens, and is
-    # created automatically when the authorization flow completes for the first
-    # time.
-    if os.path.exists("token.pickle"):
-        with open("token.pickle", "rb") as token:
-            creds = pickle.load(token)
-    # If there are no (valid) credentials available, let the user log in.
-    if not creds or not creds.valid:
-        if creds and creds.expired and creds.refresh_token:
-            creds.refresh(Request())
-        else:
-            flow = InstalledAppFlow.from_client_secrets_file("credentials.json", SCOPES)
-            creds = flow.run_local_server(port=0)
-        # Save the credentials for the next run
-        with open("token.pickle", "wb") as token:
-            pickle.dump(creds, token)
-
-    service = build("sheets", "v4", credentials=creds)
-
-    # Call the Sheets API
-    sheet = service.spreadsheets()
-    result = (
-        sheet.values().get(spreadsheetId=SPREADSHEET_ID, range=RANGE_NAME).execute()
-    )
-    values = result.get("values", [])
+    values = authenticate_and_fetch_sheets_data()
 
     if not values:
         print("No data found.")
@@ -49,7 +15,9 @@ def main():
         print("Toistumisväli, Homma, Viimeksi tehty")
         print("===")
         for row in values:
-            print(", ".join(row))
+            print(row)
+
+    run_telegram()
 
 
 if __name__ == "__main__":