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 details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

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

Uploaded Python 3

File details

Details for the file pydango-pip-1.0.2.tar.gz.

File metadata

  • Download URL: pydango-pip-1.0.2.tar.gz
  • Upload date:
  • Size: 18.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.3.0 pkginfo/1.7.0 requests/2.25.1 setuptools/51.0.0 requests-toolbelt/0.9.1 tqdm/4.56.0 CPython/3.8.7

File hashes

Hashes for pydango-pip-1.0.2.tar.gz
Algorithm Hash digest
SHA256 1621c2d9a98ac133d3ec20d27b890a39c9a442817ddbf021901aabc83989437b
MD5 9d0a9bab048629c5d4b31b8c3afb4515
BLAKE2b-256 8300a2055dcfb44c4c88fd8dead8c98a986547acf28133e32fbc692317651100

See more details on using hashes here.

File details

Details for the file pydango_pip-1.0.2-py3-none-any.whl.

File metadata

  • Download URL: pydango_pip-1.0.2-py3-none-any.whl
  • Upload date:
  • Size: 27.8 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.3.0 pkginfo/1.7.0 requests/2.25.1 setuptools/51.0.0 requests-toolbelt/0.9.1 tqdm/4.56.0 CPython/3.8.7

File hashes

Hashes for pydango_pip-1.0.2-py3-none-any.whl
Algorithm Hash digest
SHA256 be4616cf1e45c749a100ac424e0467c9af5cafed17049c58a4647d8fb28a2895
MD5 0ec07f88e60a8a9a0573f4d7919f424f
BLAKE2b-256 8da5f73aafd8ddadf21f7a026958ac7e401711b0f5a3bfbb95e8349344866441

See more details on using hashes here.

Supported by

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