/ - 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		2685	over 12 years	Aaron Marcuse-Kubitza	csv2db: Vacuum the created table
config		272	almost 13 years	Aaron Marcuse-Kubitza	Moved bien_password to new config dir
inputs		2556	over 12 years	Aaron Marcuse-Kubitza	xpath.py: get(): Create attrs: Put keys last so...
lib		2686	over 12 years	Aaron Marcuse-Kubitza	sql.py: add_pkey(): Support multiple, custom co...
mappings		2529	over 12 years	Aaron Marcuse-Kubitza	mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
schemas		2662	over 12 years	Aaron Marcuse-Kubitza	schemas/functions.sql: _nullIf(): Fixed bug whe...
to_do		2547	over 12 years	Aaron Marcuse-Kubitza	to_do/timeline.doc: Updated to reflect the mont...
Makefile	10.1 KB	2633	over 12 years	Aaron Marcuse-Kubitza	main Makefile: schemas/%/uninstall: Removed del...
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
2686	06/07/2012 09:35 PM	Aaron Marcuse-Kubitza	sql.py: add_pkey(): Support multiple, custom columns
2685	06/07/2012 09:24 PM	Aaron Marcuse-Kubitza	csv2db: Vacuum the created table
2684	06/07/2012 09:23 PM	Aaron Marcuse-Kubitza	sql.py: Added vacuum()
2683	06/07/2012 09:23 PM	Aaron Marcuse-Kubitza	sql.py: DbConn: Added with_autocommit()
2682	06/07/2012 08:58 PM	Aaron Marcuse-Kubitza	csv2db: Create errors table for use by column-based import
2681	06/07/2012 08:57 PM	Aaron Marcuse-Kubitza	sql.py: create_table(): Added has_pkey param to disable making the first column the primary key
2680	06/07/2012 08:21 PM	Aaron Marcuse-Kubitza	csv2db: Use verbosity-based logging like bin/map. Use sql.create_table(). Add indexes on the columns to speed up column-based import and to speed up searching the table for particular values.
2679	06/07/2012 08:00 PM	Aaron Marcuse-Kubitza	sql.py: create_table(): Don't add indexes on columns, because that shouldn't happen until after the table's rows have been inserted
2678	06/07/2012 07:55 PM	Aaron Marcuse-Kubitza	sql.py: DbConn._db(): Output 'SET TRANSACTION ISOLATION LEVEL SERIALIZABLE' with log_level=4 because that should not be shown when the search_path is shown, which has log_level=3
2677	06/07/2012 07:43 PM	Aaron Marcuse-Kubitza	sql.py: cleanup_table(): Use update(), which also fixes some formatting bugs

root @ 2686