Elep

# Create your models here.
from django.db import models
from picklefield.fields import PickledObjectField

class SnowflakeAuthentication(models.Model):
    account = models.CharField(max_length=255)
    user = models.CharField(max_length=255)
    password = models.CharField(max_length=255)
    role = models.CharField(max_length=255, choices=[('accountadmin', 'accountadmin'),
                                                     ('orgadmin', 'orgadmin')])
    sf_user_id = models.CharField(max_length=255)

class MappingDetail(models.Model):
    warehouse = models.CharField(max_length=255)

retention_database = models.CharField(max_length=255)

database = models.CharField(max_length=255)
    schema = models.CharField(max_length=255)
    table = models.CharField(max_length=255)

direct_list = PickledObjectField()
    direct_mapping_list = PickledObjectField()
    snowflake_static = PickledObjectField()

max_id = models.IntegerField()
    snowflake_id = models.ForeignKey(SnowflakeAuthentication, on_delete=models.CASCADE)

client_id = models.CharField(max_length=255)
    subdomain = models.CharField(max_length=255)

class SyncMappingRecord(models.Model):
    event_number = models.IntegerField()
    created_on = models.DateTimeField()
    mapping_id = models.ForeignKey(MappingDetail, on_delete=models.CASCADE)
    snowflake_id = models.ForeignKey(SnowflakeAuthentication, on_delete=models.CASCADE)