Categorizations form not inserting

[tatianacv]

Getting a SQL error for inserting the form

[khatchad]

Please add the erroneous SQL statement and the error message.

[tatianacv]

'Cannot add or update a child row: a foreign key constraint fails (heroku_4ac11fb2946b4e7.categorizations, CONSTRAINT categorizations_ibfk_7 FOREIGN KEY (sha) REFERENCES commits (sha))')

[khatchad]

@tatianacv please capture the SQL statement that is causing this error. Django has an ORM that translates OO code into SQL. It should have a debug option to output any generated SQL statements.

[khatchad]

https://stackoverflow.com/questions/1074212/how-can-i-see-the-raw-sql-queries-django-is-running

[khatchad]

Per our recent discussion, the route for this form would be as follows:

http://app/categorizations/add?commit=5

Add a categorization for commit with ID 5

[khatchad]

Per recent discussion, remove the commit entry form element from this form because it will be (instead) a query parameter as above.

[khatchad]

• [ ] From the demo this AM, this looks to be still an issue.
• [ ] Please remove the multiple SHAs from the form. The SHA should not be selectable since it is now coming from the query parameter.

[tatianacv]

Fixed insertion to form in commit e75faa16f891dd6d0280d1ba7b1a9a126a841a5a

[tatianacv]

Remove the sha from the categorizations form in commit 1f9e246c5f481574b3fd20ac9bca24dd64bf86e3