[APERO] New offline2online script

[njcuk9999]

Need to python-ise and generalise the following linux commands:

1. mv online to online_old

   • mv nirps_he_online nirps_he_online_old

2. mv offline to online

   • my nirps_he_offline nirps_he_online

3. update databases (manually)

   • astrom
     • DROP TABLE astrom_nirps_he_online_db;
     • CREATE TABLE astrom_nirps_he_online_db LIKE astrom_nirps_he_offline_db;
     • INSERT INTO astrom_nirps_he_online_db SELECT * FROM astrom_nirps_he_offline_db;
   • calib
     • DROP TABLE calib_nirps_he_online_db;
     • CREATE TABLE calib_nirps_he_online_db LIKE calib_nirps_he_offline_db;
     • INSERT INTO calib_nirps_he_online_db SELECT * FROM calib_nirps_he_offline_db;
   • lang
     • DROP TABLE lang_nirps_he_online_db;
     • CREATE TABLE lang_nirps_he_online_db LIKE lang_nirps_he_offline_db;
     • INSERT INTO lang_nirps_he_online_db SELECT * FROM lang_nirps_he_offline_db;
   • reject
     • DROP TABLE reject_nirps_he_online_db;
     • CREATE TABLE reject_nirps_he_online_db LIKE reject_nirps_he_offline_db;
     • INSERT INTO reject_nirps_he_online_db SELECT * FROM reject_nirps_he_offline_db;
   • tellu
     • DROP TABLE tellu_nirps_he_online_db;
     • CREATE TABLE tellu_nirps_he_online_db LIKE tellu_nirps_he_offline_db;
     • INSERT INTO tellu_nirps_he_online_db SELECT * FROM tellu_nirps_he_offline_db;
   • findex
     • DROP TABLE findex_nirps_he_online_db;
     • CREATE TABLE findex_nirps_he_online_db LIKE findex_nirps_he_offline_db;
     • INSERT INTO findex_nirps_he_online_db SELECT * FROM findex_nirps_he_offline_db;
     • UPDATE findex_nirps_he_online_db SET ABSPATH=REPLACE(ABSPATH, '/cosmos99/nirps/apero-data/nirps_he_offline/', '/cosmos99/nirps/apero-data/nirps_he_online/');
   • log
     • DROP TABLE log_nirps_he_online_db;
     • CREATE TABLE log_nirps_he_online_db LIKE log_nirps_he_offline_db;
     • INSERT INTO log_nirps_he_online_db SELECT * FROM log_nirps_he_offline_db;
     • UPDATE log_nirps_he_online_db SET INPATH=REPLACE(INPATH, '/cosmos99/nirps/apero-data/nirps_he_offline/', '/cosmos99/nirps/apero-data/nirps_he_online/');
     • UPDATE log_nirps_he_online_db SET OUTPATH=REPLACE(OUTPATH, '/cosmos99/nirps/apero-data/nirps_he_offline/', '/cosmos99/nirps/apero-data/nirps_he_online/');
     • UPDATE log_nirps_he_online_db SET LOGFILE=REPLACE(LOGFILE, '/cosmos99/nirps/apero-data/nirps_he_offline/', '/cosmos99/nirps/apero-data/nirps_he_online/');
     • UPDATE log_nirps_he_online_db SET PLOTDIR=REPLACE(PLOTDIR, '/cosmos99/nirps/apero-data/nirps_he_offline/', '/cosmos99/nirps/apero-data/nirps_he_online/');

4. update objects directory (manual_trigger)

   • manual_trigger.py nirps_he_profile_online.yaml --only_get=True

5. update ARI (manual_trigger)

   • apero_ri.py nirps_he_online_udem.yaml --reset

6. remove online_old

   • rm -rfv nirps_he_online_old
     Need to python-ise and generalise the following linux commands:

7. mv online to online_old

   • mv nirps_he_online nirps_he_online_old

8. mv offline to online

   • my nirps_he_offline nirps_he_online

9. update databases (manually)

   • astrom
     • DROP TABLE astrom_nirps_he_online_db;
     • CREATE TABLE astrom_nirps_he_online_db LIKE astrom_nirps_he_offline_db;
     • INSERT INTO astrom_nirps_he_online_db SELECT * FROM astrom_nirps_he_offline_db;
   • calib
     • DROP TABLE calib_nirps_he_online_db;
     • CREATE TABLE calib_nirps_he_online_db LIKE calib_nirps_he_offline_db;
     • INSERT INTO calib_nirps_he_online_db SELECT * FROM calib_nirps_he_offline_db;
   • lang
     • DROP TABLE lang_nirps_he_online_db;
     • CREATE TABLE lang_nirps_he_online_db LIKE lang_nirps_he_offline_db;
     • INSERT INTO lang_nirps_he_online_db SELECT * FROM lang_nirps_he_offline_db;
   • reject
     • DROP TABLE reject_nirps_he_online_db;
     • CREATE TABLE reject_nirps_he_online_db LIKE reject_nirps_he_offline_db;
     • INSERT INTO reject_nirps_he_online_db SELECT * FROM reject_nirps_he_offline_db;
   • tellu
     • DROP TABLE tellu_nirps_he_online_db;
     • CREATE TABLE tellu_nirps_he_online_db LIKE tellu_nirps_he_offline_db;
     • INSERT INTO tellu_nirps_he_online_db SELECT * FROM tellu_nirps_he_offline_db;
   • findex
     • DROP TABLE findex_nirps_he_online_db;
     • CREATE TABLE findex_nirps_he_online_db LIKE findex_nirps_he_offline_db;
     • INSERT INTO findex_nirps_he_online_db SELECT * FROM findex_nirps_he_offline_db;
     • UPDATE findex_nirps_he_online_db SET ABSPATH=REPLACE(ABSPATH, '/cosmos99/nirps/apero-data/nirps_he_offline/', '/cosmos99/nirps/apero-data/nirps_he_online/');
   • log
     • DROP TABLE log_nirps_he_online_db;
     • CREATE TABLE log_nirps_he_online_db LIKE log_nirps_he_offline_db;
     • INSERT INTO log_nirps_he_online_db SELECT * FROM log_nirps_he_offline_db;
     • UPDATE log_nirps_he_online_db SET INPATH=REPLACE(INPATH, '/cosmos99/nirps/apero-data/nirps_he_offline/', '/cosmos99/nirps/apero-data/nirps_he_online/');
     • UPDATE log_nirps_he_online_db SET OUTPATH=REPLACE(OUTPATH, '/cosmos99/nirps/apero-data/nirps_he_offline/', '/cosmos99/nirps/apero-data/nirps_he_online/');
     • UPDATE log_nirps_he_online_db SET LOGFILE=REPLACE(LOGFILE, '/cosmos99/nirps/apero-data/nirps_he_offline/', '/cosmos99/nirps/apero-data/nirps_he_online/');
     • UPDATE log_nirps_he_online_db SET PLOTDIR=REPLACE(PLOTDIR, '/cosmos99/nirps/apero-data/nirps_he_offline/', '/cosmos99/nirps/apero-data/nirps_he_online/');

10. update objects directory (manual_trigger)

    • rm -rfv /cosmos99/nirps/apero-data/nirps_he_online/objects/
    • manual_trigger.py nirps_he_profile_online.yaml --only_aperoget=True

11. update ARI (manual_trigger)

    • apero_ri.py nirps_he_online_udem.yaml --reset

12. remove online_old

    • rm -rfv nirps_he_online_old