Checking where your IP is from
Sometimes, you need to query from a remote database, but as you know SQLite works with a local database, which means that you have to populate it before querying. In this recipe, we are going to convert a CSV file to a SQLite database, and after this, we are going to query some results.
Getting ready
For this recipe, we will need a CSV file with the range of IPs of each country. There are some websites that will give or sell it to you and you can download it for free from https://db-ip.com/db/download/country, uncompress it, and add it to your SQLite application.
Note
Right now, this file is called dbip-country-2014-12.csv, but it changes its name every month so we need to replace the filename where it is mentioned with the one you have.
How to do it...
Perform the following steps:
Let's start completing the SQLite class by adding two additional methods: one for executing statements that don't return any result, such as the insert, delete, and update queries. To do...
