课程: SQL for Testers

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Validate user workflows

Validate user workflows - SQL教程

课程: SQL for Testers

开始一个月试用 购买团队方案

Validate user workflows

“

- [Instructor] Now that you have the testing practice site set up, let's look at how you can use SQL as a tester to validate a user workflow. Now, this is obviously a very simple site, so let's take a look at a very simple cart workflow. First of all, let's sign in so that we can add stuff to the cart. So, I'll use [email protected] and for the password, 12345. And once I'm logged in, I'll add an item to the cart and then go over to Studio to see if this was added to the database correctly. So, we'll do Select Star from Cart, semicolon, and let's run that. You can see that there is a row in our cart table with the user ID and the product ID. So that looks like it's working okay, but let's take a look at this product. So we'll do Select Star from products where product ID is equal to the product ID in our cart. So two, and we'll run this query. And you can see it's got the Woman's T-shirt, the price of $4.99. This looks like the item that we added to our cart, and this is good…

内容