ADACS-Australia / GleamXGPMonitoring

GLEAM Galactic Plane transient rating app is a web-based candidate classifier for team members to easily classify transient candidates. The transient candidates are detected in the MWA's weekly monitoring of the galactic plane.
https://gleamxgpmonitoring.readthedocs.io/en/latest/
MIT License
0 stars 1 forks source link

Issues on Database download page #56

Open PaulHancock opened 2 months ago

PaulHancock commented 2 months ago

As noted by Sammy:

Download Rating Data error

Request Method: | GET Request URL: | http://mwa-image-plane.duckdns.org/download_data/rating/ Django Version: | 4.2 Exception Type: | ValueError Exception Value: | Illegal format object. Exception Location: | /opt/conda/lib/python3.10/site-packages/astropy/io/fits/column.py, line 2524, in _convert_record2fits Raised during: | candidate_app.views.download_data Python Executable: | /opt/conda/bin/python Python Version: | 3.10.14 Python Path: | ['/home/app/web','/opt/conda/lib/python310.zip','/opt/conda/lib/python3.10','/opt/conda/lib/python3.10/lib-dynload','/opt/conda/lib/python3.10/site-packages'] Server time: | Wed, 14 Aug 2024 02:10:12 +0000

Download User Data error

Request Method: | GET Request URL: | http://mwa-image-plane.duckdns.org/download_data/user/ Django Version: | 4.2 Exception Type: | ValueError Exception Value: | Illegal format object. Exception Location: | /opt/conda/lib/python3.10/site-packages/astropy/io/fits/column.py, line 2524, in _convert_record2fits Raised during: | candidate_app.views.download_data Python Executable: | /opt/conda/bin/python Python Version: | 3.10.14 Python Path: | ['/home/app/web','/opt/conda/lib/python310.zip','/opt/conda/lib/python3.10','/opt/conda/lib/python3.10/lib-dynload','/opt/conda/lib/python3.10/site-packages'] Server time: | Wed, 14 Aug 2024 02:14:16 +0000

PaulHancock commented 2 months ago

Downloading Candidate / Observation / Filter tables works without error.

PaulHancock commented 2 months ago

Issue is that some columns in the database are datetime columns, and fits doesn't know how to store these. In 267a4641b195e3001f95c6942415495886801a07 I've implemented a filter so that datetime columns are converted into strings before writing as a fits file.

PaulHancock commented 2 months ago

I have also annotated the tables so that any column which is a link to another table will also show the name of the record.

For example: Rating table has a column called classification, which is normally filled with integers (the pk of the classification row), but now also contains classification_name which will be the name of the classification selected (e.g. rfi).