!/usr/bin/env python

* coding: utf-8 *

import flask from flask_sqlalchemy import SQLAlchemy import datetime import os from sqlalchemy import or_,and_ from flask_babelex import Babel

app = flask.Flask(name) babel = Babel(app) app.config['BABEL_DEFAULT_LOCALE'] = 'zh_CN' host = '127.0.0.1' user = 'root' password = 'admit' database = 'xingwen' app.config['SQLALCHEMY_DATABASE_URI'] = "mysql+pymysql://%s:%s@%s:3306/%s" % (user, password, host,database)

app.config['SQLALCHEMY_DATABASE_URI'] = os.getenv('DATABASE_URL',

'sqlite:///' + os.path.join(app.root_path, 'xingwen.db'))

app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False app.config['SECRET_KEY'] = 'xingwen'

db = SQLAlchemy(app)

class User(db.Model):

__tablename__ = 'User'


id = db.Column(db.Integer, unique=True, primary_key=True,autoincrement=True)
name = db.Column(db.String(32),name='用户名')  # 用户名
email = db.Column(db.String(32),name='邮箱')  # 邮箱
password = db.Column(db.String(32),name='密码')  # 密码
user_datetime = db.Column(db.DateTime, nullable=True, default=datetime.datetime.now)  # 用户创建时间

pinglun = db.relationship("PingLun", backref="User")  # 用户评论关联

def __repr__(self):
    return "<{}账号>".format(self.email)

class XinWen(db.Model): tablename = 'XinWen'

id = db.Column(db.Integer, unique=True, primary_key=True, autoincrement=True)

title = db.Column(db.String(124),name='标题')  # 新闻标题
media = db.Column(db.String(124),name='来源')  # 新闻来源
url = db.Column(db.String(512), name='链接')  # 新闻链接
top_time = db.Column(db.String(124), name='发布时间')  # 新闻发布时间
content = db.Column(db.TEXT, name='内容')  # 新闻内容

xinwen_datetime = db.Column(db.DateTime(), nullable=True, default=datetime.datetime.now)  # 新闻创建时间

pinglun = db.relationship("PingLun", backref="XinWen")  # 新闻评论关联

def __repr__(self):
    return "<{} 新闻信息>".format(self.title)

class PingLun(db.Model): tablename = 'PingLun'

id = db.Column(db.Integer, unique=True, primary_key=True)
content = db.Column(db.TEXT,name='评价内容')  # 评论内容
user_id = db.Column(db.Integer, db.ForeignKey('User.id'))  # 用户ID
xinwen_id = db.Column(db.Integer, db.ForeignKey('XinWen.id'))  # 新闻ID

dates = db.Column(db.DateTime(), nullable=True, default=datetime.datetime.now)  # 评论创建时间

def __repr__(self):
    return "< {} 评价 {} 新闻信息>".format(self.user_id,self.xinwen_id)

if name == 'main': # db.drop_all() db.create_all()

db.session.add(User(name='admin',email='admin@qq.com',password='root123456'))
db.session.commit()