Integrating Python and Database

SQLAlchemy and PyMongo

Pt1:

Integrating Python and Relational Database Management System using SQLAlchemy

Pt2:

Integrating Python with MongoDB Using Pymongo

Challenge

Part 1 - Implementing a Relational Database with SQLAlchemy

Goal:

In this challenge you will implement an integration application with SQLite based on an available relational schema. Therefore, use the schema within the client and account context to create your API classes. These classes will represent the relational database tables within the application.

Deliverable:

Application with schema definition through classes using SQLAlchemy Insertion of a minimum data set for information manipulation Execution of data recovery methods via SQLAlchemy

Part 2 – Implementing a NoSQL Database with Pymongo

Goal:

You will implement a NoSQL database with mongodb to provide an aggregated view of the relational model. As such, existing customer and account information is contained within customer-specific documents.

Perform the operations:

Connect to mongo atlas and create a database Define a bank collection to create customer documents Insert documents with the mentioned structure Write information retrieval instructions based on key-value pairs as done in class