毕设&课程作业_Flask web开发，基于python的web开发实战小例子.zip

import os from flask import Flask, render_template, session, redirect, url_for, flash from flask_script import Manager from flask_bootstrap import Bootstrap from flask_moment import Moment from flask_wtf import FlaskForm from wtforms import StringField, SubmitField from wtforms.validators import Required from flask_sqlalchemy import SQLAlchemy # 上下文 from flask_script import Shell # 数据迁移 from flask_migrate import Migrate,MigrateCommand # basedir = os.path.abspath(os.path.dirname(__file__)) # # app = Flask(__name__) # app.config['SECRET_KEY'] = 'hard to guess string' # app.config['SQLALCHEMY_DATABASE_URI'] =\ # 'sqlite:///' + os.path.join(basedir, 'data.sqlite') # app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True # app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False basedir=os.path.abspath(os.path.dirname(__file__)) app=Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI']=\ 'sqlite:///'+os.path.join(basedir,'data.sqlite') app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN']=True app.config['SECRET_KEY']='asdfadfasdfsahsdklfjaldfgashdjfgasydk' manager = Manager(app) bootstrap = Bootstrap(app) moment = Moment(app) db = SQLAlchemy(app) migrate=Migrate(app,db) class Role(db.Model): __tablename__='roles' id=db.Column(db.Integer,primary_key=True) name=db.Column(db.String(64),unique=True) users=db.relationship('User',backref='role') def __repr__(self): return '<Role %r>' %self.name class User(db.Model): __tablename__='users' id=db.Column(db.Integer,primary_key=True) name=db.Column(db.String(64),unique=True,index=True) role_id=db.Column(db.Integer,db.ForeignKey('roles.id')) def __repr__(self): return '<User %r>' % self.name class NameForm(FlaskForm): name = StringField('What is your name?', validators=[Required()]) submit = SubmitField('Submit') @app.errorhandler(404) def page_not_found(e): return render_template('404.html'), 404 @app.errorhandler(500) def internal_server_error(e): return render_template('500.html'), 500 def make_shell_context(): return dict(app=app,db=db,User=User,Role=Role) manager.add_command('shell',Shell(make_context=make_shell_context)) manager.add_command('db',MigrateCommand) # @app.route('/', methods=['GET', 'POST']) # def index(): # form = NameForm() # if form.validate_on_submit(): # old_name = session.get('name') # if old_name is not None and old_name != form.name.data: # flash('Looks like you have changed your name!') # session['name'] = form.name.data # return redirect(url_for('index')) # return render_template('index.html', form=form, name=session.get('name')) @app.route('/',methods=['GET','POST']) def index(): form=NameForm() if form.validate_on_submit(): user=User.query.filter_by(name=form.name.data).first() if user is None: user=User(name=form.name.data) db.session.add(user) session['known']=False else: session['know']=True session['name']=form.name.data form.name.data='' return redirect(url_for('index')) return render_template('sqlDb.html',form=form,name=session.get('name'),known=session.get('known',False)) if __name__ == '__main__': db.create_all() manager.run()