Project

General

Profile

Statistics
| Revision:

root @ 7180

Name Size Revision Age Author Comment
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 about 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 7037 over 11 years Aaron Marcuse-Kubitza backups/Makefile: Synchronization: %/download: ...
  bin 7163 over 11 years Aaron Marcuse-Kubitza import_all: Removed no longer needed TNRS impor...
  config 6321 over 11 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 7180 over 11 years Aaron Marcuse-Kubitza sql_io.py: put_table(): DuplicateKeyException: ...
  lib 7180 over 11 years Aaron Marcuse-Kubitza sql_io.py: put_table(): DuplicateKeyException: ...
  mappings 7170 over 11 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Removed no longer...
  schemas 7174 over 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_stem: Added loc...
  to_do 4524 almost 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 5971 over 11 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 11.3 KB 7082 over 11 years Aaron Marcuse-Kubitza root Makefile: Removed $(subMake), which is now...
README.TXT 16.5 KB 7178 over 11 years Aaron Marcuse-Kubitza README.TXT: Documentation: Redmine-formatted li...
map 1001 Bytes 6949 over 11 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 30.4 KB 4887 almost 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 almost 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
7180 01/11/2013 06:06 AM Aaron Marcuse-Kubitza

sql_io.py: put_table(): DuplicateKeyException: Uniquifying input table to avoid internal duplicate keys: Also filter out duplicate rows in the out_table, so that they don't create duplicate key errors and the resulting index holes
7179 01/11/2013 06:01 AM Aaron Marcuse-Kubitza

sql.py: distinct_table(): Added support for custom joins used in creating the new table. This can then be used by sql_io.put_table() to filter out duplicate rows in the out_table, so that they don't create duplicate key errors and the resulting index holes.
7178 01/11/2013 05:53 AM Aaron Marcuse-Kubitza

README.TXT: Documentation: Redmine-formatted list of steps for column-based import: Added step to reinstall public schema first, to reset the sequences so that they don't create a diff when the new steps.by_col.log.sql is committed
7177 01/11/2013 05:48 AM Aaron Marcuse-Kubitza

Added inputs/ACAD/Specimen/logs/steps.by_col.log.sql
7176 01/11/2013 05:45 AM Aaron Marcuse-Kubitza

sql_gen.py: Join: Added support for mapping values which are lists, for use in USING joins
7175 01/11/2013 05:40 AM Aaron Marcuse-Kubitza

inputs/SALVIAS/*/test.xml.ref: Restored SALVIAS* inserted row counts, which had gotten auto-accepted from a test run on a non-empty DB
7174 01/11/2013 05:01 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem: Added locationName (authorPlotCode), subplot, individualCode (authorPlantCode) for use in validation
7173 01/11/2013 04:57 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: sync_analytical_stem_to_view(): Drop and re-create dependent objects to avoid errors that analytical_stem can't be dropped because of dependents
7172 01/11/2013 04:56 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: sync_analytical_stem_to_view(): Changed to PL/pgSQL function to allow adding PL/pgSQL commands
7171 01/11/2013 03:26 AM Aaron Marcuse-Kubitza

schemas/vegbien.ERD.mwb: Moved family_higher_plant_group to leave room for analytical_stem to expand

View all revisions | View revisions

Also available in: Atom