Python-powered chat apps with Twilio and SendGrid Transcripts
Chapter: Using our database with the SQLAlchemy ORM
Lecture: Defining the ORM user
0:00 The other main SQLAlchemy class that we have to define is going to be
0:03 our user. And let's just go ahead and make a copy paste because there will
0:06 be some similarities here. So I'll just call this user and we'll make a few
0:10 changes. So user like that,
0:12 we're going to have an id.
0:13 In our database, as every entry has to, also have a created date.
0:17 But from then on, it's going to be a little bit different.
0:21 So our users are going to have a name,
0:23 which is a string, a phone,
0:25 which is a string, an email,
0:28 which is a string. We're also going to have orders,
0:31 which is going to be a list,
0:33 and let's actually use the typing.
0:35 And this is going to be a list of being come up here and import order
0:40 and say this is a list of order and so on.
0:43 All right now that defines our basic user class,
0:46 and we want to do something similar here.
0:49 We're going to have a user,
0:50 but in order to specify what type it is,
0:53 you can't import user here that will actually cause an issue.
0:56 So I'll just say this is a user like so,
0:58 we'll get a warning by pycharm.
1:01 But that's okay. It'll figure out what it is in the end.
1:03 All right, so we've got our user class created Name and email we've collected as
1:08 part of our studio flow phone number comes directly from the trigger.
1:12 Remember that when they come in,
1:14 they actually initiate this WhatsApp conversation with their phone,
1:16 which provides us their phone number.
1:19 We store this. This will be auto incremented,
1:21 and this is just going to be the relationships between the customers or the users and
1:25 their orders. Right? There are two main top level SQLAlchemy classes that we're going to work with.