Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 258 over 12 years Aaron Marcuse-Kubitza Moved pre-BIEN 3 files into _archive folder
  bin 865 over 12 years Aaron Marcuse-Kubitza sql.py: Print warning if SELECT statement missi...
  config 272 over 12 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 858 over 12 years Aaron Marcuse-Kubitza input.Makefile: Added nolog option to disable c...
  lib 869 over 12 years Aaron Marcuse-Kubitza sql.py: truncate(): Use run_raw_query() instead...
  mappings 816 over 12 years Aaron Marcuse-Kubitza Regenerated mappings/for_review/DwC-VegBIEN.spe...
  schemas 870 over 12 years Aaron Marcuse-Kubitza vegbien.sql: Removed the taxonOccurrence:aggreg...
  test 774 over 12 years Aaron Marcuse-Kubitza xml_dom.py: Print simple XML elements on one line
  to_do 811 over 12 years Aaron Marcuse-Kubitza Added to_do/milestones.doc
Makefile 6.16 KB 784 over 12 years Aaron Marcuse-Kubitza Makefile: Added documentation labels to each se...
README.TXT 1.71 KB 703 over 12 years Aaron Marcuse-Kubitza README.TXT: Added command for reimporting data
map 723 Bytes 274 over 12 years Aaron Marcuse-Kubitza Renamed util to bin

Latest revisions

# Date Author Comment
870 02/07/2012 11:45 AM Aaron Marcuse-Kubitza

vegbien.sql: Removed the taxonOccurrence:aggregateOccurrence 1:1 constraint

869 02/06/2012 05:22 PM Aaron Marcuse-Kubitza

sql.py: truncate(): Use run_raw_query() instead of run_query() because truncate() does not use the recover functionality of run_query(). Also, in the profiling output, this separates the "normal" SQL statements (which use run_query()) from the "core" SQL statements (which use run_raw_query()).

868 02/06/2012 05:09 PM Aaron Marcuse-Kubitza

vegbien.sql: Added indexes for each field in party used in duplicate elimination (for use by sql.put()'s DuplicateKeyException handler)

867 02/06/2012 04:58 PM Aaron Marcuse-Kubitza

sql.py: run_raw_query(): In debug mode, print query after params have been substituted in

866 02/06/2012 04:55 PM Aaron Marcuse-Kubitza

sql.py: Fixed index_cols() to handle UNIQUE indexes with expressions, whose column names are stored in a different format

865 02/06/2012 04:04 PM Aaron Marcuse-Kubitza

sql.py: Print warning if SELECT statement missing a WHERE, LIMIT, or OFFSET clause. Changed bin/map DB input get-all-rows statement to pass start=0 to suppress this warning for that statement.

864 02/06/2012 03:51 PM Aaron Marcuse-Kubitza

db_xml.py: Added start option to get() that passes through to sql.select()

863 02/06/2012 03:50 PM Aaron Marcuse-Kubitza

sql.py: Added start option to select() to set the OFFSET

862 02/06/2012 03:27 PM Aaron Marcuse-Kubitza

sql.py: If run_raw_query.debug flag is set, print each query executed (on a single line)

861 02/06/2012 03:25 PM Aaron Marcuse-Kubitza

strings.py: Added one_line() function to make a string all on one line

View all revisions | View revisions

Also available in: Atom