Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Python Flask REST API API Protection Generating Tokens

Callum Anderson
Callum Anderson
9,674 Points

Generating Tokens - API and using Postman. Unique constraint error [Solved]

Hello! I have been enjoying API work so far but seemed a little stumped at the moment and have hit an error wall. Using Postman with the code from this video and corrected my syntax everything was working as intended until we started using the authorization tool within Postman. The error I'm getting back is:

'peewee.IntegrityError: UNIQUE constraint failed: course.url'

To me this says I may have incorrectly typed the django basics library url but to be certain that was not the case I went and found the link through treehouse itself. Any suggestions would be highly appreciated as I'm thoroughly enjoying flask and everything around it!

Here is a snapshot of my workspace just incase, https://w.trhou.se/nopr2iog2b

Chris Freeman
Chris Freeman
Treehouse Moderator 67,623 Points

A few guesses.

This might simply be ‘course.url’ already exists in the database and that field value must be unique in that column.

Should ‘course.url’ have been expanded to a unique value of the URL for that particular course instead of being “course”?

Can you include the whole stacktrace?

Callum Anderson
Callum Anderson
9,674 Points

Chris Freeman I left it overnight to sleep on it and after your comments I found a fresh mindset. Since Workspaces are updated I still had the sqlite file with my other files which has caused problems in the past when trying to run the app so I deleted it and ran the app and in Postman seems to be working now. Thank you!

Callum Anderson
Callum Anderson
9,674 Points

Another reason I found that did not help for anyone else coming across this post. The workspace attacthed to the video is not 'fully' completed, there are parts Kenneth does that are already in Models.py for you but you got to follow along and create some stuff in Auth.py so it's pretty mismatched, keep watching until the end and then try some tests out

Chris Freeman
Chris Freeman
Treehouse Moderator 67,623 Points

Once additional resource is to use the downloads tab to get a zip file of all workspace files. S1V3 to S2V5 plus the Final version. One of these version might have the solution you're looking for. Good luck!!