Group Group Group Group Group Group Group Group Group

dBase for my website always gives me this error “Invalid syntax”

#1

Hi all, I am trained on selenium with blue prism. I have a web page I have developed and now am stuck getting told that the syntax is wrong. I cannot find the error, can someone please help me find my error? Here is my code for the database that is giving me my error:

from selenium import webdriver

from selenium.common.exceptions import TimeoutException
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC
from selenium.webdriver.chrome.options import Options
from selenium.webdriver.common.by import By
from selenium.webdriver.common.action_chains import ActionChains
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.support.ui import Select
from selenium.webdriver.support.ui import Select
from bs4 import BeautifulSoup
from models import *

import os # File I/O
import time
import shutil
import glob
import configparser
config_parser = configparser.ConfigParser()
config_parser.read(“config.ini”)

pdownload_dir = os.path.abspath(’./prism_downloads/’)
dt = str(datetime.datetime.now())
filelist = glob.glob(download_dir + ‘/*.html’)
dbpath = (’./db’)
def db_Prism():

    database.connect()
    database.create_tables([Prism], safe=False)
    database.close()

    for root, dir, files in os.walk(pdownload_dir):
        for file in files:
            print(file)
            file_markup = ''
            with open(os.path.abspath(os.path.join(pdownload_dir, file)), 'r') as html:
                file_markup = html.read()
            if file_markup == '':
                print('ERROR: File was not read')
            print('Reading {0} into BS4'.format(file))
            soup = BeautifulSoup(file_markup, 'html.parser')
            print('File parsed')
            data = []
            table = soup.find('table')
            rows = table.find_all('tr') # 18th row is header row 
            cols = rows[0].find_all('td')
            cols = [ele.text.strip() for ele in cols] 
            database.connect()
            for row in rows[0:]:
                d = row.find_all('td')
                d = [ele.text.strip() for ele in d]
                data.append([ele for ele in d if ele]) # Get rid of empty values 
                Prism.create(pmt_id=(d[1]),
                    old_status=d[3],
                    new_status=(d[4]),
                    last_updated=float(d[5])    

Line 96 database.close()

Now here is the error message from my console:

C:\Users\Documents\NetBeansProjects\BudgetHome>python prism.py
File “prism.py”, line 96
database.close()
^
SyntaxError: invalid syntax

C:\Users\Documents\NetBeansProjects\BudgetHome>

Thanks.

opened #3