/ - Repository - BIEN 3 - NCEAS Projects

Name	Size	Revision	Age	Author	Comment
_archive		1598	over 12 years	Aaron Marcuse-Kubitza	Moved _archive/tapir2flatClient/trunk/client/ t...
bin		3054	about 12 years	Aaron Marcuse-Kubitza	csv2db: Adding indexes: Fixed bug where sql.add...
config		272	over 12 years	Aaron Marcuse-Kubitza	Moved bien_password to new config dir
inputs		3052	about 12 years	Aaron Marcuse-Kubitza	inputs/import.stats.xls: Updated for most recen...
lib		3066	about 12 years	Aaron Marcuse-Kubitza	sql.py: cleanup_table(): Use update()'s new in_...
mappings		2529	about 12 years	Aaron Marcuse-Kubitza	mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
schemas		2980	about 12 years	Aaron Marcuse-Kubitza	Added temp schema to store intermediate tables ...
to_do		2547	about 12 years	Aaron Marcuse-Kubitza	to_do/timeline.doc: Updated to reflect the mont...
Makefile	10.2 KB	2983	about 12 years	Aaron Marcuse-Kubitza	main Makefile: Added explicit schemas/temp/rein...
README.TXT	2.76 KB	2976	about 12 years	Aaron Marcuse-Kubitza	README.TXT: Changed documentation to use make s...
map	978 Bytes	1979	about 12 years	Aaron Marcuse-Kubitza	root map: Fill in defaults for inputs from VegB...

#	Date	Author	Comment
3066	06/25/2012 08:10 PM	Aaron Marcuse-Kubitza	sql.py: cleanup_table(): Use update()'s new in_place mode to avoid needing to vacuum the table
3065	06/25/2012 08:02 PM	Aaron Marcuse-Kubitza	sql.py: mk_update(): in_place: Support updating multiple columns at once
3064	06/25/2012 07:44 PM	Aaron Marcuse-Kubitza	sql.py: update() calls: Use in_place where possible to avoid creating dead rows, which bloats table size
3063	06/25/2012 07:37 PM	Aaron Marcuse-Kubitza	sql.py: DbConn.col_info(): Support user-defined types
3062	06/25/2012 07:33 PM	Aaron Marcuse-Kubitza	sql_gen.py: Added Nullif
3061	06/25/2012 07:27 PM	Aaron Marcuse-Kubitza	sql_gen.py: Added Coalesce class and use it in EnsureNotNull
3060	06/25/2012 07:15 PM	Aaron Marcuse-Kubitza	sql_gen.py: Added coalesce and use it in EnsureNotNull
3059	06/25/2012 07:00 PM	Aaron Marcuse-Kubitza	sql.py: DbConn.col_info(): Don't cache the structure query because the column type, etc. may change between calls. This fixes a bug in mk_update() where the column type would be retrieved before a NOT NULL constraint was added, causing the NOT NULL constraint not to be in the cache info about the column.
3058	06/25/2012 06:56 PM	Aaron Marcuse-Kubitza	sql.py: mk_update(): Implemented in_place mode
3057	06/25/2012 06:39 PM	Aaron Marcuse-Kubitza	sql.py: mk_update(): Factored out filtering of input values so only `.to_str(db)` is used inline in the creation of the query

root @ 3066