REDROOM

Edit File Size: 2.80 KB

/proc/thread-self/root/opt/alt/python37/lib64/python3.7/site-packages/sqlalchemy/testing/suite/test_ddl.py

Text Base64

from .. import config
from .. import fixtures
from .. import util
from ..assertions import eq_
from ..config import requirements
from ... import Column
from ... import inspect
from ... import Integer
from ... import schema
from ... import String
from ... import Table

class TableDDLTest(fixtures.TestBase):
    __backend__ = True

def _simple_fixture(self, schema=None):
        return Table(
            "test_table",
            self.metadata,
            Column("id", Integer, primary_key=True, autoincrement=False),
            Column("data", String(50)),
            schema=schema,
        )

def _underscore_fixture(self):
        return Table(
            "_test_table",
            self.metadata,
            Column("id", Integer, primary_key=True, autoincrement=False),
            Column("_data", String(50)),
        )

def _simple_roundtrip(self, table):
        with config.db.begin() as conn:
            conn.execute(table.insert().values((1, "some data")))
            result = conn.execute(table.select())
            eq_(result.first(), (1, "some data"))

@requirements.create_table
    @util.provide_metadata
    def test_create_table(self):
        table = self._simple_fixture()
        table.create(config.db, checkfirst=False)
        self._simple_roundtrip(table)

@requirements.create_table
    @util.provide_metadata
    def test_create_table_schema(self):
        table = self._simple_fixture(schema=config.test_schema)
        table.create(config.db, checkfirst=False)
        self._simple_roundtrip(table)

@requirements.drop_table
    @util.provide_metadata
    def test_drop_table(self):
        table = self._simple_fixture()
        table.create(config.db, checkfirst=False)
        table.drop(config.db, checkfirst=False)

@requirements.create_table
    @util.provide_metadata
    def test_underscore_names(self):
        table = self._underscore_fixture()
        table.create(config.db, checkfirst=False)
        self._simple_roundtrip(table)

@requirements.comment_reflection
    @util.provide_metadata
    def test_add_table_comment(self):
        table = self._simple_fixture()
        table.create(config.db, checkfirst=False)
        table.comment = "a comment"
        config.db.execute(schema.SetTableComment(table))
        eq_(
            inspect(config.db).get_table_comment("test_table"),
            {"text": "a comment"},
        )

@requirements.comment_reflection
    @util.provide_metadata
    def test_drop_table_comment(self):
        table = self._simple_fixture()
        table.create(config.db, checkfirst=False)
        table.comment = "a comment"
        config.db.execute(schema.SetTableComment(table))
        config.db.execute(schema.DropTableComment(table))
        eq_(inspect(config.db).get_table_comment("test_table"), {"text": None})

__all__ = ("TableDDLTest",)

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Name	Size	Perms	Modified	Actions
__pycache__ DIR	-	drwxr-xr-x	2023-12-06 03:19:27	Edit Download recursive recursive
test_cte.py	6.63 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
test_ddl.py	2.80 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
test_dialect.py	4.46 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
test_insert.py	9.36 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
test_reflection.py	36.59 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
test_results.py	11.23 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
test_select.py	19.52 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
test_sequence.py	4.55 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
test_types.py	28.94 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
test_update_delete.py	1.44 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
__init__.py	358 B	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive

Directory Contents