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