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...
  bin 2195 over 12 years Aaron Marcuse-Kubitza db_xml.py: put_table(): Added limit and start o...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2235 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: placenames...
  lib 2244 over 12 years Aaron Marcuse-Kubitza sql.py: put_table(): After getting pkeys of alr...
  mappings 2235 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: placenames...
  schemas 2232 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Added _toPlacerank
  to_do 811 almost 13 years Aaron Marcuse-Kubitza Added to_do/milestones.doc
Makefile 9.47 KB 2095 over 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: functions schema: Re...
README.TXT 2.7 KB 1967 over 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: Install public schem...
map 978 Bytes 1979 over 12 years Aaron Marcuse-Kubitza root map: Fill in defaults for inputs from VegB...

Latest revisions

# Date Author Comment
2244 05/18/2012 06:45 PM Aaron Marcuse-Kubitza

sql.py: put_table(): After getting pkeys of already existing rows, insert new rows

2243 05/18/2012 06:42 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Handle FunctionValueExceptions by excluding rows with the invalid value in their "value" column

2242 05/18/2012 06:41 PM Aaron Marcuse-Kubitza

sql.py: run_query(): Also parse "invalid input syntax at assignment" errors as FunctionValueExceptions

2241 05/18/2012 06:39 PM Aaron Marcuse-Kubitza

sql_gen.py: Col: Convert string table names to Table objects

2240 05/18/2012 06:09 PM Aaron Marcuse-Kubitza

sql.py: run_query(): Parse "invalid input value at assignment" errors' values as well

2239 05/18/2012 05:55 PM Aaron Marcuse-Kubitza

sql.py: run_query(): Parse "invalid input value at assignment" errors as FunctionValueExceptions

2238 05/18/2012 05:27 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): joins: filter_out: Pass NULLs through. Use sql_gen.*2sql_gen() to add the left and right table names to the columns.

2237 05/18/2012 05:26 PM Aaron Marcuse-Kubitza

sql_gen.py: cond2sql_gen(): Take assume_col param and pass it to value2sql_gen()

2236 05/18/2012 04:45 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Use table-qualified pkey col names whenever possible, to avoid ambiguous column references

2235 05/18/2012 04:12 PM Aaron Marcuse-Kubitza

mappings/DwC2-VegBIEN.specimens.csv: placenames: Convert ranks using _toPlacerank to work with multi-inserts

View all revisions | View revisions

Also available in: Atom