Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  bin 2680 over 12 years Aaron Marcuse-Kubitza csv2db: Use verbosity-based logging like bin/ma...
  config 272 about 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 2679 over 12 years Aaron Marcuse-Kubitza sql.py: create_table(): Don't add indexes on 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...

Latest revisions

# Date Author Comment
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

2676 06/07/2012 07:24 PM Aaron Marcuse-Kubitza

sql.py: DbConn._db(): Output connection configuration statements with log_level=3

2675 06/07/2012 07:15 PM Aaron Marcuse-Kubitza

sql.py: Added create_table()

2674 06/07/2012 07:14 PM Aaron Marcuse-Kubitza

sql_gen.py: Added TypedCol

2673 06/07/2012 06:59 PM Aaron Marcuse-Kubitza

sql.py: insert_select(): Pass log_level to run_query_into()

2672 06/07/2012 05:15 PM Aaron Marcuse-Kubitza

streams.py: LineCountInputStream: Fixed bug where EOF was incorrectly considered a line, causing the final line count (used by ProgressInputStream) to be off by one

2671 06/07/2012 04:25 PM Aaron Marcuse-Kubitza

sql.py: DbConn: Added print_notices() and call it after running a query

View all revisions | View revisions

Also available in: Atom