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 Flask REST API API Protection Generating Tokens

Callum Anderson
seal-mask
.a{fill-rule:evenodd;}techdegree
Callum Anderson
Data Analysis Techdegree Student 10,200 Points
Posted by Callum Anderson
.a{fill-rule:evenodd;}techdegree
Callum Anderson
Data Analysis Techdegree Student 10,200 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 68,423 Points
Chris Freeman
Chris Freeman
Treehouse Moderator 68,423 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
seal-mask
.a{fill-rule:evenodd;}techdegree
Callum Anderson
Data Analysis Techdegree Student 10,200 Points
Callum Anderson
.a{fill-rule:evenodd;}techdegree
Callum Anderson
Data Analysis Techdegree Student 10,200 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 68,423 Points
Chris Freeman
Chris Freeman
Treehouse Moderator 68,423 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!!

1 Answer

Callum Anderson
seal-mask
.a{fill-rule:evenodd;}techdegree
Callum Anderson
Data Analysis Techdegree Student 10,200 Points
Callum Anderson
.a{fill-rule:evenodd;}techdegree
Callum Anderson
Data Analysis Techdegree Student 10,200 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!