sqlalchemy.Integer

Here are the examples of the python api sqlalchemy.Integer taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

185 Examples 7

Example 1

Project: postgresql-audit Source File: test_custom_schema.py
    def test_data_expression(self, user, session, activity_cls):
        user.name = 'Luke'
        session.commit()
        assert session.query(activity_cls).filter(
            activity_cls.table_name == 'user',
            activity_cls.data['id'].cast(sa.Integer) == user.id
        ).count() == 2

Example 2

Project: adhocracy Source File: 486aab29697a_added_velruse_table.py
Function: upgrade
def upgrade():
    op.create_table(
        'velruse',
        sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('create_time', sa.DateTime(), nullable=True),
        sa.Column('delete_time', sa.DateTime(), nullable=True),
        sa.Column('domain', sa.Unicode(length=255), nullable=False),
        sa.Column('domain_user', sa.Unicode(length=255), nullable=False),
        sa.Column('user_id', sa.Integer(), nullable=False),
        sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('domain', 'domain_user',
                            name='unique_velruse_user')
    )
    op.create_index('ix_velruse_domain', 'velruse', ['domain'],
                    unique=False)
    op.create_index('ix_velruse_domain_user', 'velruse', ['domain_user'],
                    unique=False)

Example 3

Project: glossary-bot Source File: 578b43a08697_initial_migration.py
def upgrade():
    op.create_table('interactions',
                    sa.Column('id', sa.Integer(), nullable=False),
                    sa.Column('creation_date', sa.DateTime(), nullable=True),
                    sa.Column('user', sa.Unicode(), nullable=True),
                    sa.Column('term', sa.Unicode(), nullable=True),
                    sa.Column('action', sa.Unicode(), nullable=True),
                    sa.PrimaryKeyConstraint('id'))
    op.create_index(op.f('ix_interactions_action'), 'interactions', ['action'], unique=False)

    op.create_table('definitions',
                    sa.Column('id', sa.Integer(), nullable=False),
                    sa.Column('creation_date', sa.DateTime(), nullable=True),
                    sa.Column('term', sa.Unicode(), nullable=True),
                    sa.Column('definition', sa.Unicode(), nullable=True),
                    sa.Column('user', sa.Unicode(), nullable=True),
                    sa.PrimaryKeyConstraint('id'))
    op.create_index(op.f('ix_definitions_term'), 'definitions', ['term'], unique=False)

Example 4

Project: JARR Source File: cde34831ea_adding_feed_and_user_attributes_for_.py
def upgrade():
    unix_start = datetime(1970, 1, 1)
    # commands auto generated by Alembic - please adjust! ###
    op.add_column('feed', sa.Column('error_count', sa.Integer(), nullable=True,
            default=0, server_default="0"))
    op.add_column('feed', sa.Column('last_error', sa.String(), nullable=True))
    op.add_column('feed', sa.Column('last_modified', sa.DateTime(),
            nullable=True, default=unix_start, server_default=str(unix_start)))
    op.add_column('feed', sa.Column('last_retrieved', sa.DateTime(),
            nullable=True, default=unix_start, server_default=str(unix_start)))
    op.add_column('feed', sa.Column('etag', sa.String(), nullable=True))
    op.add_column('user', sa.Column('refresh_rate', sa.Integer(),
            nullable=True, default=60))

Example 5

Project: WatchPeopleCode Source File: 6ae3f450df3_.py
Function: upgrade
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('streamer',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('reddit_username', sa.String(length=20), nullable=True),
    sa.Column('twitch_channel', sa.String(length=25), nullable=True),
    sa.Column('youtube_channel', sa.String(length=24), nullable=True),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('reddit_username'),
    sa.UniqueConstraint('twitch_channel'),
    sa.UniqueConstraint('youtube_channel')
    )
    op.add_column(u'stream', sa.Column('streamer_id', sa.Integer(), nullable=True))
    op.create_foreign_key(None, 'stream', 'streamer', ['streamer_id'], ['id'])

Example 6

Project: gamification-engine Source File: 42ab7edc19e2_added_achievementcategories.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('achievementcategories',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=255), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.add_column(u'achievements', sa.Column('achievementcategory_id', sa.Integer(), nullable=True))
    op.create_foreign_key(None, 'achievements', 'achievementcategories', ['achievementcategory_id'], ['id'])

Example 7

Project: sqlalchemy-searchable Source File: test_schema_creation.py
    def create_models(self):
        class TextItem(self.Base):
            __tablename__ = 'textitem'

            id = sa.Column(sa.Integer, primary_key=True, autoincrement=True)

            name = sa.Column(sa.Unicode(255))

            search_vector = sa.Column(TSVectorType())

            content = sa.Column(sa.UnicodeText)

Example 8

Project: dataserv Source File: 14d4ac0f0f1_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('farmer',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('btc_addr', sa.String(length=35), nullable=True),
    sa.Column('payout_addr', sa.String(length=35), nullable=True),
    sa.Column('last_seen', sa.DateTime(), nullable=True),
    sa.Column('height', sa.Integer(), nullable=True),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('btc_addr')
    )

Example 9

Project: SAUCE Source File: 6bceed82300_multiteachers.py
def downgrade():
    op.drop_table(u'event_teachers')
    op.drop_table(u'lesson_tutors')
    op.alter_column('lessons', u'tutor_id',
               existing_type=sa.Integer(),
               nullable=False)

Example 10

Project: gourmet Source File: data_plugin.py
    def setup_nutritionaliases_table (self):
        self.db.nutritionaliases_table = Table('nutritionaliases',self.db.metadata,
                                            Column('id',Integer(),primary_key=True),
                                            Column('ingkey',Text()),
                                            Column('ndbno',Integer,ForeignKey('nutrition.ndbno')),
                                            Column('density_equivalent',Text(length=20)))
        class NutritionAlias (object): pass
        self.db._setup_object_for_table(self.db.nutritionaliases_table, NutritionAlias)

Example 11

Project: holmes-api Source File: 25abb99fc57_create_workers_table.py
def upgrade():
    op.create_table(
        'workers',
        sa.Column('id', sa.Integer, primary_key=True),
        sa.Column('uuid', sa.String(36), nullable=False),
        sa.Column('last_ping', sa.DateTime, nullable=False),
        sa.Column('current_review_id', sa.Integer)
    )

    op.create_foreign_key(
        "fk_worker_current_review", "workers",
        "reviews", ["current_review_id"], ["id"]
    )

Example 12

Project: datanommer Source File: 198447250956_one_model.py
def get_table_args(tname):
    return [
        tname,
        metadata,
        sa.Column('id', sa.Integer, primary_key=True),
        sa.Column('i', sa.Integer, nullable=False),
        sa.Column('timestamp', sa.DateTime, nullable=False),
        sa.Column('certificate', sa.UnicodeText),
        sa.Column('signature', sa.UnicodeText),
        sa.Column('topic', sa.UnicodeText),
        sa.Column('_msg', sa.UnicodeText, nullable=False)
    ]

Example 13

Project: burp-ui Source File: 225d9b2f0fb1_initial.py
Function: upgrade
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('task',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('uuid', sa.String(), nullable=True),
    sa.Column('task', sa.String(), nullable=True),
    sa.Column('user', sa.String(), nullable=True),
    sa.Column('timestamp', sa.DateTime(), nullable=True),
    sa.Column('expire', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('uuid')
    )

Example 14

Project: guardrail Source File: sqlalchemy.py
Function: reference_column
def _reference_column(schema, **kwargs):
    return sa.Column(
        sa.Integer,
        sa.ForeignKey(
            _get_primary_column(schema),
            onupdate='CASCADE',
            ondelete='CASCADE',
        ),
        **kwargs
    )

Example 15

Project: Skier Source File: skier_migrate_use_a_new_table_for_uids.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('UID',
                    sa.Column('id', sa.Integer(), nullable=False),
                    sa.Column('full_uid', sa.String(), nullable=True),
                    sa.Column('uid_name', sa.String(), nullable=True),
                    sa.Column('uid_email', sa.String(), nullable=True),
                    sa.Column('uid_comment', sa.String(), nullable=True),
                    sa.Column('key_id', sa.Integer(), nullable=True),
                    sa.ForeignKeyConstraint(['key_id'], ['key.id'], ),
                    sa.PrimaryKeyConstraint('id')
                    )
    op.drop_column('key', 'uid')

Example 16

Project: sqlalchemy-i18n Source File: test_common_base_class.py
Function: create_tables
    def create_tables(self):
        ClassicTestCase.create_tables(self)

        self.textitems = sa.Table(
            'textitems', self.metadata,
            sa.Column('id', sa.Integer,
                      autoincrement=True,
                      primary_key=True,
                      nullable=False))
        self.textitems_translation = sa.Table(
            'textitems_translation', self.metadata,
            sa.Column('id', sa.Integer, sa.ForeignKey('textitems'),
                      primary_key=True,
                      nullable=False),
            sa.Column('locale', sa.types.CHAR(2),
                      primary_key=True,
                      nullable=False),
            sa.Column('name', sa.UnicodeText))

Example 17

Project: flask-bones Source File: 1fb7c6da302_.py
def upgrade():
    op.create_table('user',
        sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('username', sa.String(length=20), nullable=False),
        sa.Column('email', sa.String(length=128), nullable=False),
        sa.Column('pw_hash', sa.String(length=60), nullable=False),
        sa.Column('created_ts', sa.DateTime(), nullable=False),
        sa.Column('remote_addr', sa.String(length=20), nullable=True),
        sa.Column('active', sa.Boolean(), nullable=True),
        sa.Column('is_admin', sa.Boolean(), nullable=True),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('email'),
        sa.UniqueConstraint('username')
    )

Example 18

Project: wtforms-json Source File: test_field_type_coercion.py
    def setup_method(self, method):
        self.Base = declarative_base()

        class Team(self.Base):
            __tablename__ = 'team'
            id = sa.Column(sa.Integer, primary_key=True)
            name = sa.Column(sa.Unicode(255))

        class Match(self.Base):
            __tablename__ = 'match'
            id = sa.Column(sa.Integer, primary_key=True)
            name = sa.Column(sa.Unicode(255))
            team_id = sa.Column(sa.BigInteger, sa.ForeignKey(Team.id))
            team = sa.orm.relationship(Team)

        self.Team = Team
        self.Match = Match

Example 19

Project: pybossa Source File: 4a571e217ab8_add_webhooks_table.py
Function: upgrade
def upgrade():
    op.create_table('webhook',
                    sa.Column('id', sa.Integer, primary_key=True),
                    sa.Column('created', sa.Text, default=make_timestamp),
                    sa.Column('updated', sa.Text, default=make_timestamp),
                    sa.Column('project_id', sa.Integer,
                              sa.ForeignKey('project.id')),
                    sa.Column('payload', JSON),
                    sa.Column('response', sa.Text),
                    sa.Column('response_status_code', sa.Integer)
                    )

Example 20

Project: flasky-with-celery Source File: 38c4e85512a9_initial_migration.py
Function: upgrade
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('roles',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=64), nullable=True),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('name')
    )
    op.create_table('users',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('username', sa.String(length=64), nullable=True),
    sa.Column('role_id', sa.Integer(), nullable=True),
    sa.ForeignKeyConstraint(['role_id'], ['roles.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index('ix_users_username', 'users', ['username'], unique=True)

Example 21

Project: learning-python Source File: 20150101130345_3d8f34e83d23_add_user_model.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('user',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=50), nullable=True),
    sa.Column('email', sa.String(length=50), nullable=True),
    sa.Column('avatar', sa.String(length=200), nullable=True),
    sa.Column('password', sa.String(length=200), nullable=True),
    sa.Column('is_admin', sa.Boolean(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('email'),
    sa.UniqueConstraint('name')
    )

Example 22

Project: histsync Source File: 10759d3db3c5_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('stars_users',
    sa.Column('user_id', sa.Integer(), nullable=True),
    sa.Column('command_id', sa.Integer(), nullable=True),
    sa.ForeignKeyConstraint(['command_id'], ['command.id'], ),
    sa.ForeignKeyConstraint(['user_id'], ['user.id'], )
    )

Example 23

Project: pybossa Source File: 4f12d8650050_add_results_table.py
def upgrade():
    op.create_table(
        'result',
        sa.Column('id', sa.Integer, primary_key=True),
        sa.Column('created', sa.Text, default=make_timestamp),
        sa.Column('project_id', sa.Integer, sa.ForeignKey('project.id'), nullable=False),
        sa.Column('task_id', sa.Integer, sa.ForeignKey('task.id'), nullable=False),
        sa.Column('task_run_ids', ARRAY(sa.Integer), nullable=False),
        sa.Column('last_version', sa.Boolean, default=True),
        sa.Column('info', JSON)
    )

Example 24

Project: bodhi Source File: 2861bb4e77b1_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('stacks',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('name', sa.UnicodeText(), nullable=False),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('name')
    )
    op.add_column(u'packages', sa.Column('stack_id', sa.Integer(), nullable=True))

Example 25

Project: cslbot Source File: 55efdbb748c_merge_pending.py
def upgrade():
    if op.get_bind().dialect.name == 'sqlite':
        with op.batch_alter_table('quotes') as batch_op:
            batch_op.add_column(sa.Column('accepted', sa.Integer(), nullable=True))
            batch_op.drop_column('approved')
    else:
        op.alter_column('quotes', 'approved', new_column_name='accepted')

Example 26

Project: holmes-api Source File: 1a316b08d134_add_last_review_colu.py
def upgrade():
    op.add_column(
        'pages',
        sa.Column('last_review_id', sa.Integer)
    )

    op.create_foreign_key(
        "fk_page_last_review", "pages",
        "reviews", ["last_review_id"], ["id"]
    )

Example 27

Project: formspree Source File: dc8c1be855c_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('forms',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('hash', sa.String(length=32), nullable=True),
    sa.Column('email', sa.String(length=120), nullable=True),
    sa.Column('host', sa.String(length=300), nullable=True),
    sa.Column('confirm_sent', sa.Boolean(), nullable=True),
    sa.Column('confirmed', sa.Boolean(), nullable=True),
    sa.Column('counter', sa.Integer(), nullable=True),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('hash')
    )

Example 28

Project: viaduct Source File: 48c16211f99_added_summary_table.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('summary',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('created', sa.DateTime(), nullable=True),
    sa.Column('modified', sa.DateTime(), nullable=True),
    sa.Column('title', sa.String(length=128), nullable=True),
    sa.Column('path', sa.String(length=256), nullable=True),
    sa.Column('date', sa.Date(), nullable=True),
    sa.Column('course_id', sa.Integer(), nullable=True),
    sa.Column('education_id', sa.Integer(), nullable=True),
    sa.ForeignKeyConstraint(['course_id'], ['course.id'], name=op.f('fk_summary_course_id_course')),
    sa.ForeignKeyConstraint(['education_id'], ['education.id'], name=op.f('fk_summary_education_id_education')),
    sa.PrimaryKeyConstraint('id', name=op.f('pk_summary')),
    sqlite_autoincrement=True
    )

Example 29

Project: JARR Source File: 3f83bfe93fc_adding_category.py
def upgrade():
    op.create_table('category',
            sa.Column('id', sa.Integer(), nullable=False),
            sa.Column('name', sa.String(), nullable=True),
            sa.Column('user_id', sa.Integer(), nullable=True),
            sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
            sa.PrimaryKeyConstraint('id'))
    op.add_column('article',
                  sa.Column('category_id', sa.Integer(), nullable=True))
    op.add_column('feed',
                  sa.Column('category_id', sa.Integer(), nullable=True))
    if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI:
        op.create_foreign_key(None, 'article', 'category',
                              ['category_id'], ['id'])
        op.create_foreign_key(None, 'feed', 'category',
                              ['category_id'], ['id'])

Example 30

Project: bauble.classic Source File: db.py
    def __init__(cls, classname, bases, dict_):
        if '__tablename__' in dict_:
            cls.id = sa.Column('id', sa.Integer, primary_key=True,
                               autoincrement=True)
            cls._created = sa.Column('_created', types.DateTime(True),
                                     default=sa.func.now())
            cls._last_updated = sa.Column('_last_updated',
                                          types.DateTime(True),
                                          default=sa.func.now(),
                                          onupdate=sa.func.now())
            cls.__mapper_args__ = {'extension': HistoryExtension()}
        if 'top_level_count' not in dict_:
            cls.top_level_count = lambda x: {classname: 1}
        if 'search_view_markup_pair' not in dict_:
            cls.search_view_markup_pair = lambda x: (
                utils.xml_safe(str(x)),
                '(%s)' % type(x).__name__)

        super(MapperBase, cls).__init__(classname, bases, dict_)

Example 31

Project: filteralchemy Source File: conftest.py
Function: models
@pytest.fixture
def models(Base):
    class Album(Base):
        __tablename__ = 'album'
        id = sa.Column(sa.Integer, primary_key=True, index=True)

        name = sa.Column(sa.String, index=True)
        genre = sa.Column(sa.String, index=True)
        sales = sa.Column(sa.Float)
        date = sa.Column(sa.Date)
    return Bunch(Album=Album)

Example 32

Project: faf Source File: 2e5f6d8b68f5_add_contact_email_tables.py
Function: upgrade
def upgrade():
    op.create_table('contactemails',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('email_address', sa.String(length=128), nullable=False),
    sa.PrimaryKeyConstraint('id'),
    mysql_charset='utf8',
    mysql_engine='InnoDB'
    )
    op.create_table('reportcontactemails',
    sa.Column('report_id', sa.Integer(), nullable=False),
    sa.Column('contact_email_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['contact_email_id'], ['contactemails.id'], ),
    sa.ForeignKeyConstraint(['report_id'], ['reports.id'], ),
    sa.PrimaryKeyConstraint('report_id', 'contact_email_id'),
    mysql_charset='utf8',
    mysql_engine='InnoDB'
    )

Example 33

Project: kcsrv Source File: 83e8534880_ship_modern_fk_goes to_stats_not_resources.py
def upgrade():
### commands auto generated by Alembic - please adjust! ###
    op.add_column('ship', sa.Column('modern_stats_id', sa.Integer(), nullable=True))
    op.create_index(op.f('ix_ship_modern_stats_id'), 'ship', ['modern_stats_id'], unique=False)
    op.drop_index('ix_ship_modern_resources_id', table_name='ship')
    op.drop_constraint('ship_modern_resources_id_fkey', 'ship', type_='foreignkey')
    op.create_foreign_key(None, 'ship', 'stats', ['modern_stats_id'], ['id'])
    op.drop_column('ship', 'modern_resources_id')

Example 34

Project: climber Source File: DBPipeline.py
Function: update_table_names
    def __update_table_names(self):
        """
        Adds all tables to the internal table list.
        """
        pfx = self._table_prefix
        self.__add_table(sa.Table(pfx + 'job', self.metadata,
            sa.Column('id',     sa.Integer, primary_key = True),
            sa.Column('name',   sa.String(150), index = True),
            sa.Column('status', sa.String(50), index = True),
            sa.Column('job',    sa.PickleType()),
            mysql_engine = 'INNODB'
        ))

Example 35

Project: sqlalchemy-defaults Source File: test_float_defaults.py
@pytest.fixture
def Account(Base, lazy_options):
    class Account(Base):
        __tablename__ = 'account'
        __lazy_options__ = lazy_options

        id = Column(sa.Integer, primary_key=True)
        balance = Column(
            sa.Float,
            min=0,
            max=120000,
            default=0
        )
    return Account

Example 36

Project: ok Source File: 7e1d5c529924_custom_submission_times_for_backup.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('backup', sa.Column('creator_id', sa.Integer(), nullable=True))
    op.add_column('backup', sa.Column('custom_submission_time', sa.DateTime(timezone=True), nullable=True))
    op.create_foreign_key(op.f('fk_backup_creator_id_user'), 'backup', 'user', ['creator_id'], ['id'])
    op.drop_column('backup', 'extension')

Example 37

Project: sqlalchemy-json-api Source File: conftest.py
@pytest.fixture(scope='class')
def friendship_cls(base):
    return sa.Table(
        'friendships',
        base.metadata,
        sa.Column(
            'friend_a_id',
            sa.Integer,
            sa.ForeignKey('user.id'),
            primary_key=True
        ),
        sa.Column(
            'friend_b_id',
            sa.Integer,
            sa.ForeignKey('user.id'),
            primary_key=True
        )
    )

Example 38

Project: sopython-site Source File: 2345d75e84a_wiki_page.py
def upgrade():
    op.create_table(
        'wiki_page',
        sa.Column('id', sa.Integer, primary_key=True),
        sa.Column('title', sa.String, nullable=False),
        sa.Column('body', sa.String, nullable=False),
        sa.Column('updated', sa.DateTime, nullable=False)
    )

Example 39

Project: wtforms-alchemy Source File: test_column_aliases.py
    def test_unique_indexes(self):
        class TestModel(self.base):
            __tablename__ = 'TestTable'
            id = sa.Column(sa.Integer, primary_key=True)
            some_alias = sa.Column('some_name', sa.Integer, unique=True)

        class TestForm(ModelForm):
            class Meta:
                model = TestModel

            @staticmethod
            def get_session():
                return None

        form = TestForm()
        assert hasattr(form, 'some_alias')
        assert not hasattr(form, 'some_name')

Example 40

Project: glottolog3 Source File: 53b80531e21e_add_doctype_ord_column.py
def upgrade():
    op.add_column('doctype', sa.Column('ord', sa.Integer))

    conn = op.get_bind()

    update_doctype = sa.text('UPDATE doctype SET updated = now(), '
        'ord = :ord WHERE id = :id AND ord IS DISTINCT FROM :ord', conn)

    id_ord = [{'id': id, 'ord': i} for i, id in enumerate(DOCTYPES, 1)]

    update_doctype.execute(id_ord)

Example 41

Project: redwind Source File: 93bd528a83_add_attachment_element.py
def upgrade():
    # commands auto generated by Alembic - please adjust! ###
    op.create_table(
        'attachment',
        sa.Column('id', sa.Integer(), nullable=False, index=True),
        sa.Column('filename', sa.String(length=256), nullable=True),
        sa.Column('mimetype', sa.String(length=256), nullable=True),
        sa.Column('storage_path', sa.String(length=256), nullable=True),
        sa.Column('post_id', sa.Integer(), nullable=True),
        sa.ForeignKeyConstraint(['post_id'], ['post.id'], ),
        sa.PrimaryKeyConstraint('id'))

Example 42

Project: june Source File: f08db66d495_init.py
def create_node():
    op.create_table(
        'node',
        sa.Column('id', sa.Integer, primary_key=True),
        sa.Column('title', sa.String(100), nullable=False),
        sa.Column('urlname', sa.String(40), unique=True, index=True),
        sa.Column('description', sa.Text),
        sa.Column('topic_count', sa.Integer),
        sa.Column('role', sa.String(10)),
        sa.Column('created', sa.DateTime),
        sa.Column('updated', sa.DateTime, index=True),
    )

Example 43

Project: flasky Source File: 1b966e7f4b9e_post_model.py
Function: upgrade
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('posts',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('body', sa.Text(), nullable=True),
    sa.Column('timestamp', sa.DateTime(), nullable=True),
    sa.Column('author_id', sa.Integer(), nullable=True),
    sa.ForeignKeyConstraint(['author_id'], ['users.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index('ix_posts_timestamp', 'posts', ['timestamp'], unique=False)

Example 44

Project: aurora Source File: 370b494d9871_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('project_parameters',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=128), nullable=False),
    sa.Column('value', sa.String(length=128), nullable=False),
    sa.Column('type', sa.SmallInteger(), nullable=False),
    sa.Column('project_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['project_id'], ['projects.id'], ),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('name')
    )

Example 45

Project: flask-boilerplate Source File: 40aa1a9694cf_.py
def upgrade():
    op.create_table('docuement',
        sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('data', postgresql.JSONB(), nullable=False),
        sa.PrimaryKeyConstraint('id')
    )

Example 46

Project: pagure Source File: abc71fd60fa_add_the_closed_by_column_to_pull_.py
Function: upgrade
def upgrade():
    ''' Add the column merge_status to the table pull_requests.
    '''
    op.add_column(
        'pull_requests',
        sa.Column(
            'closed_by_id',
            sa.Integer,
            sa.ForeignKey('users.id', onupdate='CASCADE'),
        )
    )

Example 47

Project: pgcontents Source File: 3d5ea85fc44f_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('remote_checkpoints',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('user_id', sa.Unicode(length=30), nullable=False),
    sa.Column('path', sa.Unicode(length=70), nullable=False),
    sa.Column('content', sa.LargeBinary(length=100000), nullable=False),
    sa.Column('last_modified', sa.DateTime(), nullable=False),
    sa.ForeignKeyConstraint(['user_id'], [u'users.id'], ),
    sa.PrimaryKeyConstraint('id')
    )

Example 48

Project: ansible-report Source File: 53fae050253c_add_playbook_table.py
def upgrade():
    op.create_table('playbook',
        sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('path', sa.String(), nullable=True),
        sa.Column('uuid', sa.String(), nullable=True),
        sa.Column('connection', sa.String(), nullable=True),
        sa.Column('starttime', sa.DateTime(), nullable=True),
        sa.Column('endtime', sa.DateTime(), nullable=True),
        sa.Column('checksum', sa.DateTime(), nullable=True),
        sa.Column('user_id', sa.Integer(), nullable=True),
        sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
        sa.PrimaryKeyConstraint('id')
    )

Example 49

Project: appointment-reminders-flask Source File: 3e7ebdde2eb_create_appointments_table.py
def upgrade():
    op.create_table(
        'appointments',
        sa.Column('id', sa.Integer, primary_key=True),
        sa.Column('name', sa.String(255), nullable=False),
        sa.Column('phone_number', sa.String(20), nullable=False),
        sa.Column('delta', sa.Integer, nullable=False),
        sa.Column('time', sa.DateTime, nullable=False),
        sa.Column('timezone', sa.String(), nullable=False)
    )

Example 50

Project: timesketch Source File: be32626451fb_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('searchindex_accesscontrolentry', sa.Column('group_id', sa.Integer(), nullable=True))
    op.create_foreign_key(None, 'searchindex_accesscontrolentry', 'group', ['group_id'], ['id'])
    op.add_column('sketch_accesscontrolentry', sa.Column('group_id', sa.Integer(), nullable=True))
    op.create_foreign_key(None, 'sketch_accesscontrolentry', 'group', ['group_id'], ['id'])
    op.add_column('view_accesscontrolentry', sa.Column('group_id', sa.Integer(), nullable=True))
    op.create_foreign_key(None, 'view_accesscontrolentry', 'group', ['group_id'], ['id'])
See More Examples - Go to Next Page
Page 1 Selected Page 2 Page 3 Page 4