from django.core.management.base import BaseCommand, CommandError

from datetime import date
import datetime
from django.utils import timezone
import astropy
from astropy.io import ascii
import pandas as pd
import pymysql
from sqlalchemy import create_engine

from heasarc.tdat import tDat
from heasarc.models import HeasarcTable, TableColumn, HeasarcObjectClass, NSIDE_SOURCES, ORDER
from srgcat.models import ArtCat, ArtSource
from astropy.table import Table
from astropy_healpix import HEALPix
from astropy.coordinates import SkyCoord  # High-level coordinates
from astropy.coordinates import ICRS, Galactic, FK4, FK5  # Low-level frames
from astropy.coordinates import Angle, Latitude, Longitude  # Angles
import astropy.units as u

from astropy.io import fits
from django.db.models import Q
from datetime import datetime
from astropy.time import Time

from srgcat.models import SkyMaps, SrgDataDump
from monthplan.models import SurveyHealpixPlate
from srglib.utils import TZ_MSK, load_srg_data_dumps
import glob
import os
import logging

class Command(BaseCommand):
    help = 'Initiates data dase'

    def handle(self, *args, **options):

        logging.getLogger().setLevel(logging.INFO)

        #dumps = SrgDataDump.objects.all()
        #dumps.delete()
        #return

        load_srg_data_dumps('/srg/work/oper/staff/kate/skymap')
        
        self.stdout.write(self.style.SUCCESS('Done'))