Bug que no muestra nombre de productos en la tabla

[RamiGordon]

Hola, tengo problema con este ejercicio (paso el codigo tambien):

def test_nomb_produc(self):
        '''
        Punto 2_b:
        Hacer un test de integración con Selenium para verificar
        que se haya solucionado el bug no mostraba el nombre del producto
        en la tabla, arreglado en la Actividad 2
        '''
        driver = self.driver
        driver.get(self.baseURL)
        time.sleep(10)

        #Creo orden
        orden = Order(id=1)
        db.session.add(orden)

        #Creo producto
        producto = Product(id=1, name='Cuchillo', price=50)
        db.session.add(producto)

        #Creo orden_producto
        ordenProducto = OrderProduct(order_id=1, product_id=1, quantity=5, product=producto)
        db.session.add(ordenProducto)

        #commiteo
        db.session.commit()

        #Guardo el path de donde tendria que aparecel el nombre del producto
        nombre_producto = driver.find_element_by_xpath('//*[@id="orders"]/table/tbody/tr[1]/td[2]')

        #Comparo si ese nombre aparece y es igual al producto que cree
        self.assertEqual(nombre_producto.text, "Cuchillo"), 'No aparece el nombre del producto'

y este es el error:

____ Ordering.test_nomb_produc ____

self =

def test_nomb_produc(self):
    '''
        Punto 2_b:
        Hacer un test de integración con Selenium para verificar
        que se haya solucionado el bug no mostraba el nombre del producto
        en la tabla, arreglado en la Actividad 2
        '''
    driver = self.driver
    driver.get(self.baseURL)
    time.sleep(10)

    #Creo orden
    orden = Order(id=1)
    db.session.add(orden)

    #Creo producto
    producto = Product(id=1, name='Cuchillo', price=50)
    db.session.add(producto)

    #Creo orden_producto
    ordenProducto = OrderProduct(order_id=1, product_id=1, quantity=5, product=producto)
    db.session.add(ordenProducto)

    #commiteo
    db.session.commit()

    #Guardo el path de donde tendria que aparecel el nombre del producto

  nombre_producto = driver.find_element_by_xpath('//*[@id="orders"]/table/tbody/tr[1]/td[2]')

test_e2e.py:111:

---

c:\program files (x86)\python36-32\lib\site-packages\selenium\webdriver\remote\webdriver.py:387: in find_element_by_xpath return self.find_element(by=By.XPATH, value=xpath) c:\program files (x86)\python36-32\lib\site-packages\selenium\webdriver\remote\webdriver.py:957: in find_element 'value': value})['value'] c:\program files (x86)\python36-32\lib\site-packages\selenium\webdriver\remote\webdriver.py:314: in execute self.error_handler.check_response(response)

---

self = <selenium.webdriver.remote.errorhandler.ErrorHandler object at 0x0454AFB0> response = {'sessionId': '18090aa2e7c945f126caf6a740de7876', 'status': 7, 'value': {'message': 'no such element: Unable to locate...ver info: chromedriver=2.38.552522 (437e6fbedfa8762dec75e2c5b3ddb86763dc9dcb),platform=Windows NT 10.0.17134 x86_64)'}}

def check_response(self, response):
    """
        Checks that a JSON response from the WebDriver does not have an error.

        :Args:
         - response - The JSON response from the WebDriver server as a dictionary
           object.

        :Raises: If the response contains an error message.
        """
    status = response.get('status', None)
    if status is None or status == ErrorCode.SUCCESS:
        return
    value = None
    message = response.get("message", "")
    screen = response.get("screen", "")
    stacktrace = None
    if isinstance(status, int):
        value_json = response.get('value', None)
        if value_json and isinstance(value_json, basestring):
            import json
            try:
                value = json.loads(value_json)
                if len(value.keys()) == 1:
                    value = value['value']
                status = value.get('error', None)
                if status is None:
                    status = value["status"]
                    message = value["value"]
                    if not isinstance(message, basestring):
                        value = message
                        message = message.get('message')
                else:
                    message = value.get('message', None)
            except ValueError:
                pass

    exception_class = ErrorInResponseException
    if status in ErrorCode.NO_SUCH_ELEMENT:
        exception_class = NoSuchElementException
    elif status in ErrorCode.NO_SUCH_FRAME:
        exception_class = NoSuchFrameException
    elif status in ErrorCode.NO_SUCH_WINDOW:
        exception_class = NoSuchWindowException
    elif status in ErrorCode.STALE_ELEMENT_REFERENCE:
        exception_class = StaleElementReferenceException
    elif status in ErrorCode.ELEMENT_NOT_VISIBLE:
        exception_class = ElementNotVisibleException
    elif status in ErrorCode.INVALID_ELEMENT_STATE:
        exception_class = InvalidElementStateException
    elif status in ErrorCode.INVALID_SELECTOR \
            or status in ErrorCode.INVALID_XPATH_SELECTOR \
            or status in ErrorCode.INVALID_XPATH_SELECTOR_RETURN_TYPER:
        exception_class = InvalidSelectorException
    elif status in ErrorCode.ELEMENT_IS_NOT_SELECTABLE:
        exception_class = ElementNotSelectableException
    elif status in ErrorCode.ELEMENT_NOT_INTERACTABLE:
        exception_class = ElementNotInteractableException
    elif status in ErrorCode.INVALID_COOKIE_DOMAIN:
        exception_class = InvalidCookieDomainException
    elif status in ErrorCode.UNABLE_TO_SET_COOKIE:
        exception_class = UnableToSetCookieException
    elif status in ErrorCode.TIMEOUT:
        exception_class = TimeoutException
    elif status in ErrorCode.SCRIPT_TIMEOUT:
        exception_class = TimeoutException
    elif status in ErrorCode.UNKNOWN_ERROR:
        exception_class = WebDriverException
    elif status in ErrorCode.UNEXPECTED_ALERT_OPEN:
        exception_class = UnexpectedAlertPresentException
    elif status in ErrorCode.NO_ALERT_OPEN:
        exception_class = NoAlertPresentException
    elif status in ErrorCode.IME_NOT_AVAILABLE:
        exception_class = ImeNotAvailableException
    elif status in ErrorCode.IME_ENGINE_ACTIVATION_FAILED:
        exception_class = ImeActivationFailedException
    elif status in ErrorCode.MOVE_TARGET_OUT_OF_BOUNDS:
        exception_class = MoveTargetOutOfBoundsException
    elif status in ErrorCode.JAVASCRIPT_ERROR:
        exception_class = JavascriptException
    elif status in ErrorCode.SESSION_NOT_CREATED:
        exception_class = SessionNotCreatedException
    elif status in ErrorCode.INVALID_ARGUMENT:
        exception_class = InvalidArgumentException
    elif status in ErrorCode.NO_SUCH_COOKIE:
        exception_class = NoSuchCookieException
    elif status in ErrorCode.UNABLE_TO_CAPTURE_SCREEN:
        exception_class = ScreenshotException
    elif status in ErrorCode.ELEMENT_CLICK_INTERCEPTED:
        exception_class = ElementClickInterceptedException
    elif status in ErrorCode.INSECURE_CERTIFICATE:
        exception_class = InsecureCertificateException
    elif status in ErrorCode.INVALID_COORDINATES:
        exception_class = InvalidCoordinatesException
    elif status in ErrorCode.INVALID_SESSION_ID:
        exception_class = InvalidSessionIdException
    elif status in ErrorCode.UNKNOWN_METHOD:
        exception_class = UnknownMethodException
    else:
        exception_class = WebDriverException
    if value == '' or value is None:
        value = response['value']
    if isinstance(value, basestring):
        if exception_class == ErrorInResponseException:
            raise exception_class(response, value)
        raise exception_class(value)
    if message == "" and 'message' in value:
        message = value['message']

    screen = None
    if 'screen' in value:
        screen = value['screen']

    stacktrace = None
    if 'stackTrace' in value and value['stackTrace']:
        stacktrace = []
        try:
            for frame in value['stackTrace']:
                line = self._value_or_default(frame, 'lineNumber', '')
                file = self._value_or_default(frame, 'fileName', '<anonymous>')
                if line:
                    file = "%s:%s" % (file, line)
                meth = self._value_or_default(frame, 'methodName', '<anonymous>')
                if 'className' in frame:
                    meth = "%s.%s" % (frame['className'], meth)
                msg = "    at %s (%s)"
                msg = msg % (meth, file)
                stacktrace.append(msg)
        except TypeError:
            pass
    if exception_class == ErrorInResponseException:
        raise exception_class(response, message)
    elif exception_class == UnexpectedAlertPresentException:
        alert_text = None
        if 'data' in value:
            alert_text = value['data'].get('text')
        elif 'alert' in value:
            alert_text = value['alert'].get('text')
        raise exception_class(message, screen, stacktrace, alert_text)

  raise exception_class(message, screen, stacktrace)

E selenium.common.exceptions.NoSuchElementException: Message: no such element: Unable to locate element: {"method":"xpath","selector":"//*[@id="orders"]/table/tbody/tr[1]/td[2]"} E (Session info: chrome=66.0.3359.181) E (Driver info: chromedriver=2.38.552522 (437e6fbedfa8762dec75e2c5b3ddb86763dc9dcb),platform=Windows NT 10.0.17134 x86_64)

c:\program files (x86)\python36-32\lib\site-packages\selenium\webdriver\remote\errorhandler.py:242: NoSuchElementException ------------------------------ Captured log call ------------------------------ _internal.py 88 ERROR Error on request: Traceback (most recent call last): File "c:\program files (x86)\python36-32\lib\site-packages\werkzeug\serving.py", line 270, in run_wsgi execute(self.server.app) File "c:\program files (x86)\python36-32\lib\site-packages\werkzeug\serving.py", line 258, in execute application_iter = app(environ, start_response) File "c:\program files (x86)\python36-32\lib\site-packages\flask\app.py", line 1997, in call return self.wsgi_app(environ, start_response) File "c:\program files (x86)\python36-32\lib\site-packages\flask\app.py", line 1985, in wsgi_app response = self.handle_exception(e) File "c:\program files (x86)\python36-32\lib\site-packages\flask\app.py", line 1540, in handle_exception reraise(exc_type, exc_value, tb) File "c:\program files (x86)\python36-32\lib\site-packages\flask_compat.py", line 33, in reraise raise value File "c:\program files (x86)\python36-32\lib\site-packages\flask\app.py", line 1982, in wsgi_app response = self.full_dispatch_request() File "c:\program files (x86)\python36-32\lib\site-packages\flask\app.py", line 1614, in full_dispatch_request rv = self.handle_user_exception(e) File "c:\program files (x86)\python36-32\lib\site-packages\flask\app.py", line 1517, in handle_user_exception reraise(exc_type, exc_value, tb) File "c:\program files (x86)\python36-32\lib\site-packages\flask_compat.py", line 33, in reraise raise value File "c:\program files (x86)\python36-32\lib\site-packages\flask\app.py", line 1612, in full_dispatch_request rv = self.dispatch_request() File "c:\program files (x86)\python36-32\lib\site-packages\flask\app.py", line 1598, in dispatch_request return self.view_functionsrule.endpoint File "C:\Users\joaquin\Documents\GitHub\orderingg\app\routes.py", line 50, in order order = Order.query.get(pk) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\orm\query.py", line 882, in get ident, loading.load_on_pk_identity) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\orm\query.py", line 952, in _get_impl return db_load_fn(self, primary_key_identity) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\orm\loading.py", line 247, in load_on_pk_identity return q.one() File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\orm\query.py", line 2884, in one ret = self.one_or_none() File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\orm\query.py", line 2854, in one_or_none ret = list(self) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\orm\query.py", line 2925, in iter return self._execute_and_instances(context) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\orm\query.py", line 2948, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 948, in execute return meth(self, multiparams, params) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\sql\elements.py", line 269, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 1060, in _execute_clauseelement compiled_sql, distilled_params File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 1200, in _execute_context context) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 1413, in _handle_dbapi_exception exc_info File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\util\compat.py", line 203, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\util\compat.py", line 186, in reraise raise value.with_traceback(tb) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\engine\base.py", line 1193, in _execute_context context) File "c:\program files (x86)\python36-32\lib\site-packages\sqlalchemy\engine\default.py", line 507, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: order [SQL: 'SELECT "order".id AS order_id \nFROM "order" \nWHERE "order".id = ?'] [parameters: ('1',)] (Background on this error at: http://sqlalche.me/e/e3q8) ===================== 2 failed, 1 passed in 96.68 seconds =====================

Hasta donde entiendo, la logica del codigo no esta mal, porque guardo el path en "nombre_producto" y despues comparo en el assert con "nombre_producto.text". Tampoco entiendo el error igual

[RodrigoJacznik]

Hola, el problema esta en que vos haces el get antes de crear el producto.