summaryrefslogtreecommitdiff
path: root/test/dialect
Commit message (Collapse)AuthorAgeFilesLines
* Fix unicode literals on Python 3.1 and 3.2pr/10Roman Podolyaka2013-06-231-8/+8
| | | | | A few tests use u'' unicode literals which are not supported in Python versions 3.1 and 3.2.
* this locale is not needed. maybe it is somewhere but the locale I have ↵Mike Bayer2013-06-221-13/+9
| | | | | | ("C", whatever that means, cannot find meaning of this anywhere in Postgresql documentation) seems to work
* Merge pull request #5 from cjw296/pg-rangesmike bayer2013-06-221-1/+329
|\ | | | | Support for Postgres range types.
| * Implement EXCLUDE constraints for postgres.Chris Withers2013-06-101-1/+49
| |
| * add support for range operators listed in ↵Chris Withers2013-06-101-1/+159
| | | | | | | | http://www.postgresql.org/docs/9.2/interactive/functions-range.html
| * Basic type support for the new range types in postgres 9.2Chris Withers2013-06-101-1/+123
| |
* | can remove this, issue is fixedMike Bayer2013-06-171-10/+1
| |
* | - clean up this test (really we don't even need this, it's not testing much)Mike Bayer2013-06-161-13/+20
| | | | | | | | | | - for the moment, put a catch in it to see if we can trap that issue on jenkins
* | Add AUTOCOMMIT isolation level support for psycopg2pr/7Roman Podolyaka2013-06-151-0/+10
|/ | | | | | | | | | | | | | One can use this to emit statements, which can not be executed within a transaction (e. g. CREATE DATABASE): from sqlalchemy import create_engine eng = create_engine('postgresql://test:test@localhost/test') conn = eng.connect().execution_options(isolation_level='AUTOCOMMIT') conn.execute('CREATE DATABASE test2;') Fixes issue #2072.
* get nested joins to render on oracle 8Mike Bayer2013-06-081-0/+33
|
* most of these dialect=mysql.dialect() calls are redundantMike Bayer2013-06-081-23/+13
|
* Fix using of 'mysql_length' for composite indexesRoman Podolyaka2013-06-081-0/+29
| | | | | | | | | | | | | | | | | Currently, one can specify the prefix length for an index column using 'mysql_length' keyword argument when creating an Index instance. But in case of composite indexes the prefix length value is applied only to the last column. Extend the existing API in way so that 'mysql_length' argument value can be either: - an integer specifying the same prefix length value for each column of an index - a (column_name --> integer value) mapping specifying the prefix length value for each column of an index separately Fixes issue #2704.
* When querying the information schema on SQL Server 2000, removedMike Bayer2013-06-061-2/+24
| | | | | | | a CAST call that was added in 0.8.1 to help with driver issues, which apparently is not compatible on 2000. The CAST remains in place for SQL Server 2005 and greater. [ticket:2747]
* The ``deferrable`` keyword argument on :class:`.ForeignKey` andMike Bayer2013-06-031-0/+13
| | | | | | | | :class:`.ForeignKeyConstraint` will not render the ``DEFERRABLE`` keyword on the MySQL dialect. For a long time we left this in place because a non-deferrable foreign key would act very differently than a deferrable one, but some environments just disable FKs on MySQL, so we'll be less opinionated here. [ticket:2721]
* - repair for py3kMike Bayer2013-05-291-2/+2
| | | | - fix test
* hstores are text, and in py3k they seem to be implcitly unicode. soMike Bayer2013-05-291-0/+25
| | | | | add unicode encoding for py2k for the non-native hstore, pullreq for native psycopg2 support coming....
* mssql test fixesMike Bayer2013-05-261-6/+6
|
* - oracle tests passing in py3k!!Mike Bayer2013-05-261-6/+7
|
* a few more oracle fixesMike Bayer2013-05-261-1/+2
|
* cleanup for oracleMike Bayer2013-05-261-10/+11
|
* - add a test specific to sqlite testing cursor.description encoding (shouldMike Bayer2013-05-261-1/+22
| | | | | probably be one in test_query or test_unicode...) - fix up test_unitofwork
* postgresql testsMike Bayer2013-05-261-6/+6
|
* mysql testsMike Bayer2013-05-261-13/+14
|
* Merge branch 'master' into rel_0_9Mike Bayer2013-05-261-0/+1
|\
| * Add missing import that caused test_notice_logging to fail if this suite was ↵Chris Withers2013-05-261-0/+1
| | | | | | | | run on its own.
* | sqlite testsMike Bayer2013-05-261-5/+5
| |
* | merge defaultMike Bayer2013-05-152-0/+21
|\ \ | |/
| * Regression from this ticket caused the unsupported keywordMike Bayer2013-05-152-0/+21
| | | | | | | | | | | | "true" to render, added logic to convert this to 1/0 for SQL server. [ticket:2682]
* | postgresql dialect testsMike Bayer2013-04-281-29/+30
| |
* | - the raw 2to3 runMike Bayer2013-04-277-77/+77
|/ | | | - went through examples/ and cleaned out excess list() calls
* tweak this some more to handle the array being empty againMike Bayer2013-04-221-0/+11
|
* - change to [ticket:2681], pre-coerce the array to listMike Bayer2013-04-221-10/+3
| | | | unconditonally instead so that it works in all cases.
* The operators for the Postgresql ARRAY type supportsMike Bayer2013-04-221-60/+106
| | | | | | | | | | input types of sets, generators, etc. but only when a dimension is specified for the ARRAY; otherwise, the dialect needs to peek inside of "arr[0]" to guess how many dimensions are in use. If this occurs with a non list/tuple type, the error message is now informative and directs to specify a dimension for the ARRAY. [ticket:2681]
* - establish ordering here for the hstore repr testMike Bayer2013-04-201-4/+5
|
* - this pymssql test needs to be against the pymssql dialectMike Bayer2013-04-181-1/+1
| | | | | | | | | | | | | - Part of a longer series of fixes needed for pyodbc+ mssql, a CAST to NVARCHAR(max) has been added to the bound parameter for the table name and schema name in all information schema queries to avoid the issue of comparing NVARCHAR to NTEXT, which seems to be rejected by the ODBC driver in some cases, such as FreeTDS (0.91 only?) plus unicode bound parameters being passed. The issue seems to be specific to the SQL Server information schema tables and the workaround is harmless for those cases where the problem doesn't exist in the first place. [ticket:2355]
* - test all pymssql messages hereMike Bayer2013-03-291-7/+23
| | | | - changelog
* Merged in sontek/sqlalchemy/add_better_disconnect_checks (pull request #47)Mike Bayer2013-03-291-0/+6
|\ | | | | | | Add disconnect check on timeouts
| * cleaned up errors, only check for connection timeout for nowJohn Anderson2013-03-181-2/+2
| |
| * Added disconnect checks for timeout, unable to read, and unable to writeJohn Anderson2013-03-181-0/+6
| |
* | Make MonkeyPatchedBinaryTest not fail on Python 2.5 (which doesn't haveMarc Abramowitz2013-03-201-1/+2
| | | | | | | | the `b` notation for byte string literals)
* | Make MonkeyPatchedBinaryTest only run when using mssql. Prevents failedMarc Abramowitz2013-03-181-0/+2
| | | | | | | | tests when using a different dialect.
* | Add a test for http://www.sqlalchemy.org/trac/ticket/2683Marc Abramowitz2013-03-181-0/+13
|/ | | | This test currently passes in Python 2 but fails in Python 3.
* 0.8.1 bump + test, changelog for hstore fix [ticket:2680]Mike Bayer2013-03-181-0/+6
|
* Added support for Postgresql's traditional SUBSTRINGMike Bayer2013-03-091-0/+8
| | | | | | | function syntax, renders as "SUBSTRING(x FROM y FOR z)" when regular ``func.substring()`` is used. Also in 0.7.11. Courtesy Gunnlaugur Por Briem. [ticket:2676]
* - remove all compat items that are pre-2.5 (hooray)Mike Bayer2013-03-093-9/+6
| | | | | | - other cleanup - don't need compat.decimal, that approach never panned out. hopefully outside libs aren't pulling it in, they shouldn't be
* test for cymysqlHajime Nakagami2013-02-171-0/+1
|
* The :meth:`.ColumnOperators.in_` operator will now coerceMike Bayer2013-02-021-0/+4
| | | | | values of ``None`` to :func:`.null`. [ticket:2496]
* Add ANY/ALL construct support for PostgreSQL's ARRAY typeAudrius Kažukauskas2013-01-281-1/+49
|
* - replace mssql_ordering with generalized #695 solutionMike Bayer2013-01-201-1/+1
| | | | - documentation for mssql index options plus changelog and fixes
* Merged in dharland/sqlalchemy (pull request #35)Mike Bayer2013-01-201-0/+36
|\ | | | | | | Add extra mssql dialect options to Index
View Lorry Controller Status