1 00:00:05,790 --> 00:00:06,360 Here. 2 00:00:07,020 --> 00:00:08,300 So now we are no different. 3 00:00:08,910 --> 00:00:10,680 And it's time to move all the. 4 00:00:11,040 --> 00:00:12,450 So you can just define the back end. 5 00:00:12,450 --> 00:00:17,260 Come on it's here that will not make any change but what I'm going to do here. 6 00:00:17,290 --> 00:00:23,350 I'll make an ad to fight that is back end or be white and import that one in this front end or what. 7 00:00:23,460 --> 00:00:26,790 So do we work together and make the program work. 8 00:00:26,820 --> 00:00:28,640 Just make a new file here. 9 00:00:28,650 --> 00:00:31,450 Or simply copy that one. 10 00:00:31,450 --> 00:00:37,810 Change the name it will make and be important here. 11 00:00:38,370 --> 00:00:39,100 And let's begin. 12 00:00:39,900 --> 00:00:48,480 So first of all I'm going to import Eskew like three maybe go then just define a function that will 13 00:00:48,480 --> 00:00:52,270 connect and create my database. 14 00:00:52,320 --> 00:00:55,300 So here I have removed the OTB. 15 00:00:55,410 --> 00:00:59,130 That is the database for my demo project. 16 00:00:59,130 --> 00:01:00,740 So that it be not kept with distance. 17 00:01:01,080 --> 00:01:01,940 And this one. 18 00:01:02,040 --> 00:01:03,390 Going to be a new database here. 19 00:01:04,260 --> 00:01:07,220 So here we don't have any file of that one previous. 20 00:01:08,160 --> 00:01:10,800 So let's begin again the five steps. 21 00:01:11,250 --> 00:01:12,550 First disconnect. 22 00:01:12,600 --> 00:01:19,170 Second because a third execution so Kosovo would execute. 23 00:01:20,040 --> 00:01:23,870 And after that one connection to commit. 24 00:01:26,280 --> 00:01:31,530 And in last close the connection there we go. 25 00:01:32,400 --> 00:01:41,430 So first of all in Connect destroyed as you like three don't connect and pass the database name you 26 00:01:41,430 --> 00:01:55,920 want to create several beam no baby maybe go after that one create a super connection to go Zo legal. 27 00:01:56,050 --> 00:01:57,650 So here we have because a variable names. 28 00:01:58,270 --> 00:02:01,260 Now execute de Come on. 29 00:02:01,270 --> 00:02:03,050 CREATE TABLE. 30 00:02:03,130 --> 00:02:09,770 So we'll create a table here with name Ruby after that one. 31 00:02:09,800 --> 00:02:16,730 In that we have the things that we require of these things. 32 00:02:16,980 --> 00:02:20,190 Date of Ning exercise the date and bite. 33 00:02:20,730 --> 00:02:27,960 And in addition in addition to these I'm also adding primary key data that is going to be an I.D. that's 34 00:02:27,960 --> 00:02:32,980 something like the things that I presented with numbers div so. 35 00:02:33,150 --> 00:02:37,920 And that will be an integer and this one is going to be a primary key. 36 00:02:39,480 --> 00:02:46,530 So the user know required to add this one it will auto increment with each of the values so a key will 37 00:02:46,530 --> 00:02:48,750 be assigned to every single entry. 38 00:02:49,260 --> 00:02:55,220 After that let's move to the ones that we require first of all the date which is going to be a trigger 39 00:02:55,230 --> 00:02:56,760 text. 40 00:02:56,760 --> 00:02:59,710 After that when we have the links. 41 00:03:00,240 --> 00:03:03,310 So of Ning you go. 42 00:03:03,650 --> 00:03:05,820 There is a Julie Stansell. 43 00:03:05,880 --> 00:03:10,160 No that's in deja vu. 44 00:03:10,350 --> 00:03:22,350 After that when we had the exercise which is text then we have the study that is also XT then night 45 00:03:23,250 --> 00:03:32,490 which is also text and then in last by then go my data by ton which is also next. 46 00:03:32,610 --> 00:03:37,150 David Now we have defined the table here. 47 00:03:37,300 --> 00:03:51,580 Now just in lost all the dysfunction data you know if you run this one back and be David go some. 48 00:03:51,680 --> 00:03:56,000 No you do not get any data notes from the previous one there. 49 00:03:56,070 --> 00:03:58,750 We need to have a database here. 50 00:03:59,190 --> 00:04:00,270 That's not actually here. 51 00:04:00,960 --> 00:04:08,310 So let me insert something in that month and see whether this one a here or not so. 52 00:04:08,440 --> 00:04:17,680 First of all I will define a function that will insert some use not just add these values here date 53 00:04:18,570 --> 00:04:32,260 then we have of names then we have exercise after that was dirty then died and last bite maybe six values 54 00:04:33,070 --> 00:04:41,740 provide the dots and these same five months for the insert also remove this one 55 00:04:44,170 --> 00:04:46,280 and David O. 56 00:04:46,690 --> 00:04:55,270 Maybe go now to insert the data just add insert in door then pass the table. 57 00:04:55,580 --> 00:04:57,330 There you go. 58 00:04:57,700 --> 00:05:01,510 And it values will be. 59 00:05:01,870 --> 00:05:04,010 So here we are working on the database. 60 00:05:04,180 --> 00:05:10,780 So first none for the primary key that will be automatically implemented and for each of these POS a 61 00:05:10,780 --> 00:05:11,660 question mark there. 62 00:05:13,140 --> 00:05:22,350 So here we have one and we have two three four five and six question marks. 63 00:05:22,350 --> 00:05:29,970 And after getting out of discourse add there are two with these whales. 64 00:05:30,660 --> 00:05:38,400 So come on C and come on b c of this one and now Edward tried to insert something in that. 65 00:05:39,180 --> 00:05:42,850 So first that we try this one again. 66 00:05:42,940 --> 00:05:48,180 David goes some or line I didn't and David go with that database routine baby. 67 00:05:48,450 --> 00:05:55,360 So we have the database here and is showing some arrows C1 is not defined in line. 68 00:05:55,560 --> 00:06:03,060 So this one also need to contain one more n so I forget to mention one more than there. 69 00:06:03,660 --> 00:06:05,490 So we are done with this one. 70 00:06:05,520 --> 00:06:07,500 And let me try it. 71 00:06:07,590 --> 00:06:10,230 David Eagle database already exists. 72 00:06:10,290 --> 00:06:18,390 So here we have our database and knowledge we tried to insert something in Denver so just insert labial 73 00:06:19,140 --> 00:06:31,760 and positive values like first date 1 to say 2019 then earning say two hundred then exercise or no exercise 74 00:06:32,350 --> 00:06:35,700 they will then not studied 75 00:06:38,240 --> 00:06:40,340 after that one night taken 76 00:06:44,360 --> 00:06:55,930 and then last did item maybe so now remove the connect right now because the connection is already established. 77 00:06:56,400 --> 00:06:56,850 Go. 78 00:06:57,750 --> 00:06:59,460 So this one running successfully. 79 00:06:59,610 --> 00:07:06,360 We have just done a little lateral fully and that is we forget to add misplaced Miss mistakenly. 80 00:07:06,830 --> 00:07:13,380 So now view come on so that we can view what we have added there. 81 00:07:14,550 --> 00:07:18,780 So I copy this whole based. 82 00:07:18,780 --> 00:07:20,300 This one here. 83 00:07:20,310 --> 00:07:27,430 So here we have the same come on nearly just change when the execute and the second is coming. 84 00:07:28,920 --> 00:07:32,500 So for this one just add select everything. 85 00:07:32,520 --> 00:07:37,540 So for that one start from grouping. 86 00:07:37,740 --> 00:07:45,130 Labial and just close decoders after that one remove the Comet Come on. 87 00:07:45,150 --> 00:07:50,870 Or just leave that one as usual because that is something you can also work without. 88 00:07:51,660 --> 00:07:54,060 So here we need to have some draws. 89 00:07:54,120 --> 00:08:04,160 So Rose is equal to cause a dot fetch phone just like we had done while we are working with view and 90 00:08:04,170 --> 00:08:13,470 in last just return those maybe go and in last we just only view here. 91 00:08:14,950 --> 00:08:24,770 View sees maybe two so it's actually working fine. 92 00:08:24,820 --> 00:08:26,760 No let me check. 93 00:08:26,760 --> 00:08:28,290 What are the values do we have there. 94 00:08:29,310 --> 00:08:39,810 So print do feel save and now run daily over the values one that is the primary key given by this one 95 00:08:40,290 --> 00:08:48,090 and one to 2019 to under no exercise not stood a take on dead Python so perfect that one is working 96 00:08:48,090 --> 00:08:57,850 perfectly fine that we try to insert one more here so that it will be shown for that so one thousand 97 00:08:57,860 --> 00:09:05,700 ninety hundred and then did exercise 98 00:09:08,650 --> 00:09:11,610 up to that one studied 99 00:09:15,570 --> 00:09:27,970 then light taken and ideally and after that one did Python labial run that one again. 100 00:09:28,010 --> 00:09:30,510 David go perfect. 101 00:09:30,590 --> 00:09:36,550 And now just print view. 102 00:09:37,390 --> 00:09:38,000 David go. 103 00:09:38,290 --> 00:09:40,130 So we'll second entries also added there. 104 00:09:40,600 --> 00:09:43,970 So this is both actually working here. 105 00:09:44,020 --> 00:09:48,880 Now let me move to another one I delete Come on. 106 00:09:48,880 --> 00:09:53,010 So define delete here and delete. 107 00:09:53,050 --> 00:09:58,500 Here we will just take aioli and that idea will be provided by the front end. 108 00:09:58,930 --> 00:10:02,020 And we'll make that one how that will put you. 109 00:10:02,040 --> 00:10:03,950 This one I did do this from back. 110 00:10:04,810 --> 00:10:07,420 So again just copy this. 111 00:10:07,420 --> 00:10:10,720 Come on come on. 112 00:10:10,720 --> 00:10:11,610 See. 113 00:10:11,680 --> 00:10:17,110 Come on feet day we had this one and just a change the execute. 114 00:10:18,140 --> 00:10:20,140 There we go. 115 00:10:20,290 --> 00:10:32,020 So here for deletion just add delete from grouping Real I.D. equal to push and lock and then go out 116 00:10:32,050 --> 00:10:33,630 the idea. 117 00:10:34,360 --> 00:10:41,050 And if you remember in delete we also need to provide a quagmire because we need to delete all the values 118 00:10:41,110 --> 00:10:42,340 after the idea. 119 00:10:42,340 --> 00:10:45,160 That is data ending exercise study data and byte. 120 00:10:46,330 --> 00:10:51,130 So save this one and I'll try to delete 121 00:10:53,910 --> 00:11:07,900 I like to maybe you so not one just from the Bakken we've got some arrows so I feel to close these quotes 122 00:11:08,840 --> 00:11:17,870 so all we need to close these quotes so it will not show error the here quotes save this one on it again. 123 00:11:17,920 --> 00:11:19,470 David go. 124 00:11:20,170 --> 00:11:23,560 So small mistakes here showing great errors. 125 00:11:23,830 --> 00:11:30,390 Now we view that fine print view. 126 00:11:30,390 --> 00:11:31,630 There we go. 127 00:11:32,440 --> 00:11:34,200 So now we have only one entry. 128 00:11:34,330 --> 00:11:35,730 Second is deleted. 129 00:11:37,090 --> 00:11:39,100 So then with this one.