diff options
| -rw-r--r-- | CHANGES | 4 | ||||
| -rw-r--r-- | lib/sqlalchemy/databases/postgres.py | 17 |
2 files changed, 19 insertions, 2 deletions
@@ -99,6 +99,10 @@ CHANGES - postgres TIMESTAMP renders correctly [ticket:981] + - postgres PGArray is a "mutable" type by default; + when used with the ORM, mutable-style equality/ + copy-on-write techniques are used to test for changes. + 0.4.3 ------ - sql diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py index 9f8e98607..19228f558 100644 --- a/lib/sqlalchemy/databases/postgres.py +++ b/lib/sqlalchemy/databases/postgres.py @@ -113,11 +113,24 @@ class PGBoolean(sqltypes.Boolean): def get_col_spec(self): return "BOOLEAN" -class PGArray(sqltypes.Concatenable, sqltypes.TypeEngine): - def __init__(self, item_type): +class PGArray(sqltypes.MutableType, sqltypes.Concatenable, sqltypes.TypeEngine): + def __init__(self, item_type, mutable=True): if isinstance(item_type, type): item_type = item_type() self.item_type = item_type + self.mutable = mutable + + def copy_value(self, value): + if self.mutable: + return list(value) + else: + return value + + def compare_values(self, x, y): + return x == y + + def is_mutable(self): + return self.mutable def dialect_impl(self, dialect, **kwargs): impl = self.__class__.__new__(self.__class__) |