Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  bin 2824 over 12 years Aaron Marcuse-Kubitza csv2db: Errors table: Removed no longer needed ...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2775 over 12 years Aaron Marcuse-Kubitza inputs/SALVIAS: Switched to using CSV exports o...
  lib 2854 over 12 years Aaron Marcuse-Kubitza sql_gen.py: null_sentinels: Added value for USE...
  mappings 2529 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
  schemas 2839 over 12 years Aaron Marcuse-Kubitza schemas/functions.sql: _merge: Changed indexes ...
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 10.1 KB 2633 over 12 years Aaron Marcuse-Kubitza main Makefile: schemas/%/uninstall: Removed del...
README.TXT 2.7 KB 1967 over 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: Install public schem...
map 978 Bytes 1979 over 12 years Aaron Marcuse-Kubitza root map: Fill in defaults for inputs from VegB...

Latest revisions

# Date Author Comment
2854 06/14/2012 08:32 PM Aaron Marcuse-Kubitza

sql_gen.py: null_sentinels: Added value for USER-DEFINED type

2853 06/14/2012 08:31 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): Joins: Filtering on no match: Use '~=' sql_gen.CompareCond operator so that IS NULL is always used, regardless of the not-null column's nullability

2852 06/14/2012 08:24 PM Aaron Marcuse-Kubitza

sql_gen.py: null_sentinels: Added value for boolean type

2851 06/14/2012 08:21 PM Aaron Marcuse-Kubitza

sql_gen.py: ensure_not_null(): Added type_ param to override the underlying column's type

2850 06/14/2012 08:09 PM Aaron Marcuse-Kubitza

sql_gen.py: EnsureNotNull: Take a type param instead of a null param so that the EnsureNotNull object stores the underlying column's type

2849 06/14/2012 08:00 PM Aaron Marcuse-Kubitza

sql_gen.py: underlying_col(): Support non-Col inputs

2848 06/14/2012 07:42 PM Aaron Marcuse-Kubitza

sql_gen.py: EnsureNotNull: Removed default value for null param to remind user that default value depends on value's type and will not always be a string

2847 06/14/2012 07:39 PM Aaron Marcuse-Kubitza

sql.py: add_index(): Added ensure_not_null param to disable the ensure_not_null functionality to force a plain index

2846 06/14/2012 07:14 PM Aaron Marcuse-Kubitza

sql.py: flatten(): Add indexes on the created table so its columns can be used in an O(n) merge join

2845 06/14/2012 07:12 PM Aaron Marcuse-Kubitza

sql_gen.py: null_sentinels: Added value for integer type

View all revisions | View revisions

Also available in: Atom