from django.db import models

# Create your models here.

from django.db import models
from django.contrib.auth.models import User

class admin(models.Model):
    id_admin= models.AutoField(primary_key=True)
    username = models.CharField(max_length=50)
    password = models.CharField(max_length=50)
    last_time = models.DateTimeField(auto_now=True)

    class Meta:
        managed = False
        db_table = 'admin'

class user(models.Model):
    id_user= models.AutoField(primary_key=True)
    username = models.CharField(max_length=50)
    password = models.CharField(max_length=50)
    last_time = models.DateTimeField(auto_now=True)

    class Meta:
        managed = False
        db_table = 'user'

class UserProfile(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE)
    last_time = models.DateTimeField(auto_now=True)

class video(models.Model):
    id_video= models.AutoField(primary_key=True)
    video_name = models.CharField(max_length=100)
    when_uploaded = models.DateTimeField(auto_now_add=True)
    id_user = models.ForeignKey(user, on_delete=models.CASCADE)
    #path = models.CharField(max_length=200)
    path=models.FileField(upload_to='')
    duration = models.CharField(max_length=20)
    extension = models.CharField(max_length=10)

    class Meta:
        managed = False
        db_table = 'video'

    def __str__(self):
        return self.video_name

class stats(models.Model):
    id_stats= models.AutoField(primary_key=True)
    user = models.ForeignKey(User, on_delete=models.CASCADE)
    day = models.DateField(auto_now_add=True)
    total_time = models.CharField(max_length=20)

class result(models.Model):
    id_result= models.AutoField(primary_key=True)
    result_name = models.CharField(max_length=100)
    start_at = models.CharField(max_length=20)
    finish_at = models.CharField(max_length=20)
    video = models.ForeignKey(video, on_delete=models.CASCADE)
    when_generated = models.DateTimeField(auto_now_add=True)
    text_generated = models.TextField()
    path = models.CharField(max_length=200)
    duration = models.CharField(max_length=20)
    user = models.ForeignKey(user, on_delete=models.CASCADE)
    time_taken_by_user = models.CharField(max_length=20)
    text_corrected = models.TextField()
    status = models.CharField(max_length=20)