Check the type check in the sqlite DBs

[LuiggiTenorioK]

In GitLab by @mcastril on Apr 20, 2023, 10:30

@ jberlin to complete

Provide a more valuable and meaningful message when data is corrupted in a given database of Autosubmit, from the API side it should be logged and in the GUI the user will be warned about the issue.

[LuiggiTenorioK]

In GitLab by @ jberlin on Apr 21, 2023, 15:27

mentioned in commit ce84754d2ad9902fc7cef2cfc54b36103bb15a07

[LuiggiTenorioK]

In GitLab by @ jberlin on Apr 21, 2023, 17:23

mentioned in commit cf51ba39bd30d523226a19d6559a524fc2fb876f

[LuiggiTenorioK]

In GitLab by @ jberlin on Apr 21, 2023, 17:26

I added custom exceptions for DB corruption escenariosm with more clear messages and also enabled logging in the upper layers. Still proper logging must be propagated to other classes and methods to have full stack trace in the error log of gunicorns

[LuiggiTenorioK]

In GitLab by @ jberlin on Apr 27, 2023, 17:16

being carried out in issue #16

[LuiggiTenorioK]

In GitLab by @mcastril on May 11, 2023, 10:23

@ jberlin will take an experiment to create a specification of the types for the different columns in the DDBB to be taken by Autosubmit

@dbeltrankyl

[LuiggiTenorioK]

In GitLab by @ jberlin on May 25, 2023, 17:36

I will start uploading the modified scripts here:

• job_data_xxxx.sql
• ecearth.sql

[LuiggiTenorioK]

In GitLab by @ jberlin on May 26, 2023, 17:20

some more:

• job_packages_xxxx.sql

• graph_data_xxxx.sql

[LuiggiTenorioK]

In GitLab by @ jberlin on May 30, 2023, 14:59

Hi, here are the final version of all the scripts:

• as_times.sql
• graph_data_xxxx.sql
• job_packages_xxxx.sql
• status.sql
• structure_xxxx.sql
• job_data_xxxx.sql
• ecearth.sql

@dbeltrankyl Please can you use these sql snippets for testing how it goes ?