.\venv\Scripts\python.e xe : INFO: Started server process [9560] At line:1 char:1 + .\venv\Scripts\python .exe -m uvicorn agent.main:app --host 127.0.0.1 ... + ~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~ ~~ + CategoryInfo : NotSpecifi ed: (INFO: Sta rted server proces s [9560]:String) [ ], RemoteException + FullyQualifiedEr rorId : NativeComm andError INFO: Waiting for application startup. INFO: Application startup complete. INFO: Uvicorn running on http://127.0.0.1:8000 (Press CTRL+C to quit) Berhasil memuat folder app INFO: 127.0.0.1:50784 - "GET / HTTP/1.1" 307 Temporary Redirect INFO: 127.0.0.1:50784 - "GET /absensi/ HTTP/1.1" 200 OK INFO: 127.0.0.1:50784 - "GET /auth/login HTTP/1.1" 200 OK INFO: 127.0.0.1:59053 - "POST /auth/login HTTP/1.1" 200 OK INFO: 127.0.0.1:57118 - "POST /auth/login HTTP/1.1" 302 Found INFO: 127.0.0.1:57118 - "GET /admin/dashboard HTTP/1.1" 200 OK INFO: 127.0.0.1:57118 - "GET /admin/pegawai HTTP/1.1" 200 OK Traceback (most recent call last): File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\mysq l\connector\connection_ cext.py", line 772, in cmd_query self._cmysql.query( _mysql_connector.MySQLI nterfaceError: Duplicate entry 'muhamm adunicoreykhanza23@mhs. p' for key 'email' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\engine\base.py", line 1967, in _exec_single_context self.dialect.do_exe cute( File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\engine\default.p y", line 952, in do_execute cursor.execute(stat ement, parameters) File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\mysq l\connector\cursor_cext .py", line 353, in execute self._connection.cm d_query( File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\mysq l\connector\opentelemet ry\context_propagation. py", line 97, in wrapper return method(cnx, *args, **kwargs) ^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^ File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\mysq l\connector\connection_ cext.py", line 781, in cmd_query raise get_mysql_exception( mysql.connector.errors. IntegrityError: 1062 (23000): Duplicate entry 'muhammadunicorey khanza23@mhs.p' for key 'email' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\project\kuli ah\Scantools-Polda\app\ routes\admin.py", line 153, in tambah_pegawai db.commit() File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\session.py", line 2030, in commit trans.commit(_to_ro ot=True) File "", line 2, in commit File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\state_change s.py", line 137, in _go ret_value = fn(self, *arg, **kw) ^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\session.py", line 1311, in commit self._prepare_impl() File "", line 2, in _prepare_impl File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\state_change s.py", line 137, in _go ret_value = fn(self, *arg, **kw) ^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\session.py", line 1286, in _prepare_impl self.session.flush() File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\session.py", line 4331, in flush self._flush(objects) File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\session.py", line 4466, in _flush with util.safe_reraise(): File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\util\langhelpers .py", line 121, in __exit__ raise exc_value.wit h_traceback(exc_tb) File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\session.py", line 4427, in _flush flush_context.execute() File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\unitofwork.p y", line 466, in execute rec.execute(self) File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\unitofwork.p y", line 642, in execute util.preloaded.orm_ persistence.save_obj( File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\persistence. py", line 93, in save_obj _emit_insert_statem ents( File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\orm\persistence. py", line 1048, in _emit_insert_statements result = connection.execute( ^^^^^^^^^^^^^^^^^^^ File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\engine\base.py", line 1419, in execute return meth( ^^^^^ File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\sql\elements.py" , line 527, in _execute_on_connection return connection._ execute_clauseelement( ^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\engine\base.py", line 1641, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\engine\base.py", line 1846, in _execute_context return self._exec_s ingle_context( ^^^^^^^^^^^^ ^^^^^^^^^^^^^^ File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\engine\base.py", line 1986, in _exec_single_context self._handle_dbapi_ exception( File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\engine\base.py", line 2363, in _handle_dbapi_exception raise sqlalchemy_ex ception.with_traceback( exc_info[2]) from e File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\engine\base.py", line 1967, in _exec_single_context self.dialect.do_exe cute( File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\sqla lchemy\engine\default.p y", line 952, in do_execute cursor.execute(stat ement, parameters) File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\mysq l\connector\cursor_cext .py", line 353, in execute self._connection.cm d_query( File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\mysq l\connector\opentelemet ry\context_propagation. py", line 97, in wrapper return method(cnx, *args, **kwargs) ^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^ File "C:\project\kuli ah\Scantools-Polda\venv \Lib\site-packages\mysq l\connector\connection_ cext.py", line 781, in cmd_query raise get_mysql_exception( sqlalchemy.exc.Integrit yError: (mysql.connecto r.errors.IntegrityError ) 1062 (23000): Duplicate entry 'muhamm adunicoreykhanza23@mhs. p' for key 'email' [SQL: INSERT INTO pegawai (id_pegawai, nama, email, password, jabatan, pangkat, `NRP`) VALUES (%(id_pegawai)s, %(nama)s, %(email)s, %(password)s, %(jabatan)s, %(pangkat)s, %(NRP)s)] [parameters: {'id_pegawai': 'P003', 'nama': 'nikory', 'email': 'muhammadunico reykhanza23@mhs.polital a.ac.id', 'password': '123456789', 'jabatan': 'mahasiswa pkl', 'pangkat': '-', 'NRP': 1234567890}] (Background on this error at: https://sqlal che.me/e/20/gkpj) ERROR TAMBAH PEGAWAI: (mysql.connector.errors.IntegrityError) 1062 (23000): Duplicate entry 'muhammadunicoreykhanza23@mhs.p' for key 'email' [SQL: INSERT INTO pegawai (id_pegawai, nama, email, password, jabatan, pangkat, `NRP`) VALUES (%(id_pegawai)s, %(nama)s, %(email)s, %(password)s, %(jabatan)s, %(pangkat)s, %(NRP)s)] [parameters: {'id_pegawai': 'P003', 'nama': 'nikory', 'email': 'muhammadunicoreykhanza23@mhs.politala.ac.id', 'password': '123456789', 'jabatan': 'mahasiswa pkl', 'pangkat': '-', 'NRP': 1234567890}] (Background on this error at: https://sqlalche.me/e/20/gkpj) INFO: 127.0.0.1:53959 - "POST /admin/pegawai/tambah HTTP/1.1" 302 Found INFO: 127.0.0.1:53959 - "GET /admin/pegawai?error=Gagal%20menambah%20data HTTP/1.1" 200 OK INFO: 127.0.0.1:59732 - "POST /admin/pegawai/tambah HTTP/1.1" 302 Found INFO: 127.0.0.1:59732 - "GET /admin/pegawai HTTP/1.1" 200 OK INFO: 127.0.0.1:59394 - "GET /admin/pegawai/edit/P002 HTTP/1.1" 200 OK INFO: 127.0.0.1:52558 - "POST /admin/pegawai/hapus HTTP/1.1" 302 Found INFO: 127.0.0.1:52558 - "GET /admin/pegawai HTTP/1.1" 200 OK INFO: 127.0.0.1:56078 - "GET /admin/dashboard HTTP/1.1" 200 OK INFO: 127.0.0.1:53349 - "GET /admin/pegawai HTTP/1.1" 200 OK INFO: 127.0.0.1:58040 - "POST /admin/pegawai/hapus HTTP/1.1" 302 Found INFO: 127.0.0.1:58040 - "GET /admin/pegawai HTTP/1.1" 200 OK INFO: 127.0.0.1:65175 - "POST /admin/pegawai/tambah HTTP/1.1" 302 Found INFO: 127.0.0.1:65175 - "GET /admin/pegawai HTTP/1.1" 200 OK