WEBVTT 1 00:00:01.080 --> 00:00:02.900 Hi guys and welcome back. 2 00:00:02.900 --> 00:00:04.870 In this video we're going to look at an overview 3 00:00:04.870 --> 00:00:08.260 of the project we'll be building in this first section. 4 00:00:08.260 --> 00:00:10.470 The project is a programming journal 5 00:00:10.470 --> 00:00:13.240 that uses SQLite as a database. 6 00:00:13.240 --> 00:00:16.750 In this journal we're going to be able to add new entries 7 00:00:16.750 --> 00:00:18.560 or view existing entries to keep track 8 00:00:18.560 --> 00:00:20.870 of our programming learning. 9 00:00:20.870 --> 00:00:23.457 When users first run our app they're going to see 10 00:00:23.457 --> 00:00:24.890 any prompt like this one. 11 00:00:24.890 --> 00:00:27.539 A quick welcome at the top and then the three options 12 00:00:27.539 --> 00:00:30.010 that they've got in the menu. 13 00:00:30.010 --> 00:00:32.500 One to add new entries, two to view entries, 14 00:00:32.500 --> 00:00:33.550 or three to exit. 15 00:00:33.550 --> 00:00:36.280 And finally they can enter their selection at the bottom. 16 00:00:36.280 --> 00:00:39.080 To add new entries, the user is first gonna press one 17 00:00:39.080 --> 00:00:41.480 to enter that option in the menu. 18 00:00:41.480 --> 00:00:44.420 And then we'll ask them for the date and contents 19 00:00:44.420 --> 00:00:45.373 of the entry. 20 00:00:46.410 --> 00:00:47.930 These are gonna be two separate prompts. 21 00:00:47.930 --> 00:00:50.120 So the contents are gonna go in one prompt, 22 00:00:50.120 --> 00:00:52.870 one input call, and the date is gonna go 23 00:00:52.870 --> 00:00:53.860 in another prompt. 24 00:00:53.860 --> 00:00:54.860 Something like this. 25 00:00:55.860 --> 00:00:58.230 So the what you have learned today is a prompt. 26 00:00:58.230 --> 00:01:00.700 The user will type behind that and will tell 27 00:01:00.700 --> 00:01:01.990 us what they've learned today. 28 00:01:01.990 --> 00:01:03.760 And then we'll ask them for the date. 29 00:01:03.760 --> 00:01:05.431 And we're going to store both of those things 30 00:01:05.431 --> 00:01:07.383 in our database. 31 00:01:08.320 --> 00:01:10.490 If the user presses two in the menu 32 00:01:10.490 --> 00:01:12.876 instead of one, then we're gonna show them their entries. 33 00:01:12.876 --> 00:01:15.260 And for each entry we'll show the date 34 00:01:15.260 --> 00:01:16.830 and the content of the entry. 35 00:01:16.830 --> 00:01:17.810 Something like this. 36 00:01:17.810 --> 00:01:19.684 So here you can see that on the first of January 37 00:01:19.684 --> 00:01:23.340 the user learned how to start coding with Python and SQL. 38 00:01:23.340 --> 00:01:24.470 And then on the second of January 39 00:01:24.470 --> 00:01:26.970 they worked with some more SQL, and so on. 40 00:01:26.970 --> 00:01:28.860 Of course notice that the dates here 41 00:01:28.860 --> 00:01:31.760 could mean different things in the United Kingdom 42 00:01:31.760 --> 00:01:33.430 and the United States, for example. 43 00:01:33.430 --> 00:01:35.830 But we're not going to worry about dates 44 00:01:35.830 --> 00:01:37.050 and date formatting and things like that 45 00:01:37.050 --> 00:01:38.660 in this application. 46 00:01:38.660 --> 00:01:39.860 We'll look at that later on 47 00:01:39.860 --> 00:01:42.703 when we learn more about working with dates in SQL. 48 00:01:44.460 --> 00:01:46.980 Finally after the user makes a selection 49 00:01:46.980 --> 00:01:48.570 we preform the appropriate action, 50 00:01:48.570 --> 00:01:51.140 be that to add an entry or to view the entries. 51 00:01:51.140 --> 00:01:52.270 They can choose another. 52 00:01:52.270 --> 00:01:54.470 And we will continually ask them to choose 53 00:01:54.470 --> 00:01:56.805 another option until they decide to exit the application 54 00:01:56.805 --> 00:01:59.030 by entering three. 55 00:01:59.030 --> 00:02:01.490 So here's the complete flow of our application. 56 00:02:01.490 --> 00:02:03.910 Let's say that the user starts by adding a new entry. 57 00:02:03.910 --> 00:02:05.773 They enter one down there at the bottom. 58 00:02:05.773 --> 00:02:08.210 Then we ask them what they've learned today 59 00:02:08.210 --> 00:02:09.660 and they enter the date. 60 00:02:09.660 --> 00:02:12.410 And then we ask them again to select another option 61 00:02:12.410 --> 00:02:13.668 and this time they enter two. 62 00:02:13.668 --> 00:02:16.940 We will then print out the date and the contents 63 00:02:16.940 --> 00:02:19.160 and then we'll ask them again for another option 64 00:02:19.160 --> 00:02:21.253 in the menu and this time they decide to enter three 65 00:02:21.253 --> 00:02:23.890 and the application terminates. 66 00:02:23.890 --> 00:02:25.270 All right, let's get coding. 67 00:02:25.270 --> 00:02:27.570 Let's implement this project throughout this section. 68 00:02:27.570 --> 00:02:29.223 I'll see you in the next video.