So, uh, welcomebacktoanotherstreamandanothervideo.
What I'vedonenowis I'vecreatedjust a littlebitof, ahnotesformyintrobecause I justwantedtomentionsomething a littlebitquicklybeforeyougetstarted.
Becausetodaywhatwe'regonnadoiswe'regonnatrytobuildoutthewrist a p i forthisappthatwe'vebeenbuildingthelastcoupleofdays, thelastcoupleofvideosand, uh, what I wantedtomentionbeforewestart.
Sowhat I trytodohardwithmynormalvideos I doonYouTubeis I reallytriedtoshowthat I likeexactlyhowitis, howgoodorbad I am a coding.
Butit's sometimesoneofthosethingswhereif a videoturnsouttobelike 30 minuteslongand 15 ofthoseminutesisbeingspentjustonthesameproblemoverandovertryingtosolveit, I mighthavetocutthatoutjustbecause a 15 minutevideotendstodo a lotbetterthan a 30 minutevideo.
So I trytokeepthemshort.
Sobut I triedtokeepinsomeerrorsthat I dojusttokindofshow a realisticpictureofwhatitlookslikewhen I code, andwhat I'vebeengettingtheimpressionofisthatsomepeopleseemtothinkthat I'm likesomegodwhenitcomesThioprogrammingencoding.
Soandthat's notreallythecasethatold.
Andthat's kindofwhy I feellikethis.
Siri's is a goodwaytoreallyshowexactlyhowitisandexactlywhatitlookslike.
I don't catchanythingout, andit's justwhat I'm doinghereisexactlyhowgoodorbad I am a coatingwhich I thinkisreallygood.
I think I haven't reallyseenanyoneelsedodoanentirelivebuildovenappfromzeroto a completefinishedappthat's published s Oh, that's alsooneoftheideaswithandthenalsothisstreamkindofbuildsomeinterest, hopefullyintheappleonbuilding, sothatwhen I doreallysit, maybesomesomeofyouguyswillwanttodownloadIt s sothat's kindoftheideawithitanyway.
And I alsoconsiderthesestreamsnotjustpuretutorials, since I'm alsolearningthesethingsmyselfas I'm buildingitout, I considerhimkindof a mixbetweentutorialsandalsokindofjusthangoutswhere I'm coding.
It's like a tutorial, since I'm actually, likeexploringsomeofthesethingsmyselfinthestream.
Sowiththatsaid a littlebitof a longintro.
Butnowwe'regonnagetintoactuallybuildingouttherest A p I Sowhat I'vedone, Yes, I'vecreated a I think I mentionedthislasttimeinthelaststreamorvideo, andthatisthat I'vecreatedkindofanoutlineforwhat I thinkwe'regonnaneedinorderalloftheclassesand, uh, thensothisisessentiallywhatwe'regonnahavetobuildouttoday.
We'regonnatrytogetthedaughterbasesetupandthenalsogetintogettheflaskappupandrunning, andthenwe'llgothroughandtrytocreateallofclassesthatwe'regoingtoneedandtheninsertthatintothetableandkindofgetthevery, verybasicfunctionalityofthe A p I ordaughterbaseupandworking.
Okay, I thinkthat's actually a goodthingtohave, becausefromwhat I understandit, it's goingtobeessentiallythatweaddendpointshereandthatwillthencallalloftheseorthisfile.
Let's say, umsoessentially, thenwewouldhaveoneoftheseclasseshereandoneofthesefilesforadding a newtaskandthen a separatefileforadding a newproject.
Sointhatway, withinseparatingthemsothatitdoesn't become a hugelongfileoffallthedifferentinpointsthatwehaveandallthedifferentgetandputrequests.
Um, I thinkit'llmakemoresenseonceifyoudon't understandthisrightnow, I thinkit'llmakemoresense.
Onceweactuallygetit a littlebitupandrunningon, wecontestit.
So, uh, wehaveresourceisrightnowwhatwe'regoingtodoinsideresourceiswe'regonnaaddtaskpieandthisEssentially, I thinkwe'regonnaaddallofthedifferentendpointsbasedonorthefilesthatweregonnaadherearegonnabebasedonalloftheclassesthatwedecidedwe'regonnahave.
Sowe'regonnahaveprojects, supportfile.
Andyou, sir, becausewhatyoucandofromtheapples, youcaneitherget a task.
SonowitshouldbeItshouldn't beatleastspellingerrorsunlesstheirsparespellingerrorsinthewhathe's putouthere, which I mean, theremightbe.
Butthequestionis, whydoesthisnotwork?
Resourceis, don't you, sir?
Okay, let's justcopythatonDDE.
That's a reallyname.
Thisfilehere.
Nomoduleneighboringsources.
You, sir.
Okay, Nomodulenamedresourceisbye.
How?
Oh, okay.
Maybeifwegofurtherdown.
Becausesometimes I followedoneoftheseonesbefore, andwhat I noticedwasthat I didn't getittoworkeitherthefirsttime, andthen I scrolleddownintothistutorialand, like, way, waydown.
Thenwehavetheideaoftheuser, whichis a string, andthat's a primarykey.
Allofthesethingsisnotsuperimportantrightnow.
They're a littlebitadvancedthat I don't know.
I don't knowthemenoughtoactuallybeabletoexplainthemin a waythatwouldmakesense.
I don't think.
But I thinkthat a primaryKIIS, likeessentially, whenyouwanttogetsomethingfromthedaughterbase, youneedtoprovidesomethingsothatyoucanthentellthedollarbased, likewhatareyoutryingtoget?
Solet's saythatwewhenyouwanttogetsomethingfromthedaughterbutdatabaseyoutypeinselectsolikeandthenyoucantypeinsomesortoflike a conditionwhereyouwanttoselectsomething.
Solet's saythatyouwanttoselect a yusorwheretheusernameisequalThiocalorsomethinglikethat, thenyoucanprovidethathere.
NotsureLet's justlookthatupquickly.
So, likefromdaughterBays s Q L Okay, sowhatwecoulddo, forinstance, wecoulddoselectstarfrom, umthat's a tasksWhere, uh, you, sir, I d Let's sayissequaltoforwhatwesay.
Sothisthenwillselecteverytaskfromourtablecalledtaskswheretheuseour d a sequelto 12 soorwhereyoucouldalsodowhereusernameisequaltoCal, whichiswhat I use.
Wemightget, uh, Cow X andCal Y andCowsaid, Youknow, likeseveralotheruseswiththesamenameorwiththesamefirstname, wemightgetalltheirtestsaswell, whichisnotwhatwewant.
Dowewanttogetthetasksforthatspecificuser, whichmeansthatweneedsomethingcalled a primarykey, whichneedstobeuniqueinthiscaseifwewanttobeabletoactuallygetjustthetestsreferredtoorthetasksthatthisspecificuseourhouse.
Sotherefore, someofthecasethatwehave, orsomeofthefieldsoryetfieldsinourdaughterbasewillneedtobeuniquesothatwecanactuallygetsothatwecangetthespecificonesthatwewantthatwas a longexplanation, but I think I thinkit's kindof I hopeyoukindofunderstoodwhat I meant.
Allright.
Sotherefore, weneedan I d.
Thathastohave.
Thathastobe a primarykey.
Andithastobeunique.
Andthatmeansthatwecanthenusethis I d togetdaughterthatisrelatedtoonespecificyusor.
Andtheusernameisalso a primarykey.
Becausewhat I wantintheintheofficefortheusernametoactuallybeuniquebecause I don't wantyoutobeabletohavethreepeoplewiththeexactsameusernameinsomemaps.
Thatdoesn't reallymakematter.
Soyoucanhavethisnotbe a primarykey, Butthenthefirstnamelastnamethat's justgonnabe a stringpasswordisjustgonnabe a stringemailaddressisjustgonnabe a stringaswell.
Let's take a lookatourclassherelastnight.
Passwordemail a p i keright.
Somethingthat I I'm notveryfamiliarwitheither.
Butissomethingthat I thinkweshouldhave a swell.
It's called a P.
I ke, and I'm notsurehowyouwouldactuallytypethisin, butthatiswhatweessentiallywe'regonnausesothatwecanaccessallofthedifference.
I guesstheuser i d couldbean A P I t.
In a sense, but I thinkitmakessensetohaveto, umandwhatthe A p I kedoesisessentiallyitauthorizestheuseorforus.
So, forinstance, ifyouhave a napandyougointoitandyoudon't havetologinnewanymore, thatisbecauseyou'vegotan A p I hestoredprobablyonyourdevice.
I wouldguessagain, I'm verynewtothis.
I'm notsureexactlywhereitgetsstored, but I thinkit's storedlocallyonyourdevice.
Andassoonasyouopenuptheappthis a p I hegetssenttothedaughterbaseortotheFBI, andthenitbasicallyauthorizesyouforyeah, justtheauthorizationforyou.
Now, I'm notsureexactlywhattypeofhashingfunctionwe'regonnause, and I'm notsurethat I canactuallysharetheashenfunction.
No, I've I know, likeyouprobablyseenow I know a littlebitabouthowitworks, but I don't.
I'm notanexpert, like I said, and, uh, sotherefore, I don't knowquiteallthedetailsofit, but I thinkthat's somethingthat I canprobablysharethebuildoutoffthathashingfunction.
Andthen I canprobablychangeitto a differenttypeofhashingfunctionafterwards, sothatyougettoseemebuildingthatout, andthen I willjustchangeitsothat a lltheuseofdataisnotjustexposedoreasilyhackable, butthatcouldalsobesomethingthat's automaticallytakencareofbythehashingfunction.
Somuchwork.
Allright.
Okay, sotherewego.
Wehavethisnow, whichis I d a p i ke.
Allright.
It's okay.
Sotherewego.
Wehavethatoneup.
Um, I thinkwe've I'm notsurehowlongwe'vebeenactuallystreamingforrightnow, because I'm notsure I don't wanttokeepittoolong.
And I feellikethis 1 maynotbethemostentertainingonetoewatch.
I thinkthenextone, thenextdreamisprobablygoingtobe a littlebitmoreentertainingbecausethat's whenwe'regonnaNow, I'vejustlikethisentirestreamisprettymuchgonetowardsfiguringouthowtoseteverythingofthisstuffupsothatwehavetheserverupandrunningandhave, um, a p I somewhatworking.
Butnexttime, I thinkwewill.
Nexttimeiswhenwe'reactuallygoingtogetinto, like, allofthisstuff, creatingthenewdaughterbasetablesforthetasksandcreatingthetablesfortheprojectsand a lltheotherclassesthatwegothere.
Um, allright, because I don't wanttostartanythingaswellatthistimeandthenrealizethatit's gonnatakemeanhourtofinish, Sowe'llsee.
Andnexttimewe'regoingtogointoactuallymakingthis, uh, makingsomeendpointshereliketasksandbasicallythatshouldthenreturn a listoftasksfor a differentuse.
Sir, we'regonnacreateanAP i ke.
Um, Andthenoncewe'vedone a fewoftheendpoints, we'realsogoingtofinishthedaughterbaseorthetablesfortheSQLdatabasesothatwehaveallthatsetup, andthenwe'regoingtotrytofigureout a waytogetallofthestufffromtheseendpoints.