FastAPI| Arbeiten mit FastAPI
Installation
FastAPI basiert auf den nachfolgenden leistungsfähigen Paketen:
pip install fastapi
pip install fastapi
pip install fastapi
Oder die Installation von FastAPI mit allen Komponenten
pip install fastapi[all]
pip install fastapi[all]
pip install fastapi[all]
pip install uvicorn[standard]
pip install uvicorn[standard]
pip install uvicorn[standard]
Arbeiten mit Datenbanken
Alembic
Alembic ist ein leichtgewichtiges Datenbankmigrationstool zur Verwendung mit dem SQLAlchemy Database Toolkit für Python.
pip install alembic
alembic init alembic
alembic list_templates
alembic init --template generic ./scripts
pip install alembic
alembic init alembic
alembic list_templates
alembic init --template generic ./scripts
pip install alembic alembic init alembic alembic list_templates alembic init --template generic ./scripts
Migrationsskript zur Erstellug der Tabelle ‘account’
alembic revision -m "create account table"
alembic revision -m "create account table"
alembic revision -m "create account table"
Migrationsskript bearbeiten
def upgrade():
op.create_table(
'account',
sa.Column('id', sa.Integer, primary_key=True),
sa.Column('name', sa.String(50), nullable=False),
sa.Column('description', sa.Unicode(200)),
)
def downgrade():
op.drop_table('account')
def upgrade():
op.create_table(
'account',
sa.Column('id', sa.Integer, primary_key=True),
sa.Column('name', sa.String(50), nullable=False),
sa.Column('description', sa.Unicode(200)),
)
def downgrade():
op.drop_table('account')
def upgrade(): op.create_table( 'account', sa.Column('id', sa.Integer, primary_key=True), sa.Column('name', sa.String(50), nullable=False), sa.Column('description', sa.Unicode(200)), ) def downgrade(): op.drop_table('account')
Migration durchführen
alembic upgrade head
alembic upgrade head
alembic upgrade head
Migrationsskript erstellen für das Hinzufügen einer Spalte
alembic revision -m "Add a column"
alembic revision -m "Add a column"
alembic revision -m "Add a column"
Migrationsskript bearbeiten
def upgrade():
op.add_column('account', sa.Column('last_transaction_date', sa.DateTime))
def downgrade():
op.drop_column('account', 'last_transaction_date')
def upgrade():
op.add_column('account', sa.Column('last_transaction_date', sa.DateTime))
def downgrade():
op.drop_column('account', 'last_transaction_date')
def upgrade(): op.add_column('account', sa.Column('last_transaction_date', sa.DateTime)) def downgrade(): op.drop_column('account', 'last_transaction_date')
Migration durchführen
alembic upgrade head
alembic upgrade head
alembic upgrade head