ProgrammingError
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column contracts.contractor_rated does not exist
LINE 1: ...s.last_modified_by AS contracts_last_modified_by, contracts....
                                                             ^

[SQL: SELECT contracts.job_id AS contracts_job_id, contracts.contractor_id AS contracts_contractor_id, contracts.worker_id AS contracts_worker_id, contracts.agreed_rate AS contracts_agreed_rate, contracts.rate_type AS contracts_rate_type, contracts.start_date AS contracts_start_date, contracts.end_date AS contracts_end_date, contracts.scope_of_work AS contracts_scope_of_work, contracts.independent_contractor_status AS contracts_independent_contractor_status, contracts.superannuation_required AS contracts_superannuation_required, contracts.workers_comp_covered AS contracts_workers_comp_covered, contracts.status AS contracts_status, contracts.completion_status AS contracts_completion_status, contracts.payment_status AS contracts_payment_status, contracts.contractor_approval_date AS contracts_contractor_approval_date, contracts.worker_completion_date AS contracts_worker_completion_date, contracts.contractor_signed AS contracts_contractor_signed, contracts.worker_signed AS contracts_worker_signed, contracts.contractor_signed_date AS contracts_contractor_signed_date, contracts.worker_signed_date AS contracts_worker_signed_date, contracts.contractor_reviewed AS contracts_contractor_reviewed, contracts.worker_reviewed AS contracts_worker_reviewed, contracts.last_modified_by AS contracts_last_modified_by, contracts.contractor_rated AS contracts_contractor_rated, contracts.worker_rated AS contracts_worker_rated, contracts.mutual_rating_completed_date AS contracts_mutual_rating_completed_date, contracts.payment_terms AS contracts_payment_terms, contracts.payment_schedule AS contracts_payment_schedule, contracts.id AS contracts_id, contracts.created_at AS contracts_created_at, contracts.updated_at AS contracts_updated_at 
FROM contracts 
WHERE contracts.contractor_id = %(contractor_id_1)s AND contracts.status IN (%(status_1_1)s, %(status_1_2)s, %(status_1_3)s, %(status_1_4)s, %(status_1_5)s, %(status_1_6)s) ORDER BY contracts.created_at DESC]
[parameters: {'contractor_id_1': 2, 'status_1_1': 'pending_agreement', 'status_1_2': 'contractor_signed', 'status_1_3': 'worker_signed', 'status_1_4': 'active', 'status_1_5': 'pending_review', 'status_1_6': 'pending_rating'}]
(Background on this error at: https://sqlalche.me/e/20/f405)

Traceback (most recent call last)
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1965, in _exec_single_context
self.dialect.do_execute(
^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 921, in do_execute
cursor.execute(statement, parameters)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
The above exception was the direct cause of the following exception:
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/flask/app.py", line 2213, in __call__
return self.wsgi_app(environ, start_response)
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/flask/app.py", line 2193, in wsgi_app
response = self.handle_exception(e)
           ^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/flask_cors/extension.py", line 176, in wrapped_function
return cors_after_request(app.make_response(f(*args, **kwargs)))
                                            ^^^^^^^^^^^^^^^^^^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/flask/app.py", line 2190, in wsgi_app
response = self.full_dispatch_request()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/flask/app.py", line 1486, in full_dispatch_request
rv = self.handle_user_exception(e)
     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/flask_cors/extension.py", line 176, in wrapped_function
return cors_after_request(app.make_response(f(*args, **kwargs)))
                                            ^^^^^^^^^^^^^^^^^^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/flask/app.py", line 1484, in full_dispatch_request
rv = self.dispatch_request()
     ^^^^^^^^^^^^^^^^^^^^^^^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/flask/app.py", line 1469, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/runner/workspace/app/routes.py", line 369, in dashboard_contractor
).order_by(Contract.created_at.desc()).all()
                                       ^^^^^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2688, in all
return self._iter().all()  # type: ignore
       ^^^^^^^^^^^^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2842, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
                                              
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2262, in execute
return self._execute_internal(
       
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2144, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
                      
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 293, in orm_execute_statement
result = conn.execute(
         
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1412, in execute
return meth(
       
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
       
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1635, in _execute_clauseelement
ret = self._execute_context(
      
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1844, in _execute_context
return self._exec_single_context(
       
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1984, in _exec_single_context
self._handle_dbapi_exception(
^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2339, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1965, in _exec_single_context
self.dialect.do_execute(
^
File "/home/runner/workspace/.pythonlibs/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 921, in do_execute
cursor.execute(statement, parameters)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column contracts.contractor_rated does not exist
LINE 1: ...s.last_modified_by AS contracts_last_modified_by, contracts....
^

[SQL: SELECT contracts.job_id AS contracts_job_id, contracts.contractor_id AS contracts_contractor_id, contracts.worker_id AS contracts_worker_id, contracts.agreed_rate AS contracts_agreed_rate, contracts.rate_type AS contracts_rate_type, contracts.start_date AS contracts_start_date, contracts.end_date AS contracts_end_date, contracts.scope_of_work AS contracts_scope_of_work, contracts.independent_contractor_status AS contracts_independent_contractor_status, contracts.superannuation_required AS contracts_superannuation_required, contracts.workers_comp_covered AS contracts_workers_comp_covered, contracts.status AS contracts_status, contracts.completion_status AS contracts_completion_status, contracts.payment_status AS contracts_payment_status, contracts.contractor_approval_date AS contracts_contractor_approval_date, contracts.worker_completion_date AS contracts_worker_completion_date, contracts.contractor_signed AS contracts_contractor_signed, contracts.worker_signed AS contracts_worker_signed, contracts.contractor_signed_date AS contracts_contractor_signed_date, contracts.worker_signed_date AS contracts_worker_signed_date, contracts.contractor_reviewed AS contracts_contractor_reviewed, contracts.worker_reviewed AS contracts_worker_reviewed, contracts.last_modified_by AS contracts_last_modified_by, contracts.contractor_rated AS contracts_contractor_rated, contracts.worker_rated AS contracts_worker_rated, contracts.mutual_rating_completed_date AS contracts_mutual_rating_completed_date, contracts.payment_terms AS contracts_payment_terms, contracts.payment_schedule AS contracts_payment_schedule, contracts.id AS contracts_id, contracts.created_at AS contracts_created_at, contracts.updated_at AS contracts_updated_at
FROM contracts
WHERE contracts.contractor_id = %(contractor_id_1)s AND contracts.status IN (%(status_1_1)s, %(status_1_2)s, %(status_1_3)s, %(status_1_4)s, %(status_1_5)s, %(status_1_6)s) ORDER BY contracts.created_at DESC]
[parameters: {'contractor_id_1': 2, 'status_1_1': 'pending_agreement', 'status_1_2': 'contractor_signed', 'status_1_3': 'worker_signed', 'status_1_4': 'active', 'status_1_5': 'pending_review', 'status_1_6': 'pending_rating'}]
(Background on this error at: https://sqlalche.me/e/20/f405)
The debugger caught an exception in your WSGI application. You can now look at the traceback which led to the error.
To switch between the interactive traceback and the plaintext one, you can click on the "Traceback" headline. From the text traceback you can also create a paste of it. For code execution mouse-over the frame you want to debug and click on the console icon on the right side.

You can execute arbitrary Python code in the stack frames and there are some extra helpers available for introspection:

dump() shows all variables in the frame
dump(obj) dumps all that's known about the object
Brought to you by DON'T PANIC, your friendly Werkzeug powered traceback interpreter.