/ - Repository - BIEN 3 - NCEAS Projects

Name	Size	Revision	Age	Author	Comment
_archive		1598	almost 13 years	Aaron Marcuse-Kubitza	Moved _archive/tapir2flatClient/trunk/client/ t...
bin		2313	over 12 years	Aaron Marcuse-Kubitza	db_xml.py: put_table(): Accept sql_gen.Table ob...
config		272	about 13 years	Aaron Marcuse-Kubitza	Moved bien_password to new config dir
inputs		2364	over 12 years	Aaron Marcuse-Kubitza	mappings/DwC2-VegBIEN.specimens.csv: plantname....
lib		2410	over 12 years	Aaron Marcuse-Kubitza	sql.py mk_select(), sql_gen.py Join.to_str(): F...
mappings		2364	over 12 years	Aaron Marcuse-Kubitza	mappings/DwC2-VegBIEN.specimens.csv: plantname....
schemas		2338	over 12 years	Aaron Marcuse-Kubitza	schemas/vegbien.sql, schemas/functions.sql: Rel...
to_do		811	almost 13 years	Aaron Marcuse-Kubitza	Added to_do/milestones.doc
Makefile	9.47 KB	2095	over 12 years	Aaron Marcuse-Kubitza	main Makefile: VegBIEN DB: functions schema: Re...
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...

#	Date	Author	Comment
2410	05/24/2012 07:18 PM	Aaron Marcuse-Kubitza	sql.py mk_select(), sql_gen.py Join.to_str(): Fixed bug where conditions needed to be wrapped in () before being AND-ed together to ensure the proper operator precedence
2409	05/24/2012 06:49 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): Add index on columns with invalid values to enable fast filtering
2408	05/24/2012 06:47 PM	Aaron Marcuse-Kubitza	sql.py: Added index_col()
2407	05/24/2012 06:18 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): Add pkey on returned pkeys table to enable fast joins
2406	05/24/2012 06:17 PM	Aaron Marcuse-Kubitza	sql.py: Added index_pkey()
2405	05/24/2012 05:41 PM	Aaron Marcuse-Kubitza	sql.py: mk_update(): When running sql_gen.to_name_only_col(), check that the col's table is table
2404	05/24/2012 05:38 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): Renamed *pkeys to insert*_pkeys to distinguish them from the full set of pkeys on the input table
2403	05/24/2012 05:27 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): FunctionValueException: Change invalid values to NULL using UPDATE instead of filtering them out using WHERE, to avoid adding lots of conditions to the SELECT statement
2402	05/24/2012 05:11 PM	Aaron Marcuse-Kubitza	sql.py: Added mk_update() and update()
2401	05/24/2012 05:10 PM	Aaron Marcuse-Kubitza	sql_gen.py: Added to_name_only_col()

root @ 2410