Showing Revision 10 created 05/25/2016 by Udacity Robot.

1. Title:
   Order By Solution - Web Development
2. Description:

3. 0 0:00 - 0:02
   Okay, so here's my answer.
4. 2000 0:02 - 0:04
   The SQL is Select * From Links,
5. 4000 0:04 - 0:06
   where submitter ID equals 62443,
6. 6000 0:06 - 0:09
   order by submitted time
7. 9000 0:09 - 0:11
   ASC, for ascending.
8. 11000 0:11 - 0:16
   And these are the constraints of the question--62443 and submission time.
9. 16000 0:16 - 0:19
   And then what I'm doing is I'm iterating over the results,
10. 19000 0:19 - 0:22
    making a link,
11. 22000 0:22 - 0:25
    appending the link's ID to the list of results,
12. 25000 0:25 - 0:28
    and then I'm returning results.
13. 28000 0:28 - 0:31
    Okay, so let's go ahead and give this a run to make sure it works.
14. 31000 0:31 - 0:33
    We see our answer is 15, 18, 21.
15. 33000 0:33 - 0:36
    Those are the correct link IDs.
16. 36000 0:36 - 0:38
    My answer looks the way it does
17. 38000 0:38 - 0:40
    because I've been following the form we've been kind of working in--
18. 40000 0:40 - 0:42
    the general structure of this function.
19. 42000 0:42 - 0:44
    But if I were actually to make a function that does just this--
20. 44000 0:44 - 0:46
    just returns the IDs of the links--
21. 46000 0:46 - 0:48
    there's a couple things that are wasteful in here
22. 48000 0:48 - 0:50
    that I'll go ahead and clean up and show you.
23. 50000 0:50 - 0:53
    So the first thing is we don't need to select * from links.
24. 53000 0:53 - 0:55
    All we care about is the IDs.
25. 55000 0:55 - 0:57
    So we'll just select the IDs.
26. 57000 0:57 - 1:00
    Here we're creating a link object
27. 60000 1:00 - 1:03
    for every row we get back.
28. 63000 1:03 - 1:05
    Well, we don't actually need the link object.
29. 65000 1:05 - 1:08
    If we're just going to get the IDs from the results,
30. 68000 1:08 - 1:10
    we can just return those nearly directly.
31. 70000 1:10 - 1:13
    So let's get rid of this loop
32. 73000 1:13 - 1:16
    and instead change it to something like this.
33. 76000 1:16 - 1:18
    Okay, so I simplified this quite a bit.
34. 78000 1:18 - 1:21
    This syntax here is a list comprehension.
35. 81000 1:21 - 1:23
    It's a simple way of making a list.
36. 83000 1:23 - 1:25
    So we still run our SQL.
37. 85000 1:25 - 1:27
    This time we're selecting ID.
38. 87000 1:27 - 1:31
    And since SQLite Library in Python returns tuples of the results,
39. 91000 1:31 - 1:34
    and in this case we're only asking for the ID,
40. 94000 1:34 - 1:38
    we know the first column is going to be the ID.
41. 98000 1:38 - 1:43
    So for t in c--so for the tuple in the cursor--
42. 103000 1:43 - 1:46
    make a list of the first element of each of those tuples,
43. 106000 1:46 - 1:48
    store that in results, and return it.
44. 108000 1:48 - 1:50
    Let's go ahead and print this.
45. 110000 1:50 - 1:53
    And the answer is the same--15, 18, 101.
46. 113000 1:53 - 1:57
    Okay, so just a little extra Python there for you.
47. 117000 1:57 - 2:01
    Let's move along.