/ - 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		2982	about 12 years	Aaron Marcuse-Kubitza	vegbien_dest: Added temp to schemas list so the...
config		272	over 12 years	Aaron Marcuse-Kubitza	Moved bien_password to new config dir
inputs		2973	about 12 years	Aaron Marcuse-Kubitza	import.stats.xls: Added comments for estimated ...
lib		3002	about 12 years	Aaron Marcuse-Kubitza	sql.py: add_index(): Fixed bug where expr could...
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
3002	06/21/2012 05:39 PM	Aaron Marcuse-Kubitza	sql.py: add_index(): Fixed bug where expr could not be deep-copied until ensure_not_null() had been run on it, because ensure_not_null() modifies the index_cols of the table and this needs to be modified on the original table
3001	06/21/2012 05:12 PM	Aaron Marcuse-Kubitza	sql_gen.py: EnsureNotNull: Added to_str() which uses the column's index col if available. This works around a PostgreSQL bug where indexes on expressions are sometimes not used, but indexes on plain columns are used.
3000	06/21/2012 05:09 PM	Aaron Marcuse-Kubitza	sql_gen.py: Store index cols in the table instead of in the column, because columns are often recreated from the table and name but tables are generally not copied
2999	06/21/2012 04:21 PM	Aaron Marcuse-Kubitza	sql_gen.py: Added is_indexed_col()
2998	06/21/2012 04:15 PM	Aaron Marcuse-Kubitza	sql.py: add_index(): Use new sql.ensure_not_null(), which creates a separate column to store the index expr where possible
2997	06/21/2012 04:12 PM	Aaron Marcuse-Kubitza	sql.py: Added add_not_null(), add_index_col(), ensure_not_null()
2996	06/21/2012 04:10 PM	Aaron Marcuse-Kubitza	sql_gen.py: Added is_temp_col()
2995	06/21/2012 03:57 PM	Aaron Marcuse-Kubitza	sql_gen.py: concat(): Also preserve cast suffix
2994	06/21/2012 03:44 PM	Aaron Marcuse-Kubitza	sql_gen.py: Col: Added index_col attr
2993	06/21/2012 03:19 PM	Aaron Marcuse-Kubitza	sql_gen.py: Added suffixed_col()

root @ 3002