Project

General

Profile

Statistics
| Revision:

root @ 1561

Name Size Revision Age Author Comment
  _archive 258 about 13 years Aaron Marcuse-Kubitza Moved pre-BIEN 3 files into _archive folder
  bin 1553 almost 13 years Aaron Marcuse-Kubitza env_password: Print Usage message if run withou...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 1549 almost 13 years Aaron Marcuse-Kubitza inputs/CTFS: Added remaining non-data src files
  lib 1554 almost 13 years Aaron Marcuse-Kubitza sql.py: insert() (and try_insert()): Added opti...
  mappings 1540 almost 13 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Mapped est...
  schemas 1561 almost 13 years Aaron Marcuse-Kubitza schemas/tree_cross-links.sql: Added comment for...
  to_do 811 almost 13 years Aaron Marcuse-Kubitza Added to_do/milestones.doc
Makefile 6.89 KB 1550 almost 13 years Aaron Marcuse-Kubitza Renamed import-all to import_all to match conve...
README.TXT 1.8 KB 1556 almost 13 years Aaron Marcuse-Kubitza README.TXT: Added instructions how to stop all ...
map 867 Bytes 1299 almost 13 years Aaron Marcuse-Kubitza map: On nimoy, use bien2_staging unless otherwi...

Latest revisions

# Date Author Comment
1561 03/23/2012 12:48 PM Aaron Marcuse-Kubitza

schemas/tree_cross-links.sql: Added comment for how to get the namedplace trigger from the provided plantname trigger
1560 03/23/2012 12:44 PM Aaron Marcuse-Kubitza

vegbien.sql: Fixed bug in tree cross-link algorithm where recursion to descendants' ancestors did not use new to refer to the current node's plantname_id
1559 03/23/2012 12:39 PM Aaron Marcuse-Kubitza

vegbien.sql: Fixed bug in tree cross-link algorithm to also insert ancestors for top-level nodes, because they now need an ancestor entry for themselves
1558 03/23/2012 12:28 PM Aaron Marcuse-Kubitza

Added separate SQL file for tree cross-links code. A link to this can be e-mailed to people to review.
1557 03/23/2012 12:21 PM Aaron Marcuse-Kubitza

vegbien.sql: Modified tree cross-link algorithm to add an "ancestor" for this node. This is useful for queries, because you don't have to separately test if the leaf node is the one you're looking for, in addition to that leaf node's ancestors.
1556 03/22/2012 07:08 PM Aaron Marcuse-Kubitza

README.TXT: Added instructions how to stop all running imports
1555 03/22/2012 06:59 PM Aaron Marcuse-Kubitza

vegbien.sql: Added namedplace_update_ancestors and plantname_update_ancestors triggers to populate ancestor cross-links in new namedplace_ancestor and plantname_ancestor tables
1554 03/22/2012 06:07 PM Aaron Marcuse-Kubitza

sql.py: insert() (and try_insert()): Added optional returning param to provide name of an inserted column (usually pkey) to return
1553 03/22/2012 05:41 PM Aaron Marcuse-Kubitza

env_password: Print Usage message if run without initial "."
1552 03/22/2012 05:34 PM Aaron Marcuse-Kubitza

Added bin/stop_imports to stop all running imports

View all revisions | View revisions

Also available in: Atom