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

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
import re
import json
import pandas as pd
from astropy_healpix import HEALPix

import os
import io
import gzip
import tarfile
import warnings

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt

from avro.datafile import DataFileReader, DataFileWriter
from avro.io import DatumReader, DatumWriter
import fastavro

from astropy.time import Time
from astropy.io import fits
import astropy.units as u
import aplpy

from astrobasis.models import ztf_filter

from collections import defaultdict

import logging
import requests 
import json
import pprint

from astrobasis.models import ZTFAlert
from heasarc.models import NSIDE_SOURCES, ORDER, HeasarcBase
from srglib.utils import load_ztf_alerts

"""
https://zwickytransientfacility.github.io/ztf-avro-alert/filtering.html

Based on tests done at IPAC (F. Masci, priv. comm), the following filter delivers a relatively pure sample:

rb >= 0.65 and
nbad = 0 and
fwhm <= 5 and
elong <= 1.2 and
abs(magdiff) <= 0.1
"""

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

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

        all = ZTFAlert.objects.all()
        all.delete()

        #load_ztf_alerts()