{"interactiveVideo":{"video":{"startScreenOptions":{"title":"Interactive Video","hideStartTitle":false},"textTracks":{"videoTrack":[{"label":"Subtitles","kind":"subtitles","srcLang":"en"}]},"files":[{"path":"videos\/files-5f7f672adfeb0.mp4","mime":"video\/mp4","copyright":{"license":"CC BY","version":"4.0"},"metadata":{"qualityName":"720p"}}]},"assets":{"interactions":[{"x":22.925764192139738,"y":0,"width":30.829694323144107,"height":10.91703056768559,"duration":{"from":87.789,"to":103.789},"libraryTitle":"Text","action":{"library":"H5P.Text 1.1","params":{"text":"

Two measures to prevent SQL injection attacks:<\/p>\n\n

1. Use a read-only database handle via getReadableDatabase <\/strong>if you have no intention of adding\/changing the database<\/p>\n\n

2. Use \"?\" placeholders rather than string concatenation in your SQL statements if you plan to insert String values from variables into your statement.<\/p>\n"},"subContentId":"2aeeff1a-4565-4c7f-bb84-06654207fa0f","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"pause":false,"displayType":"poster","buttonOnMobile":false,"visuals":{"backgroundColor":"rgb(255, 255, 255)","boxShadow":true},"goto":{"url":{"protocol":"http:\/\/"},"visualize":false,"type":""},"label":""},{"x":28.38427947598253,"y":75.5813953488372,"width":10,"height":10,"duration":{"from":326.447,"to":336.447},"libraryTitle":"Link","action":{"library":"H5P.Link 1.3","params":{"linkWidget":{"protocol":"https:\/\/","url":"developer.android.com\/reference\/android\/database\/Cursor"},"title":"Android Cursor documentation"},"subContentId":"7625d527-e3d9-4dad-ac2e-87456da5789c","metadata":{"contentType":"Link","license":"U"}},"displayType":"poster","visuals":{"backgroundColor":"rgb(0, 0, 255)","boxShadow":true},"pause":false,"buttonOnMobile":false},{"x":64.41048034934498,"y":7.751937984496124,"width":10,"height":9.070687772925766,"duration":{"from":429.253,"to":439.253},"libraryTitle":"Text","action":{"library":"H5P.Text 1.1","params":{"text":"

Don't forget to close()<\/strong> after you are done with your get<\/strong>s (getInt, getDouble, getString)!<\/p>\n"},"subContentId":"d1c0e615-66ac-4188-9f2b-73039eec9ad0","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"pause":false,"displayType":"poster","buttonOnMobile":false,"visuals":{"backgroundColor":"rgb(255, 255, 255)","boxShadow":true},"goto":{"url":{"protocol":"http:\/\/"},"visualize":false,"type":""},"label":""},{"x":51.31004366812227,"y":36.82170542635659,"width":18.340611353711793,"height":12.532751091703057,"duration":{"from":490.94,"to":492.94},"libraryTitle":"Text","action":{"library":"H5P.Text 1.1","params":{"text":"

Try to complete the other two functions. Note that getTransactions should actually return an int, <\/strong>not a double, <\/strong>since the count of transactions is always an integer value.<\/p>\n\n

Resume the video when done or if you need to peek at a possible solution.<\/p>\n"},"subContentId":"e35b1964-8785-4b43-b98c-83f9379a6ce3","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"visuals":{"backgroundColor":"rgb(255, 255, 255)","boxShadow":true},"goto":{"url":{"protocol":"http:\/\/"},"visualize":false,"type":""},"label":""},{"x":84.06113537117903,"y":27.131782945736433,"width":10,"height":10,"duration":{"from":526.118,"to":536.118},"libraryTitle":"Text","action":{"library":"H5P.Text 1.1","params":{"text":"

A mixed array can be returned if getting a double, double and int is desired. Object[] is one possible, generic return type to handled mixed arrays, but since it is all numbers, double[] is also valid, so long as the third value for number of transactions when used by the callee is eventually cast to an int<\/strong>.<\/p>\n"},"subContentId":"cf6311b0-4fc4-4d25-a095-49a80688dd42","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"pause":false,"displayType":"button","buttonOnMobile":false,"visuals":{"backgroundColor":"rgb(255, 255, 255)","boxShadow":true},"goto":{"url":{"protocol":"http:\/\/"},"visualize":false,"type":""},"label":"

The return type for this function shouldn't be double. Click for more info.<\/p>\n"},{"x":33.842794759825324,"y":75.5813953488372,"width":10,"height":10,"duration":{"from":574.959,"to":584},"libraryTitle":"Link","action":{"library":"H5P.Link 1.3","params":{"linkWidget":{"protocol":"https:\/\/","url":"conestoga.desire2learn.com\/d2l\/le\/content\/389315\/viewContent\/8148647\/View"},"title":"Watch Part 4!"},"subContentId":"537376dd-cae4-429e-b01d-4ffb3be92d67","metadata":{"contentType":"Link","license":"U"}},"displayType":"poster","visuals":{"backgroundColor":"rgb(0, 0, 255)","boxShadow":true},"pause":false,"buttonOnMobile":false},{"x":86.24454148471615,"y":87.63575668148857,"width":5.502183406113537,"height":2.788777890769875,"duration":{"from":0,"to":584},"libraryTitle":"Image","action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-6025d16e80b71.png","mime":"image\/png","copyright":{"license":"U"},"width":219,"height":111}},"subContentId":"36408841-3247-45c7-a1ed-bac5e6b0f507","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"visuals":{"backgroundColor":"rgba(0,0,0,0)","boxShadow":true},"pause":false,"displayType":"poster","buttonOnMobile":false,"goto":{"url":{"protocol":"http:\/\/"},"visualize":false,"type":""},"label":""}]},"summary":{"task":{"library":"H5P.Summary 1.10","params":{"intro":"Choose the correct statement.","summaries":[{"subContentId":"21e1c2ba-a2ed-4a8c-8139-095c70e1995e","tip":""}],"overallFeedback":[{"from":0,"to":100}],"solvedLabel":"Progress:","scoreLabel":"Wrong answers:","resultLabel":"Your result","labelCorrect":"Correct.","labelIncorrect":"Incorrect! Please try again.","alternativeIncorrectLabel":"Incorrect","labelCorrectAnswers":"Correct answers.","tipButtonLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","progressText":"Progress :num of :total"},"subContentId":"760d12a3-9bc2-43f5-8aea-7c32ebbf8a71","metadata":{"contentType":"Summary","license":"U","title":"Untitled Summary"}},"displayAt":3}},"override":{"autoplay":false,"loop":false,"showBookmarksmenuOnLoad":false,"showRewind10":false,"deactivateSound":false,"preventSkippingMode":"none"},"l10n":{"interaction":"Interaction","play":"Play","pause":"Pause","mute":"Mute","unmute":"Unmute","quality":"Video Quality","captions":"Captions","close":"Close","fullscreen":"Fullscreen","exitFullscreen":"Exit Fullscreen","summary":"Open summary dialog","bookmarks":"Bookmarks","endscreen":"Submit screen","defaultAdaptivitySeekLabel":"Continue","continueWithVideo":"Continue with video","playbackRate":"Playback Rate","rewind10":"Rewind 10 Seconds","navDisabled":"Navigation is disabled","sndDisabled":"Sound is disabled","requiresCompletionWarning":"You need to answer all the questions correctly before continuing.","back":"Back","hours":"Hours","minutes":"Minutes","seconds":"Seconds","currentTime":"Current time:","totalTime":"Total time:","singleInteractionAnnouncement":"Interaction appeared:","multipleInteractionsAnnouncement":"Multiple interactions appeared.","videoPausedAnnouncement":"Video is paused","content":"Content","answered":"@answered answered","endcardTitle":"@answered Question(s) answered","endcardInformation":"You have answered @answered questions, click below to submit your answers.","endcardInformationNoAnswers":"You have not answered any questions.","endcardInformationMustHaveAnswer":"You have to answer at least one question before you can submit your answers.","endcardSubmitButton":"Submit Answers","endcardSubmitMessage":"Your answers have been submitted!","endcardTableRowAnswered":"Answered questions","endcardTableRowScore":"Score","endcardAnsweredScore":"answered","endCardTableRowSummaryWithScore":"You got @score out of @total points for the @question that appeared after @minutes minutes and @seconds seconds.","endCardTableRowSummaryWithoutScore":"You have answered the @question that appeared after @minutes minutes and @seconds seconds."}}

4.1,4.2 SQLite Databases - Part 3 of 5 (9m44s)

Chris Lo