def save_Preset(self):
if len(self.Dialog_Window.window.Name_Input.text()) == 0:
QMessageBox.about(self, "eMag Price Tracker",
"You must choose a name for the preset!")
list = self.get_Presets()
if str(self.Dialog_Window.window.Name_Input.text()) in list:
QMessageBox.about(self, "eMag Price Tracker",
"The preset already exists!")
else:
db_manager = DatabaseManager('Database.db')
if db_manager.check_database():
cursor = db_manager.conn.cursor()
cursor.execute("""create table if not exists Products(
link text,
preset text,
previous_price integer
)""")
for i in range(self.window.Tracker_List.count()):
cursor.execute(
"""INSERT INTO Products VALUES(?,?,?)""",
(str(self.window.Tracker_List.item(i).text()),
str(self.Dialog_Window.window.Name_Input.text()), 0))
cursor.execute("SELECT * FROM Products")
print(cursor.fetchall())
db_manager.conn.commit()
db_manager.close_connection()
self.window.Tracker_List.clear()
self.Dialog_Window.hide()
def delete_Preset(self):
preset_name = self.Select_Window2.window.List.currentItem().text()
db_manager = DatabaseManager('Database.db')
db_manager.check_database()
cursor = db_manager.conn.cursor()
cursor.execute("DELETE FROM Products WHERE preset=?", (preset_name, ))
cursor.execute("SELECT * FROM Products")
print(cursor.fetchall())
db_manager.conn.commit()
db_manager.close_connection()
self.Select_Window2.hide()
def initialize_prices(self, products):
# initialize the prices
previous_prices = [x[1] for x in products]
links = [x[0] for x in products]
header = {
"User-Agent":
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36"
}
for i in range(0, len(links)):
page = requests.get(str(links[i]), headers=header)
main = BeautifulSoup(page.content, 'html.parser')
price = main.find(class_="product-new-price").get_text()
price = price.strip()
price = self.number(price[0:len(price) - 6])
previous_prices[i] = price
db_manager = DatabaseManager('Database.db')
db_manager.check_database()
cursor = db_manager.conn.cursor()
for i in range(0, len(previous_prices)):
cursor.execute(
"UPDATE Products SET previous_price =? WHERE link=?",
(previous_prices[i], links[i]))
db_manager.conn.commit()
db_manager.close_connection()
