# coding=utf-8

from django.db import models

"""

Django数据库关系:

一对一关系:OneToOneField

多对多关系:ManyToManyField

多对一关系:ForeignKey

"""

## One-to-one relationships

class Place(models.Model):

    name = models.CharField(max_length=50)

    address = models.CharField(max_length=80)

    def __str__(self):              # __unicode__ on Python 2

        return "%s the place" % self.name

class Restaurant(models.Model):

    place = models.OneToOneField(Place, primary_key=True)

    serves_hot_dogs = models.BooleanField(default=False)

    serves_pizza = models.BooleanField(default=False)

    def __str__(self):              # __unicode__ on Python 2

        return "%s the restaurant" % self.place.name

## CREATE TABLE `db_place` (

##   `id` int(11) NOT NULL AUTO_INCREMENT,

##   `name` varchar(50) NOT NULL,

##   `address` varchar(80) NOT NULL,

##   PRIMARY KEY (`id`)

## ) ENGINE=InnoDB DEFAULT CHARSET=utf8

##

## CREATE TABLE `db_restaurant` (

##   `place_id` int(11) NOT NULL,

##   `serves_hot_dogs` tinyint(1) NOT NULL,

##   `serves_pizza` tinyint(1) NOT NULL,

##   PRIMARY KEY (`place_id`),

##   CONSTRAINT `db_restaurant_place_id_606d40e1_fk_db_place_id` FOREIGN KEY (`place_id`) REFERENCES `db_place` (`id`)

## ) ENGINE=InnoDB DEFAULT CHARSET=utf8

class Waiter(models.Model):

    restaurant = models.ForeignKey(Restaurant)

    name = models.CharField(max_length=50)

    def __str__(self):              # __unicode__ on Python 2

        return "%s the waiter at %s" % (self.name, self.restaurant)

# CREATE TABLE `db_waiter` (

#   `id` int(11) NOT NULL AUTO_INCREMENT,

#   `name` varchar(50) NOT NULL,

#   `restaurant_id` int(11) NOT NULL,

#   PRIMARY KEY (`id`),

#   KEY `db_waiter_ee9d9d3e` (`restaurant_id`),

#   CONSTRAINT `db_waiter_restaurant_id_7b6c7331_fk_db_restaurant_place_id` FOREIGN KEY (`restaurant_id`) REFERENCES `db_restaurant` (`place_id`)

# ) ENGINE=InnoDB DEFAULT CHARSET=utf8

#

# >python manage.py syncdb

# Operations to perform:

#   Apply all migrations: admin, contenttypes, auth, sessions

# Running migrations:

#   Applying contenttypes.0001_initial... OK

#   Applying auth.0001_initial... OK

#   Applying admin.0001_initial... OK

#   Applying sessions.0001_initial... OK

#

# You have installed Django's auth system, and don't have any superusers defined.

# Would you like to create one now? (yes/no): yes

# Username (leave blank to use 'zhangsan'): admin

# Email address: admin@admin.com

# Password:*****

# Password (again):*****

# Superuser created successfully.

#

# >python manage.py makemigrations

# Migrations for 'db':

#   0001_initial.py:

#     - Create model Place

#     - Create model Restaurant

#     - Create model Waiter

#

# >python manage.py migrate

# Operations to perform:

#   Apply all migrations: admin, contenttypes, db, auth, sessions

# Running migrations:

#   Applying db.0001_initial... OK

## Many-to-many relationships

class Publication(models.Model):

    title = models.CharField(max_length=30)

    def __str__(self):              # __unicode__ on Python 2

        return self.title

    class Meta:

        ordering = ('title',)

class Article(models.Model):

    headline = models.CharField(max_length=100)

    publications = models.ManyToManyField(Publication)

    def __str__(self):              # __unicode__ on Python 2

        return self.headline

    class Meta:

        ordering = ('headline',)

## CREATE TABLE `db_publication` (

##   `id` int(11) NOT NULL AUTO_INCREMENT,

##   `title` varchar(30) NOT NULL,

##   PRIMARY KEY (`id`)

## ) ENGINE=InnoDB DEFAULT CHARSET=utf8

##

##

## CREATE TABLE `db_article` (

##   `id` int(11) NOT NULL AUTO_INCREMENT,

##   `headline` varchar(100) NOT NULL,

##   PRIMARY KEY (`id`)

## ) ENGINE=InnoDB DEFAULT CHARSET=utf8

##

## CREATE TABLE `db_article_publications` (

##   `id` int(11) NOT NULL AUTO_INCREMENT,

##   `article_id` int(11) NOT NULL,

##   `publication_id` int(11) NOT NULL,

##   PRIMARY KEY (`id`),

##   UNIQUE KEY `article_id` (`article_id`,`publication_id`),

##   KEY `db_article_publications_a00c1b00` (`article_id`),

##   KEY `db_article_publications_72ef6487` (`publication_id`),

##   CONSTRAINT `db_article_publicat_publication_id_407fcd4d_fk_db_publication_id` FOREIGN KEY (`publication_id`) REFERENCES `db_publication` (`id`),

##   CONSTRAINT `db_article_publications_article_id_b757f51_fk_db_article_id` FOREIGN KEY (`article_id`) REFERENCES `db_article` (`id`)

## ) ENGINE=InnoDB DEFAULT CHARSET=utf8

# >python manage.py makemigrations

# Migrations for 'db':

#   0002_auto_20141013_1311.py:

#     - Create model Article

#     - Create model Publication

#     - Add field publications to article

#

# >python manage.py migrate

# Operations to perform:

#   Apply all migrations: admin, contenttypes, db, auth, sessions

# Running migrations:

#   Applying db.0002_auto_20141013_1311... OK

## Many-to-one relationships

class Reporter(models.Model):

    first_name = models.CharField(max_length=30)

    last_name = models.CharField(max_length=30)

    email = models.EmailField()

    def __str__(self):              # __unicode__ on Python 2

        return "%s %s" % (self.first_name, self.last_name)

class Articler(models.Model):

    headline = models.CharField(max_length=100)

    pub_date = models.DateField()

    reporter = models.ForeignKey(Reporter)

    def __str__(self):              # __unicode__ on Python 2

        return self.headline

    class Meta:

        ordering = ('headline',)

## CREATE TABLE `db_reporter` (

##   `id` int(11) NOT NULL AUTO_INCREMENT,

##   `first_name` varchar(30) NOT NULL,

##   `last_name` varchar(30) NOT NULL,

##   `email` varchar(75) NOT NULL,

##   PRIMARY KEY (`id`)

## ) ENGINE=InnoDB DEFAULT CHARSET=utf8

##

## CREATE TABLE `db_articler` (

##   `id` int(11) NOT NULL AUTO_INCREMENT,

##   `headline` varchar(100) NOT NULL,

##   `pub_date` date NOT NULL,

##   `reporter_id` int(11) NOT NULL,

##   PRIMARY KEY (`id`),

##   KEY `db_articler_947bdf92` (`reporter_id`),

##   CONSTRAINT `db_articler_reporter_id_26a49a33_fk_db_reporter_id` FOREIGN KEY (`reporter_id`) REFERENCES `db_reporter` (`id`)

## ) ENGINE=InnoDB DEFAULT CHARSET=utf8

# >python manage.py makemigrations

# Migrations for 'db':

#   0003_auto_20141013_1318.py:

#     - Create model Articler

#     - Create model Reporter

#     - Add field reporter to articler

#

# >python manage.py migrate

# Operations to perform:

#   Apply all migrations: admin, contenttypes, db, auth, sessions

# Running migrations:

#   Applying db.0003_auto_20141013_1318... OK