summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects
Commit message (Collapse)AuthorAgeFilesLines
* cleanup exception handling - use new exception hierarchy (since python 2.5)pr/140ndparker2014-10-023-12/+4
|
* improve exception vs. exit handlingndparker2014-09-233-0/+8
|
* - Added support for the Oracle table option ON COMMIT. This is beingMike Bayer2014-09-171-2/+44
| | | | | | | | | kept separate from Postgresql's ON COMMIT for now even though ON COMMIT is in the SQL standard; the option is still very specific to temp tables and we eventually would provide a more first class temporary table feature. - oracle can apparently do get_temp_table_names() too, so implement that, fix its get_table_names(), and add it to #3204. fixes #3204 again.
* Merge branch 'sqlite-temp-table-reflection' of ↵Mike Bayer2014-09-171-10/+18
|\ | | | | | | https://bitbucket.org/jerdfelt/sqlalchemy/branch/sqlite-temp-table-reflection into pr31
| * Handle sqlite get_unique_constraints() call for temporary tablesJohannes Erdfelt2014-09-171-10/+18
| | | | | | | | | | | | | | The sqlite get_unique_constraints() implementation did not do a union against the sqlite_temp_master table like other code does. This could result in an exception being raised if get_unique_constraints() was called against a temporary table.
* | - Added :meth:`.Inspector.get_temp_table_names` andMike Bayer2014-09-171-26/+23
| | | | | | | | | | | | | | | | | | | | | | | | :meth:`.Inspector.get_temp_view_names`; currently, only the SQLite dialect supports these methods. The return of temporary table and view names has been **removed** from SQLite's version of :meth:`.Inspector.get_table_names` and :meth:`.Inspector.get_view_names`; other database backends cannot support this information (such as MySQL), and the scope of operation is different in that the tables can be local to a session and typically aren't supported in remote schemas. fixes #3204
* | Merge branch 'pr128'Mike Bayer2014-09-171-3/+35
|\ \ | |/ |/|
| * - repair get_foreign_table_names() for PGInsp/dialect levelpr128Mike Bayer2014-09-171-16/+31
| | | | | | | | | | - repair get_view_names() - changelog + migration note
| * Merge remote-tracking branch 'origin/pr/128' into pr128Mike Bayer2014-09-161-3/+20
| |\
| | * Added documentation. Changed my mind - added get_foreign_table_names() only ↵pr/128Rodrigo Menezes2014-09-051-19/+17
| | | | | | | | | | | | to PGInspect and not in the Dialect. Added tests for PGInspect and removed a bunch of the old test scaffolding.
| | * Added get_foreign_table_names to interface and put it in the test requirements.Rodrigo Menezes2014-09-051-0/+1
| | |
| | * Fixing some pep8s and adding get_foreign_tables.Rodrigo Menezes2014-09-031-2/+20
| | |
| | * Removed changes that are no longer necessary for postgresql_relkind. Also, ↵Rodrigo Menezes2014-08-261-2/+2
| | | | | | | | | | | | removed newline changes.
| | * Merge branch 'master' of https://github.com/zzzeek/sqlalchemy into ↵Rodrigo Menezes2014-08-263-11/+87
| | |\ | | | | | | | | | | | | feature/postgres-relkind
| | * | Remove relkind from construct arguments.Rodrigo Menezes2014-08-261-2/+1
| | | |
| | * | Removed all mentions to postgresql_relkindRodrigo Menezes2014-08-261-29/+9
| | | |
| | * | Add a view synonym too for consistency.Rodrigo Menezes2014-08-141-1/+2
| | | |
| | * | Merge branch 'master' of https://github.com/rclmenezes/sqlalchemyRodrigo Menezes2014-08-142-23/+73
| | |\ \
| | * | | Added support for postgres_relkind.Rodrigo Menezes2014-08-141-12/+32
| | | | |
* | | | | - Fixed the version string detection in the pymssql dialect toMike Bayer2014-09-161-1/+1
|/ / / / | | | | | | | | | | | | | | | | | | | | work with Microsoft SQL Azure, which changes the word "SQL Server" to "SQL Azure". fixes #3151
* | | | - omit MySQL index flavor if its NoneMike Bayer2014-09-051-1/+2
| | | |
* | | | - MySQL boolean symbols "true", "false" work again. 0.9's changeMike Bayer2014-09-051-0/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | in :ticket:`2682` disallowed the MySQL dialect from making use of the "true" and "false" symbols in the context of "IS" / "IS NOT", but MySQL supports this syntax even though it has no boolean type. MySQL remains "non native boolean", but the :func:`.true` and :func:`.false` symbols again produce the keywords "true" and "false", so that an expression like ``column.is_(true())`` again works on MySQL. fixes #3186
* | | | - ensure literal_binds works with LIMIT clause, FOR UPDATEMike Bayer2014-09-036-21/+21
| | | |
* | | | - The hostname-based connection format for SQL Server when usingMike Bayer2014-09-031-53/+34
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | pyodbc will no longer specify a default "driver name", and a warning is emitted if this is missing. The optimal driver name for SQL Server changes frequently and is per-platform, so hostname based connections need to specify this. DSN-based connections are preferred. fixes #3182
* | | | - updates to migration / changelog for 1.0Mike Bayer2014-08-261-1/+1
| |_|/ |/| |
* | | - mention that FOUND_ROWS is hardcoded; fixes #3146Mike Bayer2014-08-251-7/+5
| | |
* | | - pep8 formatting for pg table opts feature, testsMike Bayer2014-08-231-24/+59
| | | | | | | | | | | | | | | | | | | | | - add support for PG INHERITS - fix mis-named tests - changelog fixes #2051
* | | 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
View Lorry Controller Status