<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/sqlalchemy.git/test/dialect/postgresql/test_reflection.py, branch pr/169</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>- Fixed bug where updated PG index reflection as a result of</title>
<updated>2015-04-01T20:50:32+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2015-04-01T20:50:32+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=4b164935481c44c126500761f873c5b0c5bdbe80'/>
<id>4b164935481c44c126500761f873c5b0c5bdbe80</id>
<content type='text'>
:ticket:`3184` would cause index operations to fail on Postgresql
versions 8.4 and earlier.  The enhancements are now
disabled when using an older version of Postgresql.
fixes #3343
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
:ticket:`3184` would cause index operations to fail on Postgresql
versions 8.4 and earlier.  The enhancements are now
disabled when using an older version of Postgresql.
fixes #3343
</pre>
</div>
</content>
</entry>
<entry>
<title>- The :meth:`.PGDialect.has_table` method will now query against</title>
<updated>2014-12-04T17:01:19+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-12-04T17:01:19+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=87bfcf91e9659893f17adf307090bc0a4a8a8f23'/>
<id>87bfcf91e9659893f17adf307090bc0a4a8a8f23</id>
<content type='text'>
``pg_catalog.pg_table_is_visible(c.oid)``, rather than testing
for an exact schema match, when the schema name is None; this
so that the method will also illustrate that temporary tables
are present.  Note that this is a behavioral change, as Postgresql
allows a non-temporary table to silently overwrite an existing
temporary table of the same name, so this changes the behavior
of ``checkfirst`` in that unusual scenario.
fixes #3264
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
``pg_catalog.pg_table_is_visible(c.oid)``, rather than testing
for an exact schema match, when the schema name is None; this
so that the method will also illustrate that temporary tables
are present.  Note that this is a behavioral change, as Postgresql
allows a non-temporary table to silently overwrite an existing
temporary table of the same name, so this changes the behavior
of ``checkfirst`` in that unusual scenario.
fixes #3264
</pre>
</div>
</content>
</entry>
<entry>
<title>- use provide_metadata for new unique constraint / index tests</title>
<updated>2014-10-04T23:06:35+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-10-04T22:57:01+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=b510b990947cb8e461df8877ca0f011542b7a319'/>
<id>b510b990947cb8e461df8877ca0f011542b7a319</id>
<content type='text'>
- add a test for PG reflection of unique index without any unique
constraint
- for PG, don't include 'duplicates_constraint' in the entry
if the index does not actually mirror a constraint
- use a distinct method for unique constraint reflection within table
- catch unique constraint not implemented condition; this may
be within some dialects and also is expected to be supported by
Alembic tests
- migration + changelogs for #3184
- add individual doc notes as well to MySQL, Postgreql
fixes #3184
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
- add a test for PG reflection of unique index without any unique
constraint
- for PG, don't include 'duplicates_constraint' in the entry
if the index does not actually mirror a constraint
- use a distinct method for unique constraint reflection within table
- catch unique constraint not implemented condition; this may
be within some dialects and also is expected to be supported by
Alembic tests
- migration + changelogs for #3184
- add individual doc notes as well to MySQL, Postgreql
fixes #3184
</pre>
</div>
</content>
</entry>
<entry>
<title>Reflect unique constraints when reflecting a Table object</title>
<updated>2014-09-17T20:19:50+00:00</updated>
<author>
<name>Johannes Erdfelt</name>
<email>johannes@erdfelt.com</email>
</author>
<published>2014-09-10T14:37:59+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=7fa21b22989f6d53ff70a8df71fc6d210c556e07'/>
<id>7fa21b22989f6d53ff70a8df71fc6d210c556e07</id>
<content type='text'>
Calls to reflect a table did not create any UniqueConstraint objects.
The reflection core made no calls to get_unique_constraints and as
a result, the sqlite dialect would never reflect any unique constraints.

MySQL transparently converts unique constraints into unique indexes, but
SQLAlchemy would reflect those as an Index object and as a
UniqueConstraint. The reflection core will now deduplicate the unique
constraints.

PostgreSQL would reflect unique constraints as an Index object and as
a UniqueConstraint object. The reflection core will now deduplicate
the unique indexes.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Calls to reflect a table did not create any UniqueConstraint objects.
The reflection core made no calls to get_unique_constraints and as
a result, the sqlite dialect would never reflect any unique constraints.

MySQL transparently converts unique constraints into unique indexes, but
SQLAlchemy would reflect those as an Index object and as a
UniqueConstraint. The reflection core will now deduplicate the unique
constraints.

PostgreSQL would reflect unique constraints as an Index object and as
a UniqueConstraint object. The reflection core will now deduplicate
the unique indexes.
</pre>
</div>
</content>
</entry>
<entry>
<title>- repair get_foreign_table_names() for PGInsp/dialect level</title>
<updated>2014-09-17T17:11:22+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-09-17T17:11:22+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=be57def4b909a447b10fff21bf957c804132b5ec'/>
<id>be57def4b909a447b10fff21bf957c804132b5ec</id>
<content type='text'>
- repair get_view_names()
- changelog + migration note
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
- repair get_view_names()
- changelog + migration note
</pre>
</div>
</content>
</entry>
<entry>
<title>- the actual round trip requires password authent set up for the user;</title>
<updated>2014-09-17T16:41:08+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-09-17T16:41:08+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=414bc1c64d05c8a5a26043e707c9c0013100ce4b'/>
<id>414bc1c64d05c8a5a26043e707c9c0013100ce4b</id>
<content type='text'>
we don't actually need a round trip test here as we're only testing reflection.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
we don't actually need a round trip test here as we're only testing reflection.
</pre>
</div>
</content>
</entry>
<entry>
<title>- break out and fix tests for materialized view and foreign tables.  foreign tables not working</title>
<updated>2014-09-16T21:24:34+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-09-16T21:24:34+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=8546153d5d0371e452e85b5f10232d75bce04976'/>
<id>8546153d5d0371e452e85b5f10232d75bce04976</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Added documentation. Changed my mind - added get_foreign_table_names() only to PGInspect and not in the Dialect. Added tests for PGInspect and removed a bunch of the old test scaffolding.</title>
<updated>2014-09-05T17:54:48+00:00</updated>
<author>
<name>Rodrigo Menezes</name>
<email>rodrigo.menezes@moat.com</email>
</author>
<published>2014-09-05T17:54:48+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=fd2faa9bc2c6d2d1b0b8e1738f0bce21e2527bb0'/>
<id>fd2faa9bc2c6d2d1b0b8e1738f0bce21e2527bb0</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Fixing some pep8s and adding get_foreign_tables.</title>
<updated>2014-09-03T20:38:43+00:00</updated>
<author>
<name>Rodrigo Menezes</name>
<email>rodrigo.menezes@moat.com</email>
</author>
<published>2014-09-03T20:38:43+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=fbd2d70a5cfd7b5c219c51cb5b7866c4ab89cece'/>
<id>fbd2d70a5cfd7b5c219c51cb5b7866c4ab89cece</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Removed all mentions to postgresql_relkind</title>
<updated>2014-08-26T16:53:34+00:00</updated>
<author>
<name>Rodrigo Menezes</name>
<email>rodrigo.menezes@moat.com</email>
</author>
<published>2014-08-26T16:53:34+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=2f7dce1d6fa43e88f64c81b6e612fbc42235fddd'/>
<id>2f7dce1d6fa43e88f64c81b6e612fbc42235fddd</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
