{"id":7994,"date":"2021-07-08T09:47:35","date_gmt":"2021-07-08T07:47:35","guid":{"rendered":"http:\/\/blog.via-internet.de\/?p=7994"},"modified":"2021-08-06T15:37:53","modified_gmt":"2021-08-06T13:37:53","slug":"fastapi-arbeiten-mit-fastapi","status":"publish","type":"post","link":"https:\/\/via-internet.de\/blog\/2021\/07\/08\/fastapi-arbeiten-mit-fastapi\/","title":{"rendered":"FastAPI| Arbeiten mit FastAPI"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Installation<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">FastAPI basiert auf den nachfolgenden leistungsf\u00e4higen Paketen:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.starlette.io\/\" target=\"_blank\">Starlette<\/a>&nbsp;f\u00fcr deb Web-Teil.<\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/pydantic-docs.helpmanual.io\/\" target=\"_blank\">Pydantic<\/a>&nbsp;f\u00fcr den Daten-Teil.<\/li><\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">pip install fastapi<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Oder die Installation von FastAPI mit allen Komponenten<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">pip install fastapi[all]<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">pip install uvicorn[standard]<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Arbeiten mit Datenbanken<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Alembic<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/alembic.sqlalchemy.org\/\">Alembic<\/a>&nbsp;ist ein leichtgewichtiges Datenbankmigrationstool zur Verwendung mit dem <a href=\"https:\/\/www.sqlalchemy.org\/\">SQLAlchemy<\/a>&nbsp;Database Toolkit f\u00fcr Python.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">pip install alembic\nalembic init alembic\nalembic list_templates\nalembic init --template generic .\/scripts<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Migrationsskript zur Erstellug der Tabelle &#8216;account&#8217;<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">alembic revision -m \"create account table\"<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Migrationsskript bearbeiten<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">def upgrade():\n    op.create_table(\n        'account',\n        sa.Column('id', sa.Integer, primary_key=True),\n        sa.Column('name', sa.String(50), nullable=False),\n        sa.Column('description', sa.Unicode(200)),\n    )\n\ndef downgrade():\n    op.drop_table('account')<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Migration durchf\u00fchren<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">alembic upgrade head\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Migrationsskript erstellen f\u00fcr das Hinzuf\u00fcgen einer Spalte<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">alembic revision -m \"Add a column\"\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Migrationsskript bearbeiten<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">def upgrade():\n    op.add_column('account', sa.Column('last_transaction_date', sa.DateTime))\n\ndef downgrade():\n    op.drop_column('account', 'last_transaction_date')<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Migration durchf\u00fchren<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">alembic upgrade head<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Installation FastAPI basiert auf den nachfolgenden leistungsf\u00e4higen Paketen: Starlette&nbsp;f\u00fcr deb Web-Teil. Pydantic&nbsp;f\u00fcr den Daten-Teil. Oder die Installation von FastAPI mit allen Komponenten Arbeiten mit Datenbanken Alembic Alembic&nbsp;ist ein leichtgewichtiges Datenbankmigrationstool zur Verwendung mit dem SQLAlchemy&nbsp;Database Toolkit f\u00fcr Python. Migrationsskript zur Erstellug der Tabelle &#8216;account&#8217; Migrationsskript bearbeiten Migration durchf\u00fchren Migrationsskript erstellen f\u00fcr das Hinzuf\u00fcgen einer Spalte Migrationsskript bearbeiten Migration durchf\u00fchren<\/p>\n","protected":false},"author":1,"featured_media":7995,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[96,65,126],"tags":[127,114,128],"class_list":["post-7994","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fastapi","category-python","category-tutorial","tag-fastapi","tag-python","tag-tutorial"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/7994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/comments?post=7994"}],"version-history":[{"count":1,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/7994\/revisions"}],"predecessor-version":[{"id":8372,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/7994\/revisions\/8372"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/media?parent=7994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/categories?post=7994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/tags?post=7994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}