Flask SQLAlchemy增删改查

Python

# coding:utf-8 # 导入Flask类 from flask import Flask, render_template, url_for from flask_sqlalchemy import <span class="wp_keywordlink_affiliate"><a href="https://www.168seo.cn/tag/sqlalchemy" title="View all posts in SQLAlchemy" target="_blank">SQLAlchemy</a></span> from datetime import datetime import config # Flask 实例化 app = Flask(__name__) app.config.from_object(config) db = <span class="wp_keywordlink_affiliate"><a href="https://www.168seo.cn/tag/sqlalchemy" title="View all posts in SQLAlchemy" target="_blank">SQLAlchemy</a></span>(app) # db测试是否链接成功 class Article(db.Model): __tablename__ = 'article' id = db.Column(db.Integer, autoincrement=True, primary_key=True) title = db.Column(db.String(100), nullable=False) content = db.Column(db.Text, nullable=False) db.create_all() # db.create_all() # @app.route 装饰器 @app.route('/') def hello_world(): # 增加 # addarticle = Article(title="aaa", content= 'bbbb') # db.session.add(addarticle) # db.session.commit() # 查询 # result = Article.query.filter_by(title="new title").all() # for r in result: # print r.title # print r.content # 修改 # rr = Article.query.filter_by(title='aaa').first() # rr.title = "new title" # db.session.commit() # 删除 # rr = Article.query.filter_by(title='aaa').first() # # print rr # db.session.delete(rr) # db.session.commit() data = { 'title': u'这是一个标题', 'content': u'这是内容' } print url_for("get_blog", iid=100) return render_template('index.html', **data) @app.route('/blog/<iid>') def get_blog(iid): user = { 'username': u'artdoem', 'aget': 30 } data = { 'title': 'blog title', 'content': 'blog content', 'user': user, 'blog_image': '' } return render_template('blog/article.html', **data) if __name__ == '__main__': app.run(debug=True)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76

# coding:utf-8 # 导入Flask类 from flask import Flask , render_template , url_for from flask_sqlalchemy import SQLAlchemy from datetime import datetime import config   # Flask 实例化 app = Flask ( __name__ ) app . config . from_object ( config ) db = SQLAlchemy ( app ) # db测试是否链接成功     class Article ( db . Model ) :      __tablename__ = 'article'      id = db . Column ( db . Integer , autoincrement = True , primary_key = True )      title = db . Column ( db . String ( 100 ) , nullable = False )      content = db . Column ( db . Text , nullable = False )     db . create_all ( ) # db.create_all()     # @app.route 装饰器 @ app . route ( '/' ) def hello_world ( ) :      # 增加      # addarticle = Article(title="aaa", content= 'bbbb')      # db.session.add(addarticle)      # db.session.commit()        # 查询 # result = Article.query.filter_by(title="new title").all()      # for r in result:      #     print r.title      #     print r.content          # 修改      # rr = Article.query.filter_by(title='aaa').first()      # rr.title = "new title"      # db.session.commit()        # 删除      # rr = Article.query.filter_by(title='aaa').first()      # # print rr      # db.session.delete(rr)      # db.session.commit()          data = {          'title' : u '这是一个标题' ,          'content' : u '这是内容'      }      print url_for ( "get_blog" , iid = 100 )      return render_template ( 'index.html' , * * data )     @ app . route ( '/blog/<iid>' ) def get_blog ( iid ) :      user = {          'username' : u 'artdoem' ,          'aget' : 30      }      data = {          'title' : 'blog title' ,          'content' : 'blog content' ,          'user' : user ,          'blog_image' : ''      }      return render_template ( 'blog/article.html' , * * data )     if __name__ == '__main__' :      app . run ( debug = True )

• zeropython 微信公众号 5868037 QQ号 5868037@qq.com QQ邮箱