~cjwatson/storm/is-and-is-not-operators : changes

~cjwatson/storm/is-and-is-not-operators » Changes from revision 577

From Revision 577 to 558

Rev	Summary	Authors	Tags	Date
577	Add storm.expr.Is and storm.expr.IsNot operators. Add storm.expr.Is and storm.expr.IsNot operators. Launchpad has had custom `IsTrue` and `IsFalse` operators for a while, because there are a few places where `expr` or `expr == True` (or the equivalents for False) don't quite do what we need: for example, if you're working with a nullable boolean column, then SQL NULL semantics mean that `expr = TRUE` or `expr = FALSE` return NULL when `expr` is NULL, which can be undesirable at times. In addition, `==` and `!=` comparisons with True/False/None are typically picked up as errors by modern linters, since in normal Python code they should use `is` or `is not` or simple boolean tests instead. Having to override this is an annoyance. Compare https://docs.sqlalchemy.org/en/20/core/operators.html#identity-comparisons, although SQLAlchemy is more permissive; it seems to be happy to compile anything on the right-hand-side of `IS` or `IS NOT` and leave it up to the database. Since we already have to take some care with how booleans are rendered, and there's no guarantee that the spelling of `IS TRUE` etc. is going to match the way that boolean values themselves are spelled, I thought it better to limit the set of right-hand-side expressions that we will compile. I've checked that current versions of all the databases currently supported by Storm (PostgreSQL, MySQL, and SQLite) support all the resulting expressions, although in the case of SQLite it does need at least version 3.23.0 (released in 2018).	Colin Watson		1 year ago
576	[r=ilasc] Clarify exception for a property with allow_none=F... [r=ilasc] Clarify exception for a property with allow_none=False and default=None.	Colin Watson		2 years ago
575	[r=cjwatson] Fix a typo in the tutorial doctest code block [r=cjwatson] Fix a typo in the tutorial doctest code block	Colin Watson		2 years ago
574	[r=ilasc] Fix test compatibility with MySQL >= 8.0.24. [r=ilasc] Fix test compatibility with MySQL >= 8.0.24.	Colin Watson		2 years ago
573	Bump version to 0.25.0.99. Bump version to 0.25.0.99.	Colin Watson		3 years ago
572	Avoid traceback reference cycles when wrapping exceptions. [... Avoid traceback reference cycles when wrapping exceptions. [r=ilasc]	Colin Watson		3 years ago
571	Release Storm 0.25. Release Storm 0.25.	Colin Watson	0.25	3 years ago
570	Fix MANIFEST.in prune syntax. Fix MANIFEST.in prune syntax.	Colin Watson		3 years ago
569	[r=ilasc] Support Python 3.9. [r=ilasc] Support Python 3.9.	Colin Watson		3 years ago
568	[r=ilasc] Restore MySQL support. [r=ilasc] Restore MySQL support.	Colin Watson		3 years ago
567	[r=ilasc] Fix py27 and py35 tox environments. [r=ilasc] Fix py27 and py35 tox environments.	Colin Watson		3 years ago
566	Add optional case_sensitive argument to several Like helpers... Add optional case_sensitive argument to several Like helpers. [r=ilasc]	Colin Watson		3 years ago
565	Release Storm 0.24. Release Storm 0.24.	Colin Watson	0.24	3 years ago
564	Add docstrings for storm.event.EventSystem. [r=ilasc] Add docstrings for storm.event.EventSystem. [r=ilasc]	Colin Watson		3 years ago
563	Add docstring for storm.uri.URI. [r=ilasc] Add docstring for storm.uri.URI. [r=ilasc]	Colin Watson		3 years ago
562	Add block_access to storm.store.__all__. [r=ilasc] Add block_access to storm.store.__all__. [r=ilasc]	Colin Watson		3 years ago
561	Add more docstrings to storm.references. [r=ilasc] Add more docstrings to storm.references. [r=ilasc]	Colin Watson		3 years ago
560	Add docstrings for more classes in storm.properties. [r=ilas... Add docstrings for more classes in storm.properties. [r=ilasc]	Colin Watson		3 years ago
559	Convert CaptureTracer to the improved API in fixtures >= 1.3... Convert CaptureTracer to the improved API in fixtures >= 1.3.0. [r=ilasc]	Colin Watson		3 years ago
558	Add doc-requirements.txt for readthedocs builds. Add doc-requirements.txt for readthedocs builds.	Colin Watson		3 years ago

Older »