PyMDb

Welcome to the Python Movie Database!

Built using Piccolo, Piccolo Admin, and FastAPI.

Created for a presentation given at PyData Global 2021.

Running it

Create a Postgres database called 'pymdb' (see piccolo_conf.py for the details).

pip install -r requirements.txt
piccolo migrations forwards all
piccolo movies load_data
piccolo user create

To run the server:

python main.py

Then load localhost:8000 in your browser. localhost:8000/admin shows the admin interface, and localhost:8000/docs shows the Swagger docs.

Creating something similar

To create your own app like this from scratch, start with the following:

pip install piccolo['all']
piccolo asgi new

Demo Python project using Conda and Poetry

Conda Poetry This is a demonstration of how Conda and Poetry can be used in a Python project for dev dependency management and production deployment.

2 Apr 26, 2022

Serverless demo showing users how they can capture (and obfuscate) their Lambda payloads in Datadog APM

Serverless-capture-lambda-payload-demo Serverless demo showing users how they can capture (and obfuscate) their Lambda payloads in Datadog APM This wi

1 Nov 2, 2021

Demo content - Automate your automation!

Automate-AAP2 Demo Content - Automate your automation! A fully automated Ansible Automation Platform. Context Installing and configuring Ansible Autom

0 Oct 27, 2022

Repo to demo translating colab/jupyter notebook to streamlit webapp

2 Feb 2, 2022

Demo of using DataLoader to prevent out of memory

3 Jun 25, 2022

Sample microservices application demo

Development mode docker-compose -f docker-compose.yml -f docker-compose.dev.yml up -d or export COMPOSE_FILE='docker-compose.yml:docker-compose.dev.ym

1 Nov 14, 2021

Demo of connecting Rasa with Zalo

6 Jul 25, 2022

Demo repository for Saltconf21 talk - Testing strategies for Salt states

Saltconf21 testing strategies Demonstration repository for my Saltconf21 talk "Strategies for testing Salt states" Talk recording Slides and demos Get

3 Mar 31, 2022

Demo code for "Logs in distributed systems" webinar

Hexlet Logs Demo Пререквизиты docker-compose python3 Учетка в DataDog Базовое понимание, что такое логи (можно почитать гайд

1 Dec 1, 2021

Comments

Engine AC doesn't contain start/close_connection_pool() method.
@app.on_event("startup") async def open_database_connection_pool(): engine = engine_finder() await engine.start_connection_pool() @app.on_event("shutdown") async def close_database_connection_pool(): engine = engine_finder() await engine.close_connection_pool()

This code is in many of the sample applications. The engine_finder() is typed as Engine, which is an abstract class. It doesn't however provide an (@abstract)method for start_connection_pool() and close_connection_pool(). These methods only exist in the concrete subclass for Postgres. Hence vscode/pylance complain about non-existing methods.

I can do a PR, but am unsure about best solution. Personally I would add these methods as normal methods to the Engine class, just providing a colored_warning() that pooling is not implemented for the provided engine.

Alternatively all sample programs using the connection pool could be changed like:

@app.on_event("startup") async def open_database_connection_pool(): engine = engine_finder() if isinstance(engine, PostgresEngine): await engine.start_connection_pool()
opened by gmos 1