Project

General

Profile

Statistics
| Revision:

# Date Author Comment
453 01/10/2012 04:41 PM Aaron Marcuse-Kubitza

xml_dom.py: Changed is_empty() to consider nodes with only comments to be empty

452 01/10/2012 04:23 PM Aaron Marcuse-Kubitza

bin/map: Add input row to exceptions

451 01/10/2012 04:22 PM Aaron Marcuse-Kubitza

db_xml.py: Ignore empty fields. Fixes bug where a field that's not text but has no Element children will be treated as a table, and an error is triggered because the corresponding table does not exist in the database.

450 01/10/2012 04:19 PM Aaron Marcuse-Kubitza

xml_dom.py: Added has_elems() to check if node has Element children

449 01/10/2012 03:56 PM Aaron Marcuse-Kubitza

bin/map: Use xml_func.process()'s new on_error error handler. Add row to database errors and xml_func.SyntaxExceptions.

448 01/10/2012 03:54 PM Aaron Marcuse-Kubitza

xml_func.py: Changed formatting of comment that node with syntax errors is replaced with so that it starts on its own line

447 01/10/2012 03:50 PM Aaron Marcuse-Kubitza

xml_func.py: Use on_error exception handler to allow caller to print exceptions instead of raising them

446 01/10/2012 03:41 PM Aaron Marcuse-Kubitza

db_xml.py: Add node to any database exceptions generated in put()

445 01/10/2012 03:09 PM Aaron Marcuse-Kubitza

exc.py: Added raise_() wrapper for raise statement

444 01/10/2012 02:45 PM Aaron Marcuse-Kubitza

Ignore .~* (lock files generated by OpenOffice.org) in inputs

443 01/10/2012 02:44 PM Aaron Marcuse-Kubitza

inputs/SALVIAS: Added stems map

442 01/10/2012 02:43 PM Aaron Marcuse-Kubitza

bin/map: Handle empty rows for db output

441 01/10/2012 02:34 PM Aaron Marcuse-Kubitza

mappings: Use stemParent instead of stemOrganism to identify stems so that it's clear that the stemParent is an individualOrganismObservation, not an individualOrganism

440 01/10/2012 02:25 PM Aaron Marcuse-Kubitza

input.Makefile: Include VegX maps not in tablesSort

439 01/10/2012 02:13 PM Aaron Marcuse-Kubitza

mappings/Makefile: Generate initial VegX-VegBIEN.stems.csv

438 01/10/2012 01:36 PM Aaron Marcuse-Kubitza

mappings/Makefile: Cleaned up in preparation for adding rule to generate VegX-VegBIEN.stems.csv

437 01/10/2012 12:51 PM Aaron Marcuse-Kubitza

bin/map: Continue with database insertion even if a row had XML func syntax errors, because these errors have been fixed by removing the offending function node

436 01/10/2012 12:49 PM Aaron Marcuse-Kubitza

xml_func.py: Remove function nodes with syntax errors to prevent them from causing DatabaseErrors later

435 01/10/2012 12:48 PM Aaron Marcuse-Kubitza

xml_dom.py: Added remove() function to remove a node

434 01/10/2012 12:39 PM Aaron Marcuse-Kubitza

bin/map: Track Exceptions with ExTracker

433 01/10/2012 12:38 PM Aaron Marcuse-Kubitza

exc.py: Added ExTracker to track printed (suppressed) Exceptions and exit with nonzero status if any were encountered

432 01/10/2012 12:12 PM Aaron Marcuse-Kubitza

bin/map: Parse each output XPath at the beginning so XPath syntax errors are detected right away

431 01/10/2012 12:03 PM Aaron Marcuse-Kubitza

vegbien.sql: Reran renames to capture cases where a name is in the middle of an identifier

430 01/10/2012 11:47 AM Aaron Marcuse-Kubitza

vegbien.sql: Use character varying(255) instead of text or character varying in new tables and columns

429 01/10/2012 11:35 AM Aaron Marcuse-Kubitza

input.Makefile: Print Postgres NULL as NULL instead of empty string to match MySQL output

428 01/10/2012 11:26 AM Aaron Marcuse-Kubitza

VegX-VegBIEN mapping: Fixed syntax error in mapping

427 01/09/2012 05:30 PM Aaron Marcuse-Kubitza

vegbien.sql: Added trait table

426 01/09/2012 05:22 PM Aaron Marcuse-Kubitza

vegbien.sql: Added columns to stemobservation

425 01/09/2012 05:13 PM Aaron Marcuse-Kubitza

vegbien.sql: Renamed collectiveobservation.stratum_id to taxonbin_id

424 01/09/2012 04:51 PM Aaron Marcuse-Kubitza

vegbien.sql: Added some DarwinCore attributes to collection table

423 01/09/2012 04:21 PM Aaron Marcuse-Kubitza

Makefiles: Added remake target to run clean and all

422 01/09/2012 04:04 PM Aaron Marcuse-Kubitza

vegbien.sql: Added taxondetermination.collection_id column

421 01/09/2012 03:56 PM Aaron Marcuse-Kubitza

VegBIEN: Made taxondetermination.plantname_id required

420 01/09/2012 02:59 PM Aaron Marcuse-Kubitza

vegbien.sql: Made taxondetermination.plantconcept_id optional

419 01/09/2012 02:49 PM Aaron Marcuse-Kubitza

VegBIEN: Renamed author*code to authorcode

418 01/09/2012 02:47 PM Aaron Marcuse-Kubitza

Makefiles: Added empty rules for targets without a rule so that these rules wouldn't trigger the recursive subdir invocation for the default target

417 01/09/2012 02:33 PM Aaron Marcuse-Kubitza

VegX-VegBIEN mapping: Convereted all database names to lowercase to correspond to their case in the database

416 01/09/2012 02:04 PM Aaron Marcuse-Kubitza

Makefiles: Added empty Makefile target so that Makefiles are not included in the targets recursively run on subdirs

415 01/09/2012 02:01 PM Aaron Marcuse-Kubitza

input.Makefile: Dependencies in other directories are included as prerequisistes. Use tablesSort variable instead of sort order prefix to order tables.

414 01/09/2012 01:35 PM Aaron Marcuse-Kubitza

Makefile: Added default target that recursed into subdirs with Makefiles. Used default target for all and clean.

413 01/09/2012 01:34 PM Aaron Marcuse-Kubitza

Regenerated inputs/SALVIAS/map.VegBIEN.0.plots.csv

412 01/09/2012 01:32 PM Aaron Marcuse-Kubitza

Removed scripts symlink because it was causing Makefile recursion issues

411 01/09/2012 01:28 PM Aaron Marcuse-Kubitza

Makefile: Take advantage of new inputs/Makefile

410 01/09/2012 01:24 PM Aaron Marcuse-Kubitza

Added inputs/Makefile to run input targets recursively on each input

409 01/09/2012 01:08 PM Aaron Marcuse-Kubitza

Makefile: Run inputs-* targets for all and clean

408 01/09/2012 01:00 PM Aaron Marcuse-Kubitza

input.Makefile: all doesn't run import. import runs verify.

407 01/09/2012 12:41 PM Aaron Marcuse-Kubitza

vegbien.sql: Set all FOREIGN KEY constraints to ON UPDATE CASCADE ON DELETE CASCADE

406 01/09/2012 12:35 PM Aaron Marcuse-Kubitza

SALVIAS mappings: use PlotID as authorObsCode to link plot observations and organisms correctly for organisms without a PlotCode

405 01/09/2012 12:32 PM Aaron Marcuse-Kubitza

SALVIAS mappings: use PlotID as authorObsCode to link plot observations and organisms correctly for organisms without a PlotCode

404 01/09/2012 11:49 AM Aaron Marcuse-Kubitza

input.Makefile: Fixed bug in verify's diff rule

403 01/09/2012 11:34 AM Aaron Marcuse-Kubitza

Added CTFS input

402 01/06/2012 05:01 PM Aaron Marcuse-Kubitza

Makefile: Generate error when trying to run subMake on a directory with no Makefile

401 01/06/2012 04:37 PM Aaron Marcuse-Kubitza

input.Makefile: Tests use bin/map's new new test mode

400 01/06/2012 04:37 PM Aaron Marcuse-Kubitza

bin/map: Added test mode that empties the database before doing anything

399 01/06/2012 04:37 PM Aaron Marcuse-Kubitza

sql.py: Added functions to truncate tables, list all tables, and empty a database

398 01/06/2012 04:35 PM Aaron Marcuse-Kubitza

Accepted new SALVIAS test outputs

397 01/06/2012 03:38 PM Aaron Marcuse-Kubitza

Makefile: Print Finished message after running test2 (inputs tests)

396 01/06/2012 03:38 PM Aaron Marcuse-Kubitza

Accepted test outputs for SALVIAS

395 01/06/2012 03:37 PM Aaron Marcuse-Kubitza

input.Makefile: Added ability to accept a test output to use as the new reference output

394 01/06/2012 03:01 PM Aaron Marcuse-Kubitza

vegbien db: Renamed all occurrences of interpretation to determination

393 01/06/2012 02:56 PM Aaron Marcuse-Kubitza

Makefile: Tell make that subMake rules run make recursively

392 01/06/2012 02:51 PM Aaron Marcuse-Kubitza

vegbien.sql: Updated collection table for recent refactorings

391 01/06/2012 02:42 PM Aaron Marcuse-Kubitza

Made more of Bob Peet's changes to the vegbien db and updated VegX-VegBIEN mapping

390 01/06/2012 02:32 PM Aaron Marcuse-Kubitza

Makefile: Fixed pattern for recursive invocation of subdirectory make

389 01/06/2012 12:54 PM Aaron Marcuse-Kubitza

Moved mappings/schemas to schemas

388 01/06/2012 12:50 PM Aaron Marcuse-Kubitza

Makefile: Changed all to make schemas and mappings instead of running install

387 01/06/2012 12:34 PM Aaron Marcuse-Kubitza

Moved mappings/schemas to schemas

386 01/06/2012 12:25 PM Aaron Marcuse-Kubitza

Makefile: Added inputs import target

385 01/06/2012 12:24 PM Aaron Marcuse-Kubitza

input.Makefile: Fixed syntax error with use of import_cmd variable

384 01/06/2012 12:19 PM Aaron Marcuse-Kubitza

vegbien.sql: Added collection table

383 01/06/2012 12:18 PM Aaron Marcuse-Kubitza

Makefiles: Changed _not_file to _always because _not_file is sometimes used to force a file to always be remade

382 01/05/2012 04:48 PM Aaron Marcuse-Kubitza

Decoupled VegBIEN from VegBank and removed mappings to VegBank

381 01/05/2012 04:30 PM Aaron Marcuse-Kubitza

Regenerate vegbien.sql by dumping the vegbien db

380 01/05/2012 04:06 PM Aaron Marcuse-Kubitza

Regenerate vegbien.sql by dumping the vegbien db

379 01/05/2012 04:05 PM Aaron Marcuse-Kubitza

psql_vegbien: Changed to use postgres_vegbien

378 01/05/2012 04:03 PM Aaron Marcuse-Kubitza

Added postgres_vegbien to run PostgreSQL command on the vegbien db

377 01/05/2012 03:26 PM Aaron Marcuse-Kubitza

SALVIAS verification: Added plot methods

376 01/05/2012 01:19 PM Aaron Marcuse-Kubitza

SALVIAS verification: Added # plots

375 01/05/2012 01:06 PM Aaron Marcuse-Kubitza

Makefile: Added targets to run input targets on all inputs

374 01/05/2012 12:54 PM Aaron Marcuse-Kubitza

SALVIAS verification: Added projects list to examine why project counts differ

373 01/05/2012 12:41 PM Aaron Marcuse-Kubitza

SALVIAS verification: Made statement-label SELECT statements use the same syntax for MySQL and PostgreSQL so they are easy to copy and paste between the input and output queries

372 01/04/2012 04:54 PM Aaron Marcuse-Kubitza

input.Makefile: Don't remove logs in clean

371 01/04/2012 04:32 PM Aaron Marcuse-Kubitza

input.Makefile: Added support for multi-column verification queries. inputs/SALVIAS: Added a multi-column verification query.

370 01/04/2012 03:47 PM Aaron Marcuse-Kubitza

input.Makefile: Remove all *.out in clean

369 01/04/2012 02:59 PM Aaron Marcuse-Kubitza

inputs: Don't keep *.out under version control

368 01/04/2012 02:35 PM Aaron Marcuse-Kubitza

input.Makefile: Added rules to verify inserted data and run tests

367 01/04/2012 11:38 AM Aaron Marcuse-Kubitza

Regenerated inputs/SALVIAS/map.VegBIEN.1.organisms.csv

366 01/04/2012 11:32 AM Aaron Marcuse-Kubitza

exc.py: Print ! before error messages so they can be found and counted more easily in log files

365 01/04/2012 11:13 AM Aaron Marcuse-Kubitza

input.Makefile: Only output to log if importing all rows

364 01/04/2012 10:46 AM Aaron Marcuse-Kubitza

Moved vegbien CREATE DATABASE command to Makefile and run vegbien.sql as bien user

363 01/04/2012 10:27 AM Aaron Marcuse-Kubitza

Renamed vegbien tables according to Bob Peet's new VegBank-VegBIEN mapping

362 01/04/2012 10:16 AM Aaron Marcuse-Kubitza

input.Makefile: Don't print commands that use set -x to be echoed

361 01/04/2012 10:14 AM Aaron Marcuse-Kubitza

input.Makefile: Use system's time utility instead of shell's time command

360 01/04/2012 10:09 AM Aaron Marcuse-Kubitza

sql.py: Include sql.DbException in DatabaseErrors list

359 01/03/2012 04:28 PM Aaron Marcuse-Kubitza

Generate VegX-VegBIEN.organisms.csv from VegBank-VegBIEN.map.csv, which is generated from VegBank-VegBIEN.map_only.csv

358 01/03/2012 04:21 PM Aaron Marcuse-Kubitza

repl: Process whole file as one string so that regexps can match EOF for appending

357 01/03/2012 04:21 PM Aaron Marcuse-Kubitza

mappings/Makefile: Clean -VegBIEN..csv maps

356 01/03/2012 04:08 PM Aaron Marcuse-Kubitza

Generate VegBank-VegBIEN.schema.csv from VegBank-VegBIEN.schema_only.csv and VegBank-VegBIEN.csv

355 01/03/2012 04:06 PM Aaron Marcuse-Kubitza

Added cat_csv to concatenate two spreadsheets

354 01/03/2012 03:34 PM Aaron Marcuse-Kubitza

Removed no longer needed inputs/SALVIAS/db.sh