Traceback (most recent call last): File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\mysql\connector\connection_cext.py", line 772, in cmd_query self._cmysql.query( _mysql_connector.MySQLInterfaceError: Unknown column 'absensi.tanda_tangan' in 'field list' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context self.dialect.do_execute( File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\engine\default.py", line 952, in do_execute cursor.execute(statement, parameters) File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\mysql\connector\cursor_cext.py", line 353, in execute self._connection.cmd_query( File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\mysql\connector\opentelemetry\context_propagation.py", line 97, in wrapper return method(cnx, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\mysql\connector\connection_cext.py", line 781, in cmd_query raise get_mysql_exception( mysql.connector.errors.ProgrammingError: 1054 (42S22): Unknown column 'absensi.tanda_tangan' in 'field list' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\project\kuliah\Scantools-Polda\test_dashboard.py", line 18, in test_dashboard_logic jumlah_absensi = db.query(Absensi).count() ^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\orm\query.py", line 3146, in count self._legacy_from_self(col).enable_eagerloads(False).scalar() File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\orm\query.py", line 2835, in scalar ret = self.one() ^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\orm\query.py", line 2808, in one return self._iter().one() # type: ignore ^^^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\orm\query.py", line 2857, in _iter result: Union[ScalarResult[_T], Result[_T]] = self.session.execute( ^^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\orm\session.py", line 2351, in execute return self._execute_internal( ^^^^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\orm\session.py", line 2249, in _execute_internal result: Result[Any] = compile_state_cls.orm_execute_statement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\orm\context.py", line 306, in orm_execute_statement result = conn.execute( ^^^^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1419, in execute return meth( ^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\sql\elements.py", line 527, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1641, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1846, in _execute_context return self._exec_single_context( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1986, in _exec_single_context self._handle_dbapi_exception( File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 2363, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context self.dialect.do_execute( File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\sqlalchemy\engine\default.py", line 952, in do_execute cursor.execute(statement, parameters) File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\mysql\connector\cursor_cext.py", line 353, in execute self._connection.cmd_query( File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\mysql\connector\opentelemetry\context_propagation.py", line 97, in wrapper return method(cnx, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuliah\Scantools-Polda\venv\Lib\site-packages\mysql\connector\connection_cext.py", line 781, in cmd_query raise get_mysql_exception( sqlalchemy.exc.ProgrammingError: (mysql.connector.errors.ProgrammingError) 1054 (42S22): Unknown column 'absensi.tanda_tangan' in 'field list' [SQL: SELECT count(*) AS count_1 FROM (SELECT absensi.id AS absensi_id, absensi.id_pegawai AS absensi_id_pegawai, absensi.tanggal AS absensi_tanggal, absensi.waktu_masuk AS absensi_waktu_masuk, absensi.status AS absensi_status, absensi.keterangan AS absensi_keterangan, absensi.foto AS absensi_foto, absensi.tanda_tangan AS absensi_tanda_tangan FROM absensi) AS anon_1] (Background on this error at: https://sqlalche.me/e/20/f405)