當前位置: 首頁>>代碼示例>>Python>>正文

Python op.add_column方法代碼示例

本文整理匯總了Python中alembic.op.add_column方法的典型用法代碼示例。如果您正苦於以下問題：Python op.add_column方法的具體用法？Python op.add_column怎麽用？Python op.add_column使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類alembic.op的用法示例。


在下文中一共展示了op.add_column方法的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Python代碼示例。

示例1: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    for table_name in ("resource", "resource_history", "metric"):
        creator_col = sa.Column("creator", sa.String(255))
        created_by_user_id_col = sa.Column("created_by_user_id",
                                           sa.String(255))
        created_by_project_id_col = sa.Column("created_by_project_id",
                                              sa.String(255))
        op.add_column(table_name, creator_col)
        t = sa.sql.table(
            table_name, creator_col,
            created_by_user_id_col, created_by_project_id_col)
        op.execute(
            t.update().values(
                creator=(
                    created_by_user_id_col + ":" + created_by_project_id_col
                )).where((created_by_user_id_col is not None)
                         | (created_by_project_id_col is not None)))
        op.drop_column(table_name, "created_by_user_id")
        op.drop_column(table_name, "created_by_project_id")
開發者ID:gnocchixyz，項目名稱:gnocchi，代碼行數:21，代碼來源:aba5a217ca9b_merge_created_in_creator.py

示例2: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    op.add_column("resource_type", sa.Column('tablename', sa.String(18),
                                             nullable=True))

    resource_type = sa.Table(
        'resource_type', sa.MetaData(),
        sa.Column('name', sa.String(255), nullable=False),
        sa.Column('tablename', sa.String(18), nullable=True)
    )
    op.execute(resource_type.update().where(
        resource_type.c.name == "instance_network_interface"
    ).values({'tablename': op.inline_literal("'instance_net_int'")}))
    op.execute(resource_type.update().where(
        resource_type.c.name != "instance_network_interface"
    ).values({'tablename': resource_type.c.name}))

    op.alter_column("resource_type", "tablename", type_=sa.String(18),
                    nullable=False)
    op.create_unique_constraint("uniq_resource_type0tablename",
                                "resource_type", ["tablename"])
開發者ID:gnocchixyz，項目名稱:gnocchi，代碼行數:22，代碼來源:0718ed97e5b3_add_tablename_to_resource_type.py

示例3: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    op.add_column('container',
                  sa.Column('cpu', sa.Float(),
                            nullable=True))
    op.add_column('container',
                  sa.Column('workdir', sa.String(length=255),
                            nullable=True))
    op.add_column('container',
                  sa.Column('ports',
                            zun.db.sqlalchemy.models.JSONEncodedList(),
                            nullable=True))
    op.add_column('container',
                  sa.Column('hostname', sa.String(length=255),
                            nullable=True))
    op.add_column('container',
                  sa.Column('labels',
                            zun.db.sqlalchemy.models.JSONEncodedDict(),
                            nullable=True))
開發者ID:openstack，項目名稱:zun，代碼行數:20，代碼來源:1192ba19a6e9_add_cpu_workdir_ports_hostname_labels_.py

示例4: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    for c in tables.Tasks.__add_result_links__:
        op.add_column(tables.Tasks.__tablename__, c)
開發者ID:airshipit，項目名稱:drydock，代碼行數:5，代碼來源:4713e7ebca9_add_task_status_links.py

示例5: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('chart_block_defaults',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('title', sa.String(length=255), nullable=False),
    sa.Column('caption', sa.String(length=255), nullable=True),
    sa.Column('slug', sa.String(length=255), nullable=False),
    sa.Column('dataset', sa.String(length=255), nullable=False),
    sa.Column('content', sa.Text(convert_unicode=True), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('chart_blocks',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('department_id', sa.Integer(), nullable=False),
    sa.Column('title', sa.String(length=255), nullable=False),
    sa.Column('caption', sa.String(length=255), nullable=True),
    sa.Column('slug', sa.String(length=255), nullable=False),
    sa.Column('dataset', sa.String(length=255), nullable=False),
    sa.Column('content', sa.Text(), nullable=True),
    sa.Column('date_updated', sa.DateTime(), nullable=True),
    sa.Column('date_edited', sa.DateTime(), nullable=True),
    sa.ForeignKeyConstraint(['department_id'], ['departments.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.add_column('use_of_force_incidents', sa.Column('received_date', sa.DateTime(), nullable=True))
    ### end Alembic commands ###
開發者ID:codeforamerica，項目名稱:comport，代碼行數:28，代碼來源:4ffa73ef2b8_.py

示例6: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    op.add_column('officer_involved_shootings_bpd', sa.Column('case_number', sa.String(length=255), nullable=True))
開發者ID:codeforamerica，項目名稱:comport，代碼行數:4，代碼來源:ab97630e71ce_.py

示例7: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('citizen_complaint', sa.Column('officer_age', sa.String(length=255), nullable=True))
    op.add_column('citizen_complaint', sa.Column('resident_age', sa.String(length=255), nullable=True))
    op.add_column('use_of_force_incidents', sa.Column('officer_age', sa.String(length=255), nullable=True))
    op.add_column('use_of_force_incidents', sa.Column('resident_age', sa.String(length=255), nullable=True))
    ### end Alembic commands ###
開發者ID:codeforamerica，項目名稱:comport，代碼行數:9，代碼來源:585a75fc356_.py

示例8: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('citizen_complaints', sa.Column('allegation', sa.String(length=255), nullable=True))
    op.add_column('citizen_complaints', sa.Column('allegation_type', sa.String(length=255), nullable=True))
    op.drop_column('citizen_complaints', 'category')
    ### end Alembic commands ###
開發者ID:codeforamerica，項目名稱:comport，代碼行數:8，代碼來源:2de736b481_.py

示例9: downgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('citizen_complaints', sa.Column('category', sa.VARCHAR(length=255), autoincrement=False, nullable=True))
    op.drop_column('citizen_complaints', 'allegation_type')
    op.drop_column('citizen_complaints', 'allegation')
    ### end Alembic commands ###
開發者ID:codeforamerica，項目名稱:comport，代碼行數:8，代碼來源:2de736b481_.py

示例10: downgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('denominator_values', sa.Column('arrests', sa.INTEGER(), autoincrement=False, nullable=True))
    op.drop_column('denominator_values', 'officers_out_on_service')
    ### end Alembic commands ###
開發者ID:codeforamerica，項目名稱:comport，代碼行數:7，代碼來源:507f3182b84_.py

示例11: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('use_of_force_incidents', sa.Column('received_date', sa.DateTime(), nullable=True))
    ### end Alembic commands ###
開發者ID:codeforamerica，項目名稱:comport，代碼行數:6，代碼來源:1c306b9d32_.py

示例12: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    # create the has_disposition column
    op.add_column('officer_involved_shootings_bpd', sa.Column('has_disposition', sa.Boolean(), nullable=True))

    # update the has_disposition column based on values in the disposition column
    db_bind = op.get_bind()
    db_bind.execute(sa.sql.text('''
        UPDATE officer_involved_shootings_bpd SET has_disposition = (disposition != '' AND disposition IS NOT NULL)
    '''))

    # drop the disposition column
    op.drop_column('officer_involved_shootings_bpd', 'disposition')
開發者ID:codeforamerica，項目名稱:comport，代碼行數:14，代碼來源:7f4ae427dcf6_.py

示例13: downgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def downgrade():
    op.add_column('officer_involved_shootings_bpd', sa.Column('disposition', sa.VARCHAR(length=255), autoincrement=False, nullable=True))
    op.drop_column('officer_involved_shootings_bpd', 'has_disposition')
開發者ID:codeforamerica，項目名稱:comport，代碼行數:5，代碼來源:7f4ae427dcf6_.py

示例14: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    op.add_column('chart_blocks', sa.Column('order', sa.Integer(), server_default='0', nullable=True))
開發者ID:codeforamerica，項目名稱:comport，代碼行數:4，代碼來源:0d39b8d2c5ce_.py

示例15: upgrade

# 需要導入模塊: from alembic import op [as 別名]
# 或者: from alembic.op import add_column [as 別名]
def upgrade():
    op.add_column('use_of_force_incidents_bpd', sa.Column('case_number', sa.String(length=128), nullable=True))
    op.add_column('use_of_force_incidents_bpd', sa.Column('completed_date', sa.DateTime(), nullable=True))
    op.add_column('use_of_force_incidents_bpd', sa.Column('received_date', sa.DateTime(), nullable=True))

    op.drop_column('use_of_force_incidents_bpd', 'division')
    op.drop_column('use_of_force_incidents_bpd', 'bureau')
    op.drop_column('use_of_force_incidents_bpd', 'resident_weapon_used')
開發者ID:codeforamerica，項目名稱:comport，代碼行數:10，代碼來源:77ad8047becf_.py


注：本文中的alembic.op.add_column方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。