from flask import Flask
from flask.ext.sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////tmp/test.db'
db = SQLAlchemy(app)


class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_name = db.Column(db.String, nullable=False)
    password = db.Column(db.String, nullable=False)
    last_seen = db.Column(db.TIMESTAMP, default=db.func.current_timestamp())
    birthday = db.Column(db.String)
    nameday = db.Column(db.String)
    notify = db.Column(db.Boolean, default=True)
    email = db.Column(db.String)
    phone = db.Column(db.String)
    address_line1 = db.Column(db.String)
    address_line2 = db.Column(db.String)
    address_city_line = db.Column(db.String)
    timezone = db.Column(db.String)
    kado = db.Column(db.String)

    def __init__(self, user_name, passowrd):
        self.user_name = user_name
        self.password = password

    def __repr__(self):
        return '<User {0}>'.format(self.username)

class News(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String, nullable=False)
    date = db.Column(db.TIMESTAMP, default=db.func.current_timestamp())
    content = db.Column(db.String, nullable=False)
    content_cache = db.Column(db.String)
    user_id = db.Column(db.Integer, db.Foreignkey('user.id'))
    comments = relationship("Comments")
    user = relationship("Users", backref)

    def __init__(self, user_id, title, content):
        self.user_id = user.id
        self.title = title
        self.content = content

    def __repr__(self):
        return '<News {0}>'.format(self.title)

class Comments(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    date = db.Column(db.TIMESTAMP, default=db.func.current_timestamp())
    content = db.Column(db.String)
    content_cache = db.Column(db.String)
    user_id = db.Column(db.Integer, db.Foreignkey('user.id'))
    news_id = db.Column(db.Integer, db.Foreignkey('news.id'))

    def __init__(self, user_id, news_id, content):
        self.user_id = user_id
        self.news_id = news_id
        self.content = content

    def __repr__(self):
        return '<Comments {0}>'.format(self.content)