<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects/sqlite, branch pr/72</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>Fix unique constraints reflection in SQLite</title>
<updated>2014-02-14T12:09:21+00:00</updated>
<author>
<name>Roman Podoliaka</name>
<email>rpodolyaka@mirantis.com</email>
</author>
<published>2014-02-14T11:04:57+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=a7e0d3e1e36076e20ead9447508d99b2e477ba46'/>
<id>a7e0d3e1e36076e20ead9447508d99b2e477ba46</id>
<content type='text'>
Reflection of unique constraints didn't work properly, if reserved
identifiers had been used as column names. In this case column names
would be put in double quotes (e.g. the name of column asc would be
returned as "asc").

This issue is only present in 0.8.4 and not in 0.9.x.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Reflection of unique constraints didn't work properly, if reserved
identifiers had been used as column names. In this case column names
would be put in double quotes (e.g. the name of column asc would be
returned as "asc").

This issue is only present in 0.8.4 and not in 0.9.x.
</pre>
</div>
</content>
</entry>
<entry>
<title>- backport unique constraints reflection to 0.8.4, thereby</title>
<updated>2013-12-03T19:59:50+00:00</updated>
<author>
<name>Roman Podolyaka</name>
<email>roman.podolyaka@gmail.com</email>
</author>
<published>2013-06-09T16:07:00+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=e8458ab96b1bda5f139d34a24808167dd1f590c6'/>
<id>e8458ab96b1bda5f139d34a24808167dd1f590c6</id>
<content type='text'>
assisting with alembic installations that have upgraded and are dealing with
PG index/unique constraint reflection.

Inspection API already supports reflection of table
indexes information and those also include unique
constraints (at least for PostgreSQL and MySQL).
But it could be actually useful to distinguish between
indexes and plain unique constraints (though both are
implemented in the same way internally in RDBMS).

This change adds a new method to Inspection API - get_unique_constraints()
and implements it for SQLite, PostgreSQL and MySQL dialects.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
assisting with alembic installations that have upgraded and are dealing with
PG index/unique constraint reflection.

Inspection API already supports reflection of table
indexes information and those also include unique
constraints (at least for PostgreSQL and MySQL).
But it could be actually useful to distinguish between
indexes and plain unique constraints (though both are
implemented in the same way internally in RDBMS).

This change adds a new method to Inspection API - get_unique_constraints()
and implements it for SQLite, PostgreSQL and MySQL dialects.
</pre>
</div>
</content>
</entry>
<entry>
<title>move FAQ to the docs, [ticket:2133]</title>
<updated>2013-08-21T22:49:34+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-08-21T22:48:34+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=09b93477d26e8298c255b98eb0d6371839bbfa87'/>
<id>09b93477d26e8298c255b98eb0d6371839bbfa87</id>
<content type='text'>
Conflicts:
	doc/build/index.rst
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Conflicts:
	doc/build/index.rst
</pre>
</div>
</content>
</entry>
<entry>
<title>doc fix</title>
<updated>2013-07-13T02:02:13+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-07-13T02:01:58+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=4018a03e7a0b5a84b56e9aca19deca64c1295b59'/>
<id>4018a03e7a0b5a84b56e9aca19deca64c1295b59</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>The newly added SQLite DATETIME arguments storage_format and</title>
<updated>2013-07-13T01:53:28+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-07-13T01:52:54+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=2edc13a6b82b264beba0b20f96f252d7b7a96f28'/>
<id>2edc13a6b82b264beba0b20f96f252d7b7a96f28</id>
<content type='text'>
regexp apparently were not fully implemented correctly; while the
arguments were accepted, in practice they would have no effect;
this has been fixed.
[ticket:2781]
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
regexp apparently were not fully implemented correctly; while the
arguments were accepted, in practice they would have no effect;
this has been fixed.
[ticket:2781]
</pre>
</div>
</content>
</entry>
<entry>
<title>Added :class:`.BIGINT` to the list of type names that can be</title>
<updated>2013-07-02T22:11:31+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-07-02T22:10:08+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=2180cf44e5856bc4be6cf5b125b8672b2158ffa2'/>
<id>2180cf44e5856bc4be6cf5b125b8672b2158ffa2</id>
<content type='text'>
reflected by the SQLite dialect; courtesy Russell Stuart.
[ticket:2764]
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
reflected by the SQLite dialect; courtesy Russell Stuart.
[ticket:2764]
</pre>
</div>
</content>
</entry>
<entry>
<title>Removes an errant space character that caused a newline break in the sphinx output.</title>
<updated>2013-01-17T22:31:07+00:00</updated>
<author>
<name>Taavi Burns</name>
<email>taavi.burns@gmail.com</email>
</author>
<published>2013-01-17T22:31:07+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=cfb037cfb1e8fe9b2976462f1c58da3c2573b4c7'/>
<id>cfb037cfb1e8fe9b2976462f1c58da3c2573b4c7</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>:class:`.Index` now supports arbitrary SQL expressions and/or</title>
<updated>2013-01-17T02:04:32+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-01-17T02:04:32+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=7fedf9958687222a9e3c2fc4d50983711dbb3d52'/>
<id>7fedf9958687222a9e3c2fc4d50983711dbb3d52</id>
<content type='text'>
functions, in addition to straight columns.   Common modifiers
include using ``somecolumn.desc()`` for a descending index and
``func.lower(somecolumn)`` for a case-insensitive index, depending on the
capabilities of the target backend.
[ticket:695]
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
functions, in addition to straight columns.   Common modifiers
include using ``somecolumn.desc()`` for a descending index and
``func.lower(somecolumn)`` for a case-insensitive index, depending on the
capabilities of the target backend.
[ticket:695]
</pre>
</div>
</content>
</entry>
<entry>
<title>happy new year (see #2645)</title>
<updated>2013-01-01T18:46:21+00:00</updated>
<author>
<name>Diana Clarke</name>
<email>diana.joan.clarke@gmail.com</email>
</author>
<published>2013-01-01T18:46:21+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=5db55c999faae04ca338b0d4b034b3b99e0ca3fa'/>
<id>5db55c999faae04ca338b0d4b034b3b99e0ca3fa</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>this comment is entirely from some ancient version of the code</title>
<updated>2012-12-14T15:33:23+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2012-12-14T15:33:23+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=3765920b77554d265d08dc5fdaea3ac9309865db'/>
<id>3765920b77554d265d08dc5fdaea3ac9309865db</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
