mysql

MYSQL

来自百度的myaql模块：https://www.cnblogs.com/loleina/p/6421470.html

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()


def init_db(app):
    db.init_app(app)


class Person(db.Model):
    p_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    p_name = db.Column(db.String(16))

import random

from flask import Blueprint, render_template

from App.Model import Person, db

from manage import db

blue = Blueprint('blue_first', __name__)


@blue.route('/')
def hello_world():
    return 'Hello World!'


@blue.route('/create/')
def create():
    db.create_all()
    return '创建数据库成功！'


@blue.route('/add/')
def addadmin():
    admin = Person()
    admin.p_name = '不要玩手机了%d' % random.randrange(50)
    db.session.add(admin)
    db.session.commit()
    return '添加数据成功！'


@blue.route('/personlist/')
def personlist():
    persons = Person.query.all()
    for person in persons:
        print(person.p_name)
        print(type(person))
    return render_template('personlist.html', persons=persons)

from flask import Flask
from flask_script import Manager

from flask_sqlalchemy import SQLAlchemy

from App.Model import init_db
from App.View import blue

app = Flask(__name__)
manager = Manager(app=app)
app.register_blueprint(blueprint=blue)  # alt+enter
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///Person.db'
# db = SQLAlchemy(app) # 通过类`SQLAlchemy`来连接数据库


init_db(app)

if __name__ == '__main__':
    manager.run()