Here are the examples of the python api sqlalchemy.BOOLEAN taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
46 Examples
3
View Complete Implementation : 6a4457517a3_rename_acl_creator_only_to_project_.py
Copyright Apache License 2.0
Author : cloud-security-research
Copyright Apache License 2.0
Author : cloud-security-research
def upgrade():
ctx = op.get_context()
con = op.get_bind()
op.alter_column('secret_acls', 'creator_only', existing_type=sa.BOOLEAN(),
new_column_name='project_access')
# reverse existing flag value as project_access is negation of creator_only
op.execute('UPDATE secret_acls SET project_access = NOT project_access',
execution_options={'autocommit': True})
op.alter_column('container_acls', 'creator_only',
existing_type=sa.BOOLEAN(),
new_column_name='project_access')
# reverse existing flag value as project_access is negation of creator_only
op.execute('UPDATE container_acls SET project_access = NOT project_access',
execution_options={'autocommit': True})
3
View Complete Implementation : 1e1c9c5d8e58_add_plan_model_to_db.py
Copyright GNU Affero General Public License v3.0
Author : CypherpunkArmory
Copyright GNU Affero General Public License v3.0
Author : CypherpunkArmory
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint("user_plan_fk", "user", type_="foreignkey")
op.alter_column(
"user",
"confirmed",
existing_type=sa.BOOLEAN(),
nullable=False,
existing_server_default=sa.text("false"),
)
op.drop_column("user", "plan_id")
op.drop_index(op.f("ix_plan_stripe_id"), table_name="plan")
op.drop_index(op.f("ix_plan_name"), table_name="plan")
op.drop_table("plan")
3
View Complete Implementation : 64224f776e0f_add_confirmed_to_user_table.py
Copyright GNU Affero General Public License v3.0
Author : CypherpunkArmory
Copyright GNU Affero General Public License v3.0
Author : CypherpunkArmory
def upgrade():
op.add_column(
"user",
sa.Column("confirmed", sa.BOOLEAN, nullable=False, server_default="False"),
)
past
3
View Complete Implementation : aaea9ed1df44_change_tunnel_column_names.py
Copyright GNU Affero General Public License v3.0
Author : CypherpunkArmory
Copyright GNU Affero General Public License v3.0
Author : CypherpunkArmory
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column("subdomain", "in_use", existing_type=sa.BOOLEAN(), nullable=True)
op.alter_column("subdomain", "reserved", existing_type=sa.BOOLEAN(), nullable=True)
op.drop_constraint("subdomain_name_key", "subdomain", type_="unique")
op.add_column("tunnel", sa.Column("job_id", sa.String(length=64), nullable=True))
op.add_column("tunnel", sa.Column("ssh_port", sa.Integer(), nullable=True))
op.alter_column(
"tunnel", "port", existing_type=sa.VARCHAR(length=16), nullable=True
)
op.alter_column("tunnel", "subdomain_id", existing_type=sa.INTEGER(), nullable=True)
op.alter_column("tunnel", "user_id", existing_type=sa.INTEGER(), nullable=True)
op.drop_index("ix_tunnel_id", table_name="tunnel")
op.drop_constraint("tunnel_subdomain_id_key", "tunnel", type_="unique")
op.drop_column("tunnel", "tunnel_connection_port")
op.drop_column("tunnel", "tunnel_ssh_port")
op.drop_column("tunnel", "tunnel_server")
3
View Complete Implementation : eee1ab2826c0_fix_to_cc_judgments.py
Copyright GNU General Public License v3.0
Author : dismantl
Copyright GNU General Public License v3.0
Author : dismantl
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('cc_judgments', sa.Column('amount_vehicle', sa.BOOLEAN(), autoincrement=False, nullable=True))
op.add_column('cc_judgments', sa.Column('tij_vehicle', sa.BOOLEAN(), autoincrement=False, nullable=True))
op.drop_column('cc_judgments', 'tij_other')
op.drop_column('cc_judgments', 'amount_other')
op.drop_column('cc_judgment_modifications', 'amount_other')
3
View Complete Implementation : 8692ab1298e1_replace_filerequest_with_filegeneration.py
Copyright Creative Commons Zero v1.0 Universal
Author : fedspendingtransparency
Copyright Creative Commons Zero v1.0 Universal
Author : fedspendingtransparency
def downgrade_data_broker():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('job', sa.Column('from_cached', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False))
op.drop_constraint('fk_file_request_file_generation_id', 'job', type_='foreignkey')
op.drop_column('job', 'file_generation_id')
op.drop_index(op.f('ix_file_generation_start_date'), table_name='file_generation')
op.drop_index(op.f('ix_file_generation_request_date'), table_name='file_generation')
op.drop_index(op.f('ix_file_generation_file_type'), table_name='file_generation')
op.drop_index(op.f('ix_file_generation_end_date'), table_name='file_generation')
op.drop_index(op.f('ix_file_generation_agency_type'), table_name='file_generation')
op.drop_index(op.f('ix_file_generation_agency_code'), table_name='file_generation')
op.drop_table('file_generation')
op.execute("""
DROP TYPE generation_agency_types
""")
op.execute("""
DROP TYPE generation_file_types
""")
3
View Complete Implementation : ea8fbaa044d7_remove_first_quarter_flag.py
Copyright Creative Commons Zero v1.0 Universal
Author : fedspendingtransparency
Copyright Creative Commons Zero v1.0 Universal
Author : fedspendingtransparency
def downgrade_data_broker():
### commands auto generated by Alembic - please adjust! ###
op.add_column('object_clast_program_activity', sa.Column('is_first_quarter', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False))
op.add_column('award_financial_astistance', sa.Column('is_first_quarter', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False))
op.add_column('award_financial', sa.Column('is_first_quarter', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False))
op.add_column('appropriation', sa.Column('is_first_quarter', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False))
3
View Complete Implementation : 068674f06b0f_.py
Copyright BSD 2-Clause "Simplified" License
Author : hotosm
Copyright BSD 2-Clause "Simplified" License
Author : hotosm
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column(
"users",
"expert_mode",
existing_type=sa.BOOLEAN(),
nullable=False,
existing_server_default=sa.text("false"),
)
op.drop_column("users", "picture_url")
3
View Complete Implementation : 2019_09_21_10aa7e1f95ec_is_animated_flag.py
Copyright MIT License
Author : Nukesor
Copyright MIT License
Author : Nukesor
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('inline_query_request', 'fuzzy',
existing_type=sa.BOOLEAN(),
server_default=None,
existing_nullable=True)
op.add_column('sticker', sa.Column('animated', sa.Boolean(), server_default='FALSE', nullable=False))
op.alter_column('sticker', 'banned',
existing_type=sa.BOOLEAN(),
server_default=None,
existing_nullable=False)
3
View Complete Implementation : 2019_09_21_10aa7e1f95ec_is_animated_flag.py
Copyright MIT License
Author : Nukesor
Copyright MIT License
Author : Nukesor
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('sticker', 'banned',
existing_type=sa.BOOLEAN(),
server_default=sa.text('false'),
existing_nullable=False)
op.drop_column('sticker', 'animated')
op.alter_column('inline_query_request', 'fuzzy',
existing_type=sa.BOOLEAN(),
server_default=sa.text('false'),
existing_nullable=True)