<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/sqlalchemy.git/test/dialect/mssql, branch pr/264</title>
<subtitle>github.com: zzzeek/sqlalchemy.git
</subtitle>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/'/>
<entry>
<title>- update the mssql autoincrement reflection test to accommodate</title>
<updated>2016-02-21T01:43:36+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2016-02-21T01:43:36+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=6713817e1186cd1e36c9aea9d89a30bc299ffe27'/>
<id>6713817e1186cd1e36c9aea9d89a30bc299ffe27</id>
<content type='text'>
the new behavior of the autoincrement flag as per ref #3216
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
the new behavior of the autoincrement flag as per ref #3216
</pre>
</div>
</content>
</entry>
<entry>
<title>- reworked the way the "select_wraps_for" expression is</title>
<updated>2016-02-21T01:22:38+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2016-02-21T01:22:38+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=8ad968f33100baeb3b13c7e0b724b6b79ab4277f'/>
<id>8ad968f33100baeb3b13c7e0b724b6b79ab4277f</id>
<content type='text'>
handled within visit_select(); this attribute was added in the
1.0 series to accommodate the subquery wrapping behavior of
SQL Server and Oracle while also working with positional
column targeting and no longer relying upon "key fallback"
in order to target columns in such a statement.  The IBM DB2
third-party dialect also has this use case, but its implementation
is using regular expressions to rewrite the textual SELECT only
and does not make use of a "wrapped" select at this time.
The logic no longer attempts to reconcile proxy set collections as
this was not deterministic, and instead assumes that the select()
and the wrapper select() match their columns postionally,
at least for the column positions they have in common,
so it is now very simple and safe.  fixes #3657.
- as a side effect of #3657 it was also revealed that the
strategy of calling upon a ResultProxy._getter was not
correctly calling into NoSuchColumnError when an expected
column was not present, and instead returned None up to
loading.instances() to produce NoneType failures; added
a raiseerr argument to _getter() which is called when we
aren't expecting None, fixes #3658.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
handled within visit_select(); this attribute was added in the
1.0 series to accommodate the subquery wrapping behavior of
SQL Server and Oracle while also working with positional
column targeting and no longer relying upon "key fallback"
in order to target columns in such a statement.  The IBM DB2
third-party dialect also has this use case, but its implementation
is using regular expressions to rewrite the textual SELECT only
and does not make use of a "wrapped" select at this time.
The logic no longer attempts to reconcile proxy set collections as
this was not deterministic, and instead assumes that the select()
and the wrapper select() match their columns postionally,
at least for the column positions they have in common,
so it is now very simple and safe.  fixes #3657.
- as a side effect of #3657 it was also revealed that the
strategy of calling upon a ResultProxy._getter was not
correctly calling into NoSuchColumnError when an expected
column was not present, and instead returned None up to
loading.instances() to produce NoneType failures; added
a raiseerr argument to _getter() which is called when we
aren't expecting None, fixes #3658.
</pre>
</div>
</content>
</entry>
<entry>
<title>- add missing __backend__ directives for SQL server</title>
<updated>2016-02-08T19:20:12+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2016-02-08T19:20:12+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=6831c67b8e8aa7bc78d01b8c73268430d64eb23a'/>
<id>6831c67b8e8aa7bc78d01b8c73268430d64eb23a</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>- there was a DATEPART test after all, fix format</title>
<updated>2016-01-14T22:50:03+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2016-01-14T22:50:03+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=0ff3f95d5b41335c977e1bdbe88b7dfd4ae581e1'/>
<id>0ff3f95d5b41335c977e1bdbe88b7dfd4ae581e1</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>- changelog for pr bitbucket:70, fixes #3624</title>
<updated>2016-01-12T14:53:09+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2016-01-12T14:53:09+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=215167d8d38a381d27c8448f5c6e50c70b9ba0cc'/>
<id>215167d8d38a381d27c8448f5c6e50c70b9ba0cc</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>- A descriptive ValueError is now raised in the event that SQL server</title>
<updated>2015-11-30T17:19:26+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2015-11-30T17:19:26+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=03a3b5ffd3027c79ce9b17b9388fd074e69b889d'/>
<id>03a3b5ffd3027c79ce9b17b9388fd074e69b889d</id>
<content type='text'>
returns an invalid date or time format from a DATE or TIME
column, rather than failing with a NoneType error.  Pull request
courtesy Ed Avis.
pullreq github:206
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
returns an invalid date or time format from a DATE or TIME
column, rather than failing with a NoneType error.  Pull request
courtesy Ed Avis.
pullreq github:206
</pre>
</div>
</content>
</entry>
<entry>
<title>- extend pullreq github:213 to also include DATETIMEOFFSET and TIME,</title>
<updated>2015-11-14T17:38:45+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2015-11-14T17:36:09+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=0847097c29ab48a5f111518e2c6ee324d5242057'/>
<id>0847097c29ab48a5f111518e2c6ee324d5242057</id>
<content type='text'>
which also accept zero precision
- extend test case here to include a backend-agnostic suite
- changelog for MSSQL date fix
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
which also accept zero precision
- extend test case here to include a backend-agnostic suite
- changelog for MSSQL date fix
</pre>
</div>
</content>
</entry>
<entry>
<title>Pass precision value to mssql.DATETIME2 when it is 0</title>
<updated>2015-11-13T19:51:05+00:00</updated>
<author>
<name>Jacobo de Vera</name>
<email>devel@jacobodevera.com</email>
</author>
<published>2015-11-13T15:57:41+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=80ce23f6fd0f14ab656d3ec82773bd0cffbd4791'/>
<id>80ce23f6fd0f14ab656d3ec82773bd0cffbd4791</id>
<content type='text'>
The simple check on the precision results in DATETIME2(0) generating a
DATETIME2 column, with default precision, which is 7.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
The simple check on the precision results in DATETIME2(0) generating a
DATETIME2 column, with default precision, which is 7.
</pre>
</div>
</content>
</entry>
<entry>
<title>- The ``legacy_schema_aliasing`` flag, introduced in version 1.0.5</title>
<updated>2015-09-19T22:06:23+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2015-09-19T22:06:23+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=3dfcb10befc7a8c193ee992bdea009e39b2e798c'/>
<id>3dfcb10befc7a8c193ee992bdea009e39b2e798c</id>
<content type='text'>
as part of :ticket:`3424` to allow disabling of the MSSQL dialect's
attempts to create aliases for schema-qualified tables, now defaults
to False; the old behavior is now disabled unless explicitly turned on.
fixes #3434
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
as part of :ticket:`3424` to allow disabling of the MSSQL dialect's
attempts to create aliases for schema-qualified tables, now defaults
to False; the old behavior is now disabled unless explicitly turned on.
fixes #3434
</pre>
</div>
</content>
</entry>
<entry>
<title>- fix the postgresql_jsonb requirement to include the 9.4 requirement</title>
<updated>2015-08-18T17:30:21+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2015-08-18T17:02:58+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=b653fedca5f0fc384c990e93d82c0780c9e76f2c'/>
<id>b653fedca5f0fc384c990e93d82c0780c9e76f2c</id>
<content type='text'>
- new test for json col['x']['y']['z'] seems to fail pre PG 9.4,
fails on comparisons for non-compatible data instead of not matching
- no need to call SpecPredicate(db) directly in exclusion functions,
by using Predicate.as_predicate() the spec strings can have version
comparisons
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
- new test for json col['x']['y']['z'] seems to fail pre PG 9.4,
fails on comparisons for non-compatible data instead of not matching
- no need to call SpecPredicate(db) directly in exclusion functions,
by using Predicate.as_predicate() the spec strings can have version
comparisons
</pre>
</div>
</content>
</entry>
</feed>
