The purpose of this video is to present SQLAlchemy, Python’s well-known ORM package, present the new data model for our project and present how to use SQLAlchemy in Python with the MySQL database engine.
- [Instructor] Hi and welcome to the second video…of Section Two: using SQLAlchemy for Model Mapping.…In the previous video, we looked at the basics of…CRUD operations and Arrest API best practices.…Now we will start to apply everything we learned…here now in our project.…In this video, we are going to take a look…at what SQLAlchemy is, how can we use it…with MySQL database engine,…and we will review our data model structure…for our mini HR project.…SQLAlchemy is a Python package which has two modules.…In the first place, it's an SQL toolkit.…
Since we will store all our data in a SQL like database,…we need a toolkit for managing that data.…Second, SQLAlchemy has a very good…Object Relational Mapper engine.…It implements an enterprise level persistence model…and follows the same unit of work model…which Java's well known OM, Hibernate, does.…Now we will look at the new model structure…of our application.…In this table, we can see all the entities and their fields.…We have six models: Candidate, Client,…Interview, Position, Recruiter and Review.…
Regardless of platform, you will need to build APIs to serve data between different client applications and endpoints. Good APIs are a necessity for web and mobile projects, especially with the modern, mobile-first approach to development. This course delivers the fundamental knowledge required to enable highly connected interactions between applications via RESTful web APIs. Follow along with Gergo Bogdan and learn how to build up and structure an effective web API that can be used by any client application accessing it over HTTP, using Flask, the Python microframework.
Find out how to implement CRUD operations using SQLAlchemy and MySQL as the data store. Get an understanding of how REST works relative to APIs, and learn how to test APIs written in Python with the support of Flask. Explore token-based authentication and find out how to store passwords securely in your database. Along the way, Gergo introduces best practices and design guidelines when building large applications.
- Setting up Flask
- Using Flask templates and routing
- Implementing CRUD operations
- Implementing pagination
- Configuring RESTful authentication
- HTTP caching
- Securing web APIs
- Testing the application