Release 0.13.1

Patch Changes:

• Add None as an alias for IS NULL comparison in dict restrictions (#824) PR #893
• Drop support for MySQL 5.6 since it has reached EOL PR #893
• Bugfix - schema.list_tables() is not topologically sorted (#838) PR #893
• Bugfix - Diagram part tables do not show proper class name (#882) PR #893
• Bugfix - Error in complex restrictions (#892) PR #893
• Bugfix - WHERE and GROUP BY clases are dropped on joins with aggregation (#898, #899) PR #893

Release 0.13.0

Minor Changes:

• Re-implement query transpilation into SQL, fixing issues (#386, #449, #450, #484, #558). PR #754
• Re-implement cascading deletes for better performance. PR #839
• Add support for deferred schema activation to allow for greater modularity. (#834) PR #839
• Add query caching mechanism for offline development (#550) PR #839
• Add table method .update1 to update a row in the table with new values (#867) PR #763, #889
• Python datatypes are now enabled by default in blobs (#761). PR #859
• Added permissive join and restriction operators @ and ^ (#785) PR #754
• Support DataJoint datatype and connection plugins (#715, #729) PR 730, #735
• Add dj.key_hash alias to dj.hash.key_hash (#804) PR #862
• Default enable_python_native_blobs to True
• Bugfix - Regression error on joins with same attribute name (#857) PR #878
• Bugfix - Error when fetch1('KEY') when dj.config['fetch_format']='frame' set (#876) PR #880, #878
• Bugfix - Error when cascading deletes in tables with many, complex keys (#883, #886) PR #839
• Add deprecation warning for _update. PR #889
• Add purge_query_cache utility. PR #889
• Add tests for query caching and permissive join and restriction. PR #889
• Drop support for Python 3.5 (#829) PR #861

Release 0.12.9

Patch Changes:

• Fix bug with fetch1 with dj.config['fetch_format']="frame". (#876) PR #880

Release 0.12.8

Patch Changes:

• table.children, .parents, .descendents, and ancestors can return queryable objects. PR #833
• Load dependencies before querying dependencies. (#179) PR #833
• Fix display of part tables in schema.save. (#821) PR #833
• Add schema.list_tables. (#838) PR #844
• Fix minio new version regression. PR #847
• Add more S3 logging for debugging. (#831) PR #832
• Convert testing framework from TravisCI to GitHub Actions (#841) PR #840

Release 0.12.7

Patch Changes:

• Fix case sensitivity issues to adapt to MySQL 8+. PR #819
• Fix pymysql regression bug (#814) PR #816
• Adapted attribute types now have dtype=object in all recarray results. PR #811

Release 0.12.6

Patch Changes:

• Add order_by to dj.kill (#668, #779) PR #775, #783
• Add explicit S3 bucket and file storage location existence checks (#748) PR #781
• Modify _update to allow nullable updates for strings/date (#664) PR #760
• Avoid logging events on auxiliary tables (#737) PR #753
• Add kill_quick and expand display to include host (#740) PR #741
• Bugfix - pandas insert fails due to additional index field (#666) PR #776
• Bugfix - delete_external_files=True does not remove from S3 (#686) PR #781
• Bugfix - pandas fetch throws error when fetch_format='frame' PR #774

Release 0.12.5

Patch Changes:

• Rename module dj.schema into dj.schemas. dj.schema remains an alias for class dj.Schema. (#731) PR #732
• dj.create_virtual_module is now called dj.VirtualModule (#731) PR #732
• Bugfix - SSL KeyError on failed connection (#716) PR #725
• Bugfix - Unable to run unit tests using nosetests (#723) PR #724
• Bugfix - suppress_errors does not suppress loss of connection error (#720) PR #721

Release 0.12.4

Patch Changes:

• Support for simple scalar datatypes in blobs (#690) PR #709
• Add support for the serial data type in declarations: alias for bigint unsigned auto_increment PR #713
• Improve the log table to avoid primary key collisions PR #713
• Improve documentation in README PR #713

Release 0.12.3

Patch Changes:

• Bugfix #675 (PR #705) networkx 2.4+ is now supported
• Bugfix #698 and #699 (PR #706) display table definition in doc string and help
• Bugfix #701 (PR #702) job reservation works with native python datatype support disabled

Release 0.12.2

Patch Changes:

• Bugfix - Convoluted error thrown if there is a reference to a non-existent table attribute (#691)
• Bugfix - Insert into external does not trim leading slash if defined in dj.config['stores']['<store>']['location'] (#692)