Here are the examples of the python api sqlalchemy.CHAR taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
19 Examples
3
Source : sqlalchemy_uuid.py
with MIT License
from collerek
with MIT License
from collerek
def load_dialect_impl(self, dialect: Dialect) -> Any:
return (
dialect.type_descriptor(CHAR(36))
if self.uuid_format == "string"
else dialect.type_descriptor(CHAR(32))
)
def process_bind_param(self, value: uuid.UUID, dialect: Dialect) -> Optional[str]:
3
Source : test_types.py
with Apache License 2.0
from gethue
with Apache License 2.0
from gethue
def test_char_length(self):
self.assert_compile(VARCHAR(50), "VARCHAR(50 CHAR)")
oracle8dialect = oracle.dialect()
oracle8dialect.server_version_info = (8, 0)
self.assert_compile(VARCHAR(50), "VARCHAR(50)", dialect=oracle8dialect)
self.assert_compile(NVARCHAR(50), "NVARCHAR2(50)")
self.assert_compile(CHAR(50), "CHAR(50)")
@testing.combinations(
3
Source : test_types.py
with Apache License 2.0
from gethue
with Apache License 2.0
from gethue
def test_char_length(self):
metadata = self.metadata
t1 = Table(
"t1",
metadata,
Column("c1", VARCHAR(50)),
Column("c2", NVARCHAR(250)),
Column("c3", CHAR(200)),
Column("c4", NCHAR(180)),
)
t1.create()
m2 = MetaData(testing.db)
t2 = Table("t1", m2, autoload=True)
eq_(t2.c.c1.type.length, 50)
eq_(t2.c.c2.type.length, 250)
eq_(t2.c.c3.type.length, 200)
eq_(t2.c.c4.type.length, 180)
@testing.provide_metadata
3
Source : test_resultset.py
with Apache License 2.0
from gethue
with Apache License 2.0
from gethue
def define_tables(cls, metadata):
Table(
"text1",
metadata,
Column("a", CHAR(2)),
Column("b", CHAR(2)),
Column("c", CHAR(2)),
Column("d", CHAR(2)),
)
@classmethod
3
Source : test_types.py
with Apache License 2.0
from gethue
with Apache License 2.0
from gethue
def test_decorator_doesnt_cache(self):
from sqlalchemy.dialects import postgresql
class MyType(TypeDecorator):
impl = CHAR
def load_dialect_impl(self, dialect):
if dialect.name == "postgresql":
return dialect.type_descriptor(postgresql.UUID())
else:
return dialect.type_descriptor(CHAR(32))
t1 = MyType()
d = postgresql.dialect()
assert t1._type_affinity is String
assert t1.dialect_impl(d)._type_affinity is postgresql.UUID
class PickleTypesTest(fixtures.TestBase):
3
Source : test_types.py
with Apache License 2.0
from gethue
with Apache License 2.0
from gethue
def test_char_collation(self):
self.assert_compile(
CHAR(50, collation="FOO"), 'CHAR(50) COLLATE "FOO"'
)
def test_text_plain(self):
3
Source : 20210316_ee190d0fbe21_remove_apikey_from_providers.py
with Mozilla Public License 2.0
from pass-culture
with Mozilla Public License 2.0
from pass-culture
def downgrade():
# ### commands auto generated by Alembic ###
op.add_column("provider", sa.Column("apiKey", sa.CHAR(length=32), autoincrement=False, nullable=True))
op.add_column(
"provider", sa.Column("apiKeyGenerationDate", postgresql.TIMESTAMP(), autoincrement=False, nullable=True)
)
# ### end Alembic commands ###
op.create_check_constraint(
"check_provider_has_localclass_or_apikey",
"provider",
'("localClass" IS NOT NULL AND "apiKey" IS NULL) OR ("localClass" IS NULL AND "apiKey" IS NOT NULL)',
)
3
Source : test_autogen_render.py
with MIT License
from sqlalchemy
with MIT License
from sqlalchemy
def test_render_modify_type(self):
op_obj = ops.AlterColumnOp(
"sometable",
"somecolumn",
modify_type=CHAR(10),
existing_type=CHAR(20),
)
eq_ignore_whitespace(
autogenerate.render_op_text(self.autogen_context, op_obj),
"op.alter_column('sometable', 'somecolumn', "
"existing_type=sa.CHAR(length=20), type_=sa.CHAR(length=10))",
)
def test_render_modify_type_w_schema(self):
3
Source : test_autogen_render.py
with MIT License
from sqlalchemy
with MIT License
from sqlalchemy
def test_render_modify_type_w_schema(self):
op_obj = ops.AlterColumnOp(
"sometable",
"somecolumn",
modify_type=CHAR(10),
existing_type=CHAR(20),
schema="foo",
)
eq_ignore_whitespace(
autogenerate.render_op_text(self.autogen_context, op_obj),
"op.alter_column('sometable', 'somecolumn', "
"existing_type=sa.CHAR(length=20), type_=sa.CHAR(length=10), "
"schema='foo')",
)
def test_render_modify_nullable(self):
3
Source : test_types.py
with MIT License
from sqlalchemy
with MIT License
from sqlalchemy
def test_char_length(self, metadata, connection):
t1 = Table(
"t1",
metadata,
Column("c1", VARCHAR(50)),
Column("c2", NVARCHAR(250)),
Column("c3", CHAR(200)),
Column("c4", NCHAR(180)),
)
t1.create(connection)
m2 = MetaData()
t2 = Table("t1", m2, autoload_with=connection)
eq_(t2.c.c1.type.length, 50)
eq_(t2.c.c2.type.length, 250)
eq_(t2.c.c3.type.length, 200)
eq_(t2.c.c4.type.length, 180)
def test_long_type(self, metadata, connection):
0
Source : core.py
with Apache License 2.0
from alttch
with Apache License 2.0
from alttch
def init_db():
from sqlalchemy import (Table, Column, BigInteger, Integer, Numeric, CHAR,
VARCHAR, MetaData, Float, ForeignKey, Index, JSON,
Enum, DateTime, Interval, Boolean, LargeBinary)
import enum
class LevelMatch(enum.Enum):
l = 'l'
g = 'g'
le = 'le'
ge = 'ge'
e = 'e'
if 'mysql' in _d.db.name:
from sqlalchemy.dialects.mysql import DATETIME, LONGBLOB
DateTime = partial(DATETIME, fsp=6)
LargeBinary = LONGBLOB
meta = MetaData()
addr = Table('addr',
meta,
Column('id',
BigInteger().with_variant(Integer, 'sqlite'),
primary_key=True,
autoincrement=True),
Column('a', CHAR(64), nullable=False, unique=True),
Index('addr_a', 'a'),
Column('active',
Numeric(1, 0),
nullable=False,
server_default='1'),
Column('lim_c',
Numeric(8, 0),
nullable=False,
server_default='100'),
Column('lim_s',
Numeric(12, 0),
nullable=False,
server_default='10000000'),
mysql_engine='InnoDB',
mysql_charset='latin1')
endpoint = Table('endpoint',
meta,
Column('id',
BigInteger().with_variant(Integer, 'sqlite'),
primary_key=True,
autoincrement=True),
Column('addr_id',
BigInteger().with_variant(Integer, 'sqlite'),
ForeignKey('addr.id', ondelete='CASCADE')),
Index('endpoint_addr_id', 'addr_id'),
Column('plugin_name', VARCHAR(40), nullable=False),
Column('config', JSON, nullable=False),
Column('active',
Numeric(1, 0),
nullable=False,
server_default='1'),
Column('description', VARCHAR(255), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8mb4')
subscription = Table('subscription',
meta,
Column('id',
BigInteger().with_variant(Integer, 'sqlite'),
primary_key=True,
autoincrement=True),
Column('endpoint_id',
BigInteger().with_variant(Integer, 'sqlite'),
ForeignKey('endpoint.id', ondelete='CASCADE')),
Index('subscription_endpoint_id', 'endpoint_id'),
Column('active',
Numeric(1, 0),
nullable=False,
server_default='1'),
Column('location', VARCHAR(255), nullable=True),
Column('tag', VARCHAR(255), nullable=True),
Column('sender', VARCHAR(255), nullable=True),
Column('level',
Numeric(2, 0),
nullable=False,
server_default='20'),
Column('level_match',
Enum(LevelMatch),
nullable=False,
server_default='ge'),
mysql_engine='InnoDB',
mysql_charset='utf8mb4')
bucket = Table('bucket',
meta,
Column('id', CHAR(64), nullable=False, primary_key=True),
Column('creator', VARCHAR(64), nullable=False),
Column('addr_id',
BigInteger().with_variant(Integer, 'sqlite'),
ForeignKey('addr.id', ondelete='CASCADE')),
Column('mimetype', VARCHAR(256), nullable=False),
Column('fname', VARCHAR(256), nullable=True),
Column('size',
BigInteger().with_variant(Integer, 'sqlite'),
nullable=False),
Column('public', Boolean, nullable=False,
server_default='0'),
Column('metadata', JSON, nullable=True),
Column('d', DateTime(timezone=True), nullable=False),
Column('da', DateTime(timezone=True), nullable=True),
Column('expires',
Integer if _d.db.name in ('sqlite',
'mysql') else Interval,
nullable=True),
Column('content', LargeBinary, nullable=False),
mysql_engine='InnoDB',
mysql_charset='utf8mb4')
meta.create_all(_d.db.connect())
def get_db():
0
Source : test_magazine.py
with Apache License 2.0
from gethue
with Apache License 2.0
from gethue
def define_tables(cls, metadata):
Table(
"publication",
metadata,
Column(
"id", Integer, primary_key=True, test_needs_autoincrement=True
),
Column("name", String(45), default=""),
)
Table(
"issue",
metadata,
Column(
"id", Integer, primary_key=True, test_needs_autoincrement=True
),
Column("publication_id", Integer, ForeignKey("publication.id")),
Column("issue", Integer),
)
Table(
"location",
metadata,
Column(
"id", Integer, primary_key=True, test_needs_autoincrement=True
),
Column("issue_id", Integer, ForeignKey("issue.id")),
Column("ref", CHAR(3), default=""),
Column(
"location_name_id", Integer, ForeignKey("location_name.id")
),
)
Table(
"location_name",
metadata,
Column(
"id", Integer, primary_key=True, test_needs_autoincrement=True
),
Column("name", String(45), default=""),
)
Table(
"magazine",
metadata,
Column(
"id", Integer, primary_key=True, test_needs_autoincrement=True
),
Column("location_id", Integer, ForeignKey("location.id")),
Column("page_size_id", Integer, ForeignKey("page_size.id")),
)
Table(
"page",
metadata,
Column(
"id", Integer, primary_key=True, test_needs_autoincrement=True
),
Column("page_no", Integer),
Column("type", CHAR(1), default="p"),
)
Table(
"magazine_page",
metadata,
Column(
"page_id", Integer, ForeignKey("page.id"), primary_key=True
),
Column("magazine_id", Integer, ForeignKey("magazine.id")),
Column("orders", Text, default=""),
)
Table(
"classified_page",
metadata,
Column(
"magazine_page_id",
Integer,
ForeignKey("magazine_page.page_id"),
primary_key=True,
),
Column("titles", String(45), default=""),
)
Table(
"page_size",
metadata,
Column(
"id", Integer, primary_key=True, test_needs_autoincrement=True
),
Column("width", Integer),
Column("height", Integer),
Column("name", String(45), default=""),
)
def _generate_data(self):
0
Source : test_resultset.py
with Apache License 2.0
from gethue
with Apache License 2.0
from gethue
def define_tables(cls, metadata):
Table(
"keyed1",
metadata,
Column("a", CHAR(2), key="b"),
Column("c", CHAR(2), key="q"),
)
Table("keyed2", metadata, Column("a", CHAR(2)), Column("b", CHAR(2)))
Table("keyed3", metadata, Column("a", CHAR(2)), Column("d", CHAR(2)))
Table("keyed4", metadata, Column("b", CHAR(2)), Column("q", CHAR(2)))
Table("content", metadata, Column("t", String(30), key="type"))
Table("bar", metadata, Column("ctype", String(30), key="content_type"))
if testing.requires.schemas.enabled:
Table(
"wschema",
metadata,
Column("a", CHAR(2), key="b"),
Column("c", CHAR(2), key="q"),
schema=testing.config.test_schema,
)
@classmethod
0
Source : test_types.py
with Apache License 2.0
from gethue
with Apache License 2.0
from gethue
def test_char_plain(self):
self.assert_compile(CHAR(), "CHAR")
def test_char_length(self):
0
Source : test_types.py
with Apache License 2.0
from gethue
with Apache License 2.0
from gethue
def test_char_length(self):
self.assert_compile(CHAR(50), "CHAR(50)")
def test_char_collation(self):
0
Source : test_autogen_diffs.py
with MIT License
from sqlalchemy
with MIT License
from sqlalchemy
def test_affinity_typedec(self):
class MyType(TypeDecorator):
impl = CHAR
def load_dialect_impl(self, dialect):
if dialect.name == "sqlite":
return dialect.type_descriptor(Integer())
else:
return dialect.type_descriptor(CHAR(32))
uo = ops.AlterColumnOp("sometable", "somecol")
autogenerate.compare._compare_type(
self.autogen_context,
uo,
None,
"sometable",
"somecol",
Column("somecol", Integer, nullable=True),
Column("somecol", MyType()),
)
assert not uo.has_changes()
def test_dont_barf_on_already_reflected(self):
0
Source : test_autogen_render.py
with MIT License
from sqlalchemy
with MIT License
from sqlalchemy
def test_render_variant(self):
from sqlalchemy import VARCHAR, CHAR
self.autogen_context.opts["user_module_prefix"] = None
type_ = (
String(5)
.with_variant(VARCHAR(10), "mysql")
.with_variant(CHAR(15), "oracle")
)
# the new Black formatting will help a lot with this
eq_ignore_whitespace(
autogenerate.render._repr_type(type_, self.autogen_context),
"sa.String(length=5)."
"with_variant(sa.VARCHAR(length=10), 'mysql')."
"with_variant(sa.CHAR(length=15), 'oracle')",
)
def test_repr_user_type_user_prefix_None(self):
0
Source : test_resultset.py
with MIT License
from sqlalchemy
with MIT License
from sqlalchemy
def define_tables(cls, metadata):
Table(
"keyed1",
metadata,
Column("a", CHAR(2), key="b"),
Column("c", CHAR(2), key="q"),
)
Table("keyed2", metadata, Column("a", CHAR(2)), Column("b", CHAR(2)))
Table("keyed3", metadata, Column("a", CHAR(2)), Column("d", CHAR(2)))
Table("keyed4", metadata, Column("b", CHAR(2)), Column("q", CHAR(2)))
Table("content", metadata, Column("t", String(30), key="type"))
Table("bar", metadata, Column("ctype", String(30), key="content_type"))
if testing.requires.schemas.enabled:
Table(
"wschema",
metadata,
Column("a", CHAR(2), key="b"),
Column("c", CHAR(2), key="q"),
schema=testing.config.test_schema,
)
Table(
"users",
metadata,
Column("id", Integer, primary_key=True),
Column("team_id", metadata, ForeignKey("teams.id")),
)
Table(
"teams",
metadata,
Column("id", Integer, primary_key=True),
)
@classmethod
0
Source : test_types.py
with MIT License
from sqlalchemy
with MIT License
from sqlalchemy
def test_decorator_doesnt_cache(self):
from sqlalchemy.dialects import postgresql
class MyType(TypeDecorator):
impl = CHAR
cache_ok = True
def load_dialect_impl(self, dialect):
if dialect.name == "postgresql":
return dialect.type_descriptor(postgresql.UUID())
else:
return dialect.type_descriptor(CHAR(32))
t1 = MyType()
d = postgresql.dialect()
assert t1._type_affinity is String
assert t1.dialect_impl(d)._type_affinity is postgresql.UUID
class AsGenericTest(fixtures.TestBase):