diff options
author | Pavlo Shchelokovskyy <shchelokovskyy@gmail.com> | 2022-01-27 18:20:06 +0200 |
---|---|---|
committer | Michael Johnson <johnsomor@gmail.com> | 2022-01-27 20:03:18 +0000 |
commit | 83dfa6581eec1b9d32d519592c4212e6195998a3 (patch) | |
tree | 336f2da8e21100aeff4de6200ed89ca1a1e4ca7d | |
parent | 49fa9acbb371a6fc244ec030111ba573280eabfa (diff) | |
download | taskflow-83dfa6581eec1b9d32d519592c4212e6195998a3.tar.gz |
Fix atomdetails failure column size
failure and revert_failure fields in atomdetails is defined as a JSON type,
but its data type is 'text' in mysql, which is limited to 64kbytes.
JSON data type should have the same size as a LONGTEXT.
Closes-Bug: #1959243
Change-Id: I65b6a6d896d3e8aad871dc19b0f8d0eddf48bdd6
-rw-r--r-- | taskflow/persistence/backends/sqlalchemy/alembic/versions/40fc8c914bd2_fix_atomdetails_failure_size.py | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/taskflow/persistence/backends/sqlalchemy/alembic/versions/40fc8c914bd2_fix_atomdetails_failure_size.py b/taskflow/persistence/backends/sqlalchemy/alembic/versions/40fc8c914bd2_fix_atomdetails_failure_size.py new file mode 100644 index 0000000..ec50dd6 --- /dev/null +++ b/taskflow/persistence/backends/sqlalchemy/alembic/versions/40fc8c914bd2_fix_atomdetails_failure_size.py @@ -0,0 +1,36 @@ +# Licensed under the Apache License, Version 2.0 (the "License"); you may +# not use this file except in compliance with the License. You may obtain +# a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, software +# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT +# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the +# License for the specific language governing permissions and limitations +# under the License. + +"""fix atomdetails failure size + +Revision ID: 40fc8c914bd2 +Revises: 6df9422fcb43 +Create Date: 2022-01-27 18:10:06.176006 + +""" + +# revision identifiers, used by Alembic. +revision = '40fc8c914bd2' +down_revision = '6df9422fcb43' + +from alembic import op +from sqlalchemy.dialects import mysql + + +def upgrade(): + bind = op.get_bind() + engine = bind.engine + if engine.name == 'mysql': + op.alter_column('atomdetails', 'failure', type_=mysql.LONGTEXT, + existing_nullable=True) + op.alter_column('atomdetails', 'revert_failure', type_=mysql.LONGTEXT, + existing_nullable=True) |