Python sqlalchemy.types.INTEGER Examples
The following are 30
code examples of sqlalchemy.types.INTEGER().
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example.
You may also want to check out all available functions/classes of the module
sqlalchemy.types
, or try the search function
.
Example #1
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_no_inflect(metadata): Table("simple_items", metadata, Column("id", INTEGER, primary_key=True)) assert ( generate_code(metadata, noinflect=True) == """\ # coding: utf-8 from sqlalchemy import Column, Integer from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class SimpleItems(Base): __tablename__ = 'simple_items' id = Column(Integer, primary_key=True) """ )
Example #2
Source File: test_sqlite.py From sqlalchemy with MIT License | 6 votes |
def test_default_reflection_2(self): db = testing.db m = MetaData(db) expected = ["'my_default'", "0"] table = """CREATE TABLE r_defaults ( data VARCHAR(40) DEFAULT 'my_default', val INTEGER NOT NULL DEFAULT 0 )""" try: exec_sql(db, table) rt = Table("r_defaults", m, autoload=True) for i, reflected in enumerate(rt.c): eq_(str(reflected.server_default.arg), expected[i]) finally: exec_sql(db, "DROP TABLE r_defaults")
Example #3
Source File: test_sqlite.py From sqlalchemy with MIT License | 6 votes |
def test_default_reflection_3(self): db = testing.db table = """CREATE TABLE r_defaults ( data VARCHAR(40) DEFAULT 'my_default', val INTEGER NOT NULL DEFAULT 0 )""" try: exec_sql(db, table) m1 = MetaData(db) t1 = Table("r_defaults", m1, autoload=True) exec_sql(db, "DROP TABLE r_defaults") t1.create() m2 = MetaData(db) t2 = Table("r_defaults", m2, autoload=True) self.assert_compile( CreateTable(t2), "CREATE TABLE r_defaults (data VARCHAR(40) " "DEFAULT 'my_default', val INTEGER DEFAULT 0 " "NOT NULL)", ) finally: exec_sql(db, "DROP TABLE r_defaults")
Example #4
Source File: __init__.py From parade with MIT License | 6 votes |
def str_to_sqltype(expr): import re import sqlalchemy.types as sqltypes norm_expr = expr.lower() if norm_expr.startswith('integer'): match_result = re.match(r'integer\((\d+)\)', norm_expr) if match_result is not None: return sqltypes.BIGINT() if int(match_result.group(1)) > 11 else sqltypes.INTEGER() return sqltypes.BIGINT() if norm_expr == 'decimal': return sqltypes.DECIMAL() if norm_expr == 'date': return sqltypes.DATETIME() if norm_expr == 'bool' or norm_expr == 'boolean': return sqltypes.BOOLEAN() if norm_expr.startswith('string'): match_result = re.match(r'string\((\d+)\)', norm_expr) if match_result is not None: maxlen = int(match_result.group(1)) return sqltypes.VARCHAR(maxlen) if maxlen < 65536 else sqltypes.TEXT return sqltypes.TEXT() raise RuntimeError("Unsupported data type [" + expr + "]")
Example #5
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_metadata_column(metadata): Table("simple", metadata, Column("id", INTEGER, primary_key=True), Column("metadata", VARCHAR)) assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Column, Integer, String from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class Simple(Base): __tablename__ = 'simple' id = Column(Integer, primary_key=True) metadata_ = Column('metadata', String) """ )
Example #6
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_pascal_multiple_underscore(metadata): Table("customer_API__Preference", metadata, Column("id", INTEGER, primary_key=True)) assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Column, Integer from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class CustomerAPIPreference(Base): __tablename__ = 'customer_API__Preference' id = Column(Integer, primary_key=True) """ )
Example #7
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_pascal_underscore(metadata): Table("customer_API_Preference", metadata, Column("id", INTEGER, primary_key=True)) assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Column, Integer from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class CustomerAPIPreference(Base): __tablename__ = 'customer_API_Preference' id = Column(Integer, primary_key=True) """ )
Example #8
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_underscore(metadata): Table("customer_api_preference", metadata, Column("id", INTEGER, primary_key=True)) assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Column, Integer from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class CustomerApiPreference(Base): __tablename__ = 'customer_api_preference' id = Column(Integer, primary_key=True) """ )
Example #9
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_pascal(metadata): Table("CustomerAPIPreference", metadata, Column("id", INTEGER, primary_key=True)) assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Column, Integer from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class CustomerAPIPreference(Base): __tablename__ = 'CustomerAPIPreference' id = Column(Integer, primary_key=True) """ )
Example #10
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_server_default_double_quotes(metadata): Table("simple", metadata, Column("id", INTEGER, primary_key=True, server_default=text('nextval("foo")'))) assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Column, Integer, text from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class Simple(Base): __tablename__ = 'simple' id = Column(Integer, primary_key=True, server_default=text("nextval(\\"foo\\")")) """ )
Example #11
Source File: test_sqlite.py From sqlalchemy with MIT License | 6 votes |
def test_extract(self): t = sql.table("t", sql.column("col1")) mapping = { "month": "%m", "day": "%d", "year": "%Y", "second": "%S", "hour": "%H", "doy": "%j", "minute": "%M", "epoch": "%s", "dow": "%w", "week": "%W", } for field, subst in mapping.items(): self.assert_compile( select([extract(field, t.c.col1)]), "SELECT CAST(STRFTIME('%s', t.col1) AS " "INTEGER) AS anon_1 FROM t" % subst, )
Example #12
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_pk_default(metadata): Table("simple_items", metadata, Column("id", INTEGER, primary_key=True, server_default=text("uuid_generate_v4()"))) assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Column, Integer, text from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class SimpleItem(Base): __tablename__ = 'simple_items' id = Column(Integer, primary_key=True, server_default=text("uuid_generate_v4()")) """ )
Example #13
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_schema_boolean(metadata): Table( "simple_items", metadata, Column("bool1", INTEGER), CheckConstraint("testschema.simple_items.bool1 IN (0, 1)"), schema="testschema" ) assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Boolean, Column, MetaData, Table metadata = MetaData() t_simple_items = Table( 'simple_items', metadata, Column('bool1', Boolean), schema='testschema' ) """ )
Example #14
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_table_kwargs(metadata): Table("simple_items", metadata, Column("id", INTEGER, primary_key=True), schema="testschema") assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Column, Integer from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class SimpleItem(Base): __tablename__ = 'simple_items' __table_args__ = {'schema': 'testschema'} id = Column(Integer, primary_key=True) """ )
Example #15
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_no_classes(metadata): Table("simple_items", metadata, Column("id", INTEGER, primary_key=True)) assert ( generate_code(metadata, noclasses=True) == """\ # coding: utf-8 from sqlalchemy import Column, Integer, MetaData, Table metadata = MetaData() t_simple_items = Table( 'simple_items', metadata, Column('id', Integer, primary_key=True) ) """ )
Example #16
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_mysql_column_types(metadata): Table("simple_items", metadata, Column("id", mysql.INTEGER), Column("name", mysql.VARCHAR(255))) assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Column, Integer, MetaData, String, Table metadata = MetaData() t_simple_items = Table( 'simple_items', metadata, Column('id', Integer), Column('name', String(255)) ) """ )
Example #17
Source File: test_sqlite.py From sqlalchemy with MIT License | 6 votes |
def test_on_conflict_clause_unique_constraint(self): meta = MetaData() t = Table( "n", meta, Column("id", Integer), Column("x", String(30)), UniqueConstraint("id", "x", sqlite_on_conflict="FAIL"), ) self.assert_compile( CreateTable(t), "CREATE TABLE n (id INTEGER, x VARCHAR(30), " "UNIQUE (id, x) ON CONFLICT FAIL)", dialect=sqlite.dialect(), )
Example #18
Source File: test_sqlite.py From sqlalchemy with MIT License | 6 votes |
def test_on_conflict_clause_primary_key(self): meta = MetaData() t = Table( "n", meta, Column( "id", Integer, primary_key=True, sqlite_on_conflict_primary_key="FAIL", ), sqlite_autoincrement=True, ) self.assert_compile( CreateTable(t), "CREATE TABLE n (id INTEGER NOT NULL " "PRIMARY KEY ON CONFLICT FAIL AUTOINCREMENT)", dialect=sqlite.dialect(), )
Example #19
Source File: test_sqlite.py From sqlalchemy with MIT License | 6 votes |
def test_on_conflict_clause_primary_key_constraint(self): meta = MetaData() t = Table( "n", meta, Column("id", Integer), Column("x", String(30)), PrimaryKeyConstraint("id", "x", sqlite_on_conflict="FAIL"), ) self.assert_compile( CreateTable(t), "CREATE TABLE n (" "id INTEGER NOT NULL, " "x VARCHAR(30) NOT NULL, " "PRIMARY KEY (id, x) ON CONFLICT FAIL)", dialect=sqlite.dialect(), )
Example #20
Source File: test_sqlite.py From sqlalchemy with MIT License | 6 votes |
def test_sqlite_autoincrement_constraint(self): table = Table( "autoinctable", MetaData(), Column("id", Integer, primary_key=True), Column("x", Integer, default=None), UniqueConstraint("x"), sqlite_autoincrement=True, ) self.assert_compile( schema.CreateTable(table), "CREATE TABLE autoinctable (id INTEGER NOT " "NULL PRIMARY KEY AUTOINCREMENT, x " "INTEGER, UNIQUE (x))", dialect=sqlite.dialect(), )
Example #21
Source File: test_sqlite.py From sqlalchemy with MIT License | 6 votes |
def test_on_conflict_clause_column_many_clause(self): meta = MetaData() t = Table( "n", meta, Column( "test", Integer, nullable=False, primary_key=True, sqlite_on_conflict_not_null="FAIL", sqlite_on_conflict_primary_key="IGNORE", ), ) self.assert_compile( CreateTable(t), "CREATE TABLE n (" "test INTEGER NOT NULL ON CONFLICT FAIL, " "PRIMARY KEY (test) ON CONFLICT IGNORE)", dialect=sqlite.dialect(), )
Example #22
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_indexes_table(metadata): simple_items = Table("simple_items", metadata, Column("id", INTEGER), Column("number", INTEGER), Column("text", VARCHAR)) simple_items.indexes.add(Index("idx_number", simple_items.c.number)) simple_items.indexes.add(Index("idx_text_number", simple_items.c.text, simple_items.c.number, unique=True)) simple_items.indexes.add(Index("idx_text", simple_items.c.text, unique=True)) assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Column, Index, Integer, MetaData, String, Table metadata = MetaData() t_simple_items = Table( 'simple_items', metadata, Column('id', Integer), Column('number', Integer, index=True), Column('text', String, unique=True), Index('idx_text_number', 'text', 'number', unique=True) ) """ )
Example #23
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
def test_noconstraints_table(metadata): simple_items = Table("simple_items", metadata, Column("number", INTEGER), CheckConstraint("number > 2")) simple_items.indexes.add(Index("idx_number", simple_items.c.number)) assert ( generate_code(metadata, noconstraints=True) == """\ # coding: utf-8 from sqlalchemy import Column, Integer, MetaData, Table metadata = MetaData() t_simple_items = Table( 'simple_items', metadata, Column('number', Integer, index=True) ) """ )
Example #24
Source File: test_sqlite.py From sqlalchemy with MIT License | 5 votes |
def setup(self): exec_sql(testing.db, "CREATE TABLE a (id INTEGER PRIMARY KEY)") # this syntax actually works on other DBs perhaps we'd want to add # tests to test_reflection exec_sql( testing.db, "CREATE TABLE b (id INTEGER PRIMARY KEY REFERENCES a)" )
Example #25
Source File: test_codegen.py From safrs with GNU General Public License v3.0 | 5 votes |
def test_boolean_detection(metadata): Table( "simple_items", metadata, Column("bool1", INTEGER), Column("bool2", SMALLINT), Column("bool3", mysql.TINYINT), CheckConstraint("simple_items.bool1 IN (0, 1)"), CheckConstraint("simple_items.bool2 IN (0, 1)"), CheckConstraint("simple_items.bool3 IN (0, 1)"), ) assert ( generate_code(metadata) == """\ # coding: utf-8 from sqlalchemy import Boolean, Column, MetaData, Table metadata = MetaData() t_simple_items = Table( 'simple_items', metadata, Column('bool1', Boolean), Column('bool2', Boolean), Column('bool3', Boolean) ) """ )
Example #26
Source File: test_sqlite.py From sqlalchemy with MIT License | 5 votes |
def test_old_style_default(self): """test non-quoted integer value on older sqlite pragma""" dialect = sqlite.dialect() info = dialect._get_column_info( "foo", "INTEGER", False, 3, False, False, False, None ) eq_(info["default"], "3")
Example #27
Source File: test_sqlite.py From sqlalchemy with MIT License | 5 votes |
def test_column_computed(self, text, persisted): m = MetaData() kwargs = {"persisted": persisted} if persisted != "ignore" else {} t = Table( "t", m, Column("x", Integer), Column("y", Integer, Computed("x + 2", **kwargs)), ) self.assert_compile( schema.CreateTable(t), "CREATE TABLE t (x INTEGER," " y INTEGER GENERATED ALWAYS AS (x + 2)%s)" % text, )
Example #28
Source File: base.py From moviegrabber with GNU General Public License v3.0 | 5 votes |
def __init__(self, **kw): """Construct an INTEGER.""" super(INTEGER, self).__init__(**kw)
Example #29
Source File: test_sqlite.py From sqlalchemy with MIT License | 5 votes |
def _unsupported_args_fixture(self): return [ ("INTEGER(5)", sqltypes.INTEGER()), ("DATETIME(6, 12)", sqltypes.DATETIME()), ]
Example #30
Source File: test_sqlite.py From sqlalchemy with MIT License | 5 votes |
def setup_class(cls): with testing.db.begin() as conn: conn.exec_driver_sql( 'ATTACH %r AS "default"' % conn.engine.url.database ) conn.exec_driver_sql( 'CREATE TABLE "default".a (id INTEGER PRIMARY KEY)' )