summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects
Commit message (Collapse)AuthorAgeFilesLines
* 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.
* - 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
| |
| * pg8000.dbapi is now just pg8000Tony Locke2014-05-211-1/+1
| |
* | update commentsMike Bayer2014-05-301-4/+6
| |
* | Merge branch 'psycopg_disconnect' of https://github.com/dirkmueller/sqlalchemyMike Bayer2014-05-301-1/+5
|\ \
| * | Another Variant for detecting if a connection is closedpr/87Dirk Mueller2014-05-111-1/+5
| | | | | | | | | | | | | | | | | | | | | If there is a closed attribute on the connection and it is true, return true. Implements a todo in the code and helps in one specific disconnect case where it previously did not match because the error message was "unknown error".
* | | - Added the ``hashable=False`` flag to the PG :class:`.HSTORE` type, whichMike Bayer2014-05-251-0/+1
| | | | | | | | | | | | | | | | | | is needed to allow the ORM to skip over trying to "hash" an ORM-mapped HSTORE column when requesting it in a mixed column/entity list. Patch courtesy Gunnlaugur Þór Briem. Fixes #3053
* | | - repair oracle compilation for new limit/offset system.Mike Bayer2014-05-241-15/+26
| | |
* | | - fix some identity map accessorsMike Bayer2014-05-241-1/+1
| | | | | | | | | | | | - fix a bad comparison in MySQL w/ limit/offset thing
* | | - more tests, including backend testsMike Bayer2014-05-161-17/+34
| | | | | | | | | | | | - implement for SQL server, use window functions when simple limit/offset not available
* | | Merge branch 'issue_3034' of ↵Mike Bayer2014-05-167-40/+44
|\ \ \ | |_|/ |/| | | | | https://bitbucket.org/dobesv/sqlalchemy/branch/issue_3034 into ticket_3034
| * | Remove unused importDobes Vandermeer2014-04-251-1/+0
| | |
| * | Remove unused importDobes Vandermeer2014-04-251-1/+0
| | |
| * | Pull out offset/limit to a local variable to reduce the impact of the ↵Dobes Vandermeer2014-04-251-8/+10
| | | | | | | | | | | | inefficient select._offset and select._limit operations.
| * | Remove unused importDobes Vandermeer2014-04-251-1/+0
| | |
| * | Use _offset_clause and _limit_clause, which are always Visitable and usually ↵Dobes Vandermeer2014-04-255-25/+26
| | | | | | | | | | | | a BindParameter, instead of _offset and _limit in GenerativeSelect.
| * | Extract limit/offset to variablesDobes Vandermeer2014-04-251-5/+7
| | |
| * | Proof-of-concept implementation of supporting bindparam for offset and limit ↵Dobes Vandermeer2014-04-243-7/+9
| | | | | | | | | | | | on a query.
* | | - changelog for #2785Mike Bayer2014-05-161-3/+6
| | | | | | | | | | | | | | | - refactor tests a bit fixes #2785
* | | Merge branch 'zero_indexes-param-for-postgresql-ARRAY-type' of ↵Mike Bayer2014-05-161-1/+16
|\ \ \ | | | | | | | | | | | | https://bitbucket.org/LevonXXL/sqlalchemy/overview into t
| * | | zero_indexes-param-for-postgresql-ARRAY-typeAlexey Terentev2014-05-131-1/+16
| | | |
* | | | Merged in mineo/sqlalchemy/mineo/posgtresql-postgresql-1399232068499 (pull ↵Mike Bayer2014-05-121-1/+1
|\ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | request #17) Posgtresql -> PostgreSQL
| * | | | Posgtresql -> PostgreSQLWieland Hoffmann2014-05-041-1/+1
| | |_|/ | |/| |
* | | | Merged in WSMcG/sqlalchemy (pull request #15) Mike Bayer2014-05-121-1/+1
|\ \ \ \ | |_|/ / |/| | | Added optional '=' to MySQL KEY_BLOCK_SIZE regex
| * | | Added optional '=' to MySQL KEY_BLOCK_SIZE regexW. Sean McGivern2014-04-191-1/+1
| | |/ | |/|
* | | Documentation fix-up: "its" vs. "it's"pr/91Matthias Urlichs2014-05-114-4/+4
| |/ |/| | | | | | | | | | | | | | | Removed ungrammatical apostrophes from documentation, replacing "it's" with "its" where appropriate (but in a few cases with "it is" when that read better). While doing that, I also fixed a couple of minor typos etc. as I noticed them.
* | Fix many typos throughout the codebasepr/85Alex Gaynor2014-04-267-13/+13
|/ | | | Found using: https://github.com/intgr/topy
* - Revised the query used to determine the current default schema nameMike Bayer2014-04-171-14/+8
| | | | | | | to use the ``database_principal_id()`` function in conjunction with the ``sys.database_principals`` view so that we can determine the default schema independently of the type of login in progress (e.g., SQL Server, Windows, etc). fixes #3025
* added an SSL related connection errorantti_haapala2014-04-111-1/+3
|
* - Fixed ORM bug where changing the primary key of an object, then markingMike Bayer2014-03-281-1/+4
| | | | | | | | | | | | | it for DELETE would fail to target the correct row for DELETE. Then to compound matters, basic "number of rows matched" checks were not being performed. Both issues are fixed, however note that the "rows matched" check requires so-called "sane multi-row count" functionality; the DBAPI's executemany() method must count up the rows matched by individual statements and SQLAlchemy's dialect must mark this feature as supported, currently applies to some mysql dialects, psycopg2, sqlite only. fixes #3006 - Enabled "sane multi-row count" checking for the psycopg2 DBAPI, as this seems to be supported as of psycopg2 2.0.9.
* - Tweaked the settings for mysql-connector-python; in Py2K, theMike Bayer2014-03-271-1/+4
| | | | | | | | | | | "supports unicode statements" flag is now False, so that SQLAlchemy will encode the *SQL string* (note: *not* the parameters) to bytes before sending to the database. This seems to allow all unicode-related tests to pass for mysql-connector, including those that use non-ascii table/column names, as well as some tests for the TEXT type using unicode under cursor.executemany(). - other mysql-connector fixes; latest version seems to do better on function call counts
* - Fixed regression caused by release 0.8.5 / 0.9.3's compatibilityMike Bayer2014-03-251-1/+4
| | | | | | | | | enhancements where index reflection on Postgresql versions specific to only the 8.1, 8.2 series again broke, surrounding the ever problematic int2vector type. While int2vector supports array operations as of 8.1, apparently it only supports CAST to a varchar as of 8.3. fix #3000
* - Added new datatype :class:`.oracle.DATE`, which is a subclass ofMike Bayer2014-03-223-4/+38
| | | | | | | | | | | | :class:`.DateTime`. As Oracle has no "datetime" type per se, it instead has only ``DATE``, it is appropriate here that the ``DATE`` type as present in the Oracle dialect be an instance of :class:`.DateTime`. This issue doesn't change anything as far as the behavior of the type, as data conversion is handled by the DBAPI in any case, however the improved subclass layout will help the use cases of inspecting types for cross-database compatibility. Also removed uppercase ``DATETIME`` from the Oracle dialect as this type isn't functional in that context. fixes #2987
* take out the support paragraph and just put a basic introMike Bayer2014-03-091-9/+3
|
* Merge pull request #75 from msabramo/pymssql_update_web_sitemike bayer2014-03-091-9/+7
|\ | | | | Update URL for pymssql
| * dialects/mssql/pymssql.py: Remove second two paragraphs, as requested by ↵pr/75Marc Abramowitz2014-03-031-9/+0
| | | | | | | | @zzzeek.
| * Update pymssql dialect description, remove "limitations" sectionMarc Abramowitz2014-02-271-9/+16
| |
| * Update URL for pymssqlMarc Abramowitz2014-02-271-1/+1
| |
* | - changelog for pullreq github:74Mike Bayer2014-03-052-41/+91
| | | | | | | | | | - various improvemnts to oracle docs, rewrite section on unicode, more linking, enhance section on resolve_synonyms
* | Merge branch 'master' of https://github.com/Cito/sqlalchemy into tMike Bayer2014-03-051-1/+19
|\ \
View Lorry Controller Status