summaryrefslogtreecommitdiff
path: root/test/orm
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2017-07-18 11:41:12 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2017-07-18 15:04:36 -0400
commit7628ff39dcea080171f3f8bcbc7153c4c0119857 (patch)
treedbcd9b749c08dc440e70868a0ae8136f6f9fb158 /test/orm
parent32f67637cd705840751bd1d8d37db87df5823a4b (diff)
downloadsqlalchemy-7628ff39dcea080171f3f8bcbc7153c4c0119857.tar.gz
Check for column object in eval_none, not propkey
Fixed bug involving JSON NULL evaluation logic added in 1.1 as part of :ticket:`3514` where the logic would not accommodate ORM mapped attributes named differently from the :class:`.Column` that was mapped. Change-Id: I1848afcfb63ad7f074f315d8d3097666069b42be Fixes: #4031
Diffstat (limited to 'test/orm')
-rw-r--r--test/orm/test_unitofworkv2.py49
1 files changed, 44 insertions, 5 deletions
diff --git a/test/orm/test_unitofworkv2.py b/test/orm/test_unitofworkv2.py
index ecd365000..270c3708e 100644
--- a/test/orm/test_unitofworkv2.py
+++ b/test/orm/test_unitofworkv2.py
@@ -2501,63 +2501,102 @@ class NullEvaluatingTest(fixtures.MappedTest, testing.AssertsExecutionResults):
String(50).evaluates_none(), default='default_val'),
)
+ Table(
+ 'test_w_renames', metadata,
+ Column('id', Integer, primary_key=True,
+ test_needs_autoincrement=True),
+ Column('evals_null_no_default', EvalsNull()),
+ Column('evals_null_default', EvalsNull(), default='default_val'),
+ Column('no_eval_null_no_default', String(50)),
+ Column('no_eval_null_default', String(50), default='default_val'),
+ Column(
+ 'builtin_evals_null_no_default', String(50).evaluates_none()),
+ Column(
+ 'builtin_evals_null_default',
+ String(50).evaluates_none(), default='default_val'),
+ )
+
@classmethod
def setup_classes(cls):
class Thing(cls.Basic):
pass
+ class AltNameThing(cls.Basic):
+ pass
+
@classmethod
def setup_mappers(cls):
Thing = cls.classes.Thing
+ AltNameThing = cls.classes.AltNameThing
mapper(Thing, cls.tables.test)
+ mapper(AltNameThing, cls.tables.test_w_renames, column_prefix="_foo_")
+
def _assert_col(self, name, value):
- Thing = self.classes.Thing
+ Thing, AltNameThing = self.classes.Thing, self.classes.AltNameThing
s = Session()
col = getattr(Thing, name)
obj = s.query(col).filter(col == value).one()
eq_(obj[0], value)
+ col = getattr(AltNameThing, "_foo_" + name)
+ obj = s.query(col).filter(col == value).one()
+ eq_(obj[0], value)
+
def _test_insert(self, attr, expected):
- Thing = self.classes.Thing
+ Thing, AltNameThing = self.classes.Thing, self.classes.AltNameThing
s = Session()
t1 = Thing(**{attr: None})
s.add(t1)
+
+ t2 = AltNameThing(**{"_foo_" + attr: None})
+ s.add(t2)
+
s.commit()
self._assert_col(attr, expected)
def _test_bulk_insert(self, attr, expected):
- Thing = self.classes.Thing
+ Thing, AltNameThing = self.classes.Thing, self.classes.AltNameThing
s = Session()
s.bulk_insert_mappings(
Thing, [{attr: None}]
)
+ s.bulk_insert_mappings(
+ AltNameThing, [{"_foo_" + attr: None}]
+ )
s.commit()
self._assert_col(attr, expected)
def _test_insert_novalue(self, attr, expected):
- Thing = self.classes.Thing
+ Thing, AltNameThing = self.classes.Thing, self.classes.AltNameThing
s = Session()
t1 = Thing()
s.add(t1)
+
+ t2 = AltNameThing()
+ s.add(t2)
+
s.commit()
self._assert_col(attr, expected)
def _test_bulk_insert_novalue(self, attr, expected):
- Thing = self.classes.Thing
+ Thing, AltNameThing = self.classes.Thing, self.classes.AltNameThing
s = Session()
s.bulk_insert_mappings(
Thing, [{}]
)
+ s.bulk_insert_mappings(
+ AltNameThing, [{}]
+ )
s.commit()
self._assert_col(attr, expected)