from django.db import models
import datetime
import uuid

from django.db.models.expressions import Combinable

# Create your models here.

# Create your models here.



class Users(models.Model):

    id_user= models.AutoField(primary_key=True)
    password = models.CharField(max_length=128)
    username = models.CharField(unique=True, max_length=150)
    last_time = models.CharField(max_length=128)

    class Meta:
        managed = False
        db_table = 'Users'


class Files(models.Model):
    id_file = models.AutoField(primary_key=True)
    #video_path=models.CharField(max_length=500)
   # video_path=models.FileField(upload_to='media/')
    video_path=models.FileField(upload_to='')
    id_user = models.ForeignKey(Users , models.DO_NOTHING , db_column='id_user' ,blank=True, null=True)
    duration=models.CharField(max_length=50)
    extension=models.CharField(max_length=50)
    when_uploaded=models.CharField(max_length=200)
    size=models.CharField(max_length=50)
    multi_speaker=models.CharField(max_length=50)
    

    class Meta :
        managed = False
        db_table = 'Files'


# class DjangoSession(models.Model):
#     session_key = models.CharField(primary_key=True, max_length=40)
#     session_data = models.TextField()
#     expire_date = models.DateTimeField()

#     class Meta:
#         managed = False
#         db_table = 'django_session'


# class Transcripts(models.Model):
#     id_transcript = models.UUIDField(primary_key=False, default=uuid.uuid4, editable=False)
#     id_file       = models.ForeignKey(Files, on_delete=models.CASCADE, null=True)
#     path_str_fr   = models.FileField(blank=True,null=True, upload_to='transcripts/') 
#     path_str_es   = models.FileField(blank=True,null=True, upload_to='transcripts/') 
#     path_str_en   = models.FileField(blank=True,null=True, upload_to='transcripts/') 
#     path_str_po   = models.FileField(blank=True,null=True, upload_to='transcripts/') 
#     Download_date = models.DateTimeField()