Clone – MySQL

Resources

Read or watch:

• cmd module
• packages concept page
• unittest module
• args/kwargs
• SQLAlchemy tutorial
• How To Create a New User and Grant Permissions in MySQL
• Python3 and environment variables
• SQLAlchemy
• MySQL 8.0 SQL Statement Syntax
• AirBnB clone – ORM

Learning Objectives

At the end of this project, you are expected to be able to explain to anyone, without the help of Google:

General

• What is Unit testing and how to implement it in a large project
• What is *args and how to use it
• What is **kwargs and how to use it
• How to handle named arguments in a function
• How to create a MySQL database
• How to create a MySQL user and grant it privileges
• What ORM means
• How to map a Python Class to a MySQL table
• How to handle 2 different storage engines with the same codebase
• How to use environment variables