diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2017-02-16 13:00:28 -0500 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2017-02-16 13:00:28 -0500 |
| commit | 42bb86568919a7198090235b4ab8293366866fdd (patch) | |
| tree | 28700b000fe2250c116c24dc01fe9ca05f48a5e3 /test/dialect/postgresql | |
| parent | 3b6004e6ab3fef8e37fb42981c02f4dfa34fe3b7 (diff) | |
| download | sqlalchemy-42bb86568919a7198090235b4ab8293366866fdd.tar.gz | |
- add test for inserting PG array w/ NULL, references #3916
Change-Id: I87be274c1ba019b41744a5a76c1b5e9334564ec8
Diffstat (limited to 'test/dialect/postgresql')
| -rw-r--r-- | test/dialect/postgresql/test_types.py | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/test/dialect/postgresql/test_types.py b/test/dialect/postgresql/test_types.py index ddc121a8b..3f2f6db3f 100644 --- a/test/dialect/postgresql/test_types.py +++ b/test/dialect/postgresql/test_types.py @@ -1064,6 +1064,15 @@ class ArrayRoundTripTest(fixtures.TablesTest, AssertsExecutionResults): eq_(results[0]['intarr'], [1, 2, 3]) eq_(results[0]['strarr'], [util.u('abc'), util.u('def')]) + def test_insert_array_w_null(self): + arrtable = self.tables.arrtable + arrtable.insert().execute(intarr=[1, None, 3], strarr=[util.u('abc'), + None]) + results = arrtable.select().execute().fetchall() + eq_(len(results), 1) + eq_(results[0]['intarr'], [1, None, 3]) + eq_(results[0]['strarr'], [util.u('abc'), None]) + def test_array_where(self): arrtable = self.tables.arrtable arrtable.insert().execute(intarr=[1, 2, 3], strarr=[util.u('abc'), |