from django.db import models
from seer_user.models import SeerUser
from fortune_teller.models import FortuneTeller
# Create your models here.

class Conversation(models.Model):
    seer_user = models.ForeignKey(SeerUser, on_delete=models.CASCADE)
    fortune_teller = models.ForeignKey(FortuneTeller, on_delete=models.CASCADE)
    twilio_channel_sid = models.CharField(max_length=255, blank=True, null=True)
    seer_user_twilio_id = models.CharField(max_length=200, null=True)
    fortune_teller_twilio_id = models.CharField(max_length=200, null=True)
    last_message = models.DateTimeField(null=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)
    end_date =  models.DateTimeField(null=True)

    class Meta:
        db_table = 'conversation'


class SeerUserConversation(models.Model):
    seer_user_one = models.ForeignKey(SeerUser, on_delete=models.CASCADE,related_name='seer_user_one')
    seer_user_two = models.ForeignKey(SeerUser, on_delete=models.CASCADE,related_name='seer_user_two')
    twilio_channel_sid = models.CharField(max_length=255, blank=True, null=True)
    seer_user_one_twilio_id = models.CharField(max_length=200, null=True)
    seer_user_two_twilio_id = models.CharField(max_length=200, null=True)
    last_message = models.DateTimeField(null=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)
    end_date =  models.DateTimeField(null=True)

    class Meta:
        db_table = 'seer_user_conversation'





class VideoRooms(models.Model):
    twilio_room_sid = models.CharField(max_length=255, blank=True, null=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)
    end_date =  models.DateTimeField(null=True)

    class Meta:
        db_table = 'video_rooms'

# class Rooms(models.Model):
#     twilio_channel_sid = models.CharField(max_length=255, blank=True, null=True)
#     last_message = models.DateTimeField(null=True)
#     created_at = models.DateTimeField(auto_now_add=True)
#     updated_at = models.DateTimeField(auto_now=True)
#     end_date =  models.DateTimeField(null=True)

#     class Meta:
#         db_table = 'seer_user_rooms'


# class Praticipants(models.Model):
#     room = models.ForeignKey(Rooms,on_delete = models.CASCADE)
#     join_date = models.DateTimeField(auto_now_add=True,null=True)
#     exit_date = models.DateTimeField(null=True)
#     seer_user = models.ForeignKey(SeerUser, on_delete=models.CASCADE)
#     user_twilio_id = models.CharField(max_length=200,null=True)
#     status =  models.BooleanField(default=True,null=True)
#     created_at = models.DateTimeField(auto_now_add=True)
#     updated_at = models.DateTimeField(auto_now=True)
#     end_date =  models.DateTimeField(null=True)

#     class Meta:
#         db_table = 'seer_user_praticipants'