Join Barron Stone for an in-depth discussion in this video Exploring the database connection, part of Code Clinic: Python (2014).
…In the previous video, we looked at lpoApp, which is the top level…module, in the Python solution, for the Lake Pend Oreille Code Clinic Challenge.…While the code was mostly focused on generating the GUI, it…did create and instance of a database using the lpoDB module.…And made a single call to…the get_data_for_range method to retrieve data.…In this video, I'll walk you through that lpoDB Module.…Which creates and manages a database to store a local cache…of all the weather data that's already been downloaded from the internet.…
This module is really at the center of the…entire program, responding to requests from the top level lpo@module.…And making calls to the lpoWeb module on the…backend to download data from the web as needed.…The first thing the lpoDB module does when it's initialized is open…or create a database and configure the table with the appropriate columns.…When it receives a request from the lpoApp…module to return data for a range of dates.…It'll first determine which of those dates have…
Barron introduce challenges and provides an overview of his solutions in Python. Challenges include topics such as statistical analysis, searching directories for images, and accessing peripheral devices.
Visit other courses in the series to see how to solve the exact same challenges in languages like C#, C++, Java, PHP, and Ruby.
Skill Level Intermediate
Q: Why can't I access the Lake Pend Orielle site (http://lpo.dt.navy.mil)?
A: The Lake Pend Orielle site is not accessible in some geographical areas. We have contacted the owner of the server to try to resolve this issue.
Q: I am unable to access the Lake Pend Oreille data from outside the U.S.
A: A static copy of this data is provided here for lynda.com members outside of the U.S