delta/python-packages/sqlalchemy.git/test/dialect/test_sqlite.py, branch pr/307

Add IS (NOT) DISTINCT FROM operators

2016-06-06T19:53:25+00:00

None / True / False render as literals.
For SQLite, "IS" is used as SQLite lacks
"IS DISTINCT FROM" but its "IS" operator acts
this way for NULL.

Doctext-author: Mike Bayer 
Change-Id: I9227b81f7207b42627a0349d14d40b46aa756cce
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/248

- further adjustment to accomodate for the "ON" in "NO ACTION"

2016-06-04T00:54:48+00:00

Change-Id: I734e4aec3701d7cf17813b561a1418cfeff1d473

Ensure "options" present for unnamed / unlocatable FK

2016-06-03T19:57:16+00:00

Also ensure the regular expression and subsequent matching
is case insensitive, add more tests

Change-Id: Ie4aa971dcbffca94e78965e22982478eccbf8597

Reflect ON DELETE and ON UPDATE for SQLite foreign keys

2016-06-02T21:49:09+00:00

Co-authored-by: Mike Bayer 
Change-Id: Icd77ddbf851b1950f767022d67c8142b1b3c50f3
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/244

Implemented CHECK constraint reflection for SQLite and PostgreSQL

2016-06-01T16:57:36+00:00

Co-Authored-By: Mike Bayer 
Change-Id: Ie6cf2d2958d1c567324db9e08fef2d3186e97350
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/80

sqlite: reflect primary key constraint names, fixes #3629

2016-01-28T03:54:05+00:00

- The system by which a :class:`.Column` considers itself to be an

2015-10-07T14:02:45+00:00

"auto increment" column has been changed, such that autoincrement
is no longer implicitly enabled for a :class:`.Table` that has a
composite primary key.  In order to accommodate being able to enable
autoincrement for a composite PK member column while at the same time
maintaining SQLAlchemy's long standing behavior of enabling
implicit autoincrement for a single integer primary key, a third
state has been added to the :paramref:`.Column.autoincrement` parameter
``"auto"``, which is now the default. fixes #3216
- The MySQL dialect no longer generates an extra "KEY" directive when
generating CREATE TABLE DDL for a table using InnoDB with a
composite primary key with AUTO_INCREMENT on a column that isn't the
first column;  to overcome InnoDB's limitation here, the PRIMARY KEY
constraint is now generated with the AUTO_INCREMENT column placed
first in the list of columns.

- limit the search for schemas to not include "temp", which is sort of an implicit schema

2015-09-28T21:48:55+00:00

- repair the CREATE INDEX ddl for schemas
- update provisioning to include support for setting up ATTACH DATABASE up front
for the test_schema; enable "schemas" testing for SQLite
- changelog / migration notes for new SQLite schema support
- include the "schema" as the "remote_schema" when we reflect SQLite FKs

Support get_schema_names for SQLite

2015-09-09T21:23:27+00:00

Should return "main" and the names of attached databases.

Test for partial index support in sqlite dialects.

2015-01-26T19:48:23+00:00