from django.db import models
from datetime import datetime 

# Create your models here.
class Data(models.Model):
    fmls_listing_no = models.BigIntegerField(unique=True)
    county_name = models.CharField(max_length=200)
    status = models.CharField(max_length=50, default='Expired')
    listing_display = models.CharField(max_length=50, default='False')
    address_display = models.CharField(max_length=50, default='False')
    json_value = models.TextField()
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    def __str__(self):
        return self.fmls_listing_no.__str__()

class DataMap(models.Model):
    fmls_api_data = models.ForeignKey(Data, on_delete=models.CASCADE)
    wp_id = models.BigIntegerField(unique=True)
    media_id = models.TextField(blank=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

SCHOOL_TYPE = (
    ('Elementary','Elementary'),
    ('High', 'High'),
    ('Middle','Middle')
)

class SchoolRating(models.Model):
    city_name = models.CharField(max_length=50, null=False, blank=False)
    school_type = models.CharField(max_length=50, choices=SCHOOL_TYPE, null=False, blank=False)
    school_name = models.CharField(max_length=150, null=False, blank=False)
    school_fmls_name = models.CharField(max_length=100, null=False, blank=False)
    school_zip = models.CharField(max_length=50, null=False, blank=False)
    school_rating = models.PositiveIntegerField(null=False, blank=False)