Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Python SQLAlchemy Basics Introduction to SQLAlchemy Update, Rollback, and Delete

Jonathan Grieve
MOD
Jonathan Grieve
Treehouse Moderator 91,253 Points
Posted by Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,253 Points

Console or in file updates? [Solved]

In this video, Megan uses the console to go into the virtual environment and make edits to a new user, later commits that change, and then demonstrates how to make changes to the same user once it's been committed to SQLAlchemy.

But I can't do this as my git bash in VS Code has never been able to properly access the virtual environment. (I use Windows 10)

How do I, in a python file I access a specific record in code and make changes to it? I imagined some kind of find() method in which you'd pass in an integer for the primary key of the class that you're in. But it looks to me like it isn't that simple.

Or should I just keep trying to fix my virtual environment? Is that where you're supposed to make those changes?

1 Answer

Jonathan Grieve
MOD
Jonathan Grieve
Treehouse Moderator 91,253 Points
Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,253 Points

Update: I have since worked out that my virtual environment was working this whole time! 🤦‍♂️

I just couldn't work out the differences between the MAC Environment and it showing up on Windows. Windows doesn't duplicate the directory name on Bash!