summaryrefslogtreecommitdiff
path: root/doc/build/dialects
Commit message (Collapse)AuthorAgeFilesLines
* - remove intersphinx usage, the overhead of re-fetchingMike Bayer2017-07-091-6/+6
| | | | | | inventory on every build not worth it Change-Id: I3c4506b246d0f327c4b56afa723975daee984476
* Implement MySQL's ON DUPLICATE KEY UPDATEMichael Doronin2017-07-031-0/+9
| | | | | | | | | | | Added support for MySQL's ON DUPLICATE KEY UPDATE MySQL-specific :class:`.mysql.dml.Insert` object. Pull request courtesy Michael Doronin. Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com> Resolves: #4009 Change-Id: Ic71424f3c88af6082b48a910a2efb7fbfc0a7eb4 Pull-request: https://github.com/zzzeek/sqlalchemy/pull/365
* added link for CrateDB supportJodok Batlogg2017-06-231-0/+1
|
* Add placeholder XML supportMike Bayer2017-05-261-18/+21
| | | | | | | | | | | Added a placeholder type :class:`.mssql.XML` to the SQL Server dialect, so that a reflected table which includes this type can be re-rendered as a CREATE TABLE. The type has no special round-trip behavior nor does it currently support additional qualifying arguments. Change-Id: I651fa729bd8e9b31a0b5effe0839aff077d77c46 Fixes: #3973
* Repair formatting throughout documentationKataev Denis2017-05-227-20/+20
| | | | | | | | | | | 1. Section decorators to [one style](http://docutils.sourceforge.net/docs/ref/rst/restructuredtext.html#sections): without inset at both side and with same length as text. 2. Fix broken [reference](http://docs.sqlalchemy.org/en/latest/core/type_basics.html#generic-types). 3. Convert tabs to space in some small files. 4. Some python code snippets have python+sql syntax hint. Change-Id: I39a7a41ef0b0591c6bf1e610748e2b5c19fc5379 Pull-request: https://github.com/zzzeek/sqlalchemy/pull/361
* pytds based connector for MS-SQLGrzegorz Makarewicz2017-02-121-0/+2
|
* spelling: Postgresql -> PostgreSQLVille Skyttä2016-10-081-2/+2
|
* Update index.rstpr/289Shige Takeda2016-07-111-1/+1
|
* Update index.rstShige Takeda2016-07-111-0/+1
|
* Consistently use the official PostgreSQL casingLele Gaifax2016-07-021-2/+2
|
* Add ON CONFLICT support for PostgresqlRobin Thomas2016-06-141-0/+8
| | | | | | | Fixes: #3529 Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com> Change-Id: Ie3bf6ad70d9be9f0e44938830e922db03573991a Pull-request: https://github.com/zzzeek/sqlalchemy/pull/258
* - Add support for PostgreSQL with PyGreSQLChristoph Zwerschke2016-04-151-5/+11
| | | | | Change-Id: I040b75ff3b4110e7e8b26442a4eb226ba8c26715 Pull-request: https://github.com/zzzeek/sqlalchemy/pull/234
* - generalize the verbiage on LargeBinary so that it doesn'tMike Bayer2016-01-201-2/+0
| | | | create confusion for inherited classes such as BYTEA, fixes
* - Added :class:`.mysql.JSON` for MySQL 5.7. The JSON type providesMike Bayer2016-01-062-3/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | persistence of JSON values in MySQL as well as basic operator support of "getitem" and "getpath", making use of the ``JSON_EXTRACT`` function in order to refer to individual paths in a JSON structure. fixes #3547 - Added a new type to core :class:`.types.JSON`. This is the base of the PostgreSQL :class:`.postgresql.JSON` type as well as that of the new :class:`.mysql.JSON` type, so that a PG/MySQL-agnostic JSON column may be used. The type features basic index and path searching support. fixes #3619 - reorganization of migration docs etc. to try to refer both to the fixes to JSON that helps Postgresql while at the same time indicating these are new features of the new base JSON type. - a rework of the Array/Indexable system some more, moving things that are specific to Array out of Indexable. - new operators for JSON indexing added to core so that these can be compiled by the PG and MySQL dialects individually - rename sqltypes.Array to sqltypes.ARRAY - as there is no generic Array implementation, this is an uppercase type for now, consistent with the new sqltypes.JSON type that is also not a generic implementation. There may need to be some convention change to handle the case of datatypes that aren't generic, rely upon DB-native implementations, but aren't necessarily all named the same thing.
* Merge remote-tracking branch 'origin/pr/196' into pr196pr196Mike Bayer2015-10-221-1/+1
|\
| * Link to maintained redshift dialectpr/196Thomas Grainger2015-08-191-1/+1
| |
* | - add a postgresql-specific form of array_agg() that injects theMike Bayer2015-08-271-0/+1
| | | | | | | | ARRAY type, references #3132
* | - add PG-specific aggregate_order_by(), references #3132Mike Bayer2015-08-271-0/+2
| |
* | - build out a new base type for Array, as well as new any/all operatorsMike Bayer2015-08-251-2/+2
|/ | | | | | - any/all work for Array as well as subqueries, accepted by MySQL - Postgresql ARRAY now subclasses Array - fixes #3516
* fdb drivers seem to be no longer availableMike Bayer2015-03-241-1/+0
|
* - reorganize MySQL docs re: unicode, other cleanup and updatesMike Bayer2015-03-201-38/+38
|
* - additional test adjustments for pypy / psycopg2cffi. ThisMike Bayer2015-01-261-8/+10
| | | | | | | | | | consists mainly of adjusting fixtures to ensure connections are closed explicitly. psycopg2cffi also handles unicode bind parameter names differently than psycopg2, and seems to possibly have a little less control over floating point values at least in one test which is marked as a "fail", though will see if it runs differently on linux than osx.. - changelog for psycopg2cffi, fixes #3052
* Include psycopg2cffi in dialect docsShaun Stanworth2015-01-261-0/+5
|
* - correctionsMike Bayer2014-12-271-1/+1
| | | | - attempt to add a script to semi-automate the fixing of links
* - added new backend for pysqlcipher, as we will probably getMike Bayer2014-10-291-1/+6
| | | | requests for it soon.
* Merge pull request #138 from BY-jk/mastermike bayer2014-09-161-0/+1
|\ | | | | Added EXASolution dialect to documentation
| * Added EXASolution dialect to documentationpr/138Jan2014-09-161-0/+1
| |
* | document JSONBMike Bayer2014-07-071-2/+5
| |
* | typo: s/founds/foundPriit Laes2014-06-281-1/+1
| |
* | - Added a new type :class:`.postgresql.OID` to the Postgresql dialect.Mike Bayer2014-06-201-1/+3
| | | | | | | | | | | | | | | | 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
* | - remove drizzle dialectMike Bayer2014-05-302-77/+4
| | | | | | | | | | - restore mysqldb fully within dialects/mysql/, it's no longer a connector. fixes #2984
* | fix typoMike Bayer2014-05-301-3/+3
| |
* | more docs for using psycopg2 range types, specifically instantiating models ↵Chris Withers2014-05-251-1/+30
|/ | | | with them
* - Added new datatype :class:`.oracle.DATE`, which is a subclass ofMike Bayer2014-03-221-8/+10
| | | | | | | | | | | | :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
* typorel_0_9_2Mike Bayer2014-02-021-1/+1
|
* typoMike Bayer2014-01-231-3/+5
|
* - add redshift-sqlalchemy, essentially fixes [ticket:2727]Mike Bayer2014-01-211-0/+2
|
* akiban-> foundationdbMike Bayer2014-01-181-3/+2
|
* - rework the JSON expression system so that "astext" is called *after*Mike Bayer2013-12-271-0/+3
| | | | | | | | | the indexing. this is for more natural operation. - also add cast() to the JSON expression to complement astext. This integrates the CAST call which will be needed frequently. Part of [ticket:2687]. - it's a little unclear how more advanced unicode attribute-access is going to go, some quick attempts at testing yielded strange error messages from psycopg2. - do other cross linking as mentioned in [ticket:2687].
* add JSONMike Bayer2013-12-171-1/+3
|
* Merge branch 'tsvector' of ↵Mike Bayer2013-12-091-1/+3
|\ | | | | | | https://bitbucket.org/nibrahim/sqlalchemy/branch/tsvector into tsvector
| * Updates documentation for tsvector type.Noufal Ibrahim2013-12-101-1/+3
| | | | | | | | Signed-off-by: Noufal Ibrahim <noufal@nibrahim.net.in>
* | sqlany dialect moves to githubMike Bayer2013-12-091-1/+1
|/
* remove thisMike Bayer2013-11-291-11/+0
|
* name it with a dashMike Bayer2013-11-171-1/+1
|
* - remove informix dialect, moved out to ↵Mike Bayer2013-11-171-3/+16
| | | | | | https://bitbucket.org/zzzeek/sqlalchemy_informixdb - remove informix, maxdb, access symbols from tests etc.
* add sap sqlanywhereMike Bayer2013-11-121-0/+1
|
* - add monetdbMike Bayer2013-10-011-2/+10
| | | | - break out into "production" and "experimental"
* - reorganize docs so expression, schema are broken out into subfiles, ↵Mike Bayer2013-08-185-90/+89
| | | | | | they're too big - fix the targeting of module names moved around by using custom handlers for "Bases", etc.
* Tidy range types docs and add warning about the return type support offered ↵pr/12Chris Withers2013-06-261-2/+18
| | | | by different versions of different DBAPI libraries.