<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/sqlalchemy.git/test/dialect/postgresql, branch pr/74</title>
<subtitle>github.com: zzzeek/sqlalchemy.git
</subtitle>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/'/>
<entry>
<title>- Support has been improved for Postgresql reflection behavior on very old</title>
<updated>2014-02-18T23:35:23+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-02-18T23:35:23+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=ecdfc31774e226b9f57701ae197d1bcbaf6afa24'/>
<id>ecdfc31774e226b9f57701ae197d1bcbaf6afa24</id>
<content type='text'>
(pre 8.1) versions of Postgresql, and potentially other PG engines
such as Redshift (assuming Redshift reports the version as &lt; 8.1).
The query for "indexes" as well as "primary keys" relies upon inspecting
a so-called "int2vector" datatype, which refuses to coerce to an array
prior to 8.1 causing failures regarding the "ANY()" operator used
in the query.  Extensive googling has located the very hacky, but
recommended-by-PG-core-developer query to use when PG version &lt; 8.1
is in use, so index and primary key constraint reflection now work
on these versions.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
(pre 8.1) versions of Postgresql, and potentially other PG engines
such as Redshift (assuming Redshift reports the version as &lt; 8.1).
The query for "indexes" as well as "primary keys" relies upon inspecting
a so-called "int2vector" datatype, which refuses to coerce to an array
prior to 8.1 causing failures regarding the "ANY()" operator used
in the query.  Extensive googling has located the very hacky, but
recommended-by-PG-core-developer query to use when PG version &lt; 8.1
is in use, so index and primary key constraint reflection now work
on these versions.
</pre>
</div>
</content>
</entry>
<entry>
<title>- Added :paramref:`.MetaData.reflect.**dialect_kwargs`</title>
<updated>2014-02-02T21:33:54+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-02-02T21:33:54+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=0326f3cf014ffb4928b4c6051d2fca13cb6945d7'/>
<id>0326f3cf014ffb4928b4c6051d2fca13cb6945d7</id>
<content type='text'>
to support dialect-level reflection options for all :class:`.Table`
objects reflected.

- Added a new dialect-level argument ``postgresql_ignore_search_path``;
this argument is accepted by both the :class:`.Table` constructor
as well as by the :meth:`.MetaData.reflect` method.  When in use
against Postgresql, a foreign-key referenced table which specifies
a remote schema name will retain that schema name even if the name
is present in the ``search_path``; the default behavior since 0.7.3
has been that schemas present in ``search_path`` would not be copied
to reflected :class:`.ForeignKey` objects.  The documentation has been
updated to describe in detail the behavior of the ``pg_get_constraintdef()``
function and how the ``postgresql_ignore_search_path`` feature essentially
determines if we will honor the schema qualification reported by
this function or not. [ticket:2922]
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
to support dialect-level reflection options for all :class:`.Table`
objects reflected.

- Added a new dialect-level argument ``postgresql_ignore_search_path``;
this argument is accepted by both the :class:`.Table` constructor
as well as by the :meth:`.MetaData.reflect` method.  When in use
against Postgresql, a foreign-key referenced table which specifies
a remote schema name will retain that schema name even if the name
is present in the ``search_path``; the default behavior since 0.7.3
has been that schemas present in ``search_path`` would not be copied
to reflected :class:`.ForeignKey` objects.  The documentation has been
updated to describe in detail the behavior of the ``pg_get_constraintdef()``
function and how the ``postgresql_ignore_search_path`` feature essentially
determines if we will honor the schema qualification reported by
this function or not. [ticket:2922]
</pre>
</div>
</content>
</entry>
<entry>
<title>- rework the JSON expression system so that "astext" is called *after*</title>
<updated>2013-12-27T23:25:57+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-12-27T23:25:57+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=2104d0ba2d612a26d363a3049d5e49efe4284e15'/>
<id>2104d0ba2d612a26d363a3049d5e49efe4284e15</id>
<content type='text'>
the indexing.  this is for more natural operation.
- also add cast() to the JSON expression to complement astext. This integrates
the CAST call which will be needed frequently.  Part of [ticket:2687].
- it's a little unclear how more advanced unicode attribute-access is going to go,
some quick attempts at testing yielded strange error messages from psycopg2.
- do other cross linking as mentioned in [ticket:2687].
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
the indexing.  this is for more natural operation.
- also add cast() to the JSON expression to complement astext. This integrates
the CAST call which will be needed frequently.  Part of [ticket:2687].
- it's a little unclear how more advanced unicode attribute-access is going to go,
some quick attempts at testing yielded strange error messages from psycopg2.
- do other cross linking as mentioned in [ticket:2687].
</pre>
</div>
</content>
</entry>
<entry>
<title>- make the json serializer and deserializer per-dialect, so that we are</title>
<updated>2013-12-17T22:46:09+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-12-17T22:46:09+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=fec03c88d659bf9a0b102dd328afac1ba3dc7f23'/>
<id>fec03c88d659bf9a0b102dd328afac1ba3dc7f23</id>
<content type='text'>
compatible with psycopg2's per-connection/cursor approach.  add round trip tests for
both native and non-native.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
compatible with psycopg2's per-connection/cursor approach.  add round trip tests for
both native and non-native.
</pre>
</div>
</content>
</entry>
<entry>
<title>this test appears to be failing with pg 9.3, not sure how to restore it</title>
<updated>2013-12-17T20:37:50+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-12-17T20:37:50+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=d98fcca0b3441e09c3d56ad69c93b41f9b240f0f'/>
<id>d98fcca0b3441e09c3d56ad69c93b41f9b240f0f</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>- using AssertsCompiledSQL so need __dialect__</title>
<updated>2013-12-17T20:33:27+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-12-17T20:33:27+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=e1802ff542f3d7a7d1a71befb40be65368bf7cc8'/>
<id>e1802ff542f3d7a7d1a71befb40be65368bf7cc8</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>- rework JSON expressions to be based off __getitem__ exclusively</title>
<updated>2013-12-17T20:13:39+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-12-17T20:13:39+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=73013914e7eae2a0480492ece085b48c5938dd84'/>
<id>73013914e7eae2a0480492ece085b48c5938dd84</id>
<content type='text'>
- add support for "standalone" JSON objects; this involves getting CAST
to upgrade the given type of a bound parameter.  should add a core-only test
for this.
- add tests for "standalone" json round trips both with and without unicode
- add mechanism by which we remove psycopg2's "json" handler in order to get
the effect of using our non-native result handlers
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
- add support for "standalone" JSON objects; this involves getting CAST
to upgrade the given type of a bound parameter.  should add a core-only test
for this.
- add tests for "standalone" json round trips both with and without unicode
- add mechanism by which we remove psycopg2's "json" handler in order to get
the effect of using our non-native result handlers
</pre>
</div>
</content>
</entry>
<entry>
<title>Merge branch 'issue_2581' of github.com:nathan-rice/sqlalchemy into pg_json</title>
<updated>2013-12-17T19:03:20+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-12-17T19:03:20+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=2c3afb4dcb6bedd5189ec7e5e25afaa4636be4c9'/>
<id>2c3afb4dcb6bedd5189ec7e5e25afaa4636be4c9</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title> sqlalchemy/dialects/postgresql/pgjson:</title>
<updated>2013-12-11T15:21:08+00:00</updated>
<author>
<name>nathan</name>
<email>nathan.alexander.rice@gmail.com</email>
</author>
<published>2013-12-11T15:21:08+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=015c73c83a1bd915cd34cc61370a6d89228c40d6'/>
<id>015c73c83a1bd915cd34cc61370a6d89228c40d6</id>
<content type='text'>
 - Added support for additional operators
 - Made return as json default (rather than text)
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
 - Added support for additional operators
 - Made return as json default (rather than text)
</pre>
</div>
</content>
</entry>
<entry>
<title> sqlalchemy/dialects/postgresql/pgjson:</title>
<updated>2013-12-10T15:01:51+00:00</updated>
<author>
<name>nathan</name>
<email>nathan.alexander.rice@gmail.com</email>
</author>
<published>2013-12-10T15:01:51+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=f285b3536fe01f21409e201fbeeac559ab423a9d'/>
<id>f285b3536fe01f21409e201fbeeac559ab423a9d</id>
<content type='text'>
 - Fixed reference to HSTORE
 - Corrected spelling of SQLAlchemy

 sqlalchemy/dialects/postgresql/psycopg2:
 - Added psycopg2 specific wrapper type for JSON which uses inherent json deserialization facilities
 - Added code to detect and utilize the JSON wrapper if psycopg2 &gt;= 2.5

test/dialect/postgresql/test_types:
- removed reference to use_native_hstore
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
 - Fixed reference to HSTORE
 - Corrected spelling of SQLAlchemy

 sqlalchemy/dialects/postgresql/psycopg2:
 - Added psycopg2 specific wrapper type for JSON which uses inherent json deserialization facilities
 - Added code to detect and utilize the JSON wrapper if psycopg2 &gt;= 2.5

test/dialect/postgresql/test_types:
- removed reference to use_native_hstore
</pre>
</div>
</content>
</entry>
</feed>
