sqlalchemy.BOOLEAN - python examples

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 7

3 View Complete Implementation : 6a4457517a3_rename_acl_creator_only_to_project_.py
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
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
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
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
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
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
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
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
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
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)