From commits-return-2654-archive-asf-public=cust-asf.ponee.io@superset.incubator.apache.org Wed May 8 17:31:00 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id E4A8C180630 for ; Wed, 8 May 2019 19:30:59 +0200 (CEST) Received: (qmail 2509 invoked by uid 500); 8 May 2019 17:30:59 -0000 Mailing-List: contact commits-help@superset.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@superset.incubator.apache.org Delivered-To: mailing list commits@superset.incubator.apache.org Received: (qmail 2499 invoked by uid 99); 8 May 2019 17:30:59 -0000 Received: from ec2-52-202-80-70.compute-1.amazonaws.com (HELO gitbox.apache.org) (52.202.80.70) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 May 2019 17:30:59 +0000 Received: by gitbox.apache.org (ASF Mail Server at gitbox.apache.org, from userid 33) id E0A9E872B9; Wed, 8 May 2019 17:30:55 +0000 (UTC) Date: Wed, 08 May 2019 17:30:55 +0000 To: "commits@superset.apache.org" Subject: [incubator-superset] branch master updated: fix: alter sql columns to long text #7463 (#7476) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Message-ID: <155733665532.14746.8177400723376149994@gitbox.apache.org> From: beto@apache.org X-Git-Host: gitbox.apache.org X-Git-Repo: incubator-superset X-Git-Refname: refs/heads/master X-Git-Reftype: branch X-Git-Oldrev: 6b8bda609676364436941a491c6cd91a7e6032b9 X-Git-Newrev: ca48f32a074f6411aeff8a5d220d42d75ca83204 X-Git-Rev: ca48f32a074f6411aeff8a5d220d42d75ca83204 X-Git-NotificationType: ref_changed_plus_diff X-Git-Multimail-Version: 1.5.dev Auto-Submitted: auto-generated This is an automated email from the ASF dual-hosted git repository. beto pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/incubator-superset.git The following commit(s) were added to refs/heads/master by this push: new ca48f32 fix: alter sql columns to long text #7463 (#7476) ca48f32 is described below commit ca48f32a074f6411aeff8a5d220d42d75ca83204 Author: Kim Truong <47833996+khtruong@users.noreply.github.com> AuthorDate: Wed May 8 10:30:43 2019 -0700 fix: alter sql columns to long text #7463 (#7476) Merge lyft-release-sp8@7bfe7bc to master --- ...er_sql_column_data_type_in_query_mysql_table.py | 56 ++++++++++++++++++++++ 1 file changed, 56 insertions(+) diff --git a/superset/migrations/versions/afc69274c25a_alter_sql_column_data_type_in_query_mysql_table.py b/superset/migrations/versions/afc69274c25a_alter_sql_column_data_type_in_query_mysql_table.py new file mode 100644 index 0000000..4f443e7 --- /dev/null +++ b/superset/migrations/versions/afc69274c25a_alter_sql_column_data_type_in_query_mysql_table.py @@ -0,0 +1,56 @@ +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you 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. +"""update the sql, select_sql, and executed_sql columns in the + query table in mysql dbs to be long text columns + +Revision ID: afc69274c25a +Revises: e9df189e5c7e +Create Date: 2019-05-06 14:30:26.181449 + +""" +from alembic import op +from sqlalchemy.databases import mysql +from sqlalchemy.dialects.mysql.base import MySQLDialect +import sqlalchemy as sa + +# revision identifiers, used by Alembic. +revision = 'afc69274c25a' +down_revision = 'e9df189e5c7e' + + +def upgrade(): + bind = op.get_bind() + if isinstance(bind.dialect, MySQLDialect): + with op.batch_alter_table('query') as batch_op: + batch_op.alter_column( + 'sql', existing_type=sa.Text, type_=mysql.LONGTEXT) + batch_op.alter_column( + 'select_sql', existing_type=sa.Text, type_=mysql.LONGTEXT) + batch_op.alter_column( + 'executed_sql', existing_type=sa.Text, type_=mysql.LONGTEXT) + + +def downgrade(): + bind = op.get_bind() + if isinstance(bind.dialect, MySQLDialect): + with op.batch_alter_table('query') as batch_op: + batch_op.alter_column( + 'sql', existing_type=mysql.LONGTEXT, type_=sa.Text) + batch_op.alter_column( + 'select_sql', existing_type=mysql.LONGTEXT, type_=sa.Text) + batch_op.alter_column( + 'executed_sql', existing_type=mysql.LONGTEXT, type_=sa.Text)