flask下,实现简单博客2
创建数据库
drop table if exists entries; create table entries ( id integer primary key autoincrement, title string not null, text string not null );
将上面的代码保存到schema.sql 文件中。
创建views.py
from __future__ import with_statement
from sqlite3 import dbapi2 as sqlite3
from flask import Flask, request, session, g, redirect, url_for, abort, render_template, flash, _app_ctx_stack
# configuration
DATABASE = 'blog.db'
DEBUG = True
SECRET_KEY = 'development key'
USERNAME = 'admin'
PASSWORD = '123'
# create our little application :)
app = Flask(__name__)
app.config.from_object(__name__)
app.config.from_envvar('FLASKR_SETTINGS', silent=True)
def init_db():
"""Creates the database tables."""
with app.app_context():
db = get_db()
with app.open_resource('schema.sql') as f:
db.cursor().executescript(f.read())
db.commit()
在shell模式下运行
from flaskr import init_db >>> init_db()
执行完后,将创建数据库和表。