Skip to main content

Pip installable database schema that attempts to mimic the Fandango database

Project description

PYDANGO-PIP

pydango-pip is a pip-installable database schema that aims to mimic a movie ticket reservation database system (i.e. Fandango). It's important to note that the database represented by the package is only what I think such a system should look like, not what it actually is.

This was done in the spirit of experimentation and learning as a beginner Python programmer.

The inspiration came from a YouTube video by Mike Kennedy where he build an Air Bnb-like CLI for MongoDB with MongoEngine. I've taken a lot of his code and refactored it for SQLAlchemy and relational databases. You can find the video here: https://youtu.be/E-1xI85Zog8

You can also find the non-pip-installable version of Pydango called simply "Pydango" here: https://github.com/Captmoonshot/pydango

The regular version of Pydango is good to clone. Once you clone it, and set up a configuration file, you can use it for both an SQLite and/or PostgreSQL database backend.

However, pydango-pip will only work with SQLite database backends.

Installation

You can install pydango-pip with pip: PYPI

pip install pydango-pip

pydango-pip is supported by Python 3.7 and above.

How to use

pydango-pip is a command line application.

To run:

$ python -m pydango -d sqlite

****************** PYDANGO ******************

Welcome to Pydango for movies! What would you like to do?

[t] List a new movie [c] Find a movie

# Choose [C]

****************** Hello Cinephile ******************

What action would you like to take: [C]reate an account [L]ogin to your account Log[O]ut of your account [R]eserve a movie ticket [V]iew your movie ticket [S]ee list of available movies Search for [N]earby theaters Search by ca[T]egory [M]ain menu e[X]it app [?] Help (this info)

# Choose [S]

****************** BROWSE FOR MOVIES ******************

Title: Pulp Fiction | Rating: R Description: Boxing, Robbery, Hitmen, Samuel L. Jackson

Title: Jurassic Park | Rating: PG-13 Description: Dinosaurs, DNA, T-Rex, Velociraptor, Chaos

Title: A Clockwork Orange | Rating: R Description: Crazy, Crime, Future, Dystopian

Title: Aliens | Rating: R Description: Aliens, Eat People, Spaceship, Future

Title: Interstellar | Rating: PG-13 Description: Apocalypse, Black Hole, Time Travel, Astronauts

--More--

Personally, building the project allowed me to appreciate what database engineers do for a living, and also to grokk database designs and just how complicated relational databases can get in the wild.

Special shoutout to the Las Vegas OpenSource Programming Group fro challenging me to take on this project.

For help:

$ python -m pydango -h

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pydango-pip-1.0.2.tar.gz (18.6 kB view hashes)

Uploaded Source

Built Distribution

pydango_pip-1.0.2-py3-none-any.whl (27.8 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page