8306
97%

Ran 01 Oct 2015 11:07AM UTC

Jobs 1

Files 84

Run time 3s

Badge

Embed ▾

pending completion

Build # 8306

Build Type

push

travis-ci

Committed by

nickstenning

Commit Message

Make sqlalchemy ignore old columns on INSERT/SELECT/UPDATE

These columns are going to be removed shortly. In 25ae155 we made them
nullable, in the hope that this would stop sqlalchemy from attempting to
set values in these columns. Unfortunately, that doesn't do it:
sqlalchemy continues to send explicit NULL values to these columns.

In order to get sqlalchemy to completely ignore these unused columns on
INSERT, on UPDATE and on SELECT, we have to:

- mark the `server_default` and `server_onupdate` values to be
  `FetchedValue()` -- this is usually used when a field is updated
  server-side by a trigger, and suppresses inclusion of the field in
  INSERTs and UPDATEs respectively:

  http://docs.sqlalchemy.org/en/rel_1_0/core/defaults.html#sqlalchemy.schema.FetchedValue

- mark the entire column as deferred, to prevent eager loading of these
  column values on SELECT:

  http://docs.sqlalchemy.org/en/rel_1_0/orm/loading_columns.html#deferred-column-loading

Coverage Stats

2333 of 3501 relevant lines covered (66.64%)

0.67 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	8306.1	01 Oct 2015 11:07AM UTC	0	66.64	Travis Job 8306.1

Source Files on build 8306

Detailed source file information is not available for this build.

hypothesis / h / 8306
97%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 8306

hypothesis / h / 8306 97%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 8306

hypothesis / h / 8306
97%

README BADGES
x