7. Load sequence of events data

2024-11-01

===========================================================================
Start run_io_avstats_dev
---------------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
---------------------------------------------------------------------------
ENV_FOR_DYNACONF : prod
PYTHONPATH       : .
---------------------------------------------------------------------------
TASK             : l_s_e
APPLICATION      :
COMPOSE_TASK     :
MSACCESS         :
MSEXCEL          :
---------------------------------------------------------------------------
The current time is:  5:48:49.80
Enter the new time:
===========================================================================
2024-11-01 05:48:50,718 [root] [io_logger.py  ] INFO  You are using io-aero's iocommon version 1.2.60 logger (Copyright (c) 2022-2024 IO-Aero)
2024-11-01 05:48:50,718 [root] [io_settings.py  ] INFO  Starting the configuration management system.
2024-11-01 05:48:50,718 [root] [io_settings.py  ] INFO  Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2024-11-01 05:48:50,719 [root] [io_settings.py  ] INFO  Dynaconf settings loaded successfully.
Progress update 2024-11-01 04:48:51.658769+00:00 : ===============================================================================.
Progress update 2024-11-01 04:48:51.658769+00:00 : INFO.00.004 Start Launcher.
2024-11-01 05:48:51,658 [root] [launcher.py  ] INFO  param argv=['scripts\\launcher.py', '-t', 'l_s_e']
2024-11-01 05:48:51,659 [root] [launcher.py  ] INFO  Start launcher.py
2024-11-01 05:48:51,668 [root] [launcher.py  ] INFO  locale=('en_US', 'UTF-8')
Progress update 2024-11-01 04:48:51.669567+00:00 : INFO.00.005 Argument task='l_s_e'.
Progress update 2024-11-01 04:48:51.669567+00:00 : -------------------------------------------------------------------------------.
Progress update 2024-11-01 04:48:51.669567+00:00 : INFO.00.075 Load sequence of events data.
Progress update 2024-11-01 04:48:51.670584+00:00 : --------------------------------------------------------------------------------
Progress update 2024-11-01 04:48:51.670584+00:00 : INFO.00.076 Database table io_sequence_of_events: Load data from file 'data/Sequence_of_Events/CICTT_SOE_MAP.csv'.
Progress update 2024-11-01 04:48:51.670584+00:00 : --------------------------------------------------------------------------------
2024-11-01 05:48:51,670 [root] [db_utils.py  ] INFO  INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2024-11-01 04:48:51.725585+00:00 : INFO.00.076 Database table io_sequence_of_events: Load data from file 'data/Sequence_of_Events/CICTT_SOE_MAP.csv'.
Progress update 2024-11-01 04:48:53.845819+00:00 : Number rows selected :       97.
Progress update 2024-11-01 04:48:53.845819+00:00 : Number rows upserted :       83.
Progress update 2024-11-01 04:48:53.895608+00:00 : -------------------------------------------------------------------------------.
Progress update 2024-11-01 04:48:53.895608+00:00 :                    2 s - Total time launcher.
Progress update 2024-11-01 04:48:53.895608+00:00 : INFO.00.006 End   Launcher.
Progress update 2024-11-01 04:48:53.896612+00:00 : ===============================================================================.

---------------------------------------------------------------------------
The current time is:  5:48:54.11
Enter the new time:
---------------------------------------------------------------------------
End   run_io_avstats_dev
===========================================================================

2024-03-09

===========================================================================
Start run_io_avstats
---------------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
---------------------------------------------------------------------------
ENV_FOR_DYNACONF : prod
PYTHONPATH       : .
---------------------------------------------------------------------------
TASK             : l_s_e
APPLICATION      :
COMPOSE_TASK     :
MSACCESS         :
MSEXCEL          :
---------------------------------------------------------------------------
The current time is: 12:12:21.38
Enter the new time:
===========================================================================
Progress update 2024-03-09 12:12:23.669629 : ===============================================================================.
Progress update 2024-03-09 12:12:23.669629 : INFO.00.004 Start Launcher.
2024-03-09 12:12:23,672 [iocommon.io_logger] [io_logging.py  ] INFO  initialise_logger:59 You are using io-aero's iocommon version 1.2.41 logger (Copyright (c) 2022-2024 IO-Aero)
2024-03-09 12:12:23,673 [__main__] [launcher.py  ] INFO  main:80 Start launcher.py
Progress update 2024-03-09 12:12:23.683629 : INFO.00.005 Argument task='l_s_e'.
Progress update 2024-03-09 12:12:23.683629 : -------------------------------------------------------------------------------.
Progress update 2024-03-09 12:12:23.683629 : INFO.00.075 Load sequence of events data.
Progress update 2024-03-09 12:12:23.683629 : --------------------------------------------------------------------------------
Progress update 2024-03-09 12:12:23.683629 : INFO.00.076 Database table io_sequence_of_events: Load data from file 'data/Sequence_of_Events/CICTT_SOE_MAP.csv'.
Progress update 2024-03-09 12:12:23.683629 : --------------------------------------------------------------------------------
Progress update 2024-03-09 12:12:23.684629 : INFO.00.081 User  connect request host=localhost port=5432 dbname=io_aero_db user=io_aero.
Progress update 2024-03-09 12:12:23.736631 : INFO.00.076 Database table io_sequence_of_events: Load data from file 'data/Sequence_of_Events/CICTT_SOE_MAP.csv'.
Progress update 2024-03-09 12:12:25.839857 : Number rows selected :       97.
Progress update 2024-03-09 12:12:25.839857 : Number rows upserted :       83.
Progress update 2024-03-09 12:12:25.864857 : -------------------------------------------------------------------------------.
Progress update 2024-03-09 12:12:25.864857 :                    2 s - Total time launcher.
Progress update 2024-03-09 12:12:25.864857 : INFO.00.006 End   Launcher.
Progress update 2024-03-09 12:12:25.864857 : ===============================================================================.

---------------------------------------------------------------------------
The current time is: 12:12:26.07
Enter the new time:
---------------------------------------------------------------------------
End   run_io_avstats
===========================================================================

2023-08-22

=======================================================================
Start run_io_avstats
-----------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
-----------------------------------------------------------------------
PYTHONPATH   : D:\SoftDevelopment\Projects\IO-Aero\io-avstats-db\dist;D:\SoftDevelopment\Projects\IO-Aero\io-maps\dist
-----------------------------------------------------------------------
TASK         : l_s_e
APPLICATION  : 
COMPOSE_TASK : 
MSACCESS     : 
MSEXCEL      : 
-----------------------------------------------------------------------
The current time is:  1:44:56.62
Enter the new time: 
=======================================================================
Progress update 2023-08-22 01:44:57.830700 : ===============================================================================.
Progress update 2023-08-22 01:44:57.830700 : INFO.00.004 Start Launcher.
Progress update 2023-08-22 01:44:57.832208 : INFO.00.001 The logger is configured and ready.
Progress update 2023-08-22 01:44:57.841249 : INFO.00.005 Argument task='l_s_e'.
Progress update 2023-08-22 01:44:57.841249 : -------------------------------------------------------------------------------.
Progress update 2023-08-22 01:44:57.841249 : INFO.00.075 Load sequence of events data.
Progress update 2023-08-22 01:44:57.841249 : --------------------------------------------------------------------------------
Progress update 2023-08-22 01:44:57.841249 : INFO.00.076 Database table io_sequence_of_events: Load data from file 'data/Sequence_of_Events/CICTT_SOE_MAP.xlsx'.
Progress update 2023-08-22 01:44:57.841249 : --------------------------------------------------------------------------------
Progress update 2023-08-22 01:44:57.841249 : INFO.00.081 User connect request host=localhost port=5432 dbname=io_aero_db user=io_aero.
Progress update 2023-08-22 01:44:58.007764 : Number rows selected :       97.
Progress update 2023-08-22 01:44:58.007764 : Number rows upserted :       83.
Progress update 2023-08-22 01:44:58.010778 : -------------------------------------------------------------------------------.
Progress update 2023-08-22 01:44:58.010778 :          180,078,700 ns - Total time launcher.
Progress update 2023-08-22 01:44:58.010778 : INFO.00.006 End   Launcher.
Progress update 2023-08-22 01:44:58.010778 : ===============================================================================.