summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects
Commit message (Collapse)AuthorAgeFilesLines
* Adding postgres create table options documentationpr/129Malik Diarra2014-08-171-0/+16
|
* Correcting options name from withoids to with_oidsMalik Diarra2014-08-171-3/+3
|
* quoting tablespace name in create table command in postgresql dialectMalik Diarra2014-08-171-1/+2
|
* Adding oids and on_commit table optionsMalik Diarra2014-08-171-1/+11
|
* Adding a tablespace options for postgresql create tableMalik Diarra2014-08-171-1/+9
|
* - changelog for pullreq github:125Mike Bayer2014-08-161-0/+10
| | | | - add pg8000 version detection for the "sane multi rowcount" feature
* Merge remote-tracking branch 'origin/pr/125' into pr125Mike Bayer2014-08-161-3/+1
|\
| * pg8000 now supports sane_multi_rowcountpr/125Tony Locke2014-08-021-1/+1
| | | | | | | | | | From pg8000-1.9.14 sane_multi_rowcount is supported so this commit updates the dialect accordingly.
| * Remove spurious print statements in pg8000 dialectTony Locke2014-08-021-2/+0
| |
* | Merge branch 'pr126'Mike Bayer2014-08-132-23/+73
|\ \ | | | | | | | | | | | | Conflicts: doc/build/changelog/changelog_10.rst
| * | - public method name is get_enums()Mike Bayer2014-08-131-26/+67
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - return a list of dicts like other methods do - don't combine 'schema' with 'name', leave them separate - support '*' argument so that we can retrieve cross-schema if needed - remove "conn" argument - use bound parameters for 'schema' in SQL - order by schema, name, label - adapt _load_enums changes to column reflection - changelog - module docs for get_enums() - add drop of enums to --dropfirst
| * | Public inspector method to load enum listpr/126Ilya Pekelny2014-08-081-2/+10
| | | | | | | | | | | | | | | Provide opportunity to get enums list via an inspector instance public interface.
| * | DropEnumType class available from postgres dialectIlya Pekelny2014-08-081-2/+3
| | |
* | | - rewrite all the sqlite/pysqlite transaction isolation docsMike Bayer2014-08-093-50/+156
|/ /
* | -Fixed bug where Postgresql JSON type was not able to persist orMike Bayer2014-08-071-0/+29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | otherwise render a SQL NULL column value, rather than a JSON-encoded ``'null'``. To support this case, changes are as follows: * The value :func:`.null` can now be specified, which will always result in a NULL value resulting in the statement. * A new parameter :paramref:`.JSON.none_as_null` is added, which when True indicates that the Python ``None`` value should be peristed as SQL NULL, rather than JSON-encoded ``'null'``. Retrival of NULL as None is also repaired for DBAPIs other than psycopg2, namely pg8000. fixes #3159
* | - add some docs to try to explain the behavior with MySQL / TIMESTAMP.Mike Bayer2014-08-041-0/+91
|/ | | | ref #3155
* Merge remote-tracking branch 'origin/pr/117' into pg8000Mike Bayer2014-07-251-0/+19
|\
| * Fix support for two phase commit in pg8000 dialectTony Locke2014-07-191-0/+19
| | | | | | | | | | | | | | The postgresql base dialect has problems with two-phase commit because there isn't a standard way of handling autocommit in DBAPI. This commit modifies the pg8000 dialect to use the DBAPI tpc extension, which is supported by pg8000 as of version 1.9.11.
* | Merge remote-tracking branch 'origin/pr/124' into issue3141Mike Bayer2014-07-251-1/+1
|\ \
| * | Fix argument to array() in array._bind_param()pr/124Andrew2014-07-241-1/+1
| | | | | | | | | array.__init__() expects a list as its sole parameter but inside _bind_param(), instead of sending a list it's sending each item in the list as a separate argument which is incorrect.
* | | - The MySQL dialect will now disable :meth:`.ConnectionEvents.handle_error`Mike Bayer2014-07-251-3/+6
|/ / | | | | | | | | | | | | | | | | | | events from firing for those statements which it uses internally to detect if a table exists or not. This is achieved using an execution option ``skip_user_error_events`` that disables the handle error event for the scope of that execution. In this way, user code that rewrites exceptions doesn't need to worry about the MySQL dialect or other dialects that occasionally need to catch SQLAlchemy specific exceptions.
* | - update some SQL server tests, supportMike Bayer2014-07-221-1/+17
| | | | | | | | - add support for IDENTITY INSERT setting for INSERT with inline VALUES
* | - Fixed bug introduced in 0.9.5 by new pg8000 isolation level featureMike Bayer2014-07-211-2/+6
| | | | | | | | | | where engine-level isolation level parameter would raise an error on connect. fixes #3134
* | - apply pep8 formatting to sqlalchemy/sql, sqlalchemy/util, sqlalchemy/dialects,Brian Jarrett2014-07-2041-1483/+1794
|/ | | | sqlalchemy/orm, sqlalchemy/event, sqlalchemy/testing
* - Fixed a regression from 0.9.5 caused by :ticket:`3025` where theMike Bayer2014-07-141-0/+3
| | | | | | | query used to determine "default schema" is invalid in SQL Server 2000. For SQL Server 2000 we go back to defaulting to the "schema name" parameter of the dialect, which is configurable but defaults to 'dbo'. fixes #3025
* - Added statement encoding to the "SET IDENTITY_INSERT"Mike Bayer2014-07-141-6/+12
| | | | | | | | | statements which operate when an explicit INSERT is being interjected into an IDENTITY column, to support non-ascii table identifiers on drivers such as pyodbc + unix + py2k that don't support unicode statements. ref #3091 as this fix is also in that issue's patch, but is a different issue.
* - In the SQL Server pyodbc dialect, repaired the implementationMike Bayer2014-07-141-1/+2
| | | | | | | | | for the ``description_encoding`` dialect parameter, which when not explicitly set was preventing cursor.description from being parsed correctly in the case of result sets that contained names in alternate encodings. This parameter shouldn't be needed going forward. fixes #3091
* - Fixed bug in :class:`.Enum` and other :class:`.SchemaType`Mike Bayer2014-07-131-2/+1
| | | | | | | subclasses where direct association of the type with a :class:`.MetaData` would lead to a hang when events (like create events) were emitted on the :class:`.MetaData`. fixes #3124
* - break up the <authors> copyright comment as part of a passMike Bayer2014-07-0945-45/+90
| | | | to get all flake8 passing
* - Changed the default value of "raise_on_warnings" to False forMike Bayer2014-07-091-1/+3
| | | | | | | | MySQLconnector. This was set at True for some reason. The "buffered" flag unfortunately must stay at True as MySQLconnector does not allow a cursor to be closed unless all results are fully fetched. fixes #2515 - lots of MySQL tests seemed to not be hitting all backends, so we should be getting some mysqlconnector failures now
* - add postgresql_regconfig argument to PG dialect for match() operator,jonathan vanasco2014-07-081-5/+57
| | | | implements PG's to_tsquery('regconfig', 'arg') pattern. fixes #3078
* Merge pull request #101 from ddimmich/mastermike bayer2014-07-073-3/+126
|\ | | | | Postgres 9.4 Jsonb support
| * jsonb support for <@, ?| and ?& added.pr/101Damian Dimmich2014-07-011-1/+18
| | | | | | | | need to see if equality already works.
| * minor cleanup of the jsonb - had extraneous operators that where copiedDamian Dimmich2014-06-281-5/+1
| | | | | | | | | | | | from hstore that don't apply. Add tests for ? and @> operators.
| * add has_key & contains operators for jsonb (ported over from hstore)Damian Dimmich2014-06-281-21/+17
| |
| * initial support for JSONB - this only allows you to define the JSONBDamian Dimmich2014-06-243-3/+117
| | | | | | | | | | datatype - this does not add any of the additional support for querying/indexing yet.
* | Merge pull request #98 from abbec/mssql2008-multivalues-insertmike bayer2014-07-061-0/+2
|\ \ | | | | | | Fixed support for multivalue inserts for MS SQL 2008
| * | - Fixed support for multivalue inserts for MS SQL 2008 since it is actually ↵pr/98Albert Cervin2014-06-161-0/+2
| | | | | | | | | | | | supported.
* | | - clarify that the pg8000 backend has no impact of any kind onMike Bayer2014-07-041-8/+9
| | | | | | | | | | | | the pg8000 DBAPI's encoding behavior, fixes #3112.
* | | - add link to dialect docs for SQLite autoincrement from column autoincrement,Mike Bayer2014-07-031-2/+4
| | | | | | | | | | | | fixes #3110
* | | - MySQL error 2014 "commands out of sync" appears to be raised as aMike Bayer2014-06-271-1/+1
| | | | | | | | | | | | | | | | | | | | | ProgrammingError, not OperationalError, in modern MySQL-Python versions; all MySQL error codes that are tested for "is disconnect" are now checked within OperationalError and ProgrammingError regardless. fixes #3101
* | | - write some really complete docs on MSSQL autoincrement, fixes #3094Mike Bayer2014-06-241-10/+132
| |/ |/|
* | - Added a new type :class:`.postgresql.OID` to the Postgresql dialect.Mike Bayer2014-06-202-2/+15
| | | | | | | | | | | | | | | | While "oid" is generally a private type within PG that is not exposed in modern versions, there are some PG use cases such as large object support where these types might be exposed, as well as within some user-reported schema reflection use cases. fixes #3002
* | - Fixed bug where column names added to ``mysql_length`` parameterMike Bayer2014-06-181-3/+7
|/ | | | | | | | on an index needed to have the same quoting for quoted names in order to be recognized. The fix makes the quotes optional but also provides the old behavior for backwards compatibility with those using the workaround. fixes #3085
* - remove drizzle dialectMike Bayer2014-05-305-589/+123
| | | | | - restore mysqldb fully within dialects/mysql/, it's no longer a connector. fixes #2984
* - changelog + docs for pg8000 transaction isolation levelMike Bayer2014-05-303-2/+39
|
* Merge branch 'master' of https://github.com/tlocke/sqlalchemy into tlocke-masterMike Bayer2014-05-301-21/+40
|\
| * PEP 8 tidy of pg8000 dialect and postgresql/test_dialect.pypr/88Tony Locke2014-05-221-14/+11
| |
| * Autocommit isolation level for postgresql+pg8000Tony Locke2014-05-221-0/+24
| | | | | | | | | | | | | | | | As with postgresql+psycopg2, execution_options(isolation_level='AUTOCOMMIT') now works for the postgresql+pg8000 dialect. Also enabled the autocommit test in test_dialect.py for pg8000.
| * Updated doc string for postgresql+pg8000 dialectTony Locke2014-05-211-10/+8
| |
View Lorry Controller Status