本文整理汇总了Python中sqlalchemy.String方法的典型用法代码示例。如果您正苦于以下问题：Python sqlalchemy.String方法的具体用法？Python sqlalchemy.String怎么用？Python sqlalchemy.String使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类sqlalchemy的用法示例。
在下文中一共展示了sqlalchemy.String方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('citizen_complaint',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('department_id', sa.Integer(), nullable=False),
sa.Column('opaque_id', sa.String(length=255), nullable=False),
sa.Column('occured_date', sa.DateTime(), nullable=True),
sa.Column('division', sa.String(length=255), nullable=True),
sa.Column('precinct', sa.String(length=255), nullable=True),
sa.Column('shift', sa.String(length=255), nullable=True),
sa.Column('beat', sa.String(length=255), nullable=True),
sa.Column('disposition', sa.String(length=255), nullable=True),
sa.Column('census_tract', sa.String(length=255), nullable=True),
sa.Column('resident_race', sa.String(length=255), nullable=True),
sa.Column('officer_race', sa.String(length=255), nullable=True),
sa.Column('resident_sex', sa.String(length=255), nullable=True),
sa.Column('officer_sex', sa.String(length=255), nullable=True),
sa.Column('officer_identifier', sa.String(length=255), nullable=True),
sa.Column('officer_years_of_service', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['department_id'], ['departments.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('opaque_id')
)
### end Alembic commands ### 示例2: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
op.create_table(
'assaults_on_officers',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('department_id', sa.Integer(), nullable=False),
sa.Column('opaque_id', sa.String(length=255), nullable=False),
sa.Column('officer_identifier', sa.String(length=255), nullable=True),
sa.Column('service_type', sa.String(length=255), nullable=True),
sa.Column('force_type', sa.String(length=255), nullable=True),
sa.Column('assignment', sa.String(length=255), nullable=True),
sa.Column('arrest_made', sa.Boolean(), nullable=True),
sa.Column('officer_injured', sa.Boolean(), nullable=True),
sa.Column('officer_killed', sa.Boolean(), nullable=True),
sa.Column('report_filed', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(['department_id'], ['departments.id'], ),
sa.PrimaryKeyConstraint('id')
) 示例3: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [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") 示例4: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [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"]) 示例5: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [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)) 示例6: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
op.create_table(
'container_actions',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('action', sa.String(length=255), nullable=True),
sa.Column('container_uuid', sa.String(length=36), nullable=False),
sa.Column('request_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('start_time', sa.DateTime(), nullable=True),
sa.Column('finish_time', sa.DateTime(), nullable=True),
sa.Column('message', sa.String(length=255), nullable=True),
sa.Index('container_uuid_idx', 'container_uuid'),
sa.Index('request_id_idx', 'request_id'),
sa.ForeignKeyConstraint(['container_uuid'], ['container.uuid'], ),
sa.PrimaryKeyConstraint('id')
) 示例7: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
op.create_table(
'capsule',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('capsule_version', sa.String(length=255), nullable=True),
sa.Column('kind', sa.String(length=36), nullable=True),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('restart_policy', sa.String(length=255), nullable=True),
sa.Column('host_selector', sa.String(length=255), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uuid', sa.String(length=36), nullable=False),
sa.Column('status', sa.String(length=255), nullable=True),
sa.Column('status_reason', sa.Text(), nullable=True),
sa.Column('message', models.JSONEncodedDict(), nullable=True),
sa.Column('spec', models.JSONEncodedDict(), nullable=True),
sa.Column('cpu', sa.Float(), nullable=True),
sa.Column('memory', sa.String(length=255), nullable=True),
sa.Column('meta_name', sa.String(length=255), nullable=True),
sa.Column('meta_labels', models.JSONEncodedList(), nullable=True),
sa.Column('containers_uuids', models.JSONEncodedList(), nullable=True),
sa.PrimaryKeyConstraint('id'),
) 示例8: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
op.create_table(
'allocation',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('resource_provider_id', sa.Integer(), nullable=False),
sa.Column('consumer_id', sa.String(36), nullable=False),
sa.Column('resource_class_id', sa.Integer(), nullable=False),
sa.Column('used', sa.Integer(), nullable=False),
sa.Column('is_nested', sa.Integer(), nullable=False),
sa.Column('blob', zun.db.sqlalchemy.models.JSONEncodedList(),
nullable=True),
sa.Index('allocation_resource_provider_class_used_idx',
'resource_provider_id', 'resource_class_id', 'used'),
sa.Index('allocation_consumer_id_idx', 'consumer_id'),
sa.Index('allocation_resource_class_id_idx', 'resource_class_id'),
sa.PrimaryKeyConstraint('id'),
) 示例9: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
op.create_table(
'container',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('uuid', sa.String(length=36), nullable=True),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('image', sa.String(length=255), nullable=True),
sa.Column('command', sa.String(length=255), nullable=True),
sa.Column('status', sa.String(length=20), nullable=True),
sa.Column('environment', zun.db.sqlalchemy.models.JSONEncodedDict(),
nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('uuid', name='uniq_container0uuid')
) 示例10: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
op.create_table(
'exec_instance',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), primary_key=True, nullable=False),
sa.Column('container_id', sa.Integer(), nullable=False),
sa.Column('exec_id', sa.String(255), nullable=False),
sa.Column('token', sa.String(255), nullable=True),
sa.Column('url', sa.String(255), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(['container_id'], ['container.id'],
ondelete='CASCADE'),
sa.UniqueConstraint('container_id', 'exec_id',
name='uniq_exec_instance0container_id_exec_id'),
) 示例11: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
# commands auto generated by Alembic - please adjust! #
op.create_table(
'image',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('uuid', sa.String(length=36), nullable=True),
sa.Column('image_id', sa.String(length=255), nullable=True),
sa.Column('repo', sa.String(length=255), nullable=True),
sa.Column('tag', sa.String(length=255), nullable=True),
sa.Column('size', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('repo', 'tag', name='uniq_image0repotag'),
mysql_charset='utf8',
mysql_engine='InnoDB'
)
# end Alembic commands # 示例12: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
op.add_column('compute_node',
sa.Column('rp_uuid', sa.String(length=36), nullable=True))
op.create_unique_constraint('uniq_compute_node0rp_uuid',
'compute_node', ['rp_uuid'])
# perform data migration between tables
session = sa.orm.Session(bind=op.get_bind())
with session.begin(subtransactions=True):
for row in session.query(COMPUTE_NODE_TABLE):
session.execute(
COMPUTE_NODE_TABLE.update().values(
rp_uuid=row.uuid).where(
COMPUTE_NODE_TABLE.c.uuid == row.uuid)
)
# this commit is necessary to allow further operations
session.commit()
op.alter_column('compute_node', 'rp_uuid',
nullable=False,
existing_type=sa.String(length=36),
existing_nullable=True,
existing_server_default=False) 示例13: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
op.create_table(
'volume_mapping',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uuid', sa.String(36), nullable=False),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('volume_id', sa.String(36), nullable=False),
sa.Column('volume_provider', sa.String(36), nullable=False),
sa.Column('container_uuid', sa.String(36), nullable=False),
sa.Column('container_path', sa.String(length=255), nullable=True),
sa.Column('connection_info', MediumText(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('uuid', name='uniq_volume0uuid'),
) 示例14: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
op.create_table(
'registry',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('uuid', sa.String(length=36), nullable=True),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('domain', sa.String(length=255), nullable=False),
sa.Column('username', sa.String(length=255), nullable=True),
sa.Column('password', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('uuid', name='uniq_registry0uuid'),
mysql_charset='utf8',
mysql_engine='InnoDB'
) 示例15: upgrade
# 需要导入模块: import sqlalchemy [as 别名]
# 或者: from sqlalchemy import String [as 别名]
def upgrade():
op.create_table(
'zun_service',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('report_count', sa.Integer(), nullable=False),
sa.Column('host', sa.String(length=255), nullable=True),
sa.Column('binary', sa.String(length=255), nullable=True),
sa.Column('disabled', sa.Boolean(), nullable=True),
sa.Column('disabled_reason', sa.String(length=255), nullable=True),
sa.Column('last_seen_up', sa.DateTime(), nullable=True),
sa.Column('forced_down', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('host', 'binary',
name='uniq_zun_service0host0binary')
)