Continente.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from time import sleep\n",
    "import re, os, time\n",
    "#http://allselenium.info/python-selenium-commands-cheat-sheet-frequently-used/"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = webdriver.Firefox();"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.get('https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Mercearia(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80')\n",
    "#driver.get('https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=bio-saudavel(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#');"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#driver.find_element_by_xpath('//li[@class=\"selected\"]//div[@class=\"text ecsfSortName\"]').click()\n",
    "#driver.find_element_by_css_selector('.orderOptions > ul:nth-child(1) > li:nth-child(6) > div:nth-child(1)').click()\n",
    "#driver.find_element_by_class_name('text ecsfSortName').click()\n",
    "driver.find_element_by_xpath('//div[@class=\"contentLeft\"]//ul//li[6]//div[1]').click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.continente.pt/stores/continente/pt-pt/public/Pages/ProductDetail.aspx?ProductId=5726871(eCsf_RetekProductCatalog_MegastoreContinenteOnline_Continente)&refiner=%23%2F%3Fpl%3D80\n",
      "['Massa Farfallete', 'Divella', 'emb. 500 gr']\n",
      "1.09\n"
     ]
    }
   ],
   "source": [
    "link : str = driver.find_element_by_class_name('ecsf_QuerySuggestions').get_attribute('href')\n",
    "caracteristicas : list = driver.find_element_by_class_name('containerDescription').text.split('\\n')\n",
    "preco : str = driver.find_element_by_class_name('priceFirstRow').text.replace('€', '').replace('/un', '')\n",
    "preco : str = preco.replace(',', '.').replace(' ', '')\n",
    "print(link)\n",
    "print(nome_produto)\n",
    "print(preco)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "#//div[@class='gridRow']//div[1]//div[1]//div[1]//div[6]//div[1]//div[1]//div[1] -- 1º Produto\n",
    "#//div[@class='gridRow']//div[2]//div[1]//div[1]//div[6]//div[1]//div[1]//div[1] -- 2º Produto\n",
    "#//div[@class='gridRow']//div[80]//div[1]//div[1]//div[6]//div[1]//div[1]//div[1] -- 80º Produto\n",
    "\n",
    "#/html[1]/body[1]/form[1]/div[3]/div[1]/div[3]/ul[1]/li[15]/div[2]/a[1]\n",
    "#/html[1]/body[1]/form[1]/div[3]/div[1]/div[3]/ul[1]/li[4]/div[2]/a[1]\n",
    "# /html[1]/body[1]/form[1]/div[3]/div[1]/div[3]/ul[1]/li[2]/div[2]/a[1]\n",
    "\n",
    "#/html/body/form/div[3]/div[1]/div[4]/ul/li[2]/div[2]/a\n",
    "\n",
    "\n",
    "#ahref -> /html/body/form/div[3]/div[1]/div[4]/ul/li[2]/div[4]/div/div[1]/ul/li[{}]/a"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "menu = driver.find_element_by_xpath(\"/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[2]/div[1]/div[2]/ul/li[6]/div\")\n",
    "menu.click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [],
   "source": [
    "categorias = ['https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Mercearia(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=bio-saudavel(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Frescos(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Bebidas(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Lactic%C3%ADnio(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Congelados(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Beb%C3%A9(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Higiene(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=beleza(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Limpeza(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Lazer(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80']\n",
    "\n",
    "for i in range(len(categorias)):\n",
    "    driver.get(categorias[i])\n",
    "    #aba_descontos = driver.find_element_by_xpath(\"/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[2]/div[1]/div[2]/ul/li[6]/div\")\n",
    "    #aba_descontos.click()\n",
    "    #time.sleep(20)\n",
    "    #caracteristicas : list = driver.find_elements_by_class_name('containerDescription')\n",
    "    #for i in range(1, len(caracteristicas)):\n",
    "    #    preco_com_desconto : str = driver.find_element_by_xpath(('/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[3]/div/div/div[{}]/div/div[1]/div[4]/div[1]/div[1]'.format(i)))\n",
    "    #    preco_com_desconto : str = preco_com_desconto.text.replace('€', '').replace('/un', '').replace(',', '.').replace(' ', '').replace('/kg','')\n",
    "    #    preco_sem_desconto : str = driver.find_element_by_xpath(('/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[3]/div/div/div[{}]/div/div[1]/div[6]/div[2]/div[1]/div[1]'.format(i)))\n",
    "    #    preco_sem_desconto : str = preco_sem_desconto.text.replace('€', '').replace('/un', '').replace(',', '.').replace(' ', '').replace('/kg','')\n",
    "    #    desconto : str = driver.find_element_by_xpath(('/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[3]/div/div/div[{}]/div/div[1]/div[6]/div[2]/div[2]/div[2]/span[3]').format(i)).text\n",
    "    #    print('nome: ', caracteristicas[i].text.replace('\\n', ','),preco_com_desconto , '->', preco_sem_desconto, '->', desconto)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "#for e in range(2, 16):\n",
    "#    btn = driver.find\n",
    "#/html/body/form/div[3]/div[1]/div[3]/ul/li[2]/div[4]/div/div[1]/ul/li[1]/a\n",
    "btn = driver.find_elements_by_class_name('center')\n",
    "for i in range(len(btn)):\n",
    "    try:\n",
    "        btn[i].click()\n",
    "    except:\n",
    "        pass\n",
    "#btn_todos = driver.find_element_by_class_name('menu-title')\n",
    "#print(btn_todos.click())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "None\n",
      "[]\n"
     ]
    }
   ],
   "source": [
    "btn_btn = driver.find_element_by_class_name('level-1').get_attribute('href')\n",
    "print(btn_btn)\n",
    "element = driver.find_elements_by_partial_link_text(\"/stores/continente/pt-pt/public/Pages/category.aspx?cat=\")\n",
    "print(element)\n",
    "#for btn in btn_btn:\n",
    "#    print(btn.get_attribute('href'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def retirar_produtos() -> None:\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nome:  Ananás em Calda,Benimar,emb. 810 gr 1.09 -> 1.45 -> 25%\n",
      "nome:  Batata Frita Ondulada com Sabor Molho Valentina Madre Mia,Continente,emb. 135 gr 1.99 -> 2.39 -> €0,40\n",
      "nome:  Fantasia Chocolate Moedas Saco,Disney,emb. 50 gr 0.99 -> 1.39 -> €0,40\n",
      "nome:  Marmelada,Casa Da Prisca,1 un = 200 gr 1.00 -> 1.99 -> 50%\n",
      "nome:  Batata Frita Ondulada com Sabor a Alho Madre Mia,Continente,emb. 135 gr 5.59 -> 6.99 -> 20%\n",
      "nome:  Massa Tagliatelle com Ovo,Divella,emb. 500 gr 0.99 -> 1.39 -> €0,40\n",
      "nome:  Cenoura Ralada Vinagre,Continente,emb. 345 gr 1.79 -> 2.39 -> 25%\n",
      "nome:  Corações de Alcachofra,Continente,emb. 390 gr 0.99 -> 1.19 -> €0,20\n",
      "nome:  Massa Penne Zit Rigate,Divella,emb. 500 gr 1.89 -> 2.09 -> €0,20\n",
      "nome:  Massa Sedani Rigati,Massimo,emb. 500 gr 0.97 -> 1.29 -> 25%\n",
      "nome:  Massa Bavettine,Divella,emb. 500 gr 0.44 -> 0.89 -> €0,45\n",
      "nome:  Massa Lasanha com Ovo,Divella,emb. 500 gr 0.97 -> 1.29 -> 25%\n",
      "nome:  Bolachas Recheadas Coco Continente,Continente,emb. 100 gr 1.87 -> 2.49 -> 25%\n",
      "nome:  Bolachas Recheadas Maçã,Continente,emb. 100 gr 1.49 -> 1.99 -> €0,50\n",
      "nome:  Snack Choco Wafer Minis,Continente,emb. 300 gr 1.49 -> 1.99 -> €0,50\n",
      "nome:  Bolachas Recheio Chocolate,Continente,emb. 250 gr 2.24 -> 2.49 -> €0,25\n",
      "nome:  Cereais Mix Choc Chocolate Branco,Continente,emb. 375 gr 0.89 -> 1.04 -> €0,15\n",
      "nome:  Bolachas com Coco,Continente,emb. 500 gr 1.49 -> 1.89 -> €0,40\n",
      "nome:  Cereais Estrelinhas Chocolate,Continente,emb. 375 gr 1.19 -> 1.59 -> €0,40\n",
      "nome:  Snack Mix Vegetais Fritos em Azeite,Continente,emb. 70 gr 1.49 -> 1.89 -> €0,40\n",
      "nome:  Azeite Extra Virgem,Arraial,garrafa 75 cl 1.09 -> 1.39 -> €0,30\n",
      "nome:  Corn Flakes Açucarados,Continente Infantil,emb. 375 gr 2.79 -> 2.99 -> €0,20\n",
      "nome:  Azeite Extra Virgem Vale do Sobreiro,Continente Seleção,garrafa 75 cl 1.49 -> 1.99 -> €0,50\n",
      "nome:  Atum em Azeite,Cícero,emb. 110 gr 2.99 -> 3.49 -> €0,50\n",
      "nome:  Atum em Óleo,Cícero,emb. 110 gr 0.89 -> 1.78 -> 50%\n",
      "nome:  Atum em Azeite,Cícero,emb. 385 gr 0.69 -> 1.38 -> 50%\n",
      "nome:  Atum ao Natural,Cícero,emb. 385 gr 2.69 -> 5.38 -> 50%\n",
      "nome:  Atum em Óleo,Cícero,emb. 385 gr 2.34 -> 4.68 -> 50%\n",
      "nome:  Batata Frita Lisa Sabor Hot & Spicy Madre Mia,Continente,emb. 135 gr 2.34 -> 4.68 -> 50%\n",
      "nome:  Atum ao Natural,Cícero,emb. 110 gr 0.99 -> 1.39 -> €0,40\n",
      "nome:  Sobremesa Láctea Banana,Continente,emb. 4 x 100 gr 0.69 -> 1.38 -> 50%\n",
      "nome:  Sobremesa Láctea Bolacha,Continente,emb. 4 x 100 gr 1.49 -> 1.99 -> €0,50\n",
      "nome:  Sobremesa Láctea Pêra,Continente,emb. 4 x 100 gr 1.49 -> 1.99 -> €0,50\n",
      "nome:  Sobremesa Láctea Alperce,Continente,emb. 4 x 100 gr 1.49 -> 1.99 -> €0,50\n",
      "nome:  Barras de Cereais com Chocolate Preto Crocante Clusters,Nestlé,emb. 140 gr 1.49 -> 1.99 -> €0,50\n",
      "nome:  Barras de Cereais com Amendôas e Sementes Clusters,Nestlé,emb. 140 gr 2.24 -> 2.99 -> 25%\n",
      "nome:  Barras de Cereais com Caramelo e Chocolate Clusters,Nestlé,emb. 140 gr 2.24 -> 2.99 -> 25%\n",
      "nome:  Chocolate Preto Mirtilo Vermelho e Cereja sem Glúten,Regina,emb. 100 gr 2.24 -> 2.99 -> 25%\n",
      "nome:  Bolachas Wafers de Baunilha,Continente Seleção,emb. 200 gr 1.49 -> 1.99 -> 25%\n",
      "nome:  Bolachas Palitos Chocolate Branco,Continente,emb. 150 gr 1.49 -> 1.64 -> €0,15\n",
      "nome:  Café Solúvel,Nescafé Clássico,emb. 200 gr 0.79 -> 0.99 -> €0,20\n",
      "nome:  Massa Fusilli,Divella,emb. 500 gr 3.25 -> 6.49 -> 50%\n",
      "nome:  Massa Esparguete 8,Divella,emb. 500 gr 0.97 -> 1.29 -> 25%\n",
      "nome:  Sortido de Bolachas,Cuetara,emb. 420 gr 0.97 -> 1.29 -> 25%\n",
      "nome:  Achocolatado em pó Nesquik,Nestlé,emb. 390 gr 3.99 -> 4.69 -> 15%\n",
      "nome:  Bolachas Cookies XL Choco,Milka,emb. 184 gr 2.19 -> 3.19 -> €1,00\n",
      "nome:  Chá Preto Yellow Label,Lipton,10 un 1.94 -> 2.59 -> 25%\n",
      "nome:  Biscoitos Amêndoa,Continente,emb. 350 gr 0.50 -> 0.99 -> 50%\n",
      "nome:  Caldo Molho Cervejeira,Knorr,8 un 1.99 -> 2.34 -> €0,35\n",
      "nome:  Café Lote Rossio Moagem Única,Nicola,emb. 250 gr 1.10 -> 1.69 -> 35%\n",
      "nome:  Chá Detox Saquetas,Ahmad,20 un 1.18 -> 1.82 -> 35%\n",
      "nome:  Salsichas Porco 100% sem Glúten Frasco,Izidoro,emb. 430 gr 2.99 -> 3.99 -> 25%\n",
      "nome:  Salsichas Peru 100% sem Glúten Frasco,Izidoro,emb. 430 gr 1.38 -> 2.75 -> 50%\n",
      "nome:  Doce Abóbora Temporada,Casa Mateus,emb. 325 gr 1.38 -> 2.75 -> 50%\n",
      "nome:  Pêssego Calda Metades,Continente,emb. 840 gr 2.17 -> 2.89 -> 25%\n",
      "nome:  Palitos Chocolate Leite,Continente,emb. 150 gr 1.09 -> 1.18 -> €0,09\n",
      "nome:  Tablete de Chocolate Negro Flor de Sal,Lindt,emb. 100 gr 0.79 -> 0.99 -> €0,20\n",
      "nome:  Tablete de Chocolate 70% Cacau,Regina,emb. 100 gr 2.17 -> 2.89 -> 25%\n",
      "nome:  Vinagre Balsâmico,Continente,emb. 250 ml 1.49 -> 1.99 -> 25%\n",
      "nome:  Bombons Nougat I Love,Milka,emb. 110 gr 2.09 -> 2.49 -> €0,40\n",
      "nome:  Molho Francesinha,Guloso,emb. 500 gr 2.24 -> 2.99 -> 25%\n",
      "nome:  Café Lote Selecto Aromático Moagem Única,Nicola,emb. 250 gr 1.94 -> 2.99 -> €1,05\n",
      "nome:  Café Lote Bocage Moagem Única,Nicola,emb. 250 gr 1.92 -> 2.95 -> 35%\n",
      "nome:  Café Lote Bocage Torra Intensa Moagem Única,Nicola,emb. 250 gr 1.79 -> 2.75 -> 35%\n",
      "nome:  Tablete Chocolate com Bolacha Chips Ahoy,Milka,emb. 100 gr 1.78 -> 2.74 -> 35%\n",
      "nome:  Azeite Extra Virgem Spray,Oliveira Da Serra,garrafa 0,20 lt 1.19 -> 1.59 -> 25%\n",
      "nome:  Óleo Alimentar Spray & Go,Fula,emb. 200 ml 1.99 -> 2.69 -> €0,70\n",
      "nome:  Bolachas Manteiga Palets Bretons,Continente,emb. 125 gr 1.49 -> 1.99 -> 25%\n",
      "nome:  Sanck Batatas Presunto,Pringles,emb. 190 gr 1.59 -> 1.99 -> €0,40\n",
      "nome:  Tablete Chocolate 55% Cacau com Laranja,Lacasa,emb. 100 gr 1.84 -> 2.49 -> 26%\n",
      "nome:  Leite Condensado Magro Cozido,Nestlé,emb. 387 gr 1.49 -> 1.99 -> 25%\n",
      "nome:  Bombons Sortidos Chocolate com Recheio,Continente,emb. 200 gr 1.27 -> 1.69 -> 25%\n",
      "nome:  Óleo de Girassol,Fula,emb. 3 lt 2.39 -> 2.99 -> €0,60\n",
      "nome:  Farinha de Coco Biológica,Seara,emb. 250 gr 4.49 -> 5.99 -> 25%\n",
      "nome:  Tablete de Chocolate Leite com Caramelo,Nestlé,emb. 100 gr 1.86 -> 2.49 -> €0,63\n",
      "nome:  Tablete de Chocolate Preto com Trufa,Nestlé,emb. 100 gr 1.04 -> 1.39 -> 25%\n",
      "nome:  Arroz Extra Médio Branqueado Sushi,Caçarola,emb. 1 kg 1.04 -> 1.39 -> 25%\n",
      "nome:  Óleo Alimentar,Fula,emb. 2 lt 1.49 -> 1.99 -> 25%\n",
      "nome:  Azeite Extra Virgem Oliveirinha,Oliveira Da Serra,garrafa 50 cl 3.19 -> 4.28 -> €1,09\n"
     ]
    }
   ],
   "source": [
    "caracteristicas : list = driver.find_elements_by_class_name('containerDescription')\n",
    "for i in range(1, len(caracteristicas)):\n",
    "    preco_com_desconto : str = driver.find_element_by_xpath(('/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[3]/div/div/div[{}]/div/div[1]/div[4]/div[1]/div[1]'.format(i)))\n",
    "    preco_com_desconto : str = preco_com_desconto.text.replace('€', '').replace('/un', '').replace(',', '.').replace(' ', '').replace('/kg','')\n",
    "    preco_sem_desconto : str = driver.find_element_by_xpath(('/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[3]/div/div/div[{}]/div/div[1]/div[6]/div[2]/div[1]/div[1]'.format(i)))\n",
    "    preco_sem_desconto : str = preco_sem_desconto.text.replace('€', '').replace('/un', '').replace(',', '.').replace(' ', '').replace('/kg','')\n",
    "    desconto : str = driver.find_element_by_xpath(('/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[3]/div/div/div[{}]/div/div[1]/div[6]/div[2]/div[2]/div[2]/span[3]').format(i)).text\n",
    "    print('nome: ', caracteristicas[i].text.replace('\\n', ','),preco_com_desconto , '->', preco_sem_desconto, '->', desconto)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'NoneType'>\n"
     ]
    }
   ],
   "source": [
    "cmp = driver.find_element_by_css_selector('.orderOptions > ul:nth-child(1) > li:nth-child(6) > div:nth-child(1)').click()\n",
    "#.orderOptions > ul:nth-child(1) > li:nth-child(6) > div:nth-child(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "ename": "StaleElementReferenceException",
     "evalue": "Message: The element reference of <div class=\"containerDescription\"> is stale; either the element is no longer attached to the DOM, it is not in the current frame context, or the document has been refreshed\n",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mStaleElementReferenceException\u001b[0m            Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-4-7b6967264146>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m     21\u001b[0m     \u001b[0mpreco_sem_desconto\u001b[0m \u001b[1;33m:\u001b[0m \u001b[0mstr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpreco_sem_desconto\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtext\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mreplace\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'€'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m''\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mreplace\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'/un'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m''\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mreplace\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m','\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'.'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mreplace\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m' '\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m''\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mreplace\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'/kg'\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m''\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     22\u001b[0m     \u001b[0mdesconto\u001b[0m \u001b[1;33m:\u001b[0m \u001b[0mstr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mdriver\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfind_element_by_xpath\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[3]/div/div/div[{}]/div/div[1]/div[6]/div[2]/div[2]/div[2]/span[3]'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mformat\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mi\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtext\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 23\u001b[1;33m     \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'nome: '\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcaracteristicas\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mi\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtext\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mreplace\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'\\n'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m','\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mpreco_com_desconto\u001b[0m \u001b[1;33m,\u001b[0m \u001b[1;34m'->'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mpreco_sem_desconto\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'->'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mdesconto\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\selenium\\webdriver\\remote\\webelement.py\u001b[0m in \u001b[0;36mtext\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m     74\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mtext\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     75\u001b[0m         \u001b[1;34m\"\"\"The text of the element.\"\"\"\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 76\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_execute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mCommand\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mGET_ELEMENT_TEXT\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'value'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     77\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     78\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mclick\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\selenium\\webdriver\\remote\\webelement.py\u001b[0m in \u001b[0;36m_execute\u001b[1;34m(self, command, params)\u001b[0m\n\u001b[0;32m    631\u001b[0m             \u001b[0mparams\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m{\u001b[0m\u001b[1;33m}\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    632\u001b[0m         \u001b[0mparams\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'id'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_id\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 633\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_parent\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexecute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mcommand\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    634\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    635\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mfind_element\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mby\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mBy\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mID\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\selenium\\webdriver\\remote\\webdriver.py\u001b[0m in \u001b[0;36mexecute\u001b[1;34m(self, driver_command, params)\u001b[0m\n\u001b[0;32m    319\u001b[0m         \u001b[0mresponse\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcommand_executor\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexecute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdriver_command\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    320\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mresponse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 321\u001b[1;33m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0merror_handler\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcheck_response\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mresponse\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    322\u001b[0m             response['value'] = self._unwrap_value(\n\u001b[0;32m    323\u001b[0m                 response.get('value', None))\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\selenium\\webdriver\\remote\\errorhandler.py\u001b[0m in \u001b[0;36mcheck_response\u001b[1;34m(self, response)\u001b[0m\n\u001b[0;32m    240\u001b[0m                 \u001b[0malert_text\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'alert'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'text'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    241\u001b[0m             \u001b[1;32mraise\u001b[0m \u001b[0mexception_class\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmessage\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mscreen\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstacktrace\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0malert_text\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 242\u001b[1;33m         \u001b[1;32mraise\u001b[0m \u001b[0mexception_class\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmessage\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mscreen\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstacktrace\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    243\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    244\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m_value_or_default\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mobj\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mdefault\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mStaleElementReferenceException\u001b[0m: Message: The element reference of <div class=\"containerDescription\"> is stale; either the element is no longer attached to the DOM, it is not in the current frame context, or the document has been refreshed\n"
     ]
    }
   ],
   "source": [
    "categorias : list = ['https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Mercearia(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=bio-saudavel(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Frescos(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Bebidas(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Lactic%C3%ADnio(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Congelados(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Beb%C3%A9(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Higiene(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=beleza(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Limpeza(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80',\n",
    "              'https://www.continente.pt/stores/continente/pt-pt/public/Pages/category.aspx?cat=Lazer(eCsf_WebProductCatalog_MegastoreContinenteOnline_Continente_EUR_Colombo_PT)#/?pl=80']\n",
    "driver.get(categorias[3])\n",
    "print('iniciar espera')\n",
    "time.sleep(100)\n",
    "print('espera concluida')\n",
    "cmp = driver.find_element_by_css_selector('.orderOptions > ul:nth-child(1) > li:nth-child(6) > div:nth-child(1)').click()\n",
    "caracteristicas : list = driver.find_elements_by_class_name('containerDescription')\n",
    "i : int;\n",
    "for i in range(1, len(caracteristicas)):\n",
    "    preco_com_desconto : str = driver.find_element_by_xpath(('/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[3]/div/div/div[{}]/div/div[1]/div[4]/div[1]/div[1]'.format(i)))\n",
    "    preco_com_desconto : str = preco_com_desconto.text.replace('€', '').replace('/un', '').replace(',', '.').replace(' ', '').replace('/kg','')\n",
    "    preco_sem_desconto : str = driver.find_element_by_xpath(('/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[3]/div/div/div[{}]/div/div[1]/div[6]/div[2]/div[1]/div[1]'.format(i)))\n",
    "    preco_sem_desconto : str = preco_sem_desconto.text.replace('€', '').replace('/un', '').replace(',', '.').replace(' ', '').replace('/kg','')\n",
    "    desconto : str = driver.find_element_by_xpath(('/html/body/form/div[3]/div[2]/div[1]/div[2]/table/tbody/tr/td/table/tbody/tr/td/div/div/div/div/div/div[2]/div[3]/div/div/div[{}]/div/div[1]/div[6]/div[2]/div[2]/div[2]/span[3]').format(i)).text\n",
    "    print('nome: ', caracteristicas[i].text.replace('\\n', ','),preco_com_desconto , '->', preco_sem_desconto, '->', desconto)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n",
      "['Antas de Pias Tinto', 'Antas De Pias', 'garrafa 75 cl', '€ 1,49 /un', '€ 1,99 /lt', '€ 1,89 /un', '€ 2,52 /lt', 'Desconto imediato: €0,40']\n",
      "Antas de Pias Tinto\n",
      "Antas De Pias\n",
      "garrafa 75 cl\n",
      "1.49\n",
      "1.89\n",
      "Desconto imediato: €0.40\n",
      "------\n",
      "1\n",
      "['Espumante Bruto Branco', 'Vinha Maria', 'garrafa 75 cl', '€ 3,99 /un', '€ 5,32 /lt', '€ 7,99 /un', '€ 10,65 /lt', 'Desconto imediato: €4,00']\n",
      "Espumante Bruto Branco\n",
      "Vinha Maria\n",
      "garrafa 75 cl\n",
      "3.99\n",
      "7.99\n",
      "Desconto imediato: €4.00\n",
      "------\n",
      "2\n",
      "['Lezíria Meio Seco Branco', 'Lezíria', 'garrafa 75 cl', '€ 1,19 /un', '€ 1,59 /lt', '€ 1,49 /un', '€ 1,99 /lt', 'Desconto imediato: €0,30']\n",
      "Lezíria Meio Seco Branco\n",
      "Lezíria\n",
      "garrafa 75 cl\n",
      "1.19\n",
      "1.49\n",
      "Desconto imediato: €0.30\n",
      "------\n",
      "3\n",
      "['Espumante DOC Rosé', 'Terras Do Demo', 'garrafa 75 cl', '€ 6,99 /un', '€ 9,32 /lt', '€ 7,49 /un', '€ 9,99 /lt', 'Desconto imediato: €0,50']\n",
      "Espumante DOC Rosé\n",
      "Terras Do Demo\n",
      "garrafa 75 cl\n",
      "6.99\n",
      "7.49\n",
      "Desconto imediato: €0.50\n",
      "------\n",
      "4\n",
      "['Lezíria Tinto', 'Lezíria', 'garrafa 75 cl', '€ 1,19 /un', '€ 1,59 /lt', '€ 1,49 /un', '€ 1,99 /lt', 'Desconto imediato: €0,30']\n",
      "Lezíria Tinto\n",
      "Lezíria\n",
      "garrafa 75 cl\n",
      "1.19\n",
      "1.49\n",
      "Desconto imediato: €0.30\n",
      "------\n",
      "5\n",
      "['Dom Rosato Vinho Rosé Free', 'Dom Rosato', 'garrafa 75 cl', '€ 2,25 /un', '€ 3,00 /lt', '€ 3,49 /un', '€ 4,65 /lt', 'Desconto imediato: €1,24']\n",
      "Dom Rosato Vinho Rosé Free\n",
      "Dom Rosato\n",
      "garrafa 75 cl\n",
      "2.25\n",
      "3.49\n",
      "Desconto imediato: €1.24\n",
      "------\n",
      "6\n",
      "['Espumante Rocca Glorioso Doce', 'Rocca Gloriosa', 'garrafa 75 cl', '€ 2,09 /un', '€ 2,79 /lt', '€ 2,99 /un', '€ 3,99 /lt', 'Desconto imediato: €0,90']\n",
      "Espumante Rocca Glorioso Doce\n",
      "Rocca Gloriosa\n",
      "garrafa 75 cl\n",
      "2.09\n",
      "2.99\n",
      "Desconto imediato: €0.90\n",
      "------\n",
      "7\n",
      "['Espumante Cordón Negro Reserva', 'Freixenet', 'garrafa 75 cl', '€ 5,99 /un', '€ 7,99 /lt', '€ 6,99 /un', '€ 9,32 /lt', 'Desconto imediato: €1,00']\n",
      "Espumante Cordón Negro Reserva\n",
      "Freixenet\n",
      "garrafa 75 cl\n",
      "5.99\n",
      "6.99\n",
      "Desconto imediato: €1.00\n",
      "------\n",
      "8\n",
      "['Lambrusco Riobello Branco', '', 'garrafa 75 cl', '€ 2,65 /un', '€ 3,53 /lt', '€ 4,89 /un', '€ 6,52 /lt', 'Desconto imediato: €2,24']\n",
      "Lambrusco Riobello Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "2.65\n",
      "4.89\n",
      "Desconto imediato: €2.24\n",
      "------\n",
      "9\n",
      "['Espumante Meio Seco Reserva', 'Murganheira', 'garrafa 75 cl', '€ 7,99 /un', '€ 10,65 /lt', '€ 9,49 /un', '€ 12,65 /lt', 'Desconto imediato: €1,50']\n",
      "Espumante Meio Seco Reserva\n",
      "Murganheira\n",
      "garrafa 75 cl\n",
      "7.99\n",
      "9.49\n",
      "Desconto imediato: €1.50\n",
      "------\n",
      "10\n",
      "['Albenaz Jardim Secreto Premium DOC Vinho Verde Branco', '', 'garrafa 75 cl', '€ 3,89 /un', '€ 5,19 /lt', '€ 12,99 /un', '€ 17,32 /lt', 'Desconto imediato: €9,10']\n",
      "Albenaz Jardim Secreto Premium DOC Vinho Verde Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "3.89\n",
      "12.99\n",
      "Desconto imediato: €9.10\n",
      "------\n",
      "11\n",
      "['Riobello Lambrusco Rosado', 'Riobello', 'garrafa 75 cl', '€ 2,65 /un', '€ 3,53 /lt', '€ 4,89 /un', '€ 6,52 /lt', 'Desconto imediato: €2,24']\n",
      "Riobello Lambrusco Rosado\n",
      "Riobello\n",
      "garrafa 75 cl\n",
      "2.65\n",
      "4.89\n",
      "Desconto imediato: €2.24\n",
      "------\n",
      "12\n",
      "['Espumante Rocca Gloriosa Moscato', 'Rocca Gloriosa', 'garrafa 75 cl', '€ 2,39 /un', '€ 3,19 /lt', '€ 2,99 /un', '€ 3,99 /lt', 'Desconto imediato: €0,60']\n",
      "Espumante Rocca Gloriosa Moscato\n",
      "Rocca Gloriosa\n",
      "garrafa 75 cl\n",
      "2.39\n",
      "2.99\n",
      "Desconto imediato: €0.60\n",
      "------\n",
      "13\n",
      "['Espumante Elysée Brut', '', 'garrafa 75 cl', '€ 1,99 /un', '€ 2,65 /lt', '€ 3,09 /un', '€ 4,12 /lt', 'Desconto imediato: €1,10']\n",
      "Espumante Elysée Brut\n",
      "\n",
      "garrafa 75 cl\n",
      "1.99\n",
      "3.09\n",
      "Desconto imediato: €1.10\n",
      "------\n",
      "14\n",
      "['Champanhe Bruto', 'Kryer', 'garrafa 75 cl', '€ 19,99 /un', '€ 26,65 /lt', '€ 39,99 /un', '€ 53,32 /lt', 'Desconto imediato: €20,00']\n",
      "Champanhe Bruto\n",
      "Kryer\n",
      "garrafa 75 cl\n",
      "19.99\n",
      "39.99\n",
      "Desconto imediato: €20.00\n",
      "------\n",
      "15\n",
      "['Espumante Tinto Bruto', 'Aliança', 'garrafa 75 cl', '€ 5,51 /un', '€ 7,35 /lt', '€ 6,49 /un', '€ 8,65 /lt', 'Desconto imediato: €0,98']\n",
      "Espumante Tinto Bruto\n",
      "Aliança\n",
      "garrafa 75 cl\n",
      "5.51\n",
      "6.49\n",
      "Desconto imediato: €0.98\n",
      "------\n",
      "16\n",
      "['Espumante Reserva Bruto', 'Murganheira', 'garrafa 75 cl', '€ 8,49 /un', '€ 11,32 /lt', '€ 9,99 /un', '€ 13,32 /lt', 'Desconto imediato: €1,50']\n",
      "Espumante Reserva Bruto\n",
      "Murganheira\n",
      "garrafa 75 cl\n",
      "8.49\n",
      "9.99\n",
      "Desconto imediato: €1.50\n",
      "------\n",
      "17\n",
      "['Espumante DUC Paris Doce', '', 'garrafa 75 cl', '€ 2,49 /un', '€ 3,32 /lt', '€ 4,99 /un', '€ 6,65 /lt', 'Desconto imediato: €2,50']\n",
      "Espumante DUC Paris Doce\n",
      "\n",
      "garrafa 75 cl\n",
      "2.49\n",
      "4.99\n",
      "Desconto imediato: €2.50\n",
      "------\n",
      "18\n",
      "['Alambre Moscatel Roxo do Setúbal', 'Alambre', 'garrafa 75 cl', '€ 9,69 /un', '€ 12,92 /lt', '€ 12,99 /un', '€ 17,32 /lt', 'Desconto imediato: €3,30']\n",
      "Alambre Moscatel Roxo do Setúbal\n",
      "Alambre\n",
      "garrafa 75 cl\n",
      "9.69\n",
      "12.99\n",
      "Desconto imediato: €3.30\n",
      "------\n",
      "19\n",
      "['Espumante Rocca Glorioso Bruto', 'Rocca Gloriosa', 'garrafa 75 cl', '€ 2,09 /un', '€ 2,79 /lt', '€ 2,99 /un', '€ 3,99 /lt', 'Desconto imediato: €0,90']\n",
      "Espumante Rocca Glorioso Bruto\n",
      "Rocca Gloriosa\n",
      "garrafa 75 cl\n",
      "2.09\n",
      "2.99\n",
      "Desconto imediato: €0.90\n",
      "------\n",
      "20\n",
      "['Ermelinda Tinto', 'Ermelinda', 'Bag In Box 3 lt', '€ 5,99 /un', '€ 2,00 /lt', '€ 7,49 /un', '€ 2,50 /lt', 'Desconto imediato: €1,50']\n",
      "Ermelinda Tinto\n",
      "Ermelinda\n",
      "Bag In Box 3 lt\n",
      "5.99\n",
      "7.49\n",
      "Desconto imediato: €1.50\n",
      "------\n",
      "21\n",
      "['Só Pias Tinto', 'Só Pias', 'garrafa 75 cl', '€ 1,59 /un', '€ 2,12 /lt', '€ 1,99 /un', '€ 2,65 /lt', 'Desconto imediato: €0,40']\n",
      "Só Pias Tinto\n",
      "Só Pias\n",
      "garrafa 75 cl\n",
      "1.59\n",
      "1.99\n",
      "Desconto imediato: €0.40\n",
      "------\n",
      "22\n",
      "['Quinta Da Aveleda Loureiro E Alvarinho DOC Vinho Verde Branco', '', 'garrafa 75 cl', '€ 3,69 /un', '€ 4,92 /lt', '€ 4,99 /un', '€ 6,65 /lt', 'Desconto imediato: €1,30']\n",
      "Quinta Da Aveleda Loureiro E Alvarinho DOC Vinho Verde Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "3.69\n",
      "4.99\n",
      "Desconto imediato: €1.30\n",
      "------\n",
      "23\n",
      "['Espumante Bruto Blanc de Blanc', 'Marquês De Marialva', 'garrafa 75 cl', '€ 3,99 /un', '€ 5,32 /lt', '€ 4,99 /un', '€ 6,65 /lt', 'Desconto imediato: €1,00']\n",
      "Espumante Bruto Blanc de Blanc\n",
      "Marquês De Marialva\n",
      "garrafa 75 cl\n",
      "3.99\n",
      "4.99\n",
      "Desconto imediato: €1.00\n",
      "------\n",
      "24\n",
      "['Lencastre DOC Vinho Verde Branco', '', 'garrafa 75 cl', '€ 2,99 /un', '€ 3,99 /lt', '€ 6,99 /un', '€ 9,32 /lt', 'Desconto imediato: €4,00']\n",
      "Lencastre DOC Vinho Verde Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "2.99\n",
      "6.99\n",
      "Desconto imediato: €4.00\n",
      "------\n",
      "25\n",
      "['Lezíria Meio Seco Rosé', 'Lezíria', 'garrafa 75 cl', '€ 1,19 /un', '€ 1,59 /lt', '€ 1,49 /un', '€ 1,99 /lt', 'Desconto imediato: €0,30']\n",
      "Lezíria Meio Seco Rosé\n",
      "Lezíria\n",
      "garrafa 75 cl\n",
      "1.19\n",
      "1.49\n",
      "Desconto imediato: €0.30\n",
      "------\n",
      "26\n",
      "['Espumante Bruto Blanc de Noir', 'Marquês De Marialva', 'garrafa 75 cl', '€ 5,99 /un', '€ 7,99 /lt', '€ 6,99 /un', '€ 9,32 /lt', 'Desconto imediato: €1,00']\n",
      "Espumante Bruto Blanc de Noir\n",
      "Marquês De Marialva\n",
      "garrafa 75 cl\n",
      "5.99\n",
      "6.99\n",
      "Desconto imediato: €1.00\n",
      "------\n",
      "27\n",
      "['Champanhe Gruet Bruto', '', 'garrafa 75 cl', '€ 17,99 /un', '€ 23,99 /lt', '€ 39,99 /un', '€ 53,32 /lt', 'Desconto imediato: €22,00']\n",
      "Champanhe Gruet Bruto\n",
      "\n",
      "garrafa 75 cl\n",
      "17.99\n",
      "39.99\n",
      "Desconto imediato: €22.00\n",
      "------\n",
      "28\n",
      "['Espumante DUC Paris Brutos', '', 'garrafa 75 cl', '€ 2,49 /un', '€ 3,32 /lt', '€ 4,99 /un', '€ 6,65 /lt', 'Desconto imediato: €2,50']\n",
      "Espumante DUC Paris Brutos\n",
      "\n",
      "garrafa 75 cl\n",
      "2.49\n",
      "4.99\n",
      "Desconto imediato: €2.50\n",
      "------\n",
      "29\n",
      "['Ponte de Lima Loureiro Branco', 'Ponte De Lima', 'garrafa 75 cl', '€ 2,89 /un', '€ 3,85 /lt', '€ 3,89 /un', '€ 5,19 /lt', 'Desconto imediato: €1,00']\n",
      "Ponte de Lima Loureiro Branco\n",
      "Ponte De Lima\n",
      "garrafa 75 cl\n",
      "2.89\n",
      "3.89\n",
      "Desconto imediato: €1.00\n",
      "------\n",
      "30\n",
      "['Adega Grande Frisante Vinho Branco', 'Adega Grande', 'garrafa 75 cl', '€ 1,35 /un', '€ 1,80 /lt', '€ 1,69 /un', '€ 2,25 /lt', 'Desconto imediato: €0,34']\n",
      "Adega Grande Frisante Vinho Branco\n",
      "Adega Grande\n",
      "garrafa 75 cl\n",
      "1.35\n",
      "1.69\n",
      "Desconto imediato: €0.34\n",
      "------\n",
      "31\n",
      "['Terras Felgueiras Espadeiro DOC Vinho Verde Rosé', '', 'garrafa 75 cl', '€ 1,79 /un', '€ 2,39 /lt', '€ 2,79 /un', '€ 3,72 /lt', 'Desconto imediato: €1,00']\n",
      "Terras Felgueiras Espadeiro DOC Vinho Verde Rosé\n",
      "\n",
      "garrafa 75 cl\n",
      "1.79\n",
      "2.79\n",
      "Desconto imediato: €1.00\n",
      "------\n",
      "32\n",
      "['Crista de Galo Rosé', 'Crista De Galo', 'garrafa 75 cl', '€ 1,39 /un', '€ 1,85 /lt', '€ 1,89 /un', '€ 2,52 /lt', 'Desconto imediato: €0,50']\n",
      "Crista de Galo Rosé\n",
      "Crista De Galo\n",
      "garrafa 75 cl\n",
      "1.39\n",
      "1.89\n",
      "Desconto imediato: €0.50\n",
      "------\n",
      "33\n",
      "['Lezíria Tinto', 'Lezíria', 'Bag In Box 5 lt', '€ 6,99 /un', '€ 1,40 /lt', '€ 7,69 /un', '€ 1,54 /lt', 'Desconto imediato: €0,70']\n",
      "Lezíria Tinto\n",
      "Lezíria\n",
      "Bag In Box 5 lt\n",
      "6.99\n",
      "7.69\n",
      "Desconto imediato: €0.70\n",
      "------\n",
      "34\n",
      "['Lezíria Branco', 'Lezíria', 'Bag In Box 5 lt', '€ 6,99 /un', '€ 1,40 /lt', '€ 7,69 /un', '€ 1,54 /lt', 'Desconto imediato: €0,70']\n",
      "Lezíria Branco\n",
      "Lezíria\n",
      "Bag In Box 5 lt\n",
      "6.99\n",
      "7.69\n",
      "Desconto imediato: €0.70\n",
      "------\n",
      "35\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Crista de Galo Branco', 'Crista De Galo', 'garrafa 75 cl', '€ 1,39 /un', '€ 1,85 /lt', '€ 1,89 /un', '€ 2,52 /lt', 'Desconto imediato: €0,50']\n",
      "Crista de Galo Branco\n",
      "Crista De Galo\n",
      "garrafa 75 cl\n",
      "1.39\n",
      "1.89\n",
      "Desconto imediato: €0.50\n",
      "------\n",
      "36\n",
      "['Ponte de Lima Adamado Branco', 'Ponte De Lima', 'garrafa 75 cl', '€ 2,39 /un', '€ 3,19 /lt', '€ 3,19 /un', '€ 4,25 /lt', 'Desconto imediato: €0,80']\n",
      "Ponte de Lima Adamado Branco\n",
      "Ponte De Lima\n",
      "garrafa 75 cl\n",
      "2.39\n",
      "3.19\n",
      "Desconto imediato: €0.80\n",
      "------\n",
      "37\n",
      "['Flor De Viseu Selection DOC Dão Branco', '', 'garrafa 75 cl', '€ 3,29 /un', '€ 4,39 /lt', '€ 7,39 /un', '€ 9,85 /lt', 'Desconto imediato: €4,10']\n",
      "Flor De Viseu Selection DOC Dão Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "3.29\n",
      "7.39\n",
      "Desconto imediato: €4.10\n",
      "------\n",
      "38\n",
      "['Pacheca Superior DOC Douro Tinto', '', 'garrafa 75 cl', '€ 7,99 /un', '€ 10,65 /lt', '€ 12,49 /un', '€ 16,65 /lt', 'Desconto imediato: €4,50']\n",
      "Pacheca Superior DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "7.99\n",
      "12.49\n",
      "Desconto imediato: €4.50\n",
      "------\n",
      "39\n",
      "['Meio Século Premium Tinto Douro', 'Meio Século', 'garrafa 75 cl', '€ 3,99 /un', '€ 5,32 /lt', '€ 9,99 /un', '€ 13,32 /lt', 'Desconto imediato: €6,00']\n",
      "Meio Século Premium Tinto Douro\n",
      "Meio Século\n",
      "garrafa 75 cl\n",
      "3.99\n",
      "9.99\n",
      "Desconto imediato: €6.00\n",
      "------\n",
      "40\n",
      "['Dikas DOC Douro Tinto', '', 'garrafa 75cl', '€ 2,99 /un', '€ 3,99 /lt', '€ 7,49 /un', '€ 9,99 /lt', 'Desconto imediato: €4,50']\n",
      "Dikas DOC Douro Tinto\n",
      "\n",
      "garrafa 75cl\n",
      "2.99\n",
      "7.49\n",
      "Desconto imediato: €4.50\n",
      "------\n",
      "41\n",
      "['Dikas DOC Dão Tinto', '', 'garrafa 75 cl', '€ 2,99 /un', '€ 3,99 /lt', '€ 7,49 /un', '€ 9,99 /lt', 'Desconto imediato: €4,50']\n",
      "Dikas DOC Dão Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "2.99\n",
      "7.49\n",
      "Desconto imediato: €4.50\n",
      "------\n",
      "42\n",
      "['Altano DOC Douro Tinto', '', 'garrafa 75 cl', '€ 3,29 /un', '€ 4,39 /lt', '€ 4,49 /un', '€ 5,99 /lt', 'Desconto imediato: €1,20']\n",
      "Altano DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "3.29\n",
      "4.49\n",
      "Desconto imediato: €1.20\n",
      "------\n",
      "43\n",
      "['Quadrifolia By Vallado DOC Douro Tinto', '', 'garrafa 75 cl', '€ 3,49 /un', '€ 4,65 /lt', '€ 6,99 /un', '€ 9,32 /lt', 'Desconto imediato: €3,50']\n",
      "Quadrifolia By Vallado DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "3.49\n",
      "6.99\n",
      "Desconto imediato: €3.50\n",
      "------\n",
      "44\n",
      "['Xisto Preto Reserva DOC Douro Tinto', '', 'garrafa 75 cl', '€ 3,99 /un', '€ 5,32 /lt', '€ 9,99 /un', '€ 13,32 /lt', 'Desconto imediato: €6,00']\n",
      "Xisto Preto Reserva DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "3.99\n",
      "9.99\n",
      "Desconto imediato: €6.00\n",
      "------\n",
      "45\n",
      "['Vinha Do Bispado Reserva DOC Douro Tinto', '', 'garrafa 75 cl', '€ 8,39 /un', '€ 11,19 /lt', '€ 13,99 /un', '€ 18,65 /lt', 'Desconto imediato: €5,60']\n",
      "Vinha Do Bispado Reserva DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "8.39\n",
      "13.99\n",
      "Desconto imediato: €5.60\n",
      "------\n",
      "46\n",
      "['Cancellus Regional Duriense Branco', '', 'garrafa 75 cl', '€ 1,89 /un', '€ 2,52 /lt', '€ 2,99 /un', '€ 3,99 /lt', 'Desconto imediato: €1,10']\n",
      "Cancellus Regional Duriense Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "1.89\n",
      "2.99\n",
      "Desconto imediato: €1.10\n",
      "------\n",
      "47\n",
      "['Borges Duas Encostas Vinhas Velhas Signature DOC Dão Tinto', '', 'garrafa 75 cl', '€ 4,79 /un', '€ 6,39 /lt', '€ 15,99 /un', '€ 21,32 /lt', 'Desconto imediato: €11,20']\n",
      "Borges Duas Encostas Vinhas Velhas Signature DOC Dão Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "4.79\n",
      "15.99\n",
      "Desconto imediato: €11.20\n",
      "------\n",
      "48\n",
      "['Albenaz Escadaria Maior Premium DOC Douro Tinto', '', 'garrafa 75 cl', '€ 3,89 /un', '€ 5,19 /lt', '€ 12,99 /un', '€ 17,32 /lt', 'Desconto imediato: €9,10']\n",
      "Albenaz Escadaria Maior Premium DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "3.89\n",
      "12.99\n",
      "Desconto imediato: €9.10\n",
      "------\n",
      "49\n",
      "['Passa Pequena DOC Douro Branco', '', 'garrafa 75 cl', '€ 6,99 /un', '€ 9,32 /lt', '€ 12,99 /un', '€ 17,32 /lt', 'Desconto imediato: €6,00']\n",
      "Passa Pequena DOC Douro Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "6.99\n",
      "12.99\n",
      "Desconto imediato: €6.00\n",
      "------\n",
      "50\n",
      "['Pedra Cancela Selecção Do Enólogo DOC Dão Tinto', '', 'garrafa 75 cl', '€ 4,19 /un', '€ 5,59 /lt', '€ 6,99 /un', '€ 9,32 /lt', 'Desconto imediato: €2,80']\n",
      "Pedra Cancela Selecção Do Enólogo DOC Dão Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "4.19\n",
      "6.99\n",
      "Desconto imediato: €2.80\n",
      "------\n",
      "51\n",
      "['Flor De Viseu Tradition DOC Dão Tinto', '', 'garrafa 75 cl', '€ 3,75 /un', '€ 5,00 /lt', '€ 8,39 /un', '€ 11,19 /lt', 'Desconto imediato: €4,64']\n",
      "Flor De Viseu Tradition DOC Dão Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "3.75\n",
      "8.39\n",
      "Desconto imediato: €4.64\n",
      "------\n",
      "52\n",
      "['Flor De Viseu Selection DOC Dão Tinto', '', 'garrafa 75 cl', '€ 3,29 /un', '€ 4,39 /lt', '€ 7,39 /un', '€ 9,85 /lt', 'Desconto imediato: €4,10']\n",
      "Flor De Viseu Selection DOC Dão Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "3.29\n",
      "7.39\n",
      "Desconto imediato: €4.10\n",
      "------\n",
      "53\n",
      "['Aveleda Alvarinho Colheita Selecionada Regional Minho Branco', '', 'garrafa 75 cl', '€ 3,69 /un', '€ 4,92 /lt', '€ 4,99 /un', '€ 6,65 /lt', 'Desconto imediato: €1,30']\n",
      "Aveleda Alvarinho Colheita Selecionada Regional Minho Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "3.69\n",
      "4.99\n",
      "Desconto imediato: €1.30\n",
      "------\n",
      "54\n",
      "['Passa Pequena DOC Douro Tinto', '', 'garrafa 75 cl', '€ 6,99 /un', '€ 9,32 /lt', '€ 12,99 /un', '€ 17,32 /lt', 'Desconto imediato: €6,00']\n",
      "Passa Pequena DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "6.99\n",
      "12.99\n",
      "Desconto imediato: €6.00\n",
      "------\n",
      "55\n",
      "['Encostas de Peso DOC Tinto Douro', 'Encostas De Peso', 'garrafa 75 cl', '€ 2,99 /un', '€ 3,99 /lt', '€ 5,99 /un', '€ 7,99 /lt', 'Desconto imediato: €3,00']\n",
      "Encostas de Peso DOC Tinto Douro\n",
      "Encostas De Peso\n",
      "garrafa 75 cl\n",
      "2.99\n",
      "5.99\n",
      "Desconto imediato: €3.00\n",
      "------\n",
      "56\n",
      "['Vale D.Maria Rufo DOC Douro Tinto', '', 'garrafa 75 cl', '€ 7,49 /un', '€ 9,99 /lt', '€ 9,99 /un', '€ 13,32 /lt', 'Desconto imediato: €2,50']\n",
      "Vale D.Maria Rufo DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "7.49\n",
      "9.99\n",
      "Desconto imediato: €2.50\n",
      "------\n",
      "57\n",
      "['Pacheca DOC Douro Rosé', '', 'garrafa 75 cl', '€ 3,99 /un', '€ 5,32 /lt', '€ 5,59 /un', '€ 7,45 /lt', 'Desconto imediato: €1,60']\n",
      "Pacheca DOC Douro Rosé\n",
      "\n",
      "garrafa 75 cl\n",
      "3.99\n",
      "5.59\n",
      "Desconto imediato: €1.60\n",
      "------\n",
      "58\n",
      "['Cooperativa Agrícola Felgueiras DOC Vinho Verde Branco', '', 'garrafa 75 cl', '€ 1,69 /un', '€ 2,25 /lt', '€ 2,29 /un', '€ 3,05 /lt', 'Desconto imediato: €0,60']\n",
      "Cooperativa Agrícola Felgueiras DOC Vinho Verde Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "1.69\n",
      "2.29\n",
      "Desconto imediato: €0.60\n",
      "------\n",
      "59\n",
      "['Via Latina DOC Vinho Verde Branco', '', 'garrafa 75 cl', '€ 2,19 /un', '€ 2,92 /lt', '€ 2,99 /un', '€ 3,99 /lt', 'Desconto imediato: €0,80']\n",
      "Via Latina DOC Vinho Verde Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "2.19\n",
      "2.99\n",
      "Desconto imediato: €0.80\n",
      "------\n",
      "60\n",
      "['Cabriz Colheita Seleccionada DOC Dão Branco', '', 'garrafa 75 cl', '€ 3,19 /un', '€ 4,25 /lt', '€ 4,49 /un', '€ 5,99 /lt', 'Desconto imediato: €1,30']\n",
      "Cabriz Colheita Seleccionada DOC Dão Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "3.19\n",
      "4.49\n",
      "Desconto imediato: €1.30\n",
      "------\n",
      "61\n",
      "['Cabriz Colheita Seleccionada DOC Dão Tinto', '', 'garrafa 75 cl', '€ 3,19 /un', '€ 4,25 /lt', '€ 4,49 /un', '€ 5,99 /lt', 'Desconto imediato: €1,30']\n",
      "Cabriz Colheita Seleccionada DOC Dão Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "3.19\n",
      "4.49\n",
      "Desconto imediato: €1.30\n",
      "------\n",
      "62\n",
      "['Vinha Do Bispado DOC Douro Branco', '', 'garrafa 75 cl', '€ 4,79 /un', '€ 6,39 /lt', '€ 8,79 /un', '€ 11,72 /lt', 'Desconto imediato: €4,00']\n",
      "Vinha Do Bispado DOC Douro Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "4.79\n",
      "8.79\n",
      "Desconto imediato: €4.00\n",
      "------\n",
      "63\n",
      "['Vinha Do Bispado DOC Douro Tinto', '', 'garrafa 75 cl', '€ 4,79 /un', '€ 6,39 /lt', '€ 8,79 /un', '€ 11,72 /lt', 'Desconto imediato: €4,00']\n",
      "Vinha Do Bispado DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "4.79\n",
      "8.79\n",
      "Desconto imediato: €4.00\n",
      "------\n",
      "64\n",
      "['Dona Carla Premium DOC Douro Tinto', '', 'garrafa 75 cl', '€ 3,99 /un', '€ 5,32 /lt', '€ 9,99 /un', '€ 13,32 /lt', 'Desconto imediato: €6,00']\n",
      "Dona Carla Premium DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "3.99\n",
      "9.99\n",
      "Desconto imediato: €6.00\n",
      "------\n",
      "65\n",
      "[\"Castello D'Alba DOC Reserva Branco Douro\", \"Castello D' Alba\", 'garrafa 75 cl', '€ 5,19 /un', '€ 6,92 /lt', '€ 6,99 /un', '€ 9,32 /lt', 'Desconto imediato: €1,80']\n",
      "Castello D'Alba DOC Reserva Branco Douro\n",
      "Castello D' Alba\n",
      "garrafa 75 cl\n",
      "5.19\n",
      "6.99\n",
      "Desconto imediato: €1.80\n",
      "------\n",
      "66\n",
      "['Flor De Penalva Premium DOC Dão Tinto', '', 'garrafa 75 cl', '€ 3,89 /un', '€ 5,19 /lt', '€ 12,99 /un', '€ 17,32 /lt', 'Desconto imediato: €9,10']\n",
      "Flor De Penalva Premium DOC Dão Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "3.89\n",
      "12.99\n",
      "Desconto imediato: €9.10\n",
      "------\n",
      "67\n",
      "['Flor De Penalva DOC Dão Tinto', '', 'garrafa 75 cl', '€ 2,79 /un', '€ 3,72 /lt', '€ 7,99 /un', '€ 10,65 /lt', 'Desconto imediato: €5,20']\n",
      "Flor De Penalva DOC Dão Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "2.79\n",
      "7.99\n",
      "Desconto imediato: €5.20\n",
      "------\n",
      "68\n",
      "['Flor De Penalva DOC Dão Branco', '', 'garrafa 75 cl', '€ 2,79 /un', '€ 3,72 /lt', '€ 7,99 /un', '€ 10,65 /lt', 'Desconto imediato: €5,20']\n",
      "Flor De Penalva DOC Dão Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "2.79\n",
      "7.99\n",
      "Desconto imediato: €5.20\n",
      "------\n",
      "69\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[\"Castello D'Alba DOC Vinhas Velhas Tinto Douro\", \"Castello D' Alba\", 'garrafa 75 cl', '€ 9,65 /un', '€ 12,87 /lt', '€ 12,90 /un', '€ 17,20 /lt', 'Desconto imediato: €3,25']\n",
      "Castello D'Alba DOC Vinhas Velhas Tinto Douro\n",
      "Castello D' Alba\n",
      "garrafa 75 cl\n",
      "9.65\n",
      "12.90\n",
      "Desconto imediato: €3.25\n",
      "------\n",
      "70\n",
      "['Flor De Penalva Reserva DOC Dão Tinto', '', 'garrafa 75 cl', '€ 3,49 /un', '€ 4,65 /lt', '€ 9,99 /un', '€ 13,32 /lt', 'Desconto imediato: €6,50']\n",
      "Flor De Penalva Reserva DOC Dão Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "3.49\n",
      "9.99\n",
      "Desconto imediato: €6.50\n",
      "------\n",
      "71\n",
      "['Quinta Do Vale Da Ribeira Premium DOC Dão Tinto', '', 'garrafa 75 cl', '€ 3,99 /un', '€ 5,32 /lt', '€ 9,99 /un', '€ 13,32 /lt', 'Desconto imediato: €6,00']\n",
      "Quinta Do Vale Da Ribeira Premium DOC Dão Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "3.99\n",
      "9.99\n",
      "Desconto imediato: €6.00\n",
      "------\n",
      "72\n",
      "['Pedra Do Gato Premium DOC Dão Tinto', '', 'garrafa 75 cl', '€ 6,49 /un', '€ 8,65 /lt', '€ 12,99 /un', '€ 17,32 /lt', 'Desconto imediato: €6,50']\n",
      "Pedra Do Gato Premium DOC Dão Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "6.49\n",
      "12.99\n",
      "Desconto imediato: €6.50\n",
      "------\n",
      "73\n",
      "['Quinta dos Carvalhais DOC Tinto Dão', 'Quinta Carvalhais', 'garrafa 75 cl', '€ 6,99 /un', '€ 9,32 /lt', '€ 7,99 /un', '€ 10,65 /lt', 'Desconto imediato: €1,00']\n",
      "Quinta dos Carvalhais DOC Tinto Dão\n",
      "Quinta Carvalhais\n",
      "garrafa 75 cl\n",
      "6.99\n",
      "7.99\n",
      "Desconto imediato: €1.00\n",
      "------\n",
      "74\n",
      "['Ventozelo DOC Tinto Reserva Douro', 'Ventozelo', 'garrafa 75 cl', '€ 7,69 /un', '€ 10,25 /lt', '€ 9,99 /un', '€ 13,32 /lt', 'Desconto imediato: €2,30']\n",
      "Ventozelo DOC Tinto Reserva Douro\n",
      "Ventozelo\n",
      "garrafa 75 cl\n",
      "7.69\n",
      "9.99\n",
      "Desconto imediato: €2.30\n",
      "------\n",
      "75\n",
      "['R De Romaneira Regional Duriense Tinto', '', 'garrafa 75 cl', '€ 7,19 /un', '€ 9,59 /lt', '€ 8,99 /un', '€ 11,99 /lt', 'Desconto imediato: €1,80']\n",
      "R De Romaneira Regional Duriense Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "7.19\n",
      "8.99\n",
      "Desconto imediato: €1.80\n",
      "------\n",
      "76\n",
      "['Flor De Tecedeiras DOC Douro Tinto', '', 'garrafa 75 cl', '€ 8,49 /un', '€ 11,32 /lt', '€ 9,99 /un', '€ 13,32 /lt', 'Desconto imediato: €1,50']\n",
      "Flor De Tecedeiras DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "8.49\n",
      "9.99\n",
      "Desconto imediato: €1.50\n",
      "------\n",
      "77\n",
      "['Espumante Reserva Bruto', 'Raposeira', 'garrafa 75 cl', '€ 4,99 /un', '€ 6,65 /lt', '€ 6,49 /un', '€ 8,65 /lt', 'Desconto imediato: €1,50']\n",
      "Espumante Reserva Bruto\n",
      "Raposeira\n",
      "garrafa 75 cl\n",
      "4.99\n",
      "6.49\n",
      "Desconto imediato: €1.50\n",
      "------\n",
      "78\n",
      "['Lapadas Branco Frisante', 'Lapadas', 'garrafa 75 cl', '€ 1,49 /un', '€ 1,99 /lt', '€ 2,09 /un', '€ 2,79 /lt', 'Desconto imediato: €0,60']\n",
      "Lapadas Branco Frisante\n",
      "Lapadas\n",
      "garrafa 75 cl\n",
      "1.49\n",
      "2.09\n",
      "Desconto imediato: €0.60\n",
      "------\n",
      "79\n",
      "['Altano Reserva DOC Douro Tinto', '', 'garrafa 75 cl', '€ 8,99 /un', '€ 11,99 /lt', '€ 10,49 /un', '€ 13,99 /lt', 'Desconto imediato: €1,50']\n",
      "Altano Reserva DOC Douro Tinto\n",
      "\n",
      "garrafa 75 cl\n",
      "8.99\n",
      "10.49\n",
      "Desconto imediato: €1.50\n",
      "------\n"
     ]
    }
   ],
   "source": [
    "p_db = []\n",
    "prods : list = driver.find_elements_by_class_name('productItem');\n",
    "i : int;\n",
    "for i in range(len(prods)):\n",
    "    print(i)\n",
    "    caracteristicas : list = prods[i].text.split('\\n');\n",
    "    if len(caracteristicas) < 8:\n",
    "        caracteristicas[1:1] = [''];\n",
    "    print(caracteristicas)\n",
    "    nome_prod   : str = caracteristicas[0];\n",
    "    marca       : str = caracteristicas[1];\n",
    "    desc        : str = caracteristicas[2];\n",
    "    prec_desc   : str = caracteristicas[3].replace('/un', '').replace('€', '').replace(',','.').replace(' ','');\n",
    "    prec_s_desc : str = caracteristicas[5].replace('/un', '').replace('€', '').replace(',','.').replace(' ','');\n",
    "    desc_imd    : str = caracteristicas[7].replace(',','.');\n",
    "    p_db.append([nome_prod, marca, desc, prec_desc, prec_s_desc, desc_imd])\n",
    "    #print(type(caracteristicas), caracteristicas);\n",
    "    print(nome_prod)\n",
    "    print(marca)\n",
    "    print(desc)\n",
    "    print(prec_desc)\n",
    "    print(prec_s_desc)\n",
    "    print(desc_imd)\n",
    "    print('------')\n",
    "    \n",
    "for p in range(len(p_db)):\n",
    "    prodline = '{},{},{},{},{},{}\\n'.format(p_db[p][0], p_db[p][1], p_db[p][2], p_db[p][3], p_db[p][4], p_db[p][5])\n",
    "    with open('prod.db', 'a') as f:\n",
    "        f.write(prodline)\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Lambrusco Riobello Branco', '', 'garrafa 75 cl', '€ 2,65 /un', '€ 3,53 /lt', '€ 4,89 /un', '€ 6,52 /lt', 'Desconto imediato: €2,24'] ['Espumante Cordón Negro Reserva', 'Freixenet', 'garrafa 75 cl', '€ 5,99 /un', '€ 7,99 /lt', '€ 6,99 /un', '€ 9,32 /lt', 'Desconto imediato: €1,00']\n",
      "Lambrusco Riobello Branco\n",
      "\n",
      "garrafa 75 cl\n",
      "2.65\n",
      "4.89\n",
      "Desconto imediato: €2.24\n",
      "------\n"
     ]
    }
   ],
   "source": [
    "prods : list = driver.find_elements_by_class_name('productItem');\n",
    "caracteristicas : list = prods[8].text.split('\\n');\n",
    "xx : list = prods[7].text.split('\\n');\n",
    "if len(caracteristicas) < 8:\n",
    "    caracteristicas[1:1] = [''];\n",
    "print(caracteristicas, xx);\n",
    "nome_prod   : str = caracteristicas[0];\n",
    "marca       : str = caracteristicas[1];\n",
    "desc        : str = caracteristicas[2];\n",
    "prec_desc   : str = caracteristicas[3].replace('/un', '').replace('€', '').replace(',','.').replace(' ','');\n",
    "prec_s_desc : str = caracteristicas[5].replace('/un', '').replace('€', '').replace(',','.').replace(' ','');\n",
    "desc_imd    : str = caracteristicas[7].replace(',','.');\n",
    "#print(type(caracteristicas), caracteristicas);\n",
    "print(nome_prod);\n",
    "print(marca);\n",
    "print(desc);\n",
    "print(prec_desc);\n",
    "print(prec_s_desc);\n",
    "print(desc_imd);\n",
    "print('------');"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}