Create records in SQLite with Python

- [Instructor] The Python scripts that we're going…to use for this challenge assume that…A Midsummers Nights Dream.txt and Characters.txt…are located in the exercise files folder,…next to the Python scripts.…If that's not the case with your installation,…you'll need to add them.…Creation of an SQLite database and tables is simple,…and the Python script reflects that simplicity.…

It only takes 64 lines of code,…most of which are comments or related to timing.…I've opened the script in Python IDLE,…a very basic Python development environment.…I'm going to run the script,…we'll take a look at the results,…and then I'll come back and explain the highlights…of that script for you.…So to run the script, I go to Python, run, run module.…Python runs and immediately returns back a cursor,…which means that it's executed successfully.…

We could take a look at what actually happened…by looking in the exercise files folder,…and we find that there is shakespear.sqlite,…which is the database that was created…by the Python script.…