from django.db import models


class City(models.Model):
    user_id = models.AutoField(primary_key=True)
    city = models.CharField(max_length=45, unique=True)

    def __unicode__(self):
        return u'%s' % self.city


class User(models.Model):
    user_id = models.AutoField(primary_key=True)
    login = models.CharField(max_length=30, unique=True)
    email = models.EmailField(max_length=254, unique=True)
    password = models.CharField(max_length=256)
    name = models.CharField(max_length=45, blank=True, default='')
    surname = models.CharField(max_length=45, blank=True, default='')
    city = models.ForeignKey(City, null=True, blank=True, default=None, related_name='+')
    subscriptions = models.ManyToManyField('self', symmetrical=False, db_table='MyInstagram_subscriptions')

    def __unicode__(self):
        return u'%s %s %s %s' % (self.login, self.email, self.name, self.surname)


class Photo(models.Model):
    photo_id = models.AutoField(primary_key=True)
    photo = models.ImageField()


class Post(models.Model):
    post_id = models.AutoField(primary_key=True)
    user = models.ForeignKey(User, related_name='+')
    date_time = models.DateTimeField(auto_now_add=True)
    photo = models.ForeignKey(Photo, related_name='+')
    like_users = models.ManyToManyField(User, db_table='MyInstagram_likes', related_name='user_likes')
    comments = models.ManyToManyField(User, through='Comment', related_name='user_comments')


class Comment(models.Model):
    user = models.ForeignKey(User)
    post = models.ForeignKey(Post)
    date_time = models.DateTimeField()
    text = models.TextField(max_length=1000)

    def __unicode__(self):
        return u'%s is comment " %s "' % (self.user.surname, self.text)