PonyORM v0.7.12 Release Notes

Release Date: 2020-02-04 // 20 days ago
  • 🔋 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

Previous changes from v0.7.11

  • 🔋 Features

    • 👍 #472: Python 3.8 support
    • 👌 Support of hybrid functions (inlining simple Python functions into query)
    • 👍 #438: support datetime-datetime, datetime-timedelta, datetime+timedelta in queries

    🛠 Bugfixes

    • #430: add ON DELETE CASCADE for many-to-many relationships
    • #465: Should reconnect to MySQL on OperationalError 2013 'Lost connection to MySQL server during query'
    • #468: Tuple-value comparisons generate incorrect queries
    • 🗄 #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