03/08/2013

09:53 PM Task #584 (Resolved): enable running all the import steps from one runscript

see [[Import process]] Aaron Marcuse-Kubitza

03/06/2013

10:57 PM Task #581 (New): mechanism to dynamically autopopulate NOT NULL values

* this is currently done using sql_io.put_table()'s col_defaults parameter, which only supports constant values
* th... Aaron Marcuse-Kubitza

09:08 PM Task #580 (New): automap each word *in* a VegCore term instead of just the whole term

* this avoids the need to create repetitive synonyms for each variation of a term (e.g. with different units) Aaron Marcuse-Kubitza

08:45 PM Task #579 (New): in sql_gen.EnsureNotNull, use ARRAY[] instead of COALESCE() to wrap values where NULL should be compared literally

* this avoids the need for different null sentinels for each datatype
* it would still be necessary to ensure that t... Aaron Marcuse-Kubitza

02:08 PM Task #578 (New): replace all fields of type text with a domain type that ensures the value is non-empty (not '')

* empty strings tend to cause bugs all over the database because they are sometimes, but not always, treated as NULL Aaron Marcuse-Kubitza