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.…
Author
Released
7/6/2017- 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
Duration
Views
Related Courses
-
Code Clinic: Python
with Barron Stone2h 23m Intermediate -
Learning Python Generators
with Josh McQuiston44m 23s Intermediate -
Learning Python and Django (2015)
with Caleb Smith1h 11m Intermediate
-
Introduction
-
Welcome1m 10s
-
What you should know1m 11s
-
What is PyCharm?3m 15s
-
-
1. First Steps with PyCharm
-
Install Git1m 25s
-
Adding Pypy packages3m 29s
-
Navigation shortcuts3m 33s
-
Git and PyCharms VCS tools6m 26s
-
Working with GitHub1m 46s
-
2. Code Quality
-
Lens Mode and Intentions6m 44s
-
URL utility code5m 20s
-
Refactoring2m 15s
-
Adding the URLs file2m 16s
-
Debugging7m 22s
-
Fixing the missing library2m 21s
-
-
3. Working with Databases
-
Creating the database4m 56s
-
Using the table editor3m 53s
-
Using generated SQL (DDL)5m 19s
-
Setting the SQL dialect2m 22s
-
Data Viewer and SQL console3m 55s
-
-
4. Web Projects
-
Odds and ends5m 42s
-
Conclusion
-
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.
CancelTake 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.
Share this video
Embed this video
Video: Using generated SQL (DDL)