Untitled

Hibernate: select count_big(d1_0.id) from rims.dataJoin d1_0 where d1_0.isDeleted=0
2024-04-04T14:55:49.200+07:00 DEBUG 1 --- [nio-8080-exec-5] org.hibernate.SQL                        : select count_big(d1_0.id) from rims.dataExternal d1_0 where d1_0.isDeleted=0
Hibernate: select count_big(d1_0.id) from rims.dataExternal d1_0 where d1_0.isDeleted=0
2024-04-04T14:55:49.387+07:00 DEBUG 1 --- [io-8080-exec-10] org.hibernate.SQL                        : select d1_0.id,d1_0.createdAt,d1_0.createdByEmail,d1_0.createdById,d1_0.createdByName,d1_0.dataName,d1_0.dataResource,d1_0.deletedAt,d1_0.deletedBy,d1_0.errorMessage,d1_0.fieldKeyPrimary,d1_0.fieldKeySecondary,d1_0.firstTableData,d1_0.idDataPrimary,d1_0.idDataSecondary,d1_0.idLibrary,d1_0.isDeleted,d1_0.jenisJoin,d1_0.joinStatus,d1_0.secondTableData,d1_0.tableName,d1_0.updatedAt,d1_0.updatedByEmail,d1_0.updatedById,d1_0.updatedByName,d1_0.workUnit from rims.dataJoin d1_0 where d1_0.id=?
Hibernate: select d1_0.id,d1_0.createdAt,d1_0.createdByEmail,d1_0.createdById,d1_0.createdByName,d1_0.dataName,d1_0.dataResource,d1_0.deletedAt,d1_0.deletedBy,d1_0.errorMessage,d1_0.fieldKeyPrimary,d1_0.fieldKeySecondary,d1_0.firstTableData,d1_0.idDataPrimary,d1_0.idDataSecondary,d1_0.idLibrary,d1_0.isDeleted,d1_0.jenisJoin,d1_0.joinStatus,d1_0.secondTableData,d1_0.tableName,d1_0.updatedAt,d1_0.updatedByEmail,d1_0.updatedById,d1_0.updatedByName,d1_0.workUnit from rims.dataJoin d1_0 where d1_0.id=?
2024-04-04T14:55:49.391+07:00 DEBUG 1 --- [io-8080-exec-10] org.hibernate.SQL                        : insert into rims.backgroundProsses (filename,message,name,status) values (?,?,?,?)
Hibernate: insert into rims.backgroundProsses (filename,message,name,status) values (?,?,?,?)
/usr/local/tomcat/python/export.py:28: UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.
  data = pd.read_sql_query(query, connection)
2024-04-04T14:55:50.271+07:00 DEBUG 1 --- [nio-8080-exec-4] org.hibernate.SQL                        : select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?
Hibernate: select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?

2024-04-04T14:56:00.370+07:00 DEBUG 1 --- [nio-8080-exec-2] org.hibernate.SQL                        : select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?
Hibernate: select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?
2024-04-04T14:56:10.452+07:00 DEBUG 1 --- [nio-8080-exec-8] org.hibernate.SQL                        : select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?
Hibernate: select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?
2024-04-04T14:56:20.560+07:00 DEBUG 1 --- [nio-8080-exec-9] org.hibernate.SQL                        : select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?
Hibernate: select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?
Writing Excel file:   0%|          | 0/52750 [00:00<?, ?it/s]
Writing Excel file: 100%|██████████| 52750/52750 [00:30<00:00, 1748.01it/s]


2024-04-04T14:56:30.670+07:00 DEBUG 1 --- [nio-8080-exec-3] org.hibernate.SQL                        : select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?
Hibernate: select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?
Writing Excel file: 100%|██████████| 52750/52750 [00:30<00:00, 1748.01it/s]
Writing Excel file: 100%|██████████| 52750/52750 [00:38<00:00, 1370.94it/s]
2024-04-04T14:56:31.095+07:00 DEBUG 1 --- [nio-8080-exec-1] org.hibernate.SQL                        : select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?
Hibernate: select b1_0.id,b1_0.filename,b1_0.message,b1_0.name,b1_0.status from rims.backgroundProsses b1_0 where b1_0.id=?
Proses Python selesai dengan kode keluaran: 0