/ - 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		2250	over 12 years	Aaron Marcuse-Kubitza	mappings/DwC2-VegBIEN.specimens.csv: Filter dat...
lib		2319	over 12 years	Aaron Marcuse-Kubitza	sql.py: run_query_into(): Fixed bug where into ...
mappings		2250	over 12 years	Aaron Marcuse-Kubitza	mappings/DwC2-VegBIEN.specimens.csv: Filter dat...
schemas		2249	over 12 years	Aaron Marcuse-Kubitza	schemas/functions.sql: Added _toTimestamp
to_do		811	about 13 years	Aaron Marcuse-Kubitza	Added to_do/milestones.doc
Makefile	9.47 KB	2095	almost 13 years	Aaron Marcuse-Kubitza	main Makefile: VegBIEN DB: functions schema: Re...
README.TXT	2.7 KB	1967	almost 13 years	Aaron Marcuse-Kubitza	main Makefile: VegBIEN DB: Install public schem...
map	978 Bytes	1979	almost 13 years	Aaron Marcuse-Kubitza	root map: Fill in defaults for inputs from VegB...

#	Date	Author	Comment
2319	05/22/2012 06:13 PM	Aaron Marcuse-Kubitza	sql.py: run_query_into(): Fixed bug where into table name was not being escaped
2318	05/22/2012 06:07 PM	Aaron Marcuse-Kubitza	sql.py: mk_insert_select(): Fixed bug where utput column names were not being escaped
2317	05/22/2012 05:57 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): Fixed bug where only string columns were being included in the distinct_on, but columns are now always sql_gen.Col instances
2316	05/22/2012 05:53 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): Put together varying insert_select() args using dict instead of individual vars
2315	05/22/2012 05:51 PM	Aaron Marcuse-Kubitza	sql.py: mk_select(): Fixed bug where order_by needed to default to None if distinct_on was used. Fixed bug where cond values were being treated as %s params in addition to being parsed by sql_gen.as_ValueCond().to_str().
2314	05/22/2012 05:40 PM	Aaron Marcuse-Kubitza	sql_gen.py: Col: Added to_Col()
2313	05/22/2012 05:31 PM	Aaron Marcuse-Kubitza	db_xml.py: put_table(): Accept sql_gen.Table objects or strings instead of separate table and schema names
2312	05/22/2012 05:10 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): Require all in_table_cols to be sql_gen.Col objects
2311	05/22/2012 05:03 PM	Aaron Marcuse-Kubitza	sql_gen.py: ValueCond: Unwrap NamedCode objects
2310	05/22/2012 04:55 PM	Aaron Marcuse-Kubitza	sql_gen.py: NamedCode: Inherit from Col so that its name can be retrieved using the same attribute as Col's

root @ 2319