summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/postgresql/psycopg2.py
Commit message (Collapse)AuthorAgeFilesLines
* Add AUTOCOMMIT isolation level support for psycopg2pr/7Roman Podolyaka2013-06-151-0/+1
| | | | | | | | | | | | | | One can use this to emit statements, which can not be executed within a transaction (e. g. CREATE DATABASE): from sqlalchemy import create_engine eng = create_engine('postgresql://test:test@localhost/test') conn = eng.connect().execution_options(isolation_level='AUTOCOMMIT') conn.execute('CREATE DATABASE test2;') Fixes issue #2072.
* - repair for py3kMike Bayer2013-05-291-1/+6
| | | | - fix test
* Unicode support for psycopg2 native hstore implementationDmitry Mugtasimov2013-05-291-1/+2
|
* postgresql dialect testsMike Bayer2013-04-281-14/+13
|
* - the raw 2to3 runMike Bayer2013-04-271-15/+15
| | | | - went through examples/ and cleaned out excess list() calls
* - only search in the exception before the first newline, to avoidMike Bayer2013-04-231-2/+3
| | | | false positives for SQL statements containing certain text
* Opened up the checking for "disconnect" with psycopg2/libpqMike Bayer2013-04-221-18/+21
| | | | | | | | to check for all the various "disconnect" messages within the full exception hierarchy. Specifically the "closed the connection unexpectedly" message has now been seen in at least three different exception types. [ticket:2712]
* - remove all compat items that are pre-2.5 (hooray)Mike Bayer2013-03-091-1/+1
| | | | | | - other cleanup - don't need compat.decimal, that approach never panned out. hopefully outside libs aren't pulling it in, they shouldn't be
* happy new year (see #2645)Diana Clarke2013-01-011-1/+1
|
* just a pep8 pass of lib/sqlalchemy/dialects/postgresqlDiana Clarke2012-11-191-18/+24
|
* - hstore adjustmentsMike Bayer2012-11-171-20/+46
|
* Register HStore adapter and typecaster in psycopg2 dialectAudrius Kažukauskas2012-11-151-0/+26
|
* - rework the sphinx customizations into distinct modulesMike Bayer2012-10-191-17/+6
| | | | | | | - build a new Sphinx extension that allows dialect info to be entered as directives which is then rendered consistently throughout all dialect/dbapi sections - break out the "empty_strings" requirement for oracle test
* - move out maxdbMike Bayer2012-10-181-3/+7
| | | | | | - begin consolidating docs for dialects to be more self contained - add a separate section for "external" dialects - not sure how we're going to go with this yet.
* - [bug] Added 'terminating connection' to the listMike Bayer2012-09-251-1/+2
| | | | | | of messages we use to detect a disconnect with PG, which appears to be present in some versions when the server is restarted. [ticket:2570]
* - update all the visit_mod() functions with new naming schemeMike Bayer2012-08-141-2/+3
| | | | | | - visit_mods all seemed to not propagate **kw down to process(). this is [ticket:2548] which may be backported to 0.7 pending a test case to illustrate wrong behavior.
* - update engine docstrings due to moveMike Bayer2012-08-131-1/+1
| | | | - struggle with Operators class autodoc
* - break out engine/base.py into base, interfaces, result, util.Mike Bayer2012-08-071-3/+3
| | | | - remove deprecated 0.7 engine methods
* more import cleanupsMike Bayer2012-08-071-7/+7
|
* trailing whitespace bonanzaMike Bayer2012-07-281-27/+27
|
* - a big renaming of all the _Underscore classes to haveMike Bayer2012-07-171-1/+1
| | | | | | plain names. The old names are still defined for backwards compatibility. - _BindParamClause renamed to BindParameter
* Add some `Sphinx` paragraph level versions informations markups,Mike Bayer2012-06-081-2/+3
| | | | such as ``.. versionadded::``, ``.. versionchanged::`` and ``.. deprecated::``.
* - break out sample URLs into individual, per-database sections each with a linkMike Bayer2012-02-121-0/+20
| | | | | to the dialect page. - add a section for unix domain sockets under psycopg2 [ticket:2393]
* - [feature] Added support for the "isolation_level"Mike Bayer2012-02-121-0/+2
| | | | | | | parameter to all MySQL dialects. Thanks to mu_mind for the patch here. [ticket:2394] - add documentation examples for mysql, postgresql - pep8ing
* happy new yearMike Bayer2012-01-041-1/+1
|
* emergency rewrite of the psycopg2 unicode sectionMike Bayer2011-11-291-24/+30
|
* - Added client_encoding parameter to create_engine()Mike Bayer2011-10-151-9/+35
| | | | | | when the postgresql+psycopg2 dialect is used; calls the psycopg2 set_client_encoding() method with the value upon connect. [ticket:1839]
* - use itertools.count() plus mutex for Query _new_runid, psycopg2 serverMike Bayer2011-08-061-2/+3
| | | | side cursor names, mentinoed in [ticket:2247]
* - Fixed the psycopg2_version parsing in theMike Bayer2011-04-181-2/+5
| | | | psycopg2 dialect.
* no idea what "auto-commit" means here. some reorg.Mike Bayer2011-04-151-36/+37
|
* - no encoding with arraysMike Bayer2011-04-081-0/+2
| | | | - rework the "builtin types" thing with the ReplayableSession to be py3k compatible
* - more liberal check hereMike Bayer2011-04-081-0/+2
| | | | - dont encode enums in py3k
* - assume in py3k that description encoding is None unless the dialect reallyMike Bayer2011-04-081-0/+2
| | | | | overrides it - psycopg2 + 3k supports unicode statements...
* - add connection and cursor to is_disconnect(). We aren't using it yet,Mike Bayer2011-02-091-1/+7
| | | | | | | | | | | | | | | but we'd like to. Most DBAPIs don't give us anything we can do with it. Some research was done on psycopg2 and it still seems like they give us no adequate method (tried connection.closed, cursor.closed, connection.status). mxodbc claims their .closed attribute will work (but I am skeptical). - remove beahvior in pool that auto-invalidated a connection when the cursor failed to create. That's not the pool's job. we need the conn for the error logic. Can't get any tests to fail, curious why that behavior was there, guess we'll find out (or not). - add support for psycopg2 version detection. even though we have no use for it yet... - adjust one of the reconnect tests to work with oracle's horrendously slow connect speed
* - Added an additional libpq message to the list of "disconnect"Mike Bayer2011-02-091-3/+11
| | | | | exceptions, "could not receive data from server" [ticket:2044]
* - execution_options() on Connection acceptsMike Bayer2011-01-161-12/+18
| | | | | | | | | | "isolation_level" argument, sets transaction isolation level for that connection only until returned to the connection pool, for thsoe backends which support it (SQLite, Postgresql) [ticket:2001] - disallow the option on Engine (use isolation_level to create_engine()), Executable (we don't want to check/set per statement) - docs
* - factor consistent set_isolation_level(), get_isolation_level()Mike Bayer2011-01-161-11/+20
| | | | | | per-connection methods for sqlite, postgresql, psycopg2 dialects - move isolation test suite to test engines/test_transaction - preparing for [ticket:2001]
* - whitespace removal bonanzaMike Bayer2011-01-021-8/+8
|
* - clean up copyright, update for 2011, stamp every file withMike Bayer2011-01-021-0/+6
| | | | | a consistent tag - AUTHORS file
* merge tipMichael Trier2010-12-191-2/+2
|\
| * more inlinesMike Bayer2010-12-191-2/+2
| |
* | Ridding the world of a few wasteful imports.Michael Trier2010-12-191-2/+1
|/
* - support for cdecimalMike Bayer2010-12-111-1/+1
| | | | | | | | | | | | | | | | | | - add --with-cdecimal flag to tests, monkeypatches cdecimal in - fix mssql/pyodbc.py to not use private '_int' accessor in decimal conversion routines - pyodbc version 2.1.8 is needed for cdecimal in any case as previous versions also called '_int', 2.1.8 adds the same string logic as our own dialect, so that logic is skipped for modern pyodbc version - make the imports for "Decimal" consistent across the whole lib. not sure yet how we should be importing "Decimal" or what the best way forward is that would allow a clean user-invoked swap of cdecimal; for now, added docs suggesting a global monkeypatch - the two decimal libs are not compatible with each other so any chance of mixing produces serious issues. adding adapters to DBAPIs tedious and adds in-python overhead. suggestions welcome on how we should be doing Decimal/cdecimal.
* merge tipMike Bayer2010-11-181-6/+9
|\
| * - Ensured every numeric, float, int code, scalar + array,Mike Bayer2010-11-181-6/+9
| | | | | | | | | | are recognized by psycopg2 and pg8000's "numeric" base type. [ticket:1955]
* | - initial patch for [ticket:1926]Mike Bayer2010-11-171-0/+1
|/
* - Fixed the psycopg2 dialect to use itsMike Bayer2010-08-101-13/+58
| | | | | | | set_isolation_level() method instead of relying upon the base "SET SESSION ISOLATION" command, as psycopg2 resets the isolation level on each new transaction otherwise.
* - PG doc updatesMike Bayer2010-07-131-1/+1
| | | | | | - pypostgresql has 15 errors, 3 failures, this probably puts it in the "yes" as opposed to the "partial" support category. [ticket:1850]
* add a note about native unicode mode, [ticket:1792]Mike Bayer2010-05-081-0/+5
|
* place docs for DBAPI-agnostic transaction_isolation setting for sqlite, pg ↵Mike Bayer2010-04-301-3/+0
| | | | [ticket:1784]
View Lorry Controller Status