In this article, we are going to launch favorite websites using shortcuts, for this, we will use Python’s sqlite3 and webbrowser modules to launch your favorite websites using shortcuts.
Both sqlite3 and webbrowser are a part of the python standard library, so we don’t need to install anything separately.
The best part about this is that because we are using a database to store the websites and their shortcuts, your favorite websites will remain saved in the database even if we close the terminal or shut down the PC. So you don’t need to add your favorite websites to the database every time you execute the script.
We create a new database if it does not already exist and connect it to our database.
We create different functions to fetch data from the database, open a website, add a new website to the database, and remove a website from the database
We call a while loop so that our program can listen to the user’s commands until they quit
We ask for a response from the user to perform a specific task
Below is the implementation:
# connecting to sqlite and creating
# an actual database
c.execute("""CREATE TABLE IF NOT EXISTS favorites
(title TEXT, url TEXT)""")
# Created a table named favorites
# (if it didn't already existed).
# Then inserted the headers title
# (which takes text as input)
# and url (which takes text as input)
Used to extract data from our database
c.execute('''SELECT * FROM favorites''')
Used to extract the favorite website
c.execute('''SELECT * FROM favorites WHERE title=?''',
Used to add a new favorite website
c.execute("""INSERT INTO favorites (title, url) VALUES (?, ?)""",
Used to remove a favorite website from the database
c.execute('''DELETE FROM favorites WHERE title=?''',
# A loop to listen to commands from the user
# printing each statement like
# this to keep the code clean
print("Press v to visit a favorite,", end=" ")
print("ls for list,", end=" ")
print("add to add a new item,", end=" ")
print("rm to delete,", end=" ")
print("q to quit:", end=" ")
# taking input command from the user
shortcut =input("Enter the shortcut for the website: ")
# opening the selected website in the browser
# if we don't have the shortcut
# in the database, print this:
print('This shortcut does not exist in the database')
Please Login to comment...