stefanuddenberg
3/22/2020 - 3:41 AM

Flask -- Creating database, updating info, querying info

# From python in command line
from app import db, Participant, Image
db.create_all()
participant_1 = Participant(...)
participant_2 = Paricipant(...)
# add to staging area, like git
db.session.add(participant_1)
db.session.add(participant_2)
# commit, like git
db.session.commit()

Participant.query.all()
Participant.query.first()
Participant.query.filter_by(worker_id="ASBFDSKH").all()

# Drop all tables
db.drop_all()