Hello,

I have my virtual assistant's code which is in a while true loop & runs fine, but I want to add a loop inside my virtual assistant's while loop for my checkForReminders() function which scans through an sqlite table to see if any set reminders match the current date and time (if they do a popup opens and if not it should keep scanning until it finds a matching reminder).

Is there any way to do this successfully?

Thanks in advance.

checkForReminders.py

def checkForReminders(): #Connect to the database connection = sqlite3.connect(MainDatabase) cursor = connection.cursor() #Get Reminders where their dates & times match today's date & time cursor.execute("SELECT Reminder FROM Reminders WHERE Date = ? AND Time = ?",(currentdate, currentTime)) Results = cursor.fetchall() connection.commit() connection.close() if (Results == []): return else: reminderPopup(Results)

My Virtual Assistants Code:

#!/usr/bin/env python3 #------------------------------------------------------------------------------------- # B.A.X.T.E.R A.I System #------------------------------------------------------------------------------------- #----------------------------------------------- #B.A.X.T.E.R #Version 5 -> Keyboard Input #Last Updated: 09/04/22 #Developed by Paglia Industries #----------------------------------------------- #---------------------------------------------------------------------------------------------- # Table Of Contents/Overview #---------------------------------------------------------------------------------------------- # Imports # Commander & A.I Name # WishMe Function # Main # - General Conversation, Jokes, & Fun Facts # -- Search Wikipedia # --- Search Wolfram Alpha # ---- Open Stuff on Internet # ----- Open Stuff on Computer # ------ Set Reminders & Renewals # ------- Set ToDo # -------- Send E-mails # --------- Stop Program # Run Program #---------------------------------------------------------------------------------------------- #---------------------------------------------------------------------------------------------- # TODO #---------------------------------------------------------------------------------------------- # (1) # Add More Convo Abilities # Iterate through pairs.py to do general convo and fix it's output to match the standard format # Memory Capabilities via Info stored/retrieved in a SQL Database # Open CV & Guesture Controls? # (2) # Setup GUI that takes in Constants (User's Name, DOB, E-Mail, Ect..) & Stores them in Constants.db # (3) # Track packages with Baxter - put tracking # in database and have Baxter check on it when updated # Track prices of items and sends an Email when the price drops # (4) # Access to BAXTER via discord or Email. # Ex: https://realpython.com/how-to-make-a-discord-bot-python/ # (5) # Renewals & Renewal Reminders via Email, or msg Service Like Discord & Popup msgBox via PyQT # (6) # Implement Google/Custom Calendar, so user can add appointments, b-days, events, ect.. # & Have alerts display/popup when events are coming up (1 day & 2-3h before hand) # Ex: https://pypi.org/project/gcalcli/ # (7) # Allow user to better set reminders (pick day, time & repeat times) #---------------------------------------------------------------------------------------------- #------------------------------------------------------------------------------------- # Imports #------------------------------------------------------------------------------------- import json import random import datetime import operator import os import subprocess import time import sys from unittest import result import webbrowser import requests from bs4 import BeautifulSoup import wikipedia import wolframalpha from BX_Intents import (greetings, farewell, thanks, noAnswer, youChoose) from BX_External_Functions import (autoTypeAnimation, StartupText, ShutdownText, UserInput, listen, speak, getRandomJoke, getFunFacts, setReminders, setTodo, terminateTimers, sendEmail, wishMe, setRenewal, ErrorMsg, offlineWarningMsg, checkForReminders) # Print a warning msg if there is no internet to prevent pywhatkit # from crashing the program due due no connection try: import pywhatkit except: offlineWarningMsg() #------------------------------------------------------------------------------------- #------------------------------------------------------------------------------------- # Main #------------------------------------------------------------------------------------- def BAXTER(): command = UserInput() command=str(command).lower() #checkForReminders() #------------------------------------------------------------------------------------- # General Conversation (From Intents.py) #------------------------------------------------------------------------------------- #Greetings patterns, responses = greetings() if (command in patterns): results = (random.choice(responses)) autoTypeAnimation(results) speak(results) #Farewell patterns, responses = farewell() if (command in patterns): results = (random.choice(responses)) autoTypeAnimation(results) speak(results) #Thanks patterns, responses = thanks() if (command in patterns): results = (random.choice(responses)) autoTypeAnimation(results) speak(results) #No Response patterns, responses = noAnswer() if (command in patterns): results = (random.choice(responses)) autoTypeAnimation(results) speak(results) #------------------------- # Tell a Joke #------------------------- if ('joke' in command): try: joke = getRandomJoke() autoTypeAnimation(joke) speak(joke) except: ErrorMsg("get", "jokes") #------------------------- #------------------------- # Tell a Fun Fact #------------------------- if ('fact' in command): try: funFact = getFunFacts() autoTypeAnimation(funFact) speak(funFact) except: ErrorMsg("get", "fun facts") #------------------------- #------------------------------------------------------------------------------------- # Search Wikipedia (General Info) #------------------------------------------------------------------------------------- if ('weather' not in command): if ('who is' in command) or ('what is the' in command) or ('what is a' in command) or ("what is" in command): if ('time' not in command): if ('news' not in command): autoTypeAnimation('Searching Wikipedia...') speak('Searching...') command = command.replace("who is","") command = command.replace("what is the","") command = command.replace("what is a","") command = command.replace("what is","") try: results = wikipedia.summary(command, sentences = 2) autoTypeAnimation(results) speak(results) except: ErrorMsg("connect to", "Wikipedia") #------------------------------------------------------------------------------------- # Search Wolfram Alpha (Math/Conversions, Definitions) #------------------------------------------------------------------------------------- if ('news' not in command): if ('weather' in command) or ('calculate' in command) or ("what's" in command) or ('define' in command) or ("what" in command): autoTypeAnimation('Searching Wolfram Alpha...') speak('Searching...') command = command.replace("calculate","") command = command.replace("what's","") command = command.replace("define","") # Wolframalpha App Id appId = 'JH9XHR-W9J76L7H5A' try: # Wolfram Instance client = wolframalpha.Client(appId) res = client.query(''.join(command)) results = next(res.results).text autoTypeAnimation(results) speak(results) except: ErrorMsg("connect to", "Wolfram Alpha database") #------------------------------------------------------------------------------------- # Open Stuff on the Internet #------------------------------------------------------------------------------------- #Open Youtube Videos (Ex: 'Play __ on youtube') if ('youtube' in command): autoTypeAnimation("Launching Youtube...") speak('Launching Youtube') command = command.replace("youtube","") try: pywhatkit.playonyt(command) except: ErrorMsg("connect to", "Youtube") #Open Google Maps and Find The Location of A You Want if ('where is' in command): command = command.replace("where is","") autoTypeAnimation("Locating" + command + "...") speak('Locating' + command) webbrowser.open_new_tab("https://www.google.com/maps/place/" + command) #Search Stuff on Google if ('search' in command): command = command.replace("search", "") autoTypeAnimation("Searching" + command + " on Google") speak('Searching' + command) try: pywhatkit.search(command) except: ErrorMsg("connect to" , "Google") #Close Firefox if ('close firefox' in command): autoTypeAnimation("Terminating Firefox...") speak('Closing Firefox') command = command.replace("close firefox", "") browser = "firefox.exe" try: os.system("taskkill /f /im " + browser) except: ErrorMsg("close", "Firefox") #------------------------------------------------------------------------------------- # Open Stuff on the Computer #------------------------------------------------------------------------------------- #Open Windows Media Player and Auto Play the Playlist Called Music if ('play music' in command) or ('media player' in command) or ('drop the needle' in command): autoTypeAnimation("Launching music...") speak("Launching Music") command = command.replace("play music", "") command = command.replace("media player", "") command = command.replace("drop the needle", "") try: subprocess.Popen("C:\Program Files (x86)\Windows Media Player\wmplayer.exe /Playlist Music") except: ErrorMsg("open","Windows Media Player") #Close Windows Media Player if ('stop music' in command): autoTypeAnimation("Terminating music...") speak('Closing Music') command = command.replace("stop music", "") mediaPlayer = "wmplayer.exe" try: os.system("taskkill /f /im " + mediaPlayer) except: ErrorMsg("close", "Windows Media Player") #------------------------------------------------------------------------------------- # Set Reminders & Renewals #------------------------------------------------------------------------------------- if ('remind me' in command) or ('reminder' in command) or ('renew' in command): command = command.replace("remind me to", "") #If renew is mentioned in the command call the setRenewal Function if ('renew' in command): setRenewal() #Else, call the setReminders Function else: setReminders() #Call setReminders() from External Functions #------------------------------------------------------------------------------------- # Set ToDo #------------------------------------------------------------------------------------- if ('todo' in command): command = command.replace("add", "") command = command.replace("to the todo list", "") setTodo(command) #Call setTodo() from External Functions #------------------------------------------------------------------------------------- # Send E-Mails #------------------------------------------------------------------------------------- if ('email' in command): command = command.replace("email", "") sendEmail() #Call send E-Mail function fro External Functions #------------------------------------------------------------------------------------- # Stop Program/Script Command #------------------------------------------------------------------------------------- if ('stop' in command) or ('shutdown' in command) or ('quit' in command): speak("Shutting Down...") results = "Terminating program..." autoTypeAnimation(results) ShutdownText() terminateTimers() exit() #------------------------------------------------------------------------------------- #------------------------------------------------------------------------------------- #------------------------------------------------------------------------------------------ # Run The Program #------------------------------------------------------------------------------------------ def Main(): StartupText() wishMe() speak("How may I be of service?") while True: BAXTER() #------------------------------------------------------------------------------------------