Join Bruce Van Horn for an in-depth discussion in this video Using generated SQL (DDL), part of Learning Python with PyCharm.
- [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.…
AuthorBruce Van Horn
- Installing the PyCharm, Git, and Pypy packages
- Adding functions
- Refactoring code
- Calling packages
- Debugging code
- Creating databases
- Working with in-line SQL
- Creating web projects with PyCharm
Skill Level Beginner
1. First Steps with PyCharm
2. Code Quality
3. Working with Databases
4. Web Projects
Odds and ends5m 42s
Next steps1m 42s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.