Using generated SQL (DDL)

- [Instructor] Right after we created our database,…I mentioned that I wasn't going to be adding it to Git.…The reason for this is because traditionally…when you're working with SQLite databases in Python,…you usually have code that generates them…rather than shipping an actual file with your application.…With that in mind, let's open up our database script.…I could just select it here in the hierarchy,…but I think I'll remind you one of the useful keyboard…shortcuts in here is the ability to open any file…by pressing control shift N or whatever the keyboard…shortcut listed right here on your screen shows.…

It'll be different depending on what platform you're using.…For me, I'll press control shift N,…and I'm going to open up database utilities.…I just need to type part of it and then press enter.…You can see that earlier we added a create_database…function here and so we'll just fill in this stub.…But before I do that, I need to add an import statement…at the top, so I'll add import_sqlite3,…and I usually give it a nickname like Lite.…