Python alter_drop_column_with_materialize_mysql_databaseの例

コード例 #1

def test_materialize_database_ddl_with_mysql_8_0(started_cluster, started_mysql_8_0):
    materialize_with_ddl.drop_table_with_materialize_mysql_database(clickhouse_node, started_mysql_8_0, "mysql8_0")
    materialize_with_ddl.create_table_with_materialize_mysql_database(clickhouse_node, started_mysql_8_0, "mysql8_0")
    materialize_with_ddl.rename_table_with_materialize_mysql_database(clickhouse_node, started_mysql_8_0, "mysql8_0")
    materialize_with_ddl.alter_add_column_with_materialize_mysql_database(clickhouse_node, started_mysql_8_0, "mysql8_0")
    materialize_with_ddl.alter_drop_column_with_materialize_mysql_database(clickhouse_node, started_mysql_8_0, "mysql8_0")
    materialize_with_ddl.alter_rename_table_with_materialize_mysql_database(clickhouse_node, started_mysql_8_0, "mysql8_0")
    materialize_with_ddl.alter_rename_column_with_materialize_mysql_database(clickhouse_node, started_mysql_8_0, "mysql8_0")
    materialize_with_ddl.alter_modify_column_with_materialize_mysql_database(clickhouse_node, started_mysql_8_0, "mysql8_0")

コード例 #2

ファイル: test.py プロジェクト: ylchou/ClickHouse

def test_materialize_database_ddl_with_mysql_5_7(started_cluster,
                                                 started_mysql_5_7):
    materialize_with_ddl.drop_table_with_materialize_mysql_database(
        clickhouse_node, started_mysql_5_7, "mysql5_7")
    materialize_with_ddl.create_table_with_materialize_mysql_database(
        clickhouse_node, started_mysql_5_7, "mysql5_7")
    materialize_with_ddl.rename_table_with_materialize_mysql_database(
        clickhouse_node, started_mysql_5_7, "mysql5_7")
    materialize_with_ddl.alter_add_column_with_materialize_mysql_database(
        clickhouse_node, started_mysql_5_7, "mysql5_7")
    materialize_with_ddl.alter_drop_column_with_materialize_mysql_database(
        clickhouse_node, started_mysql_5_7, "mysql5_7")
    # mysql 5.7 cannot support alter rename column
    # materialize_with_ddl.alter_rename_column_with_materialize_mysql_database(clickhouse_node, started_mysql_5_7, "mysql5_7")
    materialize_with_ddl.alter_rename_table_with_materialize_mysql_database(
        clickhouse_node, started_mysql_5_7, "mysql5_7")
    materialize_with_ddl.alter_modify_column_with_materialize_mysql_database(
        clickhouse_node, started_mysql_5_7, "mysql5_7")