This repository contains code related to the Real Python tutorial on CRUD operations.

You should first create a virtual environment:

$ python -m venv venv
$ source venv/bin/activate

Install the pinned dependencies from requirements.txt:

(venv) $ python -m pip install -r requirements.txt

Then you can execute crud_sql_alchemy.py to create a new database:

(venv) $ python crud_sql_alchemy.py

This will create a birds.db database that you can use to try out CRUD operations.

Start a new Python REPL to perform CRUD operations with raw SQL:

>>> from crud_sql import connect_to_db
>>> connection = connect_to_db("birds.db")
>>> create_birds = """
... INSERT INTO
...   bird (name)
... VALUES
...   ('Hummingbird'),
...   ('Sugar Glider');
... """
>>> connection.execute(create_birds)
<sqlite3.Cursor object at 0x105027bc0>

>>> connection.commit()
>>> connection.close()

You can also use SQL Alchemy to interact with the database:

>>> from crud_sql_alchemy import Session, Bird, init_db
>>> init_db()
>>> session = Session()
>>> new_bird = Bird(name="Test Bird")
>>> session.add(new_bird)
>>> session.commit()

If you're curious to explore CRUD operations with a REST API, then you can run this command in the terminal:

(venv) $ uvicorn crud_fastapi:app

Once the server is running, you can test out the Rest API endpoints by visiting http://127.0.0.1:8000/docs in your browser.

• Philipp Acsany, E-mail: philipp@realpython.com

Distributed under the MIT license. See LICENSE for more information.