Sometimes is_system flag is not filled at workbook creation and that causes MYSQL error. It seems new MySQL does not allow null values for a boolean (is_system = sa.Column(sa.Boolean())) filed.
Error from DB:
DBAPIError exception wrapped from (_mysql_exceptions.InterfaceError) (-1, 'error totally whack') [SQL: u'INSERT INTO workbooks_v2 (scope, project_id, created_at, updated_at, id, name, definition, spec, tags, is_system) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: ('private', '<default-project>', datetime.datetime(2017, 11, 20, 11, 8, 50), None, '31afc3f3-88bc-4746-b628-3182d9b25ed3', 'test_workbook', '---\nname: test_workbook\nversion: \'2.0\'\nworkflows:\n wf_a:\n tasks:\n a:\n action: std_noop\n', '{"version": "2.0", "name": "test_workbook", "workflows": {"wf_a": {"tasks": {"a": {"name": "a", "action": "std_noop", "type": "direct"}}, "name": "wf_a", "version": "2.0"}, "version": "2.0"}}', '[]', None)]
Traceback (most recent call last):
File "/opt/nokia/cbam-venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/opt/nokia/cbam-venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
File "/opt/nokia/cbam-venv/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/opt/nokia/cbam-venv/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
InterfaceError: (-1, 'error totally whack')
Fix proposed to branch: master
Review: https:/