sqlalchemy.String

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

190 Examples 7

Example 1

Project: cassiopeia Source File: league.py
def _sa_bind_league_entry():
    global LeagueEntry

    @cassiopeia.type.core.common.inheritdocs
    class LeagueEntry(LeagueEntry, cassiopeia.type.dto.common.BaseDB):
        __tablename__ = "LeagueEntry"
        division = sqlalchemy.Column(sqlalchemy.String(30))
        isFreshBlood = sqlalchemy.Column(sqlalchemy.Boolean)
        isHotStreak = sqlalchemy.Column(sqlalchemy.Boolean)
        isInactive = sqlalchemy.Column(sqlalchemy.Boolean)
        isVeteran = sqlalchemy.Column(sqlalchemy.Boolean)
        leaguePoints = sqlalchemy.Column(sqlalchemy.Integer)
        losses = sqlalchemy.Column(sqlalchemy.Integer)
        miniSeries = sqlalchemy.orm.relationship("cassiopeia.type.dto.league.MiniSeries", uselist=False, cascade="all, delete-orphan", passive_deletes=True)
        playerOrTeamId = sqlalchemy.Column(sqlalchemy.String(50))
        playerOrTeamName = sqlalchemy.Column(sqlalchemy.String(30))
        wins = sqlalchemy.Column(sqlalchemy.Integer)
        _id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True)
        _league_id = sqlalchemy.Column(sqlalchemy.Integer, sqlalchemy.ForeignKey("League._id", ondelete="CASCADE"))

Example 2

Project: glance Source File: 012_id_to_uuid.py
def _upgrade_other(t_images, t_image_members, t_image_properties, dialect):
    """
    Upgrade 011 -> 012 with logic for non-SQLite databases.
    """
    foreign_keys = _get_foreign_keys(t_images,
                                     t_image_members,
                                     t_image_properties, dialect)

    for fk in foreign_keys:
        fk.drop()

    t_images.c.id.alter(sqlalchemy.String(36), primary_key=True)
    t_image_members.c.image_id.alter(sqlalchemy.String(36))
    t_image_properties.c.image_id.alter(sqlalchemy.String(36))

    _update_all_ids_to_uuids(t_images, t_image_members, t_image_properties)

    for fk in foreign_keys:
        fk.create()

Example 3

Project: cassiopeia Source File: status.py
def _sa_bind_shard_status():
    global ShardStatus

    @cassiopeia.type.core.common.inheritdocs
    class ShardStatus(ShardStatus, cassiopeia.type.dto.common.BaseDB):
        __tablename__ = "ShardStatus"
        hostname = sqlalchemy.Column(sqlalchemy.String(50))
        locales = sqlalchemy.Column(cassiopeia.type.dto.common.JSONEncoded)
        name = sqlalchemy.Column(sqlalchemy.String(30))
        region_tag = sqlalchemy.Column(sqlalchemy.String(30))
        services = sqlalchemy.orm.relationship("cassiopeia.type.dto.status.Service", cascade="all, delete-orphan", passive_deletes=True)
        slug = sqlalchemy.Column(sqlalchemy.String(30))
        _id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True)

Example 4

Project: cassiopeia Source File: status.py
def _sa_bind_shard():
    global Shard

    @cassiopeia.type.core.common.inheritdocs
    class Shard(Shard, cassiopeia.type.dto.common.BaseDB):
        __tablename__ = "Shard"
        hostname = sqlalchemy.Column(sqlalchemy.String(50))
        locales = sqlalchemy.Column(cassiopeia.type.dto.common.JSONEncoded)
        name = sqlalchemy.Column(sqlalchemy.String(30))
        region_tag = sqlalchemy.Column(sqlalchemy.String(30), primary_key=True)
        slug = sqlalchemy.Column(sqlalchemy.String(30))

Example 5

Project: king-phisher Source File: 7c315088952_schema_v4.py
def upgrade():
	op.add_column('campaigns', sqlalchemy.Column('description', sqlalchemy.String))
	op.add_column('messages', sqlalchemy.Column('opener_ip', sqlalchemy.String))
	op.add_column('messages', sqlalchemy.Column('opener_user_agent', sqlalchemy.String))

	db_manager.Session.remove()
	db_manager.Session.configure(bind=op.get_bind())
	session = db_manager.Session()
	db_manager.set_meta_data('schema_version', 4, session=session)
	session.commit()

Example 6

Project: SickGear Source File: test_results.py
Function: define_tables
    @classmethod
    def define_tables(cls, metadata):
        Table('plain_pk', metadata,
                Column('id', Integer, primary_key=True),
                Column('data', String(50))
            )
        Table('has_dates', metadata,
            Column('id', Integer, primary_key=True),
            Column('today', DateTime)
        )

Example 7

Project: holmes-api Source File: 178c6db7516_add_domain_page_url_.py
def downgrade():
    op.drop_constraint('uk_domain_url', 'domains', type_='unique')
    op.drop_constraint('uk_page_url', 'pages', type_='unique')
    op.alter_column('pages', 'url', type_=sa.String(2000))
    op.alter_column('domains', 'url', type_=sa.String(2000))
    op.drop_column('pages', 'url_hash')
    op.drop_column('domains', 'url_hash')

Example 8

Project: sqlalchemy_exasol Source File: test_exasol.py
Function: define_tables
    @classmethod
    def define_tables(cls, metadata):
        Table('t', metadata,
            Column('id', Integer),
            Column('name', String(20)),
            Column('age', Integer)
        )
        Table('s', metadata,
            Column('id', Integer),
            Column('age', Integer)
        )

Example 9

Project: chronology Source File: 265ea1d587a3_.py
Function: upgrade
def upgrade():
  ### commands auto generated by Alembic - please adjust! ###
  op.create_table('task',
  sa.Column('id', sa.String(), nullable=False),
  sa.Column('active', sa.Boolean(), nullable=True),
  sa.Column('code', sa.Text(), nullable=True),
  sa.Column('interval', sa.Integer(), nullable=True),
  sa.PrimaryKeyConstraint('id')
  )

Example 10

Project: simplekv Source File: sql.py
    def __init__(self, bind, metadata, tablename):
        self.bind = bind

        self.table = Table(tablename, metadata,
            # 250 characters is the maximum key length that we guarantee can be
            # handled by any kind of backend
            Column('key', String(250), primary_key=True),
            Column('value', LargeBinary, nullable=False)
        )

Example 11

Project: brewery Source File: test_sql_streams.py
    def test_table_fields(self):
        table = Table('users', self.metadata,
                    Column('id', Integer, primary_key=True),
                    Column('login', String(32)),
                    Column('full_name', String(255)),
                    Column('profile', Text)
                )
        
        self.metadata.create_all(self.engine)
        
        stream = ds.SQLDataSource(connection=self.engine, table=str(table))
        
        fields = stream.fields
        
        self.assertEqual(4, len(fields))

Example 12

Project: autonomie Source File: 3_2_2_add_bank_code_journal_25a21d2410b7.py
def upgrade():
    op.add_column(
        'bank_account',
        sa.Column('code_journal', sa.String(120), nullable=False)
    )
    req = "select config_value from config where config_name='receipts_code_journal';"
    from alembic.context import get_bind
    from autonomie.models.base import DBSESSION
    conn = get_bind()
    res = conn.execute(req).scalar()
    if res is not None:
        req = "update bank_account set code_journal='%s'" % res
        conn.execute(req)
        session = DBSESSION()
        from zope.sqlalchemy import mark_changed
        mark_changed(session)

Example 13

Project: lrrbot Source File: 6387fbb406f3_create_card_collector_number_table.py
Function: upgrade
def upgrade():
	alembic.op.create_table(
		"card_collector",
		sqlalchemy.Column("setid", sqlalchemy.String(10), nullable=False),
		sqlalchemy.Column("collector", sqlalchemy.String(10), nullable=False),
		sqlalchemy.Column("cardid", sqlalchemy.Integer, sqlalchemy.ForeignKey("cards.id", ondelete="CASCADE"), nullable=False),
	)
	alembic.op.create_primary_key(None, "card_collector", ["setid", "collector"])

Example 14

Project: synnefo Source File: public.py
def create_tables(engine):
    metadata = MetaData()
    columns = []
    columns.append(Column('public_id', Integer, primary_key=True))
    columns.append(Column('path', String(2048), nullable=False))
    columns.append(Column('active', Boolean, nullable=False, default=True))
    columns.append(Column('url', String(2048), nullable=True))
    public = Table('public', metadata, *columns, mysql_engine='InnoDB',
                   sqlite_autoincrement=True)
    # place an index on path
    Index('idx_public_path', public.c.path, unique=True)
    # place an index on url
    Index('idx_public_url', public.c.url, unique=True)
    metadata.create_all(engine)
    return metadata.sorted_tables

Example 15

Project: faf Source File: 31d0249e8d4c_create_users_table.py
def upgrade():
    op.create_table(
        'users',
        sa.Column('username', sa.String(length=100), nullable=False),
        sa.Column('mail', sa.String(length=150), nullable=False),
        sa.Column('admin', sa.Boolean(), default=False),
        sa.PrimaryKeyConstraint('username'),
    )

Example 16

Project: sqlalchemy-utils Source File: range.py
Function: load_dialect_impl
    def load_dialect_impl(self, dialect):
        if dialect.name == 'postgresql':
            # Use the native range type for postgres.
            return dialect.type_descriptor(self.impl)
        else:
            # Other drivers don't have native types.
            return dialect.type_descriptor(sa.String(255))

Example 17

Project: bauble.classic Source File: gen_model_doc.py
Function: column_type_str
def column_type_str(col):
    print type(col)
    if isinstance(col, sa.String):
        return 'string'
    elif isinstance(col, sa.Unicode):
        return 'unicode'
    elif isinstance(col, sa.Integer):
        return 'integer'
    elif isinstance(col, sa.ForeignKey):
        return 'foreign key(int)'

Example 18

Project: incubator-airflow Source File: f2ca10b85618_add_dag_stats_table.py
Function: upgrade
def upgrade():
    op.create_table('dag_stats',
                    sa.Column('dag_id', sa.String(length=250), nullable=False),
                    sa.Column('state', sa.String(length=50), nullable=False),
                    sa.Column('count', sa.Integer(), nullable=False, default=0),
                    sa.Column('dirty', sa.Boolean(), nullable=False, default=False),
                    sa.PrimaryKeyConstraint('dag_id', 'state'))

Example 19

Project: ibis Source File: test_functions.py
def test_compile_with_one_unnamed_table():
    t = ibis.table([('a', 'string')])
    s = ibis.table([('b', 'string')], name='s')
    join = t.join(s, t.a == s.b)
    result = ibis.sqlite.compile(join)
    sqla_t = sa.table('t0', sa.column('a', sa.String)).alias('t0')
    sqla_s = sa.table('s', sa.column('b', sa.String)).alias('t1')
    sqla_join = sqla_t.join(sqla_s, sqla_t.c.a == sqla_s.c.b)
    expected = sa.select([sqla_t.c.a, sqla_s.c.b]).select_from(sqla_join)
    assert str(result) == str(expected)

Example 20

Project: crate-python Source File: dict_test.py
    def set_up_character_and_cursor_data_list(self, return_value=None):
        return_value = return_value or [('Trillian', {})]
        fake_cursor.fetchall.return_value = return_value
        fake_cursor.description = (
            ('characters_name', None, None, None, None, None, None),
            ('characters_data_list', None, None, None, None, None, None)

        )
        fake_cursor.rowcount = 1
        Base = declarative_base(bind=self.engine)

        class Character(Base):
            __tablename__ = 'characters'
            name = sa.Column(sa.String, primary_key=True)
            data_list = sa.Column(ObjectArray)

        session = Session()
        return session, Character

Example 21

Project: rootio_web Source File: 15d91338011f_call_change.py
Function: upgrade
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column(u'telephony_call', sa.Column('from_phonenumber', sa.String(length=20), nullable=True))
    op.add_column(u'telephony_call', sa.Column('to_phonenumber', sa.String(length=20), nullable=True))
    op.drop_column(u'telephony_call', u'from_phonenumber_id')
    op.drop_column(u'telephony_call', u'to_phonenumber_id')

Example 22

Project: security_monkey Source File: 538eeb160af6_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    ### end Alembic commands ###

    bind = op.get_bind()
    session = Session(bind=bind)
    op.add_column('user', sa.Column('role', sa.String(length=30), nullable=True))
    for user in session.query(User):
        if user.active:
            user.role = 'View'

    session.commit()

Example 23

Project: gourmet Source File: data_plugin.py
    def setup_nutritionconversions_table (self):
        self.db.nutritionconversions_table = Table('nutritionconversions',self.db.metadata,
                                                Column('id',Integer(),primary_key=True),
                                                Column('ingkey',String(length=255),**{}),
                                                Column('unit',String(length=255),**{}), 
                                                Column('factor',Float(),**{}), # Factor is the amount we multiply
                                                # from unit to get 100 grams
                                                ) # NUTRITION_CONVERSIONS
        class NutritionConversion (object): pass
        self.db._setup_object_for_table(self.db.nutritionconversions_table, NutritionConversion)

Example 24

Project: sentry-old Source File: models.py
def create_sqlalchemy_metadata_def(metadata, model):
    columns = [
        Column('id', String(32), primary_key=True),
        Column('key', String(255), primary_key=True),
        Column('value', Text(nullable=True), primary_key=True),
    ]

    table = Table('%s_metadata' % (model.__name__.lower(),), metadata, *columns)
    
    return table

Example 25

Project: changes Source File: 4ab789ea6b6f_delete_hipchat_projectoptions.py
def upgrade():
    # hipchat options and events aren't needed or used anymore, so we remove them.
    # THIS CANNOT BE UNDONE.
    projectoptions_table = table(
        'projectoption',
        sa.Column('name', sa.String(length=64), nullable=False),
    )
    event_table = table(
        'event',
        sa.Column('type', sa.String(length=32), nullable=False),
    )
    op.get_bind().execute(
        projectoptions_table.delete().where(
            projectoptions_table.c.name.in_(['hipchat.room', 'hipchat.notify', 'hipchat.token'])))
    op.get_bind().execute(
        event_table.delete().where(event_table.c.type == 'hipchat'))

Example 26

Project: cslbot Source File: 3614b38ddf9_kick_logging_change.py
def downgrade():
    # FIXME: this adds extraneous commas
    return
    log = sa.table('log', sa.column('type', sa.String), sa.column('msg', sa.String))
    rows = op.get_bind().execute(log.select().where(log.c.type == 'kick')).fetchall()
    rows = [x for x in rows if ',' not in x.msg or x.msg.find(' ') < x.msg.find(',')]
    if not rows:
        return
    values = [{'old_msg': x.msg, 'msg': x.msg.replace(' ', ',', 1)} for x in rows]
    op.get_bind().execute(log.update().where(log.c.msg == sa.bindparam('old_msg')).values(msg=sa.bindparam('msg')), values)

Example 27

Project: WatchPeopleCode Source File: 8b477c4e904_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('submission',
    sa.Column('submission_id', sa.String(length=6), nullable=False),
    sa.PrimaryKeyConstraint('submission_id')
    )
    op.create_table('stream_sub',
    sa.Column('stream_id', sa.Integer(), nullable=True),
    sa.Column('submission_id', sa.String(length=6), nullable=True),
    sa.ForeignKeyConstraint(['stream_id'], ['stream.id'], ),
    sa.ForeignKeyConstraint(['submission_id'], ['submission.submission_id'], )
    )

Example 28

Project: ggrc-core Source File: 20130923130503_3148b80be376_role_scopes_for_ui_h.py
Function: upgrade
def upgrade():
  op.add_column('roles', sa.Column('scope', sa.String(64)))
  op.execute(roles_table.update()\
      .where(roles_table.c.name.in_(
        ['ProgramOwner', 'ProgramEditor', 'ProgramReader',]))\
      .values(scope='Private Program'))
  op.execute(roles_table.update()\
      .where(roles_table.c.name.in_(
        ['Reader', 'ObjectEditor', 'ProgramCreator',]))\
      .values(scope='System'))

Example 29

Project: ircb Source File: 140c0dd3605_added_fields_for_local_remote_sockets_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('networks', sa.Column('lhost', sa.String(length=100), nullable=True))
    op.add_column('networks', sa.Column('lport', sa.Integer(), nullable=True))
    op.add_column('networks', sa.Column('rhost', sa.String(length=100), nullable=True))
    op.add_column('networks', sa.Column('rport', sa.Integer(), nullable=True))

Example 30

Project: hasjob Source File: 4f639a4a5fc3_apphash.py
Function: upgrade
def upgrade():
    op.add_column('job_application', sa.Column('hashid', sa.String(length=40), nullable=False))
    op.create_unique_constraint('uq_job_application_hashid', 'job_application', ['hashid'])
    op.alter_column('job_application', 'message',
               existing_type=sa.TEXT(),
               nullable=False)

Example 31

Project: SickRage Source File: test_reflection.py
    @classmethod
    def define_tables(cls, metadata):
        Table('test_table', metadata,
                Column('id', Integer, primary_key=True),
                Column('data', String(50))
            )

Example 32

Project: census Source File: utils.py
def _create_base_table(name):
    metadata = MetaData()
    sql_table = Table(name, metadata)
    for name,length in LINKING_COLUMNS:
        sql_table.append_column(Column(name, String(length=length), nullable=False))

    return sql_table

Example 33

Project: odo Source File: test_sql.py
Function: test_discover
def test_discover():
    assert discover(sa.String()) == datashape.string
    metadata = sa.MetaData()
    s = sa.Table('accounts', metadata,
                 sa.Column('name', sa.String),
                 sa.Column('amount', sa.Integer),
                 sa.Column('timestamp', sa.DateTime, primary_key=True))
    ds = dshape('var * {name: ?string, amount: ?int32, timestamp: datetime}')
    assert_dshape_equal(discover(s), ds)
    for name in ds.measure.names:
        assert isinstance(name, string_types)

Example 34

Project: braindump Source File: b237b9f6a2ce_update_user_model_remove_username_add_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('users', sa.Column('first_name', sa.String(length=200), nullable=True))
    op.add_column('users', sa.Column('last_name', sa.String(length=200), nullable=True))
    op.drop_index('ix_users_username', table_name='users')
    op.drop_column('users', 'username')

Example 35

Project: pagure Source File: 368fd931cf7f_add_the_notifications_column_to_projects.py
def upgrade():
    ''' Add the column notifications to the table projects.
    '''
    op.add_column(
        'projects',
        sa.Column('_notifications', sa.String(255), nullable=True)
    )

Example 36

Project: waymarked-trails-site Source File: routes.py
    def columns(self):
        return (Column('class', Integer),
                Column('network', String(length=2)),
                Column('style', Integer),
                Column('inrshields', ARRAY(String)),
                Column('allshields', ARRAY(String)),
                Column('rels', ARRAY(BigInteger))
               )

Example 37

Project: ckanext-googleanalytics Source File: dbutil.py
def init_tables():
    metadata = MetaData()
    package_stats = Table('package_stats', metadata,
                          Column('package_id', String(60),
                                 primary_key=True),
                          Column('visits_recently', Integer),
                          Column('visits_ever', Integer))
    resource_stats = Table('resource_stats', metadata,
                           Column('resource_id', String(60),
                                  primary_key=True),
                           Column('visits_recently', Integer),
                           Column('visits_ever', Integer))
    metadata.create_all(model.meta.engine)

Example 38

Project: sign-language-tutor Source File: db.py
def get_engine_and_table():
    engine = create_engine('sqlite:///asl_data.db', echo=True)

    metadata = MetaData()
    columns = [Column('feat' + str(i), Numeric) for i in range(NUM_FEATURES)]
    columns.append(Column('sign', String(length=1)))
    tagged_data = Table('tagged_data', metadata, *columns)
    
    metadata.create_all(engine)

    return engine, tagged_data

Example 39

Project: awesomestream Source File: backends.py
    def setup_table(self):
        from sqlalchemy import MetaData, Table, Column, String, Text, DateTime
        index_columns = []
        for k in self.keys:
            index_columns.append(Column(k, Text, index=True))
        self.metadata = MetaData()
        self.metadata.bind = self.engine
        self.table = Table(self.table_name, self.metadata,
            Column('key', String(length=36), primary_key=True),
            Column('data', Text, nullable=False),
            Column('date', DateTime, default=datetime.datetime.now, index=True,
                nullable=False),
            *index_columns
        )
        self.table.create(bind=self.engine, checkfirst=True)

Example 40

Project: Flask-FeatureFlags Source File: __init__.py
  def _make_model(self, db):

    class FeatureFlag(db.Model):
      id = Column(Integer, primary_key=True)
      feature = Column(String(255), nullable=False, unique=True)
      is_active = Column(Boolean, default=False)

      @classmethod
      def check(cls, feature):
        r = cls.query.filter_by(feature=feature).one()
        return r.is_active

    return FeatureFlag

Example 41

Project: anitya Source File: 2925648d8cc3_add_a_version_prefix_field.py
def upgrade():
    ''' Add the `version_prefix` column on the projects table. '''
    op.add_column(
        'projects',
        sa.Column(
            'version_prefix',
            sa.String(200),
            nullable=True)
    )

Example 42

Project: tokenserver Source File: 2b968b28bcdc_remove_node_column.py
def downgrade():
    # Re-create the column, making it nullable so that it
    # can be safely inserted in the presence of existing data.
    # The previous migration knows how to make it non-nullable.
    op.add_column(
        'users',
        sa.Column('node', sa.String(64), nullable=True)
    )

Example 43

Project: pyload Source File: sqla.py
Function: make_cache_table
def make_cache_table(metadata, table_name='beaker_cache'):
    """Return a ``Table`` object suitable for storing cached values for the
    namespace manager.  Do not create the table."""
    return sa.Table(table_name, metadata,
                    sa.Column('namespace', sa.String(255), primary_key=True),
                    sa.Column('accessed', sa.DateTime, nullable=False),
                    sa.Column('created', sa.DateTime, nullable=False),
                    sa.Column('data', sa.PickleType, nullable=False))

Example 44

Project: koschei Source File: 525ad809cccb_add_table_for_admin_notices.py
Function: upgrade
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('admin_notice',
    sa.Column('key', sa.String(), nullable=False),
    sa.Column('content', sa.String(), nullable=False),
    sa.PrimaryKeyConstraint('key')
    )

Example 45

Project: kairos Source File: sql_backend.py
  def __init__(self, *a, **kwargs):
    # TODO: define indices
    # TODO: optionally create separate tables for each interval, like mongo?
    self._table_name = 'gauge'
    super(SqlGauge,self).__init__(*a, **kwargs)
    self._table = Table(self._table_name, self._metadata,
      Column('name', String(self._str_length), nullable=False),      # stat name
      Column('interval', String(self._str_length), nullable=False),  # interval name
      Column('i_time', Integer, nullable=False),        # interval timestamp
      Column('r_time', Integer, nullable=True),         # resolution timestamp
      Column('value', self._value_type, nullable=False),           # key counts

      # Use a constraint for transaction-less insert vs update
      UniqueConstraint('name', 'interval', 'i_time', 'r_time', name='unique_count')
    )
    self._metadata.create_all(self._client)

Example 46

Project: pygotham Source File: 5d619660cfa7_switch_navbar_section_to_navbar_path.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column(
        'about_pages',
        sa.Column(
            'navbar_path',
            postgresql.ARRAY(sa.String()),
            nullable=False,
            server_default='{}',
        ),
    )
    op.create_unique_constraint('ix_about_pages_navbar_path_slug_event_id', 'about_pages', ['navbar_path', 'slug', 'event_id'])
    op.execute(
        'UPDATE about_pages '
        'SET navbar_path=ARRAY[navbar_section, title]'
    )
    op.drop_constraint('ix_about_pages_navbar_section_slug_event_id', 'about_pages', type_='unique')
    op.drop_column('about_pages', 'navbar_section')

Example 47

Project: pagure Source File: 36386a60b3fd_add_milestone_to_issues.py
Function: upgrade
def upgrade():
    ''' Add the column milestone to the table issues.
    '''
    op.add_column(
        'issues',
        sa.Column('milestone', sa.String(255), nullable=True)
    )

Example 48

Project: fedocal Source File: 4f509700da52_add_status_field_for.py
Function: upgrade
def upgrade():
    op.create_table(
        'calendar_status',
        sa.Column('status', sa.String(50), primary_key=True),
    )

    for str_status in ['Enabled', 'Disabled']:
        ins = "INSERT INTO calendar_status (status) VALUES ('%s');" % (
            str_status)
        op.execute(ins)

Example 49

Project: viaduct Source File: 4d1a5fb71db_add_address_fields_to_user.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('user', sa.Column('address', sa.String(length=256), nullable=True))
    op.add_column('user', sa.Column('city', sa.String(length=256), nullable=True))
    op.add_column('user', sa.Column('country', sa.String(length=256), nullable=True))
    op.add_column('user', sa.Column('zip', sa.String(length=8), nullable=True))

Example 50

Project: open-event-orga-server Source File: 4891e2b124f8_.py
Function: upgrade
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('events', sa.Column('bank_details', sa.String(), nullable=True))
    op.add_column('events', sa.Column('cheque_details', sa.String(), nullable=True))
    op.add_column('events', sa.Column('onsite_details', sa.String(), nullable=True))
    op.add_column('events_version', sa.Column('bank_details', sa.String(), autoincrement=False, nullable=True))
    op.add_column('events_version', sa.Column('cheque_details', sa.String(), autoincrement=False, nullable=True))
    op.add_column('events_version', sa.Column('onsite_details', sa.String(), autoincrement=False, nullable=True))
See More Examples - Go to Next Page
Page 1 Selected Page 2 Page 3 Page 4