Google Code-in

Introduction

CCExtractor is a tool to extract subtitles/closed captions from video streams. In order to verify that changes to the code don't break previous samples with issues, we created a test suite. To run this whenever a pull request on GitHub is opened, or when a commit is made, we created the Sample Platform (often abbreviated as SP), which is a website where users can submit faulty samples, and which kicks off the test suite on different platforms.

The task

Deleting regression test gives the error :

sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (sample_platform.customized_test, CONSTRAINT customized_test_ibfk_2 FOREIGN KEY (regression_id) REFERENCES regression_test (id) ON UPDATE CASCADE)') [SQL: 'DELETE FROM regression_test WHERE regression_test.id = %(id)s'] [parameters: {'id': 1}] (Background on this error at: http://sqlalche.me/e/gkpj)

Requirements to complete this task

We expect an opened pull request, which contains the modification requested above, unit tests that cover (most of) the changes, and documentation where necessary.

Relevant extra links

• https://docs.python.org/3/library/unittest.html
• http://flask.pocoo.org/
• https://pythonhosted.org/Flask-Testing/
• http://www.sqlalchemy.org/