Help adding a loop inside a loop

[Extra]

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14

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:

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 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323

#!/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() #------------------------------------------------------------------------------------------

[deanhystad]

Take a look at the sched library unless you like reinventing the wheel.

https://docs.python.org/3/library/sched.html

If you like reinventing the wheel I would think about making an infinite iterator for "looping" through the reminder list. If your while True loop runs frequently, just check if the next(reminder) needs to sent. No need for an extra loop.

[Extra]

My while True loop runs very frequently (I hope to have it run 24/7), but how do I check if the next(reminder) needs to be sent, without adding another loop or crashing the current(while True) loop?

And if I did Sched would that run at the same time as my while True loop, so they would both work "side by side" without issues?

[deanhystad]

Check the next event each time through your while True loop.

If you run your outer loop frequently there is little difference between this:

1 2 3 4 5 6

events = normal_iterator() # One time through while True:     for next_event in events         if time_to_execute_event(next_event):             execute_event(next_event )     # Do other stuff

And this

1 2 3 4 5 6

events = make_a_forever_iterator()  # Iterator that starts over when reaching end while True:     next_event = next(events)     if time_to_execute_event(next_event):         execute_event(next_event )     # Do other stuff

I think the sched library is a better choice. Schedule events when you start your program or when an event gets added, and then forget about it. The event scheduler will run the event when it is scheduled to run.

[Extra]

Ok, so I tried using sched by doing this:

1 2 3 4 5 6 7 8 9 10 11 12 13

import sched import time from BX_External_Functions import checkForReminders     # instance is created scheduler = sched.scheduler(time.time, time.sleep)   print ('Checking for reminders...')     event = scheduler.enter(1, 1, checkForReminders )     # executing the events scheduler.run()

But if it doesn't find any reminders set for the current time it just exits, instead of returning and keep scanning until the current time matches the reminder time (ex: if the current time is 10:30 and the reminder is set for 10:32, the sched exits instead of staying open and running until the current time is 10:32, then once it's 10:32 it should still stay open/running in case there is another reminder set for a later time. It should only exit/stop once I quit the whole main program.)

So how can I use the sched library to do that?

[deanhystad]

You don't schedule an event to check for the reminders, you schedule the reminders.

[Extra]

Sorry, I still don't understand.
So I would have to set/add reminders using sched?

Right now all my reminders are stored/set/added in an sqlite table with the columns (Reminder, Date, Time). I'm just looking for something to iterate through the table, comparing the current date & time with the Date & Time from the sqlite table and if it's a match it calls my popup function and if it's not a match it keeps iterating until it finds a match.
Is there a way to iterate like that?

[deanhystad]

You create a schedule
You read in reminders from the database. For each reminder you add an event to the schedule (enter or enterabs).
If your program creates a new reminder it adds the reminder to the database and adds an event to the schedule.
Inside your while True: loop you call schedule.run(blocking=False)
When it is time to execute a reminder event, the schedule will do it automatically.

[Extra]

Thanks, I'm starting to understand it a bit more.

The part I'm having trouble with is when I'm reading in the Reminders from my database do I read in all the reminders or just the ones where their dates/times match the current date/time?
And if I read in all the reminders how would they (the Reminderpopup function) execute when their set date/time match the current date/time?


This is what I have so far:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

import sched import time import sqlite3 from BX_External_Functions import checkForReminders from BX_Constants import MainDatabase, currentdate, currentTime     #Create schedule scheduler = sched.scheduler(time.time, time.sleep)   #Read in reminders from database # Connect to the database connection = sqlite3.connect(MainDatabase) cursor = connection.cursor() cursor.execute("SELECT Reminder,Date,Time FROM Reminders") Results = cursor.fetchall() connection.commit() connection.close()   #For each reminder, add an event to the schedule (enter) for row in Results:     print(row) #If a new reminder is created, add it to the database & add an event to the schedule   #Inside Baxter's while True loop, call schedule.run(blocking=False)

--------

This would be my SQlite statement for reading in only the reminders where their date/time match the current date/time:

1 2 3 4 5 6 7 8 9 10 11 12

import sqlite3 from BX_Constants import MainDatabase, currentdate, currentTime    #Read in reminders from database # 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()

[deanhystad]

Schedule all the reminders when you start the program. I don't know if you want to delete reminders that happened in the past or have them all sent when the program starts.

Here's a small example that schedules a reminder to print the scheduled time of the reminder. The example jumps through a few hoops to look like I am using an absolute time without forcing you to wait to see the reminder.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

from datetime import datetime, timedelta from sched import scheduler import time   schedule = scheduler(time.time, time.sleep)   # Make a reminder that happens five seconds from now now = datetime.now() scheduled_time = now + timedelta(seconds=5) action = lambda: print(f"The scheduled time is", scheduled_time)   # Create an event to execute the reminder schedule.enterabs(scheduled_time.timestamp(), 1, action) print("The start time is", now) schedule.run(True) print("The current time is", datetime.now())

You will not set blocking=True when you schedule.run() because you don't want it blocking your while True: loop.