Python alter_table Exemples

Exemple #1

Fichier : mssql.py Projet : 13917547121/me

def visit_column_nullable(element, compiler, **kw):
    return "%s %s %s %s" % (
        alter_table(compiler, element.table_name, element.schema),
        alter_column(compiler, element.column_name),
        format_type(compiler, element.existing_type),
        "NULL" if element.nullable else "NOT NULL"
    )

Exemple #2

def visit_column_default(element, compiler, **kw):
    # TODO: there can also be a named constraint
    # with ADD CONSTRAINT here
    return "%s ADD DEFAULT %s FOR %s" % (
        alter_table(compiler, element.table_name, element.schema),
        format_server_default(compiler, element.default),
        format_column_name(compiler, element.column_name))

Exemple #3

def visit_column_type(element: "ColumnType", compiler: "SpannerDDLCompiler",
                      **kw) -> str:
    return "%s %s %s" % (
        alter_table(compiler, element.table_name, element.schema),
        alter_column(compiler, element.column_name),
        "%s" % format_type(compiler, element.type_),
    )

Exemple #4

Fichier : mssql.py Projet : 13917547121/me

def visit_column_default(element, compiler, **kw):
    # TODO: there can also be a named constraint
    # with ADD CONSTRAINT here
    return "%s ADD DEFAULT %s FOR %s" % (
        alter_table(compiler, element.table_name, element.schema),
        format_server_default(compiler, element.default),
        format_column_name(compiler, element.column_name)
    )

Exemple #5

def visit_column_nullable(element: "ColumnNullable",
                          compiler: "SpannerDDLCompiler", **kw) -> str:
    return "%s %s %s %s" % (
        alter_table(compiler, element.table_name, element.schema),
        alter_column(compiler, element.column_name),
        format_type(compiler, element.existing_type),
        "" if element.nullable else "NOT NULL",
    )

Exemple #6

Fichier : oracle.py Projet : zky001/me

def visit_column_default(element, compiler, **kw):
    return "%s %s %s" % (
        alter_table(compiler, element.table_name, element.schema),
        alter_column(compiler, element.column_name),
        "DEFAULT %s" %
            format_server_default(compiler, element.default)
        if element.default is not None
        else "DEFAULT NULL"
    )

Exemple #7

Fichier : oracle.py Projet : richsilv/mytoptenfacebook

def visit_column_default(element, compiler, **kw):
    return "%s %s %s" % (
        alter_table(compiler, element.table_name, element.schema),
        alter_column(compiler, element.column_name),
        "DEFAULT %s" %
            format_server_default(compiler, element.default)
        if element.default is not None
        else "DEFAULT NULL"
    )

Exemple #8

Fichier : mysql.py Projet : zky001/me

def _mysql_alter_column(element, compiler, **kw):
    return "%s CHANGE %s %s" % (
        alter_table(compiler, element.table_name, element.schema),
        element.column_name,
        _mysql_colspec(
            compiler,
            name=element.newname,
            nullable=element.nullable,
            server_default=element.default,
            type_=element.type_,
            autoincrement=element.autoincrement
        ),
    )

Exemple #9

Fichier : oracle.py Projet : richsilv/mytoptenfacebook

def visit_column_type(element, compiler, **kw):
    return "%s %s %s" % (
        alter_table(compiler, element.table_name, element.schema),
        alter_column(compiler, element.column_name),
        "%s" % format_type(compiler, element.type_)
    )

Exemple #10

Fichier : oracle.py Projet : richsilv/mytoptenfacebook

def visit_add_column(element, compiler, **kw):
    return "%s %s" % (
        alter_table(compiler, element.table_name, element.schema),
        add_column(compiler, element.column, **kw),
    )

Exemple #11

Fichier : ibm_db.py Projet : waliwali/ibm-db.ibm-db-alembic

def visit_column_type(element, compiler, **kw):
    return "%s %s %s" % (
        base.alter_table(compiler, element.table_name, element.schema),
        base.alter_column(compiler, element.column_name),
        "SET DATA TYPE %s" % base.format_type(compiler, element.type_)
    )

Exemple #12

def visit_column_nullable(element, compiler, **kw):
    return "%s %s %s %s" % (alter_table(
        compiler, element.table_name,
        element.schema), alter_column(compiler, element.column_name),
                            format_type(compiler, element.existing_type),
                            "NULL" if element.nullable else "NOT NULL")

Exemple #13

def visit_add_column(element, compiler, **kw):
    return "%s %s" % (alter_table(
        compiler, element.table_name,
        element.schema), mssql_add_column(compiler, element.column, **kw))

Exemple #14

Fichier : oracle.py Projet : zky001/me

def visit_column_name(element, compiler, **kw):
    return "%s RENAME COLUMN %s TO %s" % (
        alter_table(compiler, element.table_name, element.schema),
        format_column_name(compiler, element.column_name),
        format_column_name(compiler, element.newname)
    )

Exemple #15

Fichier : oracle.py Projet : richsilv/mytoptenfacebook

def visit_column_name(element, compiler, **kw):
    return "%s RENAME COLUMN %s TO %s" % (
        alter_table(compiler, element.table_name, element.schema),
        format_column_name(compiler, element.column_name),
        format_column_name(compiler, element.newname)
    )

Exemple #16

def visit_column_type(element, compiler, **kw):
    return "%s %s %s" % (alter_table(
        compiler, element.table_name,
        element.schema), alter_column(compiler, element.column_name),
                         format_type(compiler, element.type_))

Exemple #17

def visit_column_type(element, compiler, **kw):
    return "%s %s %s" % (
        base.alter_table(compiler, element.table_name, element.schema),
        base.alter_column(compiler, element.column_name),
        "SET DATA TYPE %s" % base.format_type(compiler, element.type_))