from django.db import models

class cs2snipe_users(models.Model):
    steamid = models.CharField(max_length=200)
    free_snipes = models.IntegerField(default=10)
    pub_date = models.DateTimeField("date published")

class cs2snipe_queries(models.Model):
    steamid = models.CharField(max_length=200)
    query_json = models.JSONField()
    query_failed = models.BooleanField()
    query_status = models.CharField(max_length=200)
    message = models.CharField(max_length=200)
    pub_date = models.DateTimeField("date published")

class cs2snipe_found(models.Model):
    skin = models.CharField(max_length=300)
    float = models.FloatField(default=None, blank=True, null=True)
    pattern = models.IntegerField(default=None, blank=True, null=True)
    rank = models.IntegerField(default=None, blank=True, null=True)
    stickers = models.CharField(max_length=300, default=None, blank=True, null=True)
    price = models.DecimalField(decimal_places=2, max_digits=10, default=None, blank=True, null=True)
    page = models.IntegerField(default=0)
    inspect_link = models.CharField(max_length=300)
    market_url = models.CharField(max_length=300)
    steamid = models.CharField(max_length=200)
    pub_date = models.DateTimeField("date published")
    foundskins_id = models.ForeignKey(cs2snipe_queries, on_delete=models.CASCADE, default=None, blank=True, null=True)