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
5
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"))
5
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()
5
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)
5
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))
5
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()
4
Example 6
@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)
)
3
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')
3
Example 8
@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)
)
3
Example 9
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')
)
3
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)
)
3
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))
3
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)
3
Example 13
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"])
3
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
3
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'),
)
3
Example 16
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))
3
Example 17
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)'
3
Example 18
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'))
3
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)
3
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
3
Example 21
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')
3
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()
3
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)
3
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
3
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'))
3
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)
3
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'], )
)
3
Example 28
Project: ggrc-core Source File: 20130923130503_3148b80be376_role_scopes_for_ui_h.py
Function: upgrade
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'))
3
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))
3
Example 30
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)
3
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))
)
3
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
3
Example 33
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)
3
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')
3
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)
)
3
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))
)
3
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)
3
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
3
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)
3
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
3
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)
)
3
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)
)
3
Example 43
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))
3
Example 44
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')
)
3
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)
3
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')
3
Example 47
def upgrade():
''' Add the column milestone to the table issues.
'''
op.add_column(
'issues',
sa.Column('milestone', sa.String(255), nullable=True)
)
3
Example 48
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)
3
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))
3
Example 50
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))