/ - 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		2195	about 12 years	Aaron Marcuse-Kubitza	db_xml.py: put_table(): Added limit and start o...
config		272	over 12 years	Aaron Marcuse-Kubitza	Moved bien_password to new config dir
inputs		2184	about 12 years	Aaron Marcuse-Kubitza	Mapped some unmapped fields in DwC inputs
lib		2204	about 12 years	Aaron Marcuse-Kubitza	sql.py: put_table(): insert_(): Fixed bug where...
mappings		2183	about 12 years	Aaron Marcuse-Kubitza	Added mappings/for_review/DwC2-VegBIEN.specimen...
schemas		2159	about 12 years	Aaron Marcuse-Kubitza	schemas/vegbien.sql: Added _toGrowthform
to_do		811	over 12 years	Aaron Marcuse-Kubitza	Added to_do/milestones.doc
Makefile	9.47 KB	2095	about 12 years	Aaron Marcuse-Kubitza	main Makefile: VegBIEN DB: functions schema: Re...
README.TXT	2.7 KB	1967	about 12 years	Aaron Marcuse-Kubitza	main Makefile: VegBIEN DB: Install public schem...
map	978 Bytes	1979	about 12 years	Aaron Marcuse-Kubitza	root map: Fill in defaults for inputs from VegB...

#	Date	Author	Comment
2204	05/15/2012 03:55 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): insert_(): Fixed bug where distinct_on was not passed to mk_select_()
2203	05/15/2012 03:30 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): mk_select_(): Fixed bug where distinct_on needed to be passed as a keyword param
2202	05/15/2012 03:21 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): insert_() and mk_select_() take distinct_on param
2201	05/15/2012 03:10 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): Factored out code that inserts into pkeys table into run_query_into_pkeys() helper function
2200	05/15/2012 02:55 PM	Aaron Marcuse-Kubitza	sql.py: mk_select(): Implemented DISTINCT ON according to the distinct_on param
2199	05/15/2012 02:48 PM	Aaron Marcuse-Kubitza	sql.py: mk_select(): Added distinct_on param to set the columns to SELECT DISTINCT ON
2198	05/15/2012 02:31 PM	Aaron Marcuse-Kubitza	sql.py: clean_name(): Convert names to lowercase so that PostgreSQL will behave the same whether the name is escaped with "" or not. This will help avoid bugs in code that uses temp tables created by the sql module.
2197	05/15/2012 02:29 PM	Aaron Marcuse-Kubitza	sql.py: put_table(): Added order_by=None wherever rows were not supposed to be re-ordered. On DuplicateKeyException: Save existing pkeys in temp table for joining on.
2196	05/15/2012 01:31 PM	Aaron Marcuse-Kubitza	db_xml.py: put_table(): Pass limit and start to sql.put_table()
2195	05/15/2012 01:09 PM	Aaron Marcuse-Kubitza	db_xml.py: put_table(): Added limit and start options

root @ 2204