Notify Me by Email When A Certain Product Appears In The Store

-----------------
EXPLANATION:

ROMANIAN: https://neculaifantanaru.com/python-anunta-cand-apare-in-magazin-un-anumit-produs-in-functie-de-pretul-cel-mai-mic.html

ENGLISH:  https://neculaifantanaru.com/en/python-notifies-me-when-a-certain-product-appears-in-the-store-depending-on-the-lowest-price.html
-----------------


#-------------------------------------------------------------------------------
# Author:      Fantanaru Neculai
#
# Created:     16/03/2022
# Copyright:   (c) Fantanaru Neculai 2022
#-------------------------------------------------------------------------------

from bs4 import BeautifulSoup as bs
import pandas as pd
pd.set_option('display.max_colwidth', 500)
import time
import requests
import random
import re

page = requests.get("https://www.okazii.ro/")

soup = bs(page.content)

# Studiul desenului, culorii, compozitiei si expresiei in arta eclesiala
result = requests.get("https://www.okazii.ro/cautare/studiul+desenului%2C+culorii%2C+compozitiei+si+expresiei+in+arta+eclesiala.html")

# preluam text dintre <!-- END SPECIALE IN LISTA--> si <!-- RECENT INTRODUSE -->
produse_sectiune_pattern = re.compile('<!-- END SPECIALE IN LISTA-->([\s\S]*?)<div id=\'div-gpt-ad-15\'>')
produse_sectiune = re.findall(produse_sectiune_pattern, result.text)
produse_sectiune = produse_sectiune[0]

preturi_pattern = re.compile('<span class=\"prSup\"><span>(.*?)</span><span class=\"seo-price-indent\">')
preturi = re.findall(preturi_pattern, produse_sectiune)
print(preturi)

count = 0
for pret in preturi:
    if int(pret) < 90:  # puneti <= daca vreti ca pretul sa fie si egal cu 90 RON
        count += 1
print("Am gasit {} oferte cu pretul sub 90 lei.".format(count))

# soup_cautare = bs(result.text, 'html.parser')
# print(soup_cautare)

#items = soup_cautare.find_all(class_ = 'listing-product ')
#print(items)


# Trimitere email
import sys
import smtplib

from_addr = 'YOUR EMAIL ADRESS'
to_addrs = ['YOUR EMAIL ADRESS']
msg = """From: Sender
To: Recipient
Subject: Okazii

Am gasit 1 oferte cu pretul sub 90 lei.
"""

try:
    s = smtplib.SMTP('mail.neculaifantanaru.com', 26) # put here your own SMTP PORT and hosting email
    s.login('YOUR EMAIL ADRESS', 'PASSWORD')  # do not use GMAIL !!
    s.sendmail(from_addr, to_addrs, msg)
    s.quit()
except smtplib.SMTPException:
    print("Error: ", sys.exc_info()[0])