Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 over 12 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 about 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 5038 about 12 years Aaron Marcuse-Kubitza with_all: Support additional command-line args ...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 5035 about 12 years Aaron Marcuse-Kubitza input.Makefile: Existing maps discovery: $(anyM...
  lib 5037 about 12 years Aaron Marcuse-Kubitza sql_io.py: append_csv(): Check that the CSV's h...
  mappings 5014 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Use new, more gen...
  schemas 5036 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Added tnrs table to hold c...
  to_do 4524 about 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 4523 about 12 years Aaron Marcuse-Kubitza Added validation/
Makefile 9.99 KB 4752 about 12 years Aaron Marcuse-Kubitza root Makefile: PostgreSQL: postgres-Linux: Adde...
README.TXT 11.3 KB 5016 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: `make test by_col=1`: ...
map 1.28 KB 4981 about 12 years Aaron Marcuse-Kubitza root map: Fixed custom public schema override t...
new_terms.csv 30.4 KB 4887 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
5038 09/27/2012 03:35 AM Aaron Marcuse-Kubitza

with_all: Support additional command-line args for the make target, such as vars

5037 09/27/2012 03:11 AM Aaron Marcuse-Kubitza

sql_io.py: append_csv(): Check that the CSV's header matches the table's columns

5036 09/27/2012 03:08 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Added tnrs table to hold contents of TNRS response

5035 09/27/2012 02:20 AM Aaron Marcuse-Kubitza

input.Makefile: Existing maps discovery: $(anyMap): Inlined patterns used because they are only used here

5034 09/27/2012 01:27 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonpath_canon_taxonpath_id_self_ref(), placepath_canon_placepath_id_self_ref(): Fixed bug where the pkey could only be prepopulated if it was not already set, in order to support UPDATE as well as INSERT statements

5033 09/27/2012 01:15 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonpath.canon_taxonpath_id, placepath.canon_placepath_id: Fixed comment describing that the special value 0 creates an automatic self-reference

5032 09/27/2012 01:09 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonpath.canon_taxonpath_id, placepath.canon_placepath_id: Added trigger to automatically create a self-reference (indicating a scrubbed name) when set to the special value 0

5031 09/27/2012 12:33 AM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: `%/install: %/create.sql`: Don't add a row number column to the created table because it is now added automatically to the temp table by column-based import (row-based import now also does not require a pkey for DB inputs)

5030 09/27/2012 12:28 AM Aaron Marcuse-Kubitza

bin/map, db_xml.put_table() (row-based and column-based import): Don't sort the input table by its pkey, in order to support input tables with no pkey. Note that reading the input table in table order and having this match the input flat file's order is only possible with sql_io.import_csv()'s truncation of the table on a failed import, which ensures that the rows will be stored in inserted order.

5029 09/27/2012 12:19 AM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: Removed no longer used $(isJoinedTable). Note that it is no longer necessary for joined tables to be suffixed with ".src" to prevent the creation of a row_num column, which collided during joins.

View all revisions | View revisions

Also available in: Atom