from django.db import models

# Create your models here

class Huc10(models.Model): 
    huc10 = models.AutoField('ID', primary_key=True)
    huc10_name = models.CharField(maxlength=255)  
    county = models.CharField(maxlength=255) 
    
    def __str__(self):
        return self.huc10_name
    
    class Admin: 
        list_display = ('huc10','huc10_name','county',) 
        list_filter = ('huc10_name',)
        ordering = ('huc10',)
        search_fields = ('huc10','huc10_name','county') 



class Lake(models.Model):
    midas = models.AutoField('ID', primary_key=True)
    name = models.CharField(maxlength=255) 
    type = models.CharField(maxlength=255)
    huc_6 =  models.CharField(maxlength=255)
    huc_8 =  models.CharField(maxlength=255) 
    huc_8_name = models.CharField(maxlength=255)
    huc_10 =  models.CharField(maxlength=255)
    huc_10_name =  models.CharField(maxlength=255)
    huc_12 =   models.CharField(maxlength=255)
    huc_12_name =  models.CharField(maxlength=255)
    geocode = models.CharField(maxlength=255)
    town  = models.CharField(maxlength=255)
    county = models.CharField(maxlength=255)

    def __str__(self):
        return '%s %s' % (self.name, self.midas)

    class Admin: 
        list_display = ('midas','name','town','county',) 
        ordering = ('name',)
        search_fields = ('name','midas','type') 

    class Meta:
        ordering = ["name"]



class Post(models.Model): 
    title = models.CharField(maxlength=255)  
    content =  models.TextField(maxlength=10000)  
    lake = models.CharField(maxlength=255)  
    huc10 = models.ForeignKey(Huc10) 
    CATEGORY_CHOICES = ( 
        ('g', 'general'),   
        ('l', 'land'), 
        ('w', 'water'), 
        ('a', 'animal'), 
        ('p', 'plant'),
        ) 
    category = models.CharField(maxlength=1, choices=CATEGORY_CHOICES) 
    TYPE_CHOICES = ( 
        ('g', 'general informaion'), 
        ('q', 'question'),
        ('a', 'answer'),
      ) 
    type = models.CharField(maxlength=1, choices=TYPE_CHOICES) 
    date =  models.DateField()
    user =  models.Manager()

    def __str__(self):
        return self.title 

    class Admin: 
        pass