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
3
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
3
Example 2
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)
3
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)
3
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))
3
Example 5
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'])
3
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'])
3
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)
3
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')
)
3
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)
3
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)
3
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"]
)
3
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)
]
3
Example 13
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')
)
3
Example 14
def _reference_column(schema, **kwargs):
return sa.Column(
sa.Integer,
sa.ForeignKey(
_get_primary_column(schema),
onupdate='CASCADE',
ondelete='CASCADE',
),
**kwargs
)
3
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')
3
Example 16
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))
3
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')
)
3
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
3
Example 19
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)
)
3
Example 20
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)
3
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')
)
3
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'], )
)
3
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)
)
3
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))
3
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')
3
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"]
)
3
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')
)
3
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
)
3
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'])
3
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_)
3
Example 31
@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)
3
Example 32
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'
)
3
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')
3
Example 34
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'
))
3
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
3
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')
3
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
)
)
3
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)
)
3
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')
3
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)
3
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'))
3
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),
)
3
Example 43
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)
3
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')
)
3
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')
)
3
Example 46
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'),
)
)
3
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')
)
3
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')
)
3
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)
)
3
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'])