Method define_tables

test/ext/test_mutable.py:1192–1221

(cls, metadata)

class MutableWithScalarJSONTest(_MutableDictTestBase, fixtures.MappedTest):
    @classmethod
    def define_tables(cls, metadata):
        import json

        class JSONEncodedDict(TypeDecorator):
            impl = VARCHAR(50)
            cache_ok = True

            def process_bind_param(self, value, dialect):
                if value is not None:
                    value = json.dumps(value)

                return value

            def process_result_value(self, value, dialect):
                if value is not None:
                    value = json.loads(value)
                return value

        MutableDict = cls._type_fixture()

        Table(
            class="st">"foo",
            metadata,
            Column(
                class="st">"id", Integer, primary_key=True, test_needs_autoincrement=True
            ),
            Column(class="st">"data", MutableDict.as_mutable(JSONEncodedDict)),
            Column(class="st">"non_mutable_data", JSONEncodedDict),
            Column(class="st">"unrelated_data", String(50)),
        )

    def test_non_mutable(self):
        self._test_non_mutable()