Python-powered chat apps with Twilio and SendGrid Transcripts
Chapter: Using our database with the SQLAlchemy ORM
Lecture: Placing the order in WhatsApp
0:00 Well, we're ready to test the entire flow,
0:02 including calling into our API and talking to the database and getting information back into WhatsApp
0:07 But it's very important to remember that if WhatsApp is going to find its way
0:12 back onto our computer, two things must be happening, First,
0:16 we must be running the app over here on localhost:5000 Just hit Run!
0:21 That's running. But also remember our friend in ngrok We haven't seen in ngrok for
0:26 a while, but it's back and we're going to run it again.
0:29 This is how studio flow is going to get through into our local machine.
0:34 Now remember, I use the sub domain option because I have a pro account.
0:38 If you didn't do that, you've got a new ID potentially here.
0:42 And when you get a new id,
0:43 and you've got to go back to studio and updat it and publish it.
0:45 So just be aware they give the
0:46 URL here Changes should be good to go.
0:49 Alright with those things in place,
0:52 kick me, over a small on the red velvet coming on.
0:57 We haven't ordered a lot of red velvet,
0:59 vanilla frosting and Sprinkles.,17 gold coins.
1:07 Sure, we got lots of gold coins
1:09 It's all good. Excellent. We just need your name.
1:12 I'll put Michael. I'm going to make sure that I use my same email address
1:16 I've already used, that way
1:20 When it comes back, it's going to find again that same user and associate.
1:24 Still, a new order with it should be making that call,
1:27 Now you order has been placed.
1:29 Oh my gosh, look at that.
1:30 It's under Michael, michael@talk python.fm,
1:32 and it's order number 4 that came out of the database.
1:35 Well, let's go check the database.
1:37 Exciting. You can see the call came in perfect.
1:42 Go to our database and get our orders.
1:43 What is order for a small red velvet Sprinkles,
1:50 Vanilla, 17 gold coins? user_id is 1 and that 4:51:43
1:59 4:51, 43. I'm going to say that's what The secondary.
2:03 You don't see it there, but exactly that time,
2:04 that's our order that came in and we go to the users again.
2:09 There's just the one user because it found that email address and pulled it back and
2:14 said, that user exists or is going to put the order on to their existing
2:18 account. So that's it. We've got our database entirely integrated into our API
2:22 which received the order from studio.
2:25 The studio flow saves it validates it, sends it back beautiful.