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...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 4751 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 4996 over 12 years Aaron Marcuse-Kubitza csv2db: Use new sql_io.import_csv()
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 5002 over 12 years Aaron Marcuse-Kubitza schemas/py_functions.sql: _namePart(): Fixed bu...
  lib 5001 over 12 years Aaron Marcuse-Kubitza sql_io.py: import_csv(): Documented that sql.tr...
  mappings 4987 over 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Removed unnecessa...
  schemas 4986 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: taxonoccurrence: taxonoccu...
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 4523 over 12 years Aaron Marcuse-Kubitza Added validation/
Makefile 9.99 KB 4752 over 12 years Aaron Marcuse-Kubitza root Makefile: PostgreSQL: postgres-Linux: Adde...
README.TXT 11.5 KB 4985 over 12 years Aaron Marcuse-Kubitza README.TXT: Documented that if the row-based an...
map 1.28 KB 4981 over 12 years Aaron Marcuse-Kubitza root map: Fixed custom public schema override t...
new_terms.csv 30.4 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
5002 09/25/2012 10:59 PM Aaron Marcuse-Kubitza

schemas/py_functions.sql: _namePart(): Fixed bug where it was returning the empty string instead of NULL

5001 09/25/2012 10:46 PM Aaron Marcuse-Kubitza

sql_io.py: import_csv(): Documented that sql.truncate() MUST be run so that the rows will be stored in inserted order, and the row_num added after import will match up with the CSV's row order

5000 09/25/2012 10:35 PM Aaron Marcuse-Kubitza

sql.py: add_row_num(): Add distinguishing comment to ADD COLUMN statement so that it will be cached. The distinguishing comment is required because sometimes column names are truncated, leading to unwanted collisions with previously-cached ADD COLUMN statements. It provides a way of distinguishing the full column name behind a particular ADD COLUMN statement.

4999 09/25/2012 10:24 PM Aaron Marcuse-Kubitza

sql_io.py: import_csv(): Free memory used by deleted rows from any failed import. Documented that sql.create_table() is not rolled back if the import fails, but instead is cached, and will not be re-run if the import is retried.

4998 09/25/2012 09:37 PM Aaron Marcuse-Kubitza

sql_io.py: import_csv(): Fixed bug where the added row number column needed to be named row_num instead of _row_num to be autodetected as the pkey column (sql.pkey_col) by sql.pkey() and to avoid name collisions with the row number column added in column-based import

4997 09/25/2012 09:34 PM Aaron Marcuse-Kubitza

sql.py: add_row_num(): Support custom row number column name

4996 09/25/2012 09:12 PM Aaron Marcuse-Kubitza

csv2db: Use new sql_io.import_csv()

4995 09/25/2012 09:10 PM Aaron Marcuse-Kubitza

sql_io.py: Added import_csv()

4994 09/25/2012 09:05 PM Aaron Marcuse-Kubitza

csv2db: Don't truncate the table before loading rows because it has just been created, and is therefore empty. This statement may be left over from a time when the table was created only once, and its creation was not rolled back if the import fails.

4993 09/25/2012 08:44 PM Aaron Marcuse-Kubitza

sql_io.py: cleanup_table(): Print 'Cleaning up table' log message

View all revisions | View revisions

Also available in: Atom