Testing delete query...
Testing count queries...
.\venv\Scripts\python.exe 
: Traceback (most recent 
call last):
At line:1 char:1
+ 
.\venv\Scripts\python.exe 
test_dashboard.py > 
error.txt 2>&1
+ ~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~
    + CategoryInfo         
     : NotSpecified: (Tra  
  ceback (most recent ca   
 ll last)::String) [],     
RemoteException
    + FullyQualifiedErrorI 
   d : NativeCommandError
 
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\mysql\connector\
connection_cext.py", line 
772, in cmd_query
    self._cmysql.query(
_mysql_connector.MySQLInter
faceError: 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\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\engin
e\base.py", line 1967, in 
_exec_single_context
    
self.dialect.do_execute(
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\engin
e\default.py", line 952, 
in do_execute
    
cursor.execute(statement, 
parameters)
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\mysql\connector\
cursor_cext.py", line 353, 
in execute
    
self._connection.cmd_query(
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\mysql\connector\
opentelemetry\context_propa
gation.py", line 97, in 
wrapper
    return method(cnx, 
*args, **kwargs)
           ^^^^^^^^^^^^^^^^
^^^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\mysql\connector\
connection_cext.py", line 
781, in cmd_query
    raise 
get_mysql_exception(
mysql.connector.errors.Prog
rammingError: 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\S
cantools-Polda\test_dashboa
rd.py", line 18, in 
test_dashboard_logic
    jumlah_absensi = 
db.query(Absensi).count()
                     
^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\orm\q
uery.py", line 3146, in 
count
    self._legacy_from_self(
col).enable_eagerloads(Fals
e).scalar()
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\orm\q
uery.py", line 2835, in 
scalar
    ret = self.one()
          ^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\orm\q
uery.py", line 2808, in one
    return 
self._iter().one()  # 
type: ignore
           ^^^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\orm\q
uery.py", line 2857, in 
_iter
    result: 
Union[ScalarResult[_T], 
Result[_T]] = 
self.session.execute(
                           
                       
^^^^^^^^^^^^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\orm\s
ession.py", line 2351, in 
execute
    return 
self._execute_internal(
           
^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\orm\s
ession.py", line 2249, in 
_execute_internal
    result: Result[Any] = c
ompile_state_cls.orm_execut
e_statement(
                          ^
^^^^^^^^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\orm\c
ontext.py", line 306, in 
orm_execute_statement
    result = conn.execute(
             ^^^^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\engin
e\base.py", line 1419, in 
execute
    return meth(
           ^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\sql\e
lements.py", line 527, in 
_execute_on_connection
    return connection._exec
ute_clauseelement(
           ^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\engin
e\base.py", line 1641, in 
_execute_clauseelement
    ret = 
self._execute_context(
          
^^^^^^^^^^^^^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\engin
e\base.py", line 1846, in 
_execute_context
    return 
self._exec_single_context(
           
^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\engin
e\base.py", line 1986, in 
_exec_single_context
    self._handle_dbapi_exce
ption(
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\engin
e\base.py", line 2363, in 
_handle_dbapi_exception
    raise sqlalchemy_except
ion.with_traceback(exc_info
[2]) from e
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\engin
e\base.py", line 1967, in 
_exec_single_context
    
self.dialect.do_execute(
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\sqlalchemy\engin
e\default.py", line 952, 
in do_execute
    
cursor.execute(statement, 
parameters)
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\mysql\connector\
cursor_cext.py", line 353, 
in execute
    
self._connection.cmd_query(
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\mysql\connector\
opentelemetry\context_propa
gation.py", line 97, in 
wrapper
    return method(cnx, 
*args, **kwargs)
           ^^^^^^^^^^^^^^^^
^^^^^^^^^^^^
  File "C:\project\kuliah\S
cantools-Polda\venv\Lib\sit
e-packages\mysql\connector\
connection_cext.py", line 
781, in cmd_query
    raise 
get_mysql_exception(
sqlalchemy.exc.ProgrammingE
rror: (mysql.connector.erro
rs.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/2
0/f405)

During handling of the 
above exception, another 
exception occurred:

Traceback (most recent 
call last):
  File "C:\project\kuliah\S
cantools-Polda\test_dashboa
rd.py", line 37, in 
<module>
    test_dashboard_logic()
  File "C:\project\kuliah\S
cantools-Polda\test_dashboa
rd.py", line 31, in 
test_dashboard_logic
    print("\u274c 
Dashboard logic test 
failed!")
  File "C:\Users\HYPE AMD\A
ppData\Local\Programs\Pytho
n\Python311\Lib\encodings\c
p1252.py", line 19, in 
encode
    return codecs.charmap_e
ncode(input,self.errors,enc
oding_table)[0]
           ^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^
UnicodeEncodeError: 
'charmap' codec can't 
encode character '\u274c' 
in position 0: character 
maps to <undefined>