summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/postgresql/psycopg2.py
Commit message (Collapse)AuthorAgeFilesLines
...
* 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]
* - fixed numeric test for pg8000, factored out decimal/float codesMike Bayer2010-04-091-5/+5
|
* - Repaired missing import in psycopg2._PGNumeric type whenMike Bayer2010-04-071-5/+5
| | | | | | | | | | | unknown numeric is received. - psycopg2/pg8000 dialects now aware of REAL[], FLOAT[], DOUBLE_PRECISION[], NUMERIC[] return types without raising an exception. - introducing testing.provide_metadata for all these stupid little create/drop tests
* fix typoMike Bayer2010-03-261-1/+1
|
* - The psycopg2 dialect will log NOTICE messages via theMike Bayer2010-03-251-2/+28
| | | | | "sqlalchemy.dialects.postgresql" logger name. [ticket:877]
* - The visit_pool() method of Dialect is removed, and replaced withMike Bayer2010-03-151-11/+9
| | | | | | | | on_connect(). This method returns a callable which receives the raw DBAPI connection after each one is created. The callable is assembled into a first_connect/connect pool listener by the connection strategy if non-None. Provides a simpler interface for dialects.
* - name all the "sub" dialect components <DB><component>_<dialectname>, ↵Mike Bayer2010-03-141-9/+9
| | | | [ticket:1738]
* - Added an optional C extension to speed up the sql layer byGaëtan de Menten2010-02-131-13/+6
| | | | | | | | | | | | | | | reimplementing the highest impact functions. The actual speedups will depend heavily on your DBAPI and the mix of datatypes used in your tables, and can vary from a 50% improvement to more than 200%. It also provides a modest (~20%) indirect improvement to ORM speed for large queries. Note that it is *not* built/installed by default. See README for installation instructions. - The most common result processors conversion function were moved to the new "processors" module. Dialect authors are encouraged to use those functions whenever they correspond to their needs instead of implementing custom ones.
* - inline some code and turn some instance-level defaults into class levelMike Bayer2010-01-291-16/+14
|
* statement_options -> execution_optionsMike Bayer2010-01-171-4/+4
|
* - added "statement_options()" to Query, to so options can beMike Bayer2010-01-161-12/+28
| | | | | | | | | | | | | | | | | | | | | passed to the resulting statement. Currently only Select-statements have these options, and the only option used is "stream_results", and the only dialect which knows "stream_results" is psycopg2. - Query.yield_per() will set the "stream_results" statement option automatically. - Added "statement_options()" to Selects, which set statement specific options. These enable e.g. dialect specific options such as whether to enable using server side cursors, etc. - The psycopg2 now respects the statement option "stream_results". This option overrides the connection setting "server_side_cursors". If true, server side cursors will be used for the statement. If false, they will not be used, even if "server_side_cursors" is true on the connection. [ticket:1619] - added a "frozendict" from http://code.activestate.com/recipes/414283/, adding more default collections as immutable class vars on Query, Insert, Select
* - pg8000 + postgresql dialects now check for float/numeric returnMike Bayer2009-11-151-10/+25
| | | | | | | | | | types to more intelligently determine float() vs. Decimal(), [ticket:1567] - since result processing is a hot issue of late, the DBAPI type returned from cursor.description is certainly useful in cases like these to determine an efficient result processor. There's likely other result processors that can make use of it. But, backwards incompat change to result_processor(). Happy major version number..
* supports unicode binds in PG too. even without the UNICODE extension it ↵Mike Bayer2009-11-061-1/+2
| | | | seems to work now...
* - The psycopg2 dialect now uses psycopg2's "unicode extension"Mike Bayer2009-10-261-5/+40
| | | | | | | | | | | | | | | | | | on all new connections, which allows all String/Text/etc. types to skip the need to post-process bytestrings into unicode (an expensive step due to its volume). Other dialects which return unicode natively (pg8000, zxjdbc) also skip unicode post-processing. - String/Text/Unicode types now skip the unicode() check on each result column value if the dialect has detected the DBAPI as returning Python unicode objects natively. This check is issued on first connect using "SELECT CAST 'some text' AS VARCHAR(10)" or equivalent, then checking if the returned object is a Python unicode. This allows vast performance increases for native-unicode DBAPIs, including pysqlite/sqlite3, psycopg2, and pg8000.
* - DefaultRunner and subclasses have been removed. The jobMike Bayer2009-10-151-2/+2
| | | | | | | of this object has been simplified and moved into ExecutionContext. Dialects which support sequences should add a `fire_sequence()` method to their execution context implementation. [ticket:1566]
* - Inserting NULL into a primary key + foreign key columnMike Bayer2009-08-311-0/+1
| | | | | | | | | | | will allow the "not null constraint" error to raise, not an attempt to execute a nonexistent "col_id_seq" sequence. [ticket:1516] - autoincrement SELECT statements, i.e. those which select from a procedure that modifies rows, now work with server-side cursor mode (the named cursor isn't used for such statements.)
* move postgresql's % escape handling out of basePhilip Jenvey2009-08-111-1/+10
|
* merge 0.6 series to trunk.Mike Bayer2009-08-061-0/+147
View Lorry Controller Status