Tags: shishironline/pony
Tags
PonyORM release 0.7.15-RC1 (2022-01-10) # Features * Add Python 3.10 support, drop support of Python < 3.7 # Bugfixes * Do not perform optimistic checks when deleting an object (it is OK if it was already deleted by concurrent transaction) * Validation of int fields should take into account field size and check that the value is fit into the range * More tests for hybrid methods added * Fix incorrect assertion check `assert t is translator.` * Fix aggregated query `sum(x.field for x in previous_query)` * ponyorm#594: Use a clearly synthetic filename when compiling dynamic code to not confuse coverage.py * Use DecompileError exception instead of AssertionError when a function cannot be decompiled
PonyORM release 0.7.14 (2020-11-23) # Features * Add Python 3.9 support * Allow to use kwargs in select: Entity.select(**kwargs) and obj.collection.select(**kwargs), a feature that was announced but actually missed from 0.7.7 * Add support for volatile collection attributes that don't throw "Phantom object appeared/disappeared" exceptions # Bugfixes * Fix negative timedelta conversions * Pony should reconnect to PostgreSQL when receiving 57P01 error (AdminShutdown) * Allow mixing compatible types (like int and float) in coalesce() arguments * Support of subqueries in coalesce() arguments * Fix using aggregated subqueries in ORDER BY section * Fix queries with expressions like `(x, y) in ((a, b), (c, d))` * ponyorm#451: KeyError for seeds with unique attributes in SessionCache.update_simple_index()
PonyORM release 0.7.12 (2020-02-04) # Features * CockroachDB support added * CI testing for SQLite, PostgreSQL & CockroachDB # Bugfixes * Fix translation of getting array items with negative indexes * Fix string getitem translation for slices and negative indexes * PostgreSQL DISTINCT bug fixed for queries with ORDER BY clause * Fix date difference syntax in PostgreSQL * Fix casting json to dobule in PostgreSQL * Fix count by several columns in PostgreSQL * Fix PostgreSQL MIN and MAX expressions on boolean columns * Fix determination of interactive mode in PyCharm * Fix column definition when `sql_default` is specified: DEFAULT should be before NOT NULL * Relax checks on updating in-memory cache indexes (don't throw CacheIndexError on valid cases) * Fix deduplication logic for attribute values
PonyORM release 0.7.11 (2019-10-23) # Features * ponyorm#472: Python 3.8 support * Support of hybrid functions (inlining simple Python functions into query) * ponyorm#438: support datetime-datetime, datetime-timedelta, datetime+timedelta in queries # Bugfixes * ponyorm#430: add ON DELETE CASCADE for many-to-many relationships * ponyorm#465: Should reconnect to MySQL on OperationalError 2013 'Lost connection to MySQL server during query' * ponyorm#468: Tuple-value comparisons generate incorrect queries * ponyorm#470 fix PendingDeprecationWarning of imp module * Fix incorrect unpickling of objects with Json attributes * Check value of discriminator column on object creation if set explicitly * Correctly handle Flask current_user proxy when adding new items to collections * Some bugs in syntax of aggregated queries were fixed * Fix syntax of bulk delete queries * Bulk delete queries should clear query results cache so next select will get correct result from the database * Fix error message when hybrid method is too complex to decompile
PonyORM release 0.7.10 (2019-04-20) # Bugfixes * Python3.7 and PyPy decompiling fixes * Fix reading NULL from Optional nullable array column * Fix handling of empty arrays in queries * ponyorm#415: error message typo * ponyorm#432: PonyFlask - request object can trigger teardown_request without real request * Fix GROUP CONCAT separator for MySQL
PonyORM release 0.7.8 (2019-01-19) # Bugfixes * ponyorm#414: prefetching Optional relationships fails on 0.7.7 * Fix a bug caused by incorrect deduplication of column values
PonyORM release 0.7.8 (2019-01-19) # Bugfixes * ponyorm#414: prefetching Optional relationships fails on 0.7.7 * Fix a bug caused by incorrect deduplication of column values
PonyORM release 0.7.7 (2019-01-17) # Major features * Array type support for PostgreSQL and SQLite * isinstance() support in queries * Support of queries based on collections: select(x for x in y.items) # Other features * Support of Entity.select(**kwargs) * Support of SKIP LOCKED option in 'SELECT ... FOR UPDATE' * New function make_proxy(obj) to make cros-db_session proxy objects * Specify ON DELETE CASCADE/SET NULL in foreign keys * Support of LIMIT in `SELECT FROM (SELECT ...)` type of queries * Support for negative JSON array indexes in SQLite # Improvements * Improved query prefetching: use fewer number of SQL queries * Memory optimization: deduplication of values recieved from the database in the same session * increase DBAPIProvider.max_params_count value # Bugfixes * ponyorm#405: breaking change with cx_Oracle 7.0: DML RETURNING now returns a list * ponyorm#380: db_session should work with async functions * ponyorm#385: test fails with python3.6 * ponyorm#386: release unlocked lock error in SQLite * ponyorm#390: TypeError: writable buffers are not hashable * ponyorm#398: add auto coversion of numpy numeric types * ponyorm#404: GAE local run detection * Fix Flask compatibility: add support of LocalProxy object * db_session(sql_debug=True) should log SQL commands also during db_session.__exit__() * Fix duplicated table join in FROM clause * Fix accessing global variables from hybrid methods and properties * Fix m2m collection loading bug * Fix composite index bug: stackoverflow.com/questions/53147694 * Fix MyEntity[obj.get_pk()] if pk is composite * MySQL group_concat_max_len option set to max of 32bit platforms to avoid truncation * Show all attribute options in show(Entity) call * For nested db_session retry option should be ignored * Fix py_json_unwrap * Other minor fixes
PreviousNext