#!/usr/bin/env python

from sqlalchemy import Column, ForeignKey, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship
from sqlalchemy import create_engine

Base = declarative_base()


class User(Base):
    """Create a Users table"""
    __tablename__ = 'user'

    id = Column(Integer, primary_key=True)
    name = Column(String(250), nullable=False)
    email = Column(String(250), nullable=False)
    picture = Column(String(250))
    placeTypes = relationship('PlaceType', backref="user", passive_deletes=True)
    places = relationship('Place', backref="user", passive_deletes=True)


class PlaceType(Base):
    """Create a PlaceType table"""
    __tablename__ = 'placeType'

    id = Column(Integer, primary_key=True)
    name = Column(String(250), nullable=False)
    user_id = Column(Integer, ForeignKey('user.id', ondelete='CASCADE'))
    places = relationship('Place', backref="placeType", passive_deletes=True)

    # Set up the related JSON API endpoints
    @property
    def serialize(self):
        """Return object data in an easily serializeable format"""
        return {
            'name': self.name,
            'id': self.id
        }


class Place(Base):
    """Createa a Place table"""
    __tablename__ = 'place'

    id = Column(Integer, primary_key=True)
    name = Column(String(80), nullable=False)
    description = Column(String(850))
    location = Column(String(250), nullable=False)
    price = Column(String(10))
    link = Column(String(300))
    placeType_id = Column(Integer, ForeignKey('placeType.id', ondelete='CASCADE'))
    user_id = Column(Integer, ForeignKey('user.id', ondelete='CASCADE'))

    # Set up the related JSON API endpoints
    @property
    def serialize(self):
        """Return object data in an easily serializeable format"""
        return {
            'name': self.name,
            'id': self.id,
            'description': self.description,
            'location': self.location,
            'price': self.price,
            'link': self.link
        }


# Create an SQLite database called nuevomexico.db
engine = create_engine('postgresql://catalog:INSERT_PASSWORD_HERE@localhost/catalog')

Base.metadata.create_all(engine)