PonyORM v0.7.7 Release Notes

Release Date: 2019-01-17 // over 3 years ago
  • 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

    • #405: breaking change with cx_Oracle 7.0: DML RETURNING now returns a list
    • #380: db_session should work with async functions
    • โœ… #385: test fails with python3.6
    • ๐Ÿš€ #386: release unlocked lock error in SQLite
    • #390: TypeError: writable buffers are not hashable
    • #398: add auto coversion of numpy numeric types
    • #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