sqlalchemy - choisungwook/portfolio GitHub Wiki

개요

  • flask sqlalchmey 사용 메뉴얼

엔티티 생성

참고자료: https://flask-sqlalchemy.palletsprojects.com/en/2.x/models/#simple-example

  • db.Model을 상속하여 class 정의
from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class Example(db.Models):
    __tablename__  = 'user'

    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(50), unique=True, nullable=False)
    password = db.Column(db.String(20), nullable=False)

    ...

select, where

참고자료: https://flask-sqlalchemy.palletsprojects.com/en/2.x/queries/#querying-records

  • 객체.filter_by(컬럼1=검색조건).first()
example = Example()
example.query.filter_by(email=email)).first()

블로그 유투브

⚠️ **GitHub.com Fallback** ⚠️