Python-powered chat apps with Twilio and SendGrid Transcripts
Chapter: Course conclusion and review
Lecture: Review: SQLAlchemy model class
Login or purchase this course to watch this video and the rest of the course contents.
0:00 Eventually we wanted to save the information that we got from twilio and all the computation that we did. Save that into a database.
0:09 We're going to use that for admin backend We're going to use that later for probably when a customer comes into the store and
0:14 we pull it up on our application and say, Oh yeah, here's the order and we're ready to hand your cake over and so on. So in order to do that,
0:22 we use SQLAlchemy. Instead of going straight to the database and defining the tables there, we said, Well,
0:27 let's define some classes, in this case, a user class that derives from SQLalchemy base
0:32 And we said it's going to correspond through the Dunder table name over to the
0:37 users table in the database, and we mapped out the columns as fields in the classes with SQLalchemy column types.
0:43 So, for example, the 'id' is a string and code, but in practice and SQLAlchemy Landed, it's a SQLAlchemy column, which is a SQLAlchemy string.
0:52 It's a primary key, and in this case it has a default id of some arbitrary uuid, we're generating we have created date.
0:59 It's datetime. It has the default of datetime. Now, now be really careful. You don't want now parentheses just now. The function with the name, phone,
1:09 email and so on. And we also have orders. And we created a relationship which was very useful in binding our orders and our users
1:18 together encode, for example, when we wanted to insert an order into the data base, we just found the users,
1:23 put it onto the order, object and SQLAlchemy to put that into the database.
1:28 That's it. When I create a couple classes and SQLAlchemy will actually create the tables for us. When it first sees those classes,
1:34 Just remember it won't propagate changes after it's already created the table.